Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

We are evaluating a project that costs $915,000, has an 13-year life, and has no salvage value. Assume that depreciation is straight-line to zero over

We are evaluating a project that costs $915,000, has an 13-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 95,000 units per year. Price per unit is $42, variable cost per unit is $23, and fixed costs are $926,895 per year. The tax rate is 37 percent, and we require a 20 percent return on this project.

Requirement 1: Break-Even

(a) Calculate the accounting break-even point. (Do not round your intermediate calculations.)

(b) What is the degree of operating leverage at the accounting break-even point? (Do not round your intermediate calculations.)

Requirement 2: Base-Case & NPV Sensitivity

(a) Calculate the base-case operating cash flow. (Do not round your intermediate calculations.)

(b) Calculate the base-case NPV. (Do not round your intermediate calculations.)

(c) What is the sensitivity/elasticity of NPV to changes in the sales figure? Recall from your economics class that an elasticity measures a percentage change in one variable due to a percentage change in another. So simply increase sales quantity by 1 percent, calculate the new NPV, and then calculate the percentage change in the NPV. (Do not round your intermediate calculations.)

(d) Based on this sensitivity, what is the change in NPV (in dollars) if there is a 8 percent decrease in projected sales? (Do not round your intermediate calculations.)

Requirement 3: Sensitivity of OCF

(a) In addition to NPV, we can calculate the sensitivity of other things, such as OCF. What is the sensitivity of base-case OCF to changes in the variable cost? Estimate the sensitivity by increasing variable costs by 10%. (Do not round your intermediate calculations.)

(b) Based on this sensitivity, estimate the change in OCF (in dollars) given a 10% decrease in the variable costs? (Do not round your intermediate calculations.)

Can you show the formulas and breakdown of the problem in Excel? Thank you!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Unknown Market Wizards The Best Traders Youve Never Heard Of

Authors: Jack D. Schwager

1st Edition

0857198718, 978-0857198716

More Books

Students also viewed these Finance questions