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

Consider the three-dimensional return series jointlybuild a

Consider the three-dimensional return series jointly. Build a multivariate time-varying volatility model for the data, using the Cholesky decomposition. Discuss the implications of the model and compute the 1-step ahead ...

See the cash flow statement below for h j heinz hnz all

See the cash flow statement below for H. J. Heinz (HNZ) (all values in thousands of dollars) a. What were Heinz's cumulative earnings over these four quarters? What were its cumulative cash flows from operating activitie ...

Assume a reserve requirement of 10 percentif chemical bank

Assume a reserve requirement of 10 percent. If Chemical Bank is successful in getting Microsoft to convert a $2 million demand deposit to a Eurodollar deposit, how much can Chemical Bank lend out because of this transact ...

Difference between venture capital and conventional

Difference between venture capital and conventional financing

The fleming company a food distributor is considering

The Fleming Company, a food distributor, is considering replacing a filling line at its Oklahoma City warehouse. The existing line was purchased several years ago for $600,000. The line's book value is $200,000, and Flem ...

You want to buy a house within 3 years and you are

You want to buy a house within 3 years, and you are currently saving for the down payment. You plan to save $3,000 at the end of the first year, and you anticipate that your annual savings will increase by 10% annually t ...

Sunnybrook farms is a local grocery store that is currently

Sunnybrook Farms is a local grocery store that is currently open only Monday through Saturday. Sunnybrook is considering opening on Sundays. The annual incremental costs of Sunday openings are estimated at $24,960. Sunny ...

In 2010 senator blanche lincoln d-arkansas proposed that

In 2010, Senator Blanche Lincoln (D-Arkansas) proposed that commercial banks be forbidden to trade derivative securities. Discuss the arguments for and against this proposal.

Answer the following questionthe calculations must be done

Answer the following question: The Calculations must be done on Excel with actual calculations in the cells. Question 1: Using a Spreadsheet to Calculate Yield to Maturity. What is the yield to maturity on the following ...

Suppose again that melvins bank starts with the balance

Suppose again that Melvin's Bank starts with the balance sheet in given Table. Then the bank sells $10 of loans for $10 of cash. a. What is the immediate effect on the balance sheet? b. After the loan sale, what addition ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate