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
- Which of the following statements is true? Multiple Cholce There Is no correlation between net present value and Internal rate of return. A project with a positive net present value will have a discount rate that Is greater than the Internal rate of return. None of the statements are true Glven several projects with positive net present values, the company should choose the project with the hlghest net present value. A project with a positive net present value will have a discount rate that Is less than the Internal rate of return.arrow_forwardConsider the following payoff table: DA: Decision Alternative. Decision Alternative Good Bad Probabilities State of Nature 0.6 DA1 -3.22 DA2 13.80 DA3 3.75 DA4 4.06 6.33 What is the Expected value under perfect Information (EVUPI)? (Please keep 2 decimals for your answer) Your Answer: Answer 0.4 5.21 -5.40 6.00arrow_forwardConsider two different forward contracts on the same consumption asset. There are no storage costs. Today it is t = 0. One contract has maturity date T and the other has maturity date T_2 where T_2 > T_1. The risk free rate is r. Show that no arbritrage implies that:F_2 <= F_1(1 + r)^(T_2 - T_1)arrow_forward
- A portfolio manager summarizes the input from the macro and micro forecasters in the following table: Micro Forecasts Asset Stock A Stock B Stock C Stock D Expected Return (%) Beta Deviation (%) 1.6 25 22 21 16 Asset T-bills Passive equity portfolio Residual Standard) 2.2 1.4 1.5 Cost of restriction 50 58 55 43 Macro Forecasts Expected Return (%) 12 18 Standard Deviation (%) 0 30 Calculate the following for a portfolio manager who is not allowed to short sell securities. If allowed to short sell securities, the manager's Sharpe ratio is 0.2476. a. What is the cost of the restriction in terms of Sharpe's measure? (Do not round intermediate calculations. Enter your answer as decimals rounded to 4 places.)arrow_forwardmcq'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_forwardQUESTION 7 Which of the following statements is correct? a. When there are two mutually exclusive projects, the project with the highest NPV should be chosen. D. The payback period criterion properly considers the time value of money. OC. The IRR method correctly ranks mutually exclusive projects. d. Since investors prefer more return and less risk, one will never hold a dominated asset in the risk-return sense. In other words, if asset A has a higher expected return and lower standard-deviation than asset B, then investors would only hold asset A in their optimal portfolio. e. When an investment project is evaluated today, the spending that occurred in the last year has to be included in the NPV analysis.arrow_forward
- 4. The following is a payoff table giving profits for various situations. Probability Alternative 1 Alternative 2 Alternative 3 Alternative 4 State 1 0.4 45 16 23 44 State 2 0.35 37 59 65 33 State 3 0.25 83 72 91 55 a) Using the expected monetary value (EMV), which alternative should be chosen? b) Set up the opportunity loss table and compute the minimum expected opportunity loss (EOL). c) What is the maximum value that you would be willing to pay to decide under certainty?arrow_forwardthe market? 10.6 Semistrong Efficiency If a market is semistrong form efficient, is it also weak form efficient? Explain. 10.7 Efficient Markets Hypothesis What are the implications of the efficientarrow_forwardProblem 1 Consider a three period model with two assets, a safe and an unsafe asset. The safe asset always has a price of p, = 1 and returns dividends of r every period. The unsafe asset also returns dividends of r but its price has a random component. Its final price is P₁ =1+ where & ~N(0,0%). The unsafe asset is available in unit net supply in periods 1 and 2. All agents in this economy myopically maximize identical one period ahead utility and have mean-variance utility functions: Now E₁[U]=E[W]-yo 1+1 a.) Suppose there is a sophisticated investor, whom we will also refer to as the arbitrageur, with wealth at time 1 of w₁. Denote this investor's demand for the unsafe asset at time t by 2. Write down the sophisticated investor's wealth at time 3 as a function of parameters, time 2 variables, and the time 3 price. Using this equation, write down the expression that the investor maximizes at time 2 and solve the optimal time 2 demand 2 as a function of only time 2 variables and…arrow_forward
- 4. Which of the following statements about market efficiency is/are true? (a) If a market is weak-form efficient, it is automatically also semi-strong form efficient. (b) If a market is weak-form efficient, fundamental analysis is a waste of time. (c) If a market is weak-form efficient, technical analysis is a waste of time. O (a) only. (b) only. (c) only. (a) and (b) only. (b) and (c) only. O (a) and (c) only.arrow_forwardMultinational 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_forwardWhich of the following is TRUE about NPV? LO3 NPV is the ratio of a project's present value to the amount of resources consumed in generating it. O NPV is the rate at which IRR equals $0. O NPV and IRR are equally reliable investment decision rules when evaluating mutually exclusive projects. O NPV is the difference between the present value of the benefits and the present value of the costs of a project.arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning