Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10% 3% Years Unit sales forcast Price (grow with infl) COGS (grows with inflation) Forecast discount Discount rate Inflation Investment (Depreciated 5 year $

image text in transcribed

10% 3% Years Unit sales forcast Price (grow with infl) COGS (grows with inflation) Forecast discount Discount rate Inflation Investment (Depreciated 5 year $ 1 2 3 4 5 100 150 200 200 100 50 51.5 53.045 54.63635 56.2754405 40 41.2 42.436 43.70908 45.0203524 2,500.00 Starting in year 1 SGA % of sales 5% YEAR 1 2 3 4 Sales 5,000.0 7,725.0 10,609.0 10,927.3 5,627.5 COGS 4,000.0 6,180.0 8,487.2 8,741.8 4,502.0 Depr 500.0 500.0 500.0 500.0 500.0 Selling and admin 250.0 386.3 530.5 546.4 281.4 EBIT 250.0 658.8 1,091.4 1,139.1 344.1 Interest EBT 250.0 658.8 1,091.4 1,139.09 344.13 100.0 150.0 Tax Net income Investment (2,500.0) Net cash flow or free cash (2,500.0)| 650.0 895.3 1,154.8 1,183.45 706.48 263.5 436.5 455.64 137.65 395.3 654.8 683.45 206.48

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

Basic Finance An Introduction to Financial Institutions Investments and Management

Authors: Herbert B. Mayo

10th edition

1111820635, 978-1111820633

More Books

Students also viewed these Finance questions

Question

What are the possible sources of error in this project?

Answered: 1 week ago