Concept explainers
Project Analysis [LO1, 2, 3, 4] You are considering a new product launch. The project will cost $1,750,000, have a four-year life, and have no salvage value;
a. Based on your experience, you think the unit sales, variable cost, and fixed cost projections given here are probably accurate to within ±10 percent. What are the upper and lower bounds for these projections? What is the base-case
b. Evaluate the sensitivity of your base-case NPV to changes in fixed costs.
c. What is the cash break-even level of output for this project (ignoring taxes)?
d. What is the accounting break-even level of output for this project? What is the degree of operating leverage at the accounting break-even point? How do you interpret this number?
a)
To determine: The upper and lower bounds of unit sales, variable costs, and fixed costs projections under the scenario analysis.
Introduction:
Fixed costs remain the same as the total costs despite of the changes in the level of activity. However, the fixed cost per unit has a negative relationship with activity, that is, if the activity volume increases then total cost will decrease and vice-versa.
Variable costs are the type of costs that would vary according to the production output. It depends on the production volume.
Answer to Problem 19QP
Under the scenario analysis, the lower (worst scenario) and upper (best scenario) bounds of unit sales, variable costs, and fixed costs projections are as follows:
Scenarios |
Unit sales (in units) |
Variable cost (in $) |
Fixed cost (in $) |
Base | 190 | 10,400 | 515,000 |
Best | 209 | 9,360 | 463,500 |
Worst | 171 | 11,440 | 566,500 |
Explanation of Solution
Given information:
The unit sales is 190 units, variable costs is $10,400, and fixed costs is $515,000. The accurate estimate is ±10%.
Formula:
The formula to calculate upper bounds of unit sales projection under the scenario analysis:
The formula to calculate upper bounds of variable costs projection under the scenario analysis:
The formula to calculate upper bounds of fixed costs projection under the scenario analysis:
The formula to calculate lower bounds of unit sales projection under the scenario analysis:
The formula to calculate lower bounds of variable costs projection under the scenario analysis:
The formula to calculate lower bounds of fixed costs projection under the scenario analysis:
Compute the upper bounds of unit sales projection under the scenario analysis:
Hence, the upper bounds of unit sales projection under the scenario analysis are 209 units.
Compute the upper bounds of variable costs projection under the scenario analysis:
Hence, the upper bounds of variable costs projection under the scenario analysis are $9,360.
Compute the upper bounds of fixed costs projection under the scenario analysis:
Hence, the upper bounds of fixed costs projection under the scenario analysis are $463,500.
Compute the lower bounds of unit sales projection under the scenario analysis:
Hence, the lower bounds of unit sales projection under the scenario analysis are 171 units.
Compute the lower bounds of variable costs projection under the scenario analysis:
Hence, the lower bounds of variable costs projection under the scenario analysis are $11,440.
Compute the lower bounds of fixed costs projection under the scenario analysis:
Hence, the lower bounds of fixed costs projection under the scenario analysis are $566,500.
To determine: The base-case Net present value (NPV)
Introduction:
Net present value (NPV) refers to the discounted value of the future cash flows at present. 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 19QP
The NPV for the base-case scenario is $286,619.11.
Explanation of Solution
Given information:
The fixed costs of the project are $515,000 per year and the initial cost of the project is $1,750,000 for the lifetime of 4 years. The variable cost per unit is $10,400 and the price per unit of the project is $17,300. The unit sold is 190 units per year, the required rate of return is 12%, and the tax rate is 35%.
The formula to calculate the operating cash flow under the base-case scenario:
Where,
P refers to the price per unit of the project
v refers to the variable cost per unit
Q refers to the number of unit sold
FC refers to the fixed costs
The formula to calculate the NPV of base-case operating cash flow:
Compute the operating cash flow in the base-case scenario:
Hence, the operating cash flow under the base-case scenario is $670,525.
Compute the NPV for the base-case scenario:
Note: To determine the present value of annuity of $1 period for 4 period at a discount rate of 12% refer the PV of an annuity of $1 table. Then find out 12% discount rate and period of 8 years value from the table. Here, the value for the rate 12% and 4 years period is 3.03735.
Hence, the NPV for the base-case scenario is $286,619.11.
To determine: The worst-case scenario
Introduction:
Worst-case scenario is a particular case under the scenario analysis to determine the worst scenarios of the project. The financial managers of the company use this worst-case technique to anticipate potential losses and operational issues of the project.
Answer to Problem 19QP
The NPV for the worst-case scenario is -$1,309,315.
Explanation of Solution
Given information:
The fixed costs of the project are $515,000 per year and initial cost of the project is $1,750,000 for the life time of 4 years. The variable cost per unit is $10,400 and price per unit of the project is $17,300. The unit sold is 190 units per year, required rate of return is 12%, and tax rate is 35%.
The formula to calculate the operating cash flow for worst-case scenario:
Where,
P refers to the price per unit of the project
v refers to the variable cost per unit
Q refers to the number of unit sold
FC refers to the fixed costs
The formula to calculate the NPV for worst- case operating cash flow:
Compute the operating cash flow under the worst-case scenario:
Hence, the operating cash flow under the worst-case scenario is $440,685.
Compute the NPV for worst case scenario:
Hence, the NPV for the worst-case scenario is -$1,309,315.
b)
To determine: The sensitivity of base-case NPV to change in fixed costs
Introduction:
Sensitivity analysis is analyzing the impact of changing only one variable of the net present value. It helps to identify the areas in which the forecasting errors would be severe. The basic concept of sensitivity analysis is to freeze all the variables except one variable.
Answer to Problem 19QP
The sensitivity of NPV to change in the sales value is -$1.97.
Explanation of Solution
Given information:
The fixed costs of the project are $515,000 per year and initial cost of the project is $1,750,000 for the life time of 4 years. The variable cost per unit is $10,400 and price per unit of the project is $17,300. The unit sold is 190 units per year, required rate of return is 12%, and tax rate is 35%. Assume the fixed cost has $516,000.
Formula:
The formula to calculate the sensitivity of NPV to make changes in the sales value:
The formula to calculate the NPV of the new case operating cash flow:
The formula to calculate the new case operating cash flow:
Where,
P refers to the price per unit of the project
v refers to the variable cost per unit
Q refers to the number of unit sold
FC refers to the fixed costs
Compute the new case operating cash flow:
Hence, the new case operating cash flow is $669,875.
Compute the NPV of new case operating cash flow:
Note: To determine the present value of annuity of $1 period for 4 period at a discount rate of 12% refer the PV of an annuity of $1 table. Then find out 12% discount rate and period of 8 years value from the table. Here, the value for the rate 12% and 4 years period is 3.03735.
Hence, the NPV of the new case operating cash flow is $284,644.83.
Compute the sensitivity of NPV to change in the sales value:
Hence, the sensitivity of NPV to change in the sales value is -$1.97. As a result, for every dollar of fixed cost, the NPV decrease by $1.97.
c)
To determine: The cash break-even level of output of the project
Introduction:
Cash break-even point specifies a sales level which can result in zero operating cash flow.
Answer to Problem 19QP
The cash break-even level of output is 74.64 units.
Explanation of Solution
Given information:
The unit price is $17,300, unit variable costs are $10,400, and fixed costs are $515,000.
The formula to calculate the cash break-even quantity:
Compute the cash break-even quantity:
Hence, the cash breakeven quantity is 74.64 units.
d)
To determine: The accounting break-even level of output
Introduction:
Accounting break-even is a sales point at which there is no profit or loss. It is the most widely used measure of break-even point.
Answer to Problem 19QP
The accounting break-even level of output is 138.04 units.
Explanation of Solution
Given information:
The fixed costs of the project are $515,000 per year. The initial cost of the project is $1,750,000 for the life time of 4 years. The variable cost per unit is $10,400 and price per unit of the project is $17,300.
The formula to calculate the accounting break-even quantity:
Compute the accounting break-even quantity:
Hence, the accounting breakeven quantity is 138.04 units.
To determine: The degree of operating leverage
Introduction:
Degree of operating leverage is a measure that indicates the sensitivity on the fixed cost of a project. It interprets that a company with more high operating leverage indicates higher fixed costs and vice versa.
Answer to Problem 19QP
The degree of operating leverage is 2.18 times.
Explanation of Solution
Given information:
The fixed costs of the project are $515,000 per year. The operating cash is $$670,525.
The formula to calculate the degree of operating leverage:
Compute the degree of operating leverage:
Hence, the degree of operating leverage is 1.76 times. The operating cash flows will increase by 1.76% for each 1% increase in unit sales.
Want to see more full solutions like this?
Chapter 11 Solutions
FUND. OF CORPORATE FIN. 18MNTH ACCESS
- A3 8avi You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (vi) Average Accounting Return (AAR in %) Hint: Net Income = {[(Price – variable cost)*Quantity Sold] – Fixed Costs – Depreciation} * (1 – Tax rate)arrow_forwardA3 8ai You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (i) NPVarrow_forwardA3 8aiii You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (iii) Payback period (in years)arrow_forward
- You are considering a new product launch. The project will cost $1,950,000, have a 4-year life, and have no salvage value; depreciation is straight-line to 0. Sales are projected at 180 units per year; price per unit will be $24,000; variable cost per unit will be $15,000; and fixed costs will be $540,000 per year. The required return on the project is 10%, and the relevant tax rate is 34%. d-2. What is the degree of operating leverage at the accounting break-even point? (Round the final answer to 4 decimal places.) Note: To calculate the degree of operating leverage in this requirement, you need to use the OCF base. If you use depreciation, your answer will be marked incorrectly. Give typing answer with explanation and conclusionarrow_forward13. Project Analysis You are considering a new product launch. The project will cost $1.675 million, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 195 units per year; price per unit will be $16,300; variable cost per unit will be $9,400; and fixed costs will be $550,000 per year. The required return on the proiect is 12 percent and the relevant tax rate is 21 percent. a. Based on your experience, you think the unit sales, variable cost, and fixed cost projections given here are probably accurate to within #10 percent. What are the upper and lower bounds for these projections? What is the base-case NPV? What are the best-case and worst-case scenarios? b. Evaluate the sensitivity of your base-case NPV to changes in fixed costs. c. What is the accounting break-even level of output for this project? use excel to solve thisarrow_forwardEngineering economy - ENGR 3322 The International Parcel Service has installed a new radio frequency identification system to help reduce the number of packages that are incorrectly delivered. The capital investment in the system is $65,000, and the projected annual savings are tabled below. The system’s market value at the EOY five is negligible, and the MARR is 18% per year. Calculate the annual worth of the project. a. $ 9,750 b. $ 10,750 c. $ 11,750 d. None of the choicesarrow_forward
- A3 8av You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (v) Internal Rate of Return (IRR in %)arrow_forwardYou are considering a new product launch. The project will cost $750,000, have a 4-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 440 units per year; price per unit will be $17,700, variable cost per unit will be $14,400, and fixed costs will be $725,000 per year. The required return on the project is 12 percent, and the relevant tax rate is 23 percent. a. The unit sales, variable cost, and fixed cost projections given above are probably accurate to within ±10 percent. What are the upper and lower bounds for these projections?arrow_forwardYou are considering a new product launch. The project will cost $2,050,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 170 units per year; price per unit will be $26,000, variable cost per unit will be $16,000, and fixed costs will be $560,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 23 percent. a-1. The unit sales, variable cost, and fixed cost projections given above are probably accurate to within ±10 percent. What are the upper and lower bounds for these projections? What is the base-case NPV? What are the best-case and worst-case scenarios? (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) a-2. What is the base-case NPV? What are the best-case and worst-case scenarios? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g.,…arrow_forward
- You are considering a new product launch. The project will cost $1,750,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 220 units per year; price per unit will be $20,000, variable cost per unit will be $13,000, and fixed costs will be $500,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 22 percent. a-1.The unit sales, variable cost, and fixed cost projections given above are probably accurate to within ±10 percent. What are the upper and lower bounds for these projections? What is the base-case NPV? What are the best-case and worst-case scenarios? (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)a-2.What is the base-case NPV? What are the best-case and worst-case scenarios? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g.,…arrow_forwardA company just paid $10 million for a feasibility study. If the company goes ahead with the project, it must immediately spend another $84,052,480 now, and then spend $20 million in one year. In two years it will receive $80 million, and in three years it will receive $90 million. If the cost of capital for the project is 11 percent, what is the project’s NPV 10.6. 1 newarrow_forward13. Project Analysis You are considering a new product launch. The project will cost$720,000, have a 4-year life, and have no salvage value; depreciation is straight-line tozero. Sales are projected at 380 units per year; price per unit will be $17,400; variablecost per unit will be $14,100; and fixed costs will be $680,000 per year. The requiredreturn on the project is 15 percent and the relevant tax rate is 21 percent.a. Based on your experience, you think the unit sales, variable cost, and fixed costprojections given here are probably accurate to within ±10 percent. What are theupper and lower bounds for these projections? What is the base-case NPV? What arethe best-case and worst-case scenarios?b. Evaluate the sensitivity of your base-case NPV to changes in fixed costs.c. What is the accounting break-even level of output for this 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