To determine: The best-case and worst-case
Introduction:
Net present value (NPV) refers to the current discounted value of the future cash flows. The company should accept the project, if the net present value is positive or greater than zero and vice-versa. If there are two mutually exclusive projects, then the company has to select the project that has higher net present value.
Answer to Problem 21QP
The best-case NPV is $53,849,087.272.
The NPVof worst-caseis -$19,007,791.712.
Explanation of Solution
Given information:
The new clubs sold $715 per set and number of sets sold is 75,000 set per year. The cheaper club was sold for $425 per set and number of sets sold is 12,000 set per year. The expensive clubs was sold for $1,150 in which the company has lost sales of 10,000 sets.
The variable cost of the new club is $385 per set, variable cost of the expensive cub is $620, and the variable cost of the cheaper club is $195. The fixed costs each years is $9,400,000. The accurate estimate is ±10%.
Formula:
The formula to calculate best-case of unit sales projection under the scenario analysis:
The formula to calculate best-case of price projection under the scenario analysis:
The formula to calculate best-case of variable costs projection under the scenario analysis:
The formula to calculate best-case of fixed costs projection under the scenario analysis:
The formula to calculate best-case of sales lost projection under the scenario analysis:
The formula to calculate best-case of sales gained projection under the scenario analysis:
The formula to calculate worst-case of unit sales projection under the scenario analysis:
The formula to calculate worst-case of price projection under the scenario analysis:
The formula to calculate worst-case of variable costs projection under the scenario analysis:
The formula to calculate worst-case of fixed costs projection under the scenario analysis:
The formula to calculate worst case of sales lost projection under the scenario analysis:
The formula to calculate worst-case of sales gained projection under the scenario analysis:
Compute the best-case of unit sales projection under the scenario analysis:
Hence, the best-case of unit sales projection under the scenario analysis are 82,500 units.
Compute best-case of price projection under the scenario analysis:
Hence, the best-case of price projection under the scenario analysis are $787.
Compute the best-case of variable costs projection under the scenario analysis:
Hence, the best-case of variable costs projection under the scenario analysis are $347.
Compute the best-case of fixed costs projection under the scenario analysis:
Hence, the best-case of fixed costs projection under the scenario analysis are $8,460,000.
Compute best-case of sales lost projection under the scenario analysis:
Hence, the best-case of sales lost projection under the scenario analysis are 9,000 units.
Compute the best-case of sales gained projection under the scenario analysis:
Hence, the best-case of sales gained projection under the scenario analysis are 13,200 units.
Compute the worst-case of unit sales projection under the scenario analysis:
Hence, the worst-case of unit sales projection under the scenario analysis are 67,500 units.
Compute worst-case of price projection under the scenario analysis:
Hence, the worst-case of price projection under the scenario analysis are $644.
Compute the worst-case of variable costs projection under the scenario analysis:
Hence, the worst-case of variable costs projection under the scenario analysis are $424.
Compute the worst-case of fixed costs projection under the scenario analysis:
Hence, the worst-case of fixed costs projection under the scenario analysis are $10,340,000.
Compute worst-case of sales lost projection under the scenario analysis:
Hence, the worst-case of sales lost projection under the scenario analysis are 11,000 units.
Compute the worst-case of sales gained projection under the scenario analysis:
Hence, the worst-case of sales gained projection under the scenario analysis are 10,800 units.
Note: After estimating the best-case and worst-case for the variables find out the total sales and total variable costs for the best-case scenario in each variable.
Formulae:
The formula to calculate total sales:
The formula to calculate total variable costs:
The formula to calculate total sales of the entire clubs:
The formula to calculate total variable costs of the entire clubs:
Compute the total sales of new clubs:
Hence, the total sales of the new clubs are $64,927,500.
Compute the total sales of expensive clubs:
Hence, the total sales of the expensive clubs are -$10,350,000.
Compute the total sales of cheaper clubs:
Hence, the total sales of the cheaper clubs are $5,610,000.
Compute the total sales of the entire clubs:
Hence, the total sales of the entire clubs are $60,187,500.
Table that indicating the entire sales for clubs:
Particulars | Price per sets (in $) (A) | Number of set Sold (in units) (B) | Total sales (in $) (C)=(A)×(B) |
New clubs | 787 | 82,500 | 64,927,500 |
Expensive clubs | 1,150 | (9,000) | (10,350,000) |
Cheaper clubs | 425 | 13,200 | 5,610,000 |
Total sales | 60,187,500 |
Hence, the total sales for the entire clubs are $60,187,500.
Compute total variable costs of new clubs:
Hence, the total variable costs of the new clubs are −$28,627,500.
Compute total variable costs of expensive clubs:
Hence, the total variable costs of the expensive clubs are $5,580,000.
Compute total variable costs of cheaper clubs:
Hence, the total variable costs of the cheaper clubs are −$2,574,000.
Compute the total variable costs of the entire clubs:
Hence, the total variable costs of the entire clubs are -$25,621,500.
Table that indicating the variable costs:
Particulars | Variable cost per Sets (in $) (A) | Number of set sold (in units) (B) | Total variable costs (in $) (C)=(A)×(B) |
New clubs | ($347) | 82,500 | ($28,627,500) |
Expensive clubs | ($620) | (9,000) | $5,580,000 |
Cheaper clubs | ($195) | 13,200 | ($2,574,000) |
Total variable costs | ($25,621,500) |
Hence, the variable costs for the clubs are −$25,621,500.
Note: Inorder toprepare pro forma income statement,
The formula to calculate depreciation of plant and equipment:
The formula to calculate EBIT:
The formula to calculate tax when tax rate is given:
The formula to calculate net income:
Compute depreciation expense of plant and equipment:
Hence, the depreciation expense is $4,300,000.
Compute the EBIT:
Hence, the EBIT is $21,806,000.
Compute tax when tax rate is given:
Hence, the tax is $8,722,400.
Compute the net income:
Hence, the net income is $13,083,600.
Table that indicating pro form income statement:
Pro forma income statement | |
Particulars | Amounts (in $) |
Sales | 60,187,500 |
Variable costs | 25,627,500 |
Fixed costs | 8,460,000 |
Depreciation | 4,300,000 |
Earnings before interest and taxes | 21,806,000 |
Taxes | 8,722,400 |
Net income | 13,083,600 |
Hence, the net income as per the pro forma income statement is $13,083,600.
Note: After preparing pro forma income statement, determine the operating cash flow (OCF) and NPV of best-case.
The formula to calculate OCF:
The formula to calculate NPV (after change in price):
Where,
OCF refers to the operating cash flows
Compute the operating cash flow (OCF):
Hence, the OCF is $17,383,600.
Compute the NPV:
Hence, the NPVof best-caseis $53,849,087.272.
Note: After estimating the NPV of best-case find out the total sales and total variable costs for the worst-case scenario in each variable.
Formulae:
The formula to calculate total sales:
The formula to calculate total variable costs:
The formula to calculate total sales of the entire clubs:
The formula to calculate total variable costs of the entire clubs:
Compute the total sales of new clubs:
Hence, the total sales of the new clubs are $43,470,000.
Compute the total sales of expensive clubs:
Hence, the total sales of the expensive clubs are -$12,650,000.
Compute the total sales of cheaper clubs:
Hence, the total sales of the cheaper clubs are $4,590,000.
Compute the total sales of the entire clubs:
Hence, the total sales of the entire clubs are $35,410,000.
Table that indicating the entire sales for clubs:
Particulars | Price per sets (in $) (A) | Number of set sold (in units) (B) | Total sales (in $) (C)=(A)×(B) |
New clubs | 644 | 67,500 | 43,470,000 |
Expensive clubs | 1,150 | (11,000) | (12,650,000) |
Cheaper clubs | 425 | 10,800 | 4,590,000 |
Total sales | 35,410,000 |
Hence, the total sales for the entire clubs are $35,410,000.
Compute total variable costs of new clubs:
Hence, the total variable costs of the new clubs are −$28,620,000.
Compute total variable costs of expensive clubs:
Hence, the total variable costs of the expensive clubs are $6,820,000.
Compute total variable costs of cheaper clubs:
Hence, the total variable costs of the cheaper clubs are -$2,106,000.
Compute the total variable costs of the entire clubs:
Hence, the total variable costs of the entire clubs are -$23,906,000.
Table that indicating the variable costs:
Particulars | Variable cost per sets (in $) (A) | Number of set sold (in units) (B) | Total variable costs (in $) (C)=(A)×(B) |
New clubs | ($424) | 67,500 | ($28,620,000) |
Expensive clubs | ($620) | (11,000) | $6,820,000 |
Cheaper clubs | ($195) | 10,800 | ($2,106,000) |
Total variable costs | ($23,906,000) |
Hence, the variable costs for the clubs are -$23,906,000.
Note: Inorder toprepare pro forma income statement, depreciation Earnings before interest and taxes (EBIT), and tax has to be computed to ascertain net income from this statement.
The formula to calculate EBIT:
The formula to calculate tax when tax rate is given:
The formula to calculate net income:
Compute the EBIT:
Hence, the EBIT is -$3,136,000.
Compute tax when tax rate is given:
Hence, the tax is -$1,254,400.
Compute the net income:
Hence, the net income is -$1,881,600.
Table that indicating pro form income statement:
Pro forma income statement | |
Particulars | Amounts (in $) |
Sales | 35,410,000 |
Variable costs | 23,906,000 |
Fixed costs | 10,340,000 |
Depreciation | 4,300,000 |
Earnings before interest and taxes | -3,136,000 |
Taxes | -1,254,400 |
Net income | -1,881,600 |
Hence, the net income as per the pro forma income statement is −$1,881,600.
Note: After preparing pro forma income statement, determine the operating cash flow (OCF) and NPV of worst-case.
The formula to calculate OCF:
The formula to calculate NPV (after change in price):
Where,
OCF refers to the operating cash flows
Compute the operating cash flow (OCF):
Hence, the OCF is $2,418,400.
Compute the NPV:
Hence, the NPVof worst-caseis -$19,007,791.712.
Want to see more full solutions like this?
Chapter 11 Solutions
Fundamentals of Corporate Finance
- mcq's 34) weakness of the net present value/payback method is that ___. a.because it recognizes the riskiness of various projects, it can develop multiple outcomes b.it is a complicated calculation c.it is subjective d.it is directly related to . 35) IKON is financed entirely with equity, and its beta is 1.31. If the current risk-free rate is 6.25% and the expected market return is 12.8%, what is IKON's required rate of return on a project of average risk? a.14.83% . b.17.65% c.8.58% d.12.81%arrow_forwardReconsider Example 11.6, where the expected cash flows for the Capstone project arePeriod 0 1 2 3 4 5Cash Flow -$55,000 $17,094 $20,439 $20,069 $20,212 $29,660Suppose that Capstone consider the MicroCHP project to be just one of their normal risky projects. Then the appropriate discount rate to use is 15%. However, Capstone considers the MicroCHP project to be much riskier than normal projects, so it believes an additional risk premium of 6.93% should be added. If management has decided to use a risk-adjusted discount rate of 21.93% to compensate for the uncertainty of the cash flows, is this project acceptable?arrow_forwardQ.3 (x1=70000 x2=10%) The IPS company has installed a system to help reduce the number of defective products. The capital investment in the system is $X1, and the projected annual savings are tabled below. The system's market value at the EOY five is negligible, and the MARR is x2% per year A. What is the FW of this investment? Based on econonical deciston rule, is this a good investment. b. What is the IRR of the system? Based on economical decision rule, is this a good investmentr. C. What is the discounted pavback period for this investment.arrow_forward
- Multinational Finance & investment Q2 d) Use a numerical example to illustrate that when there is a large change in the interest rate, the approximation error by using the duration and convexity rule is smaller than the approximation error by using the duration rule only.arrow_forward36 The relationship between the payback method and the internal rate of return is that: Group of answer choices The discounted payback period is exactly the same as the IRR. The payback period is the present value factor for the IRR. A payback period of less than one-half of the life of a project will yield an IRR lower than the target rate. A project whose payback period does not meet the company’s cut-off rate for payback will not meet the company’s criterion for IRR.arrow_forward16. Which of the following statements regarding the net present value rule and the rate of return rule is false? A. Accept a project if NPV > cost of investment.B. Accept a project if NPV is positive.C. Accept a project if return on investment exceeds the rate of return on an equivalent-risk investment in the financial market.D. Reject a project if NPV is negative.arrow_forward
- P8–28 Security market line (SML) Assume that the risk-free rate, RF, is currently 9% and that the market return, rm, is currently 13%. Draw the security market line (SML) on a set of “nondiversifiable risk (x-axis)–required return (y-axis)” axes. Calculate and label the market risk premium on the axes in part Given the previous data, calculate the required return on asset A having a beta of 0.80 and asset B having a beta of 1.30. Draw in the betas and required returns from part cfor assets A and B on the axes in part Label the risk premium associated with each asset and discuss them.arrow_forwarduse excel/show all excel formulas answering the following LO3 20. Sensitivity Analysis We are evaluating a project that costs $1.68 million, has a six-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 90,000 units per year. Price per unit is $37.95, variable cost per unit is $23.20, and fixed costs are $815,000 per year. The tax rate is 21 percent, and we require a return of 11 percent on this project. a. Calculate the base-case cash flow and NPV. What is the sensitivity of NPV to changes in the sales figure? Explain what your answer tells you about a 500-unit decrease in projected sales. b. What is the sensitivity of OCF to changes in the variable cost figure? Explain what your answer tells you about a $1 decrease in estimated variable costs. LO3 21. Scenario Analysis In the previous problem, suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to…arrow_forwardA4) Finance which of the following statements on consumption-based asset pricing are correct? 1. The power utility model predicts that the variance of consumption growth is positively related to the risk-free rate. 2. Assets that perform well when marginal utility is high should earn lower expected returns. 3. In the data, consumption growth is smooth with low standard deviation relative to stock returns. 4. In the data, the sharpe ratio of the market portfolio is about 50% per year. This implies the standard deviation of any valid stochastic discount factor that can explain the equity risk premium puzzle must be less than 50%arrow_forward
- 1) 43- Current Design Co. is considering two mutually exclusive, equally risky, and not repeatable projects, S and L. Their cash flows are shown below. The CEO believes the IRR is the best selection criterion, while the CFO advocates the NPV. If the decision is made by choosing the project with the higher IRR rather than the one with the higher NPV, how much, if any, value will be forgone, i.e., what's the chosen NPV versus the maximum possible NPV? Note that (1) "true value" is measured by NPV, and (2) under some conditions the choice of IRR vs. NPV will have no effect on the value gained or lost. r: 7.50% Year 0 1 2 3 4 CFS −$1,100 $550 $600 $100 $100 CFL −$2,700 $650 $725 $800 $1,400 a. $182.52 b. $171.42 c. $160.31 d. $149.21 e. $138.10 2) 44- Buchholz Corporation follows a moderate current asset investment policy, but it is now considering a change, perhaps to a restricted or maybe to…arrow_forward4. Introduction to real options Consider the following statement about real options: Sometimes real options can give managers the flexibility to decide to invest in a project or wait to make a more calculated decision. True or False: The preceding statement is correct. False True Which type of real option allows the output and/or inputs in the production process to be altered, depending on how market conditions change during a project’s life? A. Expansion option B. Flexibility option C. Abandonment option D. Timing option Consider the following example: Clemens Inc. is considering a $100 million investment in a new line of soft drinks. However, $100 million is a huge investment for Clemens; if things turn bad, it could wipe out the company. A few senior managers have suggested a smaller investment of $20 million to see if the market is as strong as they hope it is. If demand is strong and the opportunity is still…arrow_forward[EXCEL] Payback: Refer to Problem 5. What are the payback periods for production systems 1 and 2? If the systems are mutually exclusive and the firm always chooses projects with the lowest payback period, in which system should the firm invest? please use excel. Problem 5 info: 5. [EXCEL] Net present value: Blanda Incorporated management is considering investing in two alternative production systems. The systems are mutually exclusive, and the cost of the new equipment and the resulting cash flows are shown in the accompanying table. If the firm uses a 9 percent discount rate for production system projects, in which system should the firm invest? Year System 1 System 2 0 −$15,000 −$45,000 1 15,000 32,000 2 15,000 32,000 3 15,000 32,000arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education