O3 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 within +10 percent. Calculate the best-case and worst-case NPV figures.

O3 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 within +10 percent. Calculate the best-case and worst-case NPV figures.

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter10: Project Cash Flows And Risk

Section: Chapter Questions

Problem 17PROB

See similar textbooks

Similar questions

1We are evaluating a project that costs $864,000, has an eight-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 71,000 units per year. Price per unit is $49, variable cost per unit is $33, and fixed costs are $765,000 per year. The tax rate is 35%, and we require a 10% return on this project. urgent please answer!! will like
While evaluating a project that costs $2.58 million having 4 years life has no salvage value. Estimated sales at $1400000 per year, price per unit is 20$, variable cost per unit is 12.5$ and fixed cost $90,000 per year. The tax rate and the required rate of return is 18% and 11% respectively. 1- Find base CF 2-Find Base NPV 3-find NPV change for 300 unit decrease in projected sales
show all excel formulas/ work answering the following: LO2 27. Project Analysis You are considering a new product launch. The project will cost $780,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 $16,300, variable cost per unit will be $11,100, and fixed costs will be $535,000 per year. The required return on the project is 11 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 within +10 percent. What are the best and worst cases 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.
9 Estimates for a construction project appear in the following table: Dear optimistic most likely pessimistic Cost ($) 60,000 80,000 120,000 Annual profit ($) 16,000 15,000 13,500 Useful life (years) 10 10 10 Residual value ($) 0 0 0 a)Calculate the weighted average for costs and benefits, assigning 4 times more weight to the most probable estimate. b. Calculate the average internal rate of return. c)Weighted Average of Cost d)Weighted Average of Annual Profits e)Average internal rate of return
ASAP!! The most likely outcomes for a particular project are estimated as follows: Unit price: $50 Variable cost: $30 Fixed cost: $300,000 Expected sales: 30,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 12 percent higher or 12 percent lower than the initial estimate. The project will last for 5 years and requires an initial investment of $1 million, which will be depreciated straight-line over the project life to a final value of zero. The firm’s tax rate is 35 percent and the required rate of return is 12 percent. What is project NPV in the “best-case scenario,” that is, assuming all variables take on the best possible value? What about the worst-case scenario?
Please show work without excel You are considering a new product launch. The project will cost $1,022,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 400 units per year; price per unit will be $20,200, variable cost per unit will be $16,700, and fixed costs will be $338,000 per year. The required return on the project is 14 percent, and the relevant tax rate is 35 percent. 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 best- and worst-case OCFs and NPVs with these projections?
Sensitivity Analysis and Break-Even Point We are evaluating a project that costs $604,000, has an 8-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 55,000 units per year. Price per unit is $36, variable cost per unit is $17, and fixed costs are $685,000 per year. The tax rate is 21 percent and we require a return of 15 percent on this Calculate the accounting break-even point. 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. 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.
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)
Estimates for a construction project appear in the following table: Dear optimistic most likely pessimistic Cost ($) 60,000 80,000 120,000 Annual profit ($) 16,000 15,000 13,500 Useful life (years) 10 10 10 Residual value ($) 0 0 0 Calculate the weighted average for costs and benefits, assigning 4 times more weight to the most probable estimate. Calculate the average internal rate of return. a)Weighted Average of Cost b)Weighted Average of Annual Profits c)Average internal rate of return Submit calculations
show all excel formulas/ work answering the following: LO2 30. Calculating Required Savings A proposed cost-saving device has an installed cost of $565,000. The device will be used in a five- year project but is classified as three-year MACRS property for tax purposes. The required initial net working capital investment is $40,000, the tax rate is 23 percent, and the project discount rate is 12 percent. The device has an estimated Year 5 salvage value of $55,000. What level of pretax cost savings do we require for this project to be profitable?
You are considering an investment project with the following financial information: Required investment = $500,000 Project life = 5 years Salvage value = $50,000 Depreciation method = straight-line deprecation (no half-year convention) Unit price = $40 Unit variable cost = $18 Fixed annual cost = $230,000 Annual sales volume = 100,000 units Tax rate = 35% MARR = 15% The company is concerned about the price estimate they have used to calculate the rate of return. Using sensitivity analysis, how much can the price vary to still break-even? The company believes that their estimates for unit price, demand, variable cost, fixed cost, and salvage value are accurate to +/- 10%. Using scenario analysis compare the base case to the best-case and worst-case scenarios.
Tiffany Co. is analyzing two projects for the future. Assume that only one project can be selected. Project Y Project X Cost of machine P680,000 P600,000 Net cash flow: Year 1 240,000 40,000 Year 2 240,000 260,000 Year 3 240,000 260,000 Year 4 0 200,000 If the company is using the payback period method and it requires a payback of three years or less, which project should be selected? Group of answer choices Project Y. Project Y because it has a lower initial investment. Both X and Y are acceptable projects. Project X. Neither X nor Y is an acceptable project.