Ask Question, Ask an Expert


Ask Basic Finance Expert

The Proposal

The Research and Development Division of your company has just developed a latest gaming system called the Zed Box.  The R&D Division give $800,000 for developing this product and the Marketing Division has given another $210,000 to assess the market demand.  They think 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 following demand for the Zed Box:

Year    Units
2012    15,500
2013    30,000
2014    30,000
2015    30,000
2016    5,000

After that time they think there would be no more sales of the product as newer products become accessible. The Zed Box is expected to cost $132 each to manufacture (variable cost). Additionally, fixed production costs are estimated at $1 million per year.  The manufacturing equipment necessary to create the games costs $2,800,000 million to purchase 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 need to invest $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 percent, and the tax rate is expected to be 42 percent. 


1. Using an Excel spreadsheet:

• Find out the NPV and IRR of the Zed Box project using the pro forma financial statement technique to determine cash flows.

• Enter the input variables in cells of their own at the top of the spreadsheet (so it is easier to do sensitivity calculations). 

• 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 probable (e.g. PV and IRR functions). 

• HINTS:  Your answer, the NPV of the proposal, must be $41,384 using the base case variables as stated in the proposal above.  Appendix 10B in the text shows an ex of a similar spreadsheet problem.

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. Identify all the variables used in the proposal that are estimates or are subject to change during the life of the project. Briefly describe why these variables might change.

b. Select 2 variables that you identified above on which to do sensitivity analysis:

• Change these 2 variables (one at a time) in small increments through a fairly broad range of values using your Excel spreadsheet, and show how sensitive the project is to changes in these two variables. Remember, 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 that summarize the results of your sensitivity analysis (i.e. the NPV, IRR and Breakeven Analysis results at the different values for the input variables).  You will need Copy/Paste Special/Value to paste the changed values into your tables.  Otherwise the values in your tables will keep changing when you change the input variables.
4. Recommendation

Use the results you obtained in the NPV, IRR, breakeven and sensitivity analysis above to prepare a one page report on your findings and recommend whether or not we should precede with the project.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91375

Have any Question? 

Related Questions in Basic Finance

Sorenson inc has sales of 4056000 a gross profit margin of

Sorenson Inc. has sales of $4,056,000, a gross profit margin of 38.55 percent, and inventory of $1,139,000. What are the company's inventory turnover ratio and days' sales in inventory? (Round inventory turnover ratio to ...

Response of firms to a stimulative monetary policyin a weak

Response of Firms to a Stimulative Monetary Policy : In a weak economy, the Fed commonly implements a stimulative monetary policy to lower interest rates, and presumes that firms will be more willing to borrow. Even if b ...

The secondary market for t-bills is active and the

The secondary market for T-bills is active, and the secondary market for federal agency securities is limited. How does this affect the primary market for each security? Why are well- developed secondary markets importan ...

Anna has been saving 450 in her retirement account each

Anna has been saving $450 in her retirement account each month for the last 20 years and plans to continue contributing $450 each month for the next 20 years. Her account has been earning a 9 percent annual interest rate ...

An analysis of water testing to determine lead content was

An analysis of water testing to determine lead content was conducted in the metropolitan area. Specifically samples were taken at 100 homes in the area of Guaynabo and another 100 samples were taken in the area of Hato R ...

1 rate the following five websites from best to worst for

1. Rate the following five websites from best to worst for finding comparative financial ratio information about a company. Explain. 2. What might you do if you fail to find comparative financial ratio information and ne ...

Capital asset pricing model levine manufacturing inc is

(Capital Asset Pricing Model) Levine Manufacturing, Inc., is considering several investments. The rate on Treasury bills is currently 6.75 percent, and the expected return for the market is 12 percent. What should be the ...

How do pension funds lsquouse assets in their portfolioshow

How do pension funds ‘use' assets in their portfolios? How does this depend on the degree of maturity of the pension fund?

Choose three of the stocks - two within the same industry

Choose three of the stocks - two within the same industry plus one additional stock - from the Company Selection and Stock Watch completed in module 03 and then locate interest rates on two other investments that are not ...

Twice a year for 15 years warren ford invested 1700

Twice a year for 15 years, Warren Ford invested $1,700 compounded semiannually at 6% interest. What is the value of this annuity due?

  • 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