Ask Question, Ask an Expert


Ask Financial Management Expert

Assignment - Capital Budgeting, Breakeven Analysis and Sensitivity Analysis

The Proposal:

The Research and Development Division of your company has just developed a new gaming system termed as the Zed Box. The R&D Division spent $800,000 developing this product and the Marketing Division has spent the other $210,000 to assess the market demand. They believe that the Zed Box system has superior graphics and speed, and will have great market appeal at a competitive price of $225. The Marketing Division estimates the given demand for the Zed Box:

215_capital budgeting.jpg

After that time they believe there would be no more sales of the product as newer products become available. The Zed Box is expected to cost $132 each to manufacture (variable cost).  In addition, fixed production costs are estimated at $1 million per year. The manufacturing equipment essential to generate the games costs $2,800,000 million to buy and would be depreciated at a 30 percent CCA rate. The manufacturing equipment is expected to have salvage value equivalent to 15% of the initial cost. We would require investing $350,000 in net working capital up front (primarily for inventory) and NWC will rise to 18% of sales. The NWC will be recovered at the end of the project. The required return is 10%, and the tax rate is expected to be 42 %.


1) Using an Excel spreadsheet:

• Find out the NPV and the IRR of the Zed Box project by using the pro forma financial statement method to find out cash flows.
• Enter the input variables in cells of their own at the top of the spreadsheet (so it is simpler to do sensitivity computations). 
• Set up the essential equations by referencing to the input variable cells. The spreadsheet should be formula driven; don’t put any numbers in equations, only cell references.
• Use Excel’s built-in functions wherever possible (ex: PV and IRR functions).

2) Breakeven analysis (cash B/E point only)
Set up a formula in Excel (this formula is not built-in) to compute the cash breakeven point for the base case.

3) Sensitivity analysis:

a) Recognize all the variables used in the proposal that are estimates or are subject to change during the life of the project. In brief describe why such variables might change.

b) Select two variables which you identified above on which to do sensitivity analysis:

• Change such two variables (one at a time) in small increments via a fairly broad range of values by using your Excel spreadsheet, and show how sensitive the project is to changes in these two variables. Keep in mind, the better your sensitivity analysis, the more information it will give you to interpret and develop your recommendation.

• Present your sensitivity analysis in two Excel tables which summarize the results of your sensitivity analysis (that is, the NPV, IRR and Breakeven Analysis results at the different values for the input variables). You will require Copy/Paste Special/Value to paste the changed values into your tables. Or else the values in your tables will keep modifying when you change the input variables.

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M94241

Have any Question? 

Related Questions in Financial Management

Assume that you recently graduated and you just landed a

Assume that you recently graduated and you just landed a job as a financial planner with the Cleveland Clinic. Your first assignment is to invest $100,000. Because the funds are to be invested at the end of one year, you ...

The binomial model can be used to price unusual features of

The binomial model can be used to price unusual features of options. Consider the following scenario. A stock priced at $75 can go up by 20 percent or down by 10 percent per period for three periods. The risk-free rate i ...

In 2012 client creates a 10-year qprt into which his

In 2012, client creates a 10-year QPRT into which his primary residence is transferred. The value of the residence on the transfer date was $1 million. Since the client is a widower, the residence is far too large. As a ...

A yesterday the price was 5 per pizza and john was willing

A) Yesterday, the price was $5 per pizza, and John was willing to buy 5 pizzas. Today, the price has gone up to $7, and John is now willing to buy only 3 pizzas. What is John's elasticity of demand? Is John's demand for ...

Current assets 2000net fixed assets 3000total assets

Current assets $2,000 Net fixed assets 3,000 Total assets $5,000 Current liabilities $ 900 Long-term debt 1,200 Preferred stock (10,000 shares) 250 Common stock (50,000 shares) 1,300 Retained earnings 1,350 Total common ...

Biocom inc case study - assessment activityevaluatenbspthe

Biocom, Inc. Case Study - Assessment Activity Evaluate  the following in a 350-word response: Explain what depreciation, cash flow, operating cash flow and NPV are and how they interact with business decisions. Explain w ...

Based on the cash flows shown in the chart below compute

Based on the cash flows shown in the chart below, compute the IRR and MIRR for Project Erie. Suppose that the appropriate cost of capital is 12 percent. Advise the organization about whether it should accept or reject th ...

Identify the critical factors on each side of the

Identify the critical factors on each side of the “shareholder versus stakeholder debate.” Discuss the factors that currently motivate corporate leaders to address this issue.

A couple thinking about retirement decide to put aside

A couple thinking about retirement decide to put aside $21,000 each year in a savings plan that earns 5.20% interest. In 6 years they will receive a gift of $72,000 that also can be invested. a. How much money will they ...

You own a 5-year bond with a face value of 1000 and a

You own a 5-year bond with a face value of $1,000 and a coupon rate of 10 percent with annual payments. The bond is currently worth $832.39. If market interest rates remain unchanged, what will be the value of the bond w ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen