Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show your work and formulas on excel. NO HARDCODED ANSWERS. ONLY EXCEL WORK For the problems 1-5, begin by assuming you have: Unit Sales:

Please show your work and formulas on excel. NO HARDCODED ANSWERS. ONLY EXCEL WORK

For the problems 1-5, begin by assuming you have: Unit Sales: 8275 Sales Growth Rate, years 1-4: 0.07 Inflation Rate: 0.02 Real Cost of Capital: 0.11 Tax Rate: 0.22 Sales Revenue / Unit: 10.79 Variable Cost / Unit: 7.23 Cash Fixed Costs: 8676 Investment: 50271.

Problem 1: What are the projected unit sales in year 7 if sales are expected to increase by 12% in year 5, and then decrease by 21% in years 6 and 7? "Problem 2: Assuming sales revenue per unit, variable cost per unit, and cash fixed costs all increase by the rate of inflation, what is your projected gross margin in year 7?"

Problem 3: What is the net present value of this project?

Problem 4: After you conduct your initial analysis, you discover that the firm has the option to abandon the project and sell its specialized equipment at the end of year 8 for $4189.25. What is the new NPV of the project?"

"Problem 5: Your boss is apprehensive about your worksheet and your estimation of this project's NP. THIS LOOKS LIKE A JOB FOR SOLVER, you blurt out, only to find out that your boss bought a bootleg version of Excel that does not include the add-in. By changing the unit sales of your existing model as it stands from the prior problem (i.e., assuming the option to abandon from #4 is exercised, basically DO NOT REVERT YOUR ANSWER BACK BEFORE COMPLETING THE PROBLEM), find the number of unit sales needed in year 1 to give you an NPV of zero.

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

Recent Advances In Computational Finance

Authors: Nikolaos S. Thomaidis, Jr. Dash, Gordon H.

1st Edition

1626181233, 978-1626181236

More Books

Students also viewed these Finance questions