Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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. 

Requirements

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

A very thin polymeric coating of thickness 01 mm uniformly

A very thin polymeric coating of thickness 0.1 mm uniformly coats a rectangular surface. The rectangular surface has a length of 20 cm and a width of 10 cm. the coating contains a solvent that must be evaporated away fro ...

List three ways to control preload directly what are the

List three ways to control preload directly ? What are the advantages of a bonded ultrasonic transducer? What is sometimes cited as a disadvantage? Can torque be used to tighten a 6 in. diameter bolt? If not, why not? Na ...

1 present value of annuity what formula is used to

1. Present Value of Annuity. What formula is used to determine the present value of an annuity? What does the present value of an annuity indicate? 2. Future Value of Annuity. How would you modify the FVA equation to det ...

1 why is variance reduction important to logistical

1. Why is variance reduction important to logistical integration? Illustrate in terms of logistical operations. 2. What is the meaning of the phrase cradle-to-cradle logistics? Discuss the operational differences of orig ...

Budget assignmentrefer to the city of granston case 11-3 at

Budget Assignment Refer to the City of Granston Case 11-3 at the end of Chapter 11. Using the ‘Current Year Q-3' data found in Exhibit 2 and Exhibit 3, create a project supply and materials budget based on the informatio ...

1 what are the advantages and disadvantages of usinga

1. What are the advantages and disadvantages of using (a) figures, (b) tables, and (c) text to report the results of experiments in the research report? 2. Differentiate between random sampling and random assignment. Whi ...

1 a certain number of bankruptcies are good for the economy

1. A certain number of bankruptcies are good for the economy. Discuss why you agree or disagree with this statement. 2. A business should always be liquidated when the liquidation value exceeds the business's value as a ...

A company exports 37000 products to chile nbspunder an

A company exports 37,000 products to Chile  under an import license that expires in five years. In Chile, the products are sold for the Chile peso equivalent of $45. Direct shipping costs in the United States and indirec ...

1 under what circumstances is it acceptable for a

1. Under what circumstances is it acceptable for a researcher to use deception in a study with human participants? 2. What kinds of information must be included accurately as part of the informed consent? (That is, what ...

1 why is cindy fratelli unprepared to play an ihr role2 how

1. Why is Cindy Fratelli unprepared to play an IHR role? 2. How can she prepare herself? 3. What areas of IHR will Cindy need to learn?

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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