Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Calculate the NPV of a project that your company is considering. Use the assumptions in yellow. DCF Analysis NPV (in $1000's) 2013 2014 2015

2. Calculate the NPV of a project that your company is considering. Use the assumptions in yellow.
DCF Analysis NPV
(in $1000's)
2013 2014 2015 2016 2017 2018 2019 2020
Key Assumptions
Unit Sales 2000 4000 5700 6700 7450 3712 1816
Inflation Rate 2.0% 2.5% 3.0% 3.5% 4.0% 4.0% 4.0%
Cost of Capital 9.0% 9.2% 9.4% 9.6% 9.8% 10.0% 10.2%
Tax Rate 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0%
Discounting
Discount Rate = Cost of Capital 11.2%
Cumulative Discount Factor 11.2% 11.2%
Price or Cost / Unit
Sales / Unit $9.69
Variable Cost / Unit $7.86
Cash Fixed Costs $5,320
Cash Flow Forecasts
Sales
Variable Costs
Gross Margin
Cash Fixed Costs
Depreciation
Total Fixed Costs
Operating Profit
Taxes
Net Profit
Add Back Depreciation
Operating Cash Flow
Investment in Plant & Equipment ($10,826) $1,210
Cash Flows
PV of Annual Cash Flow
Net Present Value

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_2

Step: 3

blur-text-image_3

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

Financial Management Theory And Practice

Authors: Prasanna Chandra

10th Edition

9353166527, 978-9353166526

More Books

Students also viewed these Finance questions