Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

We are evaluating a project that costs $1,160,000, has a life of 10 years, and has no salvage value. Assume that depreciation is straight-line to

We are evaluating a project that costs $1,160,000, has a life of 10 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 44,000 units per year. Price per unit is $45, variable cost per unit is $20, and fixed costs are $645,000 per year. The tax rate is 24 percent and we require a return of 13 percent on this project.

a.

Calculate the accounting break-even point. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

b-1. Calculate the base-case cash flow and NPV. (Do not round intermediate calculations and round your NPV answer to 2 decimal places, e.g., 32.16.)
b-2. 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.)
c.

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.)

***Please use excel and show your work. Thank you! I was having a hard time with the last part.

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

The Cyber Attack Survival Manual

Authors: Heather Vescent ,Nick Selby

1st Edition

1681886545, 978-1681886541

More Books

Students also viewed these Finance questions

Question

A bottle green sports jacket is hard to find.

Answered: 1 week ago