Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show your work, ANSWERS and formulas on excel screenshot. NO HARDCODED ANSWERS. ONLY EXCEL WORK. ONLY EXCEL SHEETS If no excel sheets, I'll rate

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

If no excel sheets, I'll rate negative, thank you so much!

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

Handbook Of Heavy Tailed Distributions In Finance

Authors: S.T Rachev

1st Edition

0444508961, 9780444508966

More Books

Students also viewed these Finance questions

Question

What is the Sharpe performance measure for portfolio Q? .P-96

Answered: 1 week ago

Question

12:29 PM @ .. AT&T AT&T Answered: 1 week ago

Answered: 1 week ago