Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi Tutor, please assist with the below question: Assume a firm is considering a new project that requires an initial investment and has equal sales

Hi Tutor, please assist with the below question:

  1. Assume a firm is considering a new project that requires an initial investment and has equal sales and costs over its life. Elaborate on the accounting, cash, or financial break-even point. Justified which breakeven it will reach first, second and the last. Will this ordering always apply? 10marks
  • Please provide the definition and the equation to illustrate the concepts.
  • Table 11.1 (see screenshot below) may help.
  • Please justify and explain whether this rank order will always apply or not.

Marks allocation

2.5 m elaboration on accounting break-evenimage text in transcribed

2.5 m elaboration on cash break-even

2.5 m elaboration on financial break-even

2.5 m ranking and justification

10 m Total

Cash Flow IRR Scenario Base case Worst case Best case Unit Sales 6,000 5,500 6,500 $59,800 53,200 66,400 Net Present Value $15,567 -8,226 39,357 15.1% 10.3 19.7 A cash flow sensitivity analysis spreadsheet is available at www.toolkit.cch.com/ tools/cfsens_m.asp. By way of comparison, we now freeze everything except fixed costs and repeat the analysis: IRR Scenario Base case Worst case Best case Fixed Costs $50,000 55,000 45,000 Cash Flow $59,800 56,500 63,100 Net Present Value S15,567 3,670 27,461 15.1% 12.7 17.4 What we see here is that, given our ranges, the estimated NPV of this project is more sen- sitive to changes in projected unit sales than it is to changes in projected fixed costs. In fact, under the worst case for fixed costs, the NPV is still positive. The results of our sensitivity analysis for unit sales can be illustrated graphically as in Figure 11.1. Here we place NPV on the vertical axis and unit sales on the horizontal axis. When we plot the combinations of unit sales versus NPV, we see that all possible combi- nations fall on a straight line. The steeper the resulting line is, the greater the sensitivity of the estimated NPV to changes in the projected value of the variable being investigated. FIGURE ILI >> Sensitivity Analysis for Unit Sales 50 40 NPV - $39,357 T T 30 Net present value (5000) 20 10 - 0 NPV - $15,567 (worst (base (best case) case) case) 5,500 6,000 6,500 Unit sales NPV = -58,226 -10 Cash Flow IRR Scenario Base case Worst case Best case Unit Sales 6,000 5,500 6,500 $59,800 53,200 66,400 Net Present Value $15,567 -8,226 39,357 15.1% 10.3 19.7 A cash flow sensitivity analysis spreadsheet is available at www.toolkit.cch.com/ tools/cfsens_m.asp. By way of comparison, we now freeze everything except fixed costs and repeat the analysis: IRR Scenario Base case Worst case Best case Fixed Costs $50,000 55,000 45,000 Cash Flow $59,800 56,500 63,100 Net Present Value S15,567 3,670 27,461 15.1% 12.7 17.4 What we see here is that, given our ranges, the estimated NPV of this project is more sen- sitive to changes in projected unit sales than it is to changes in projected fixed costs. In fact, under the worst case for fixed costs, the NPV is still positive. The results of our sensitivity analysis for unit sales can be illustrated graphically as in Figure 11.1. Here we place NPV on the vertical axis and unit sales on the horizontal axis. When we plot the combinations of unit sales versus NPV, we see that all possible combi- nations fall on a straight line. The steeper the resulting line is, the greater the sensitivity of the estimated NPV to changes in the projected value of the variable being investigated. FIGURE ILI >> Sensitivity Analysis for Unit Sales 50 40 NPV - $39,357 T T 30 Net present value (5000) 20 10 - 0 NPV - $15,567 (worst (base (best case) case) case) 5,500 6,000 6,500 Unit sales NPV = -58,226 -10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Brilliant Book Keeping How To Keep Your Business Efficient And Cost Effective

Authors: Martin Quinn

1st Edition

0273731785,0273746707

More Books

Students also viewed these Finance questions