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

From the text web site connect to the site of the federal

From the text Web site, connect to the site of the Federal Reserve Board, which includes minutes from FOMC meetings. Choose any meeting at which the committee changed its federal funds rate target. a. Based on the minute ...

How does each of the following events affect the risk of a

How does each of the following events affect the risk of a liquidity trap? a. The central bank decides to push long-run inflation to zero. b. The neutral real interest rate rises (see Section 12.5 for a review of the neu ...

Journal entries and trial balanceon january 1 2014 alicia

Journal entries and trial balance On January 1, 2014, Alicia Masingale established Leopard Realty, which completed the following transactions during the month: a. Alicia Masingale transferred cash from a personal bank ac ...

Financial management assignmentq1 argentina company has

Financial Management Assignment Q1. Argentina Company has bought a machine, which has expected life 6 years, with standard deviation 1.5 years. While the machine is running, its expected annual earnings before taxes are ...

The 2011 balance sheet of annas tennis shop inc showed

The 2011 balance sheet of Anna's Tennis Shop, Inc., showed long-term debt of $6.4 million, and the 2012 balance sheet showed long-term debt of $6.65 million. The 2012 income statement showed an interest expense of $225,0 ...

Does a rise in national production and income per capita

Does a rise in national production and income per capita tend to worsen or improve air pollution, water pollution, and sanitation? Explain.

Consider the put option of a non-dividend-paying

Consider the put option of a non-dividend-paying stock. Suppose that Pt = $44, K = $47, r = 6% per annum, and T - t = 0.5 year. If the European put option of the stock is selling at $1.00, what opportunities are there fo ...

Solve each problem using excel show both the solution and

Solve each problem using Excel. Show both the solution and the formula you used (by putting an apostrophe in front of the equals sign). Double-check each solution using your financial calculator. (Note: This assignment d ...

Financial managementplease discuss and analyze one of the

FINANCIAL MANAGEMENT Please, discuss and analyze one of the following two topics (your choice of topic). Be sure to state an opinion and defend your stance: 3-5 pages. Topic 1: There seems to be an escalation of non-bind ...

Consider the market for loanable funds which determines the

Consider the market for loanable funds, which determines the real interest rate in the long run (see Section 4.1). a. As usual, draw the supply and demand for loans as functions of the pretax real interest rate, r. b. Su ...

  • 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