Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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 %.

Requirements:

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

The miami art museum mam is working on the budgets for the

The Miami Art Museum (MAM) is working on the budgets for the 2008 fiscal year, which runs from January 1 through December 31. During the first half of FY08 MAM expects its revenues and expenses to be relatively the same ...

How is liquidity a source of risk explain how the

How is liquidity a source of risk? Explain how the stockholders of a company hold an implicit put option written by the creditors ? Identify the five types of credit derivatives and briefly describe how each works ? Supp ...

Eric borrowed money last year to buy a new car for his

Eric borrowed money last year to buy a new car for his part-time consulting work. The loan is a 3-year loan with 36 monthly payments. Due to his bad credit history, the loan he got is with a 12% annual interest rate comp ...

What return on equity do investors expect for a firm with a

"What return on equity do investors expect for a firm with a $17 stock price, a dividend in year one of $2.00, a beta of 1.6, and a constant growth rate of 2%.

Kevin is considering building a new studio to record his

Kevin is considering building a new studio to record his podcast. The studio costs $300,000 to build, but the higher quality will attract more downloads and subscriptions. If the new studio generates $80,000 per year in ...

1 ajax corps sales last year were 430000 its total

1. Ajax Corp's sales last year were $430,000, its total operating costs were $362,500, and its interest charges were $12,500. What was the firm's times-interest-earned (TIE) ratio? A) 5.7 B) 5.4 C) 5.5 D) 5.3 E) 5.6 2. T ...

Well-bred service company earned 50000000 during 2005 and

Well-Bred Service Company earned $50,000,000 during 2005 and paid $20,000,000 in dividends to the holders of its 40 million shares. If the current market price of Well-Bred's stock is $31.25, calculate the following: (a) ...

Future value of annuity michelle is attending college and

Future Value of Annuity. Michelle is attending college and has a part-time job. Once she finishes college, Michelle would like to relocate to a metropolitan area. She wants to build her savings so that she will have a "n ...

If a firm has low fixed costs relative to all other firms

If a firm has low fixed costs relative to all other firms in the same industry, a large change in sales volume (either up or down) should have: a. no effect in any way on the firms as volume does not effect fixed costs. ...

You are serving on a jury a plaintiff is suing the city for

You are serving on a jury. A plaintiff is suing the city for injuries sustained after a freak street sweeper accident. In the trial, doctors testified that it will be five years before the plaintiff is able to return to ...

  • 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