We are evaluating a project that costs 924000 has a fouryear

We are evaluating a project that costs $924,000, has a four-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 87,600 units per year. Price per unit is $34.55, variable cost per unit is $20.80, and fixed costs are $756,000 per year. The tax rate is 35 percent, and we require a return of 13 percent on this project.

Calculate the base-case operating cash flow and NPV. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

What is the sensitivity of NPV to changes in the sales figure? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.)

Sensitivity of NPV            $

If there is a 500-unit decrease in projected sales, how much would the NPV drop? (Input your answer as a positive value. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

NPV drop            $

What is the sensitivity of OCF to changes in the variable cost figure? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

Sensitivity of OCF            $

If there is $1 decrease in estimated variable costs, how much would the increase in OCF be? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

Increase in OCF

Solution

Answer a.

Initial Cost = $924,000
Life of Project = 4 years

Annual Depreciation = Initial Cost / Life of Project
Annual Depreciation = $924,000 / 4
Annual Depreciation = $231,000

Operating Cash Flow = [(Selling Price-Variable Cost)*Unit Sales - Fixed Costs]*(1-tax) + tax*Depreciation
Operating Cash Flow = [($34.55 - $20.80)*87,600 - $756,000]*(1 - 0.35) + 0.35 * $231,000
Operating Cash Flow = $448,500 * 0.65 + 0.35 * $231,000
Operating Cash Flow = $372,375

NPV = -$924,000 + $372,375 * PVA of $1 (13%, 4)
NPV = -$924,000 + $372,375 * (1 - (1/1.13)^4) / 0.13
NPV = -$924,000 + $372,375 * 2.97447
NPV = $183,618.27

Answer b.

If units sales decreased by 500 units:

Operating Cash Flow = [(Selling Price-Variable Cost)*Unit Sales - Fixed Costs]*(1-tax) + tax*Depreciation
Operating Cash Flow = [($34.55 - $20.80)*87,100 - $756,000]*(1 - 0.35) + 0.35 * $231,000
Operating Cash Flow = $441,625 * 0.65 + 0.35 * $231,000
Operating Cash Flow = $367,906.25

NPV = -$924,000 + $367,906.25 * PVA of $1 (13%, 4)
NPV = -$924,000 + $367,906.25 * (1 - (1/1.13)^4) / 0.13
NPV = -$924,000 + $367,906.25 * 2.97447
NPV = $170,326.10

Sensitivity of NPV = (New NPV - Old NPV) / (New Unit Sales - Old Unit Sales)
Sensitivity of NPV = ($170,326.10 - $183,618.27) / (87,100 - 87,600)
Sensitivity of NPV = $26.584

Answer c.

If sales drops by 500 units, then NPV will drop by $13,292.17 ($183,618.27 - $170,326.10)

Answer d.

If variable cost per unit decreased by $1.00 units:

Operating Cash Flow = [(Selling Price-Variable Cost)*Unit Sales - Fixed Costs]*(1-tax) + tax*Depreciation
Operating Cash Flow = [($34.55 - $19.80)*87,100 - $756,000]*(1 - 0.35) + 0.35 * $231,000
Operating Cash Flow = $528,725 * 0.65 + 0.35 * $231,000
Operating Cash Flow = $424,521.25

Sensitivity of OCF = (New OCF - Old OCF) / (New Variable cost per unit - Old Variable cost per unit)
Sensitivity of OCF = ($424,521.25 - $372,375) / ($19.80 - $20.80)
Sensitivity of OCF = -$52,146

Answer e.

Increase in OCF = New OCF - Old OCF
Increase in OCF = $424,521.25 - $372,375.00
Increase in OCF = $52,146