Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pleaae use excel and show the formulas PARTI: Suppose a firm is considering the following project (all figures in $ thousands): To undertake the project

image text in transcribed
pleaae use excel and show the formulas
PARTI: Suppose a firm is considering the following project (all figures in $ thousands): To undertake the project the firm will need to make a one-time investment of $137,500 in year 0. This specialized equipment can be depreciated using the straight-line method over the seven years, with a salvage value of $5,600 in year 7. Your sales and marketing team tell you that they estimate sales of 7,500 units in year 1, rising by roughly 35% per year through year 5, then declining by 45% each year through year 7. They assume the product is dead at that point, with 0 units demanded/sold in year 8. The inflation rate is forecast to be 1.5% in year 1, rising by a constant to 2.8% in year 5, then leveling off. The firm's real cost of capital is forecast to be 9.3% in year 1 and projected to increase by 2.5% each year through year 7. The tax rate is estimated to be a level 39%. Sales revenue per unit is expected to be $15.30 in year 1. Variable cost per unit is estimated at $10.20 in ye . 1. Cash fixed costs will be $17,940 in year 1. All will grow with inflation. What is the project NPV under these assumptions

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

Entrepreneurial Financial Management An Applied Approach

Authors: Jeffrey R Cornwall, David O Vang, Jean M Hartman

5th Edition

0367335417, 978-0367335410

More Books

Students also viewed these Finance questions