Scribd
Upload
8 views4 pages

Five-Year Financial Projection Analysis

The document shows financial information for a company over 5 years including revenue, costs, expenses, earnings, taxes, assets, liabilities and cash flows. Revenue grew each year from $600,000 in year 1 to $988,727.04 in year 5 as units and prices increased. Costs also rose over time. After taxes, the cumulative net present value of free cash flows to the firm was $433,444.67.

Uploaded by

Test
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
8 views4 pages

Five-Year Financial Projection Analysis

The document shows financial information for a company over 5 years including revenue, costs, expenses, earnings, taxes, assets, liabilities and cash flows. Revenue grew each year from $600,000 in year 1 to $988,727.04 in year 5 as units and prices increased. Costs also rose over time. After taxes, the cumulative net present value of free cash flows to the firm was $433,444.67.

Uploaded by

Test
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Particulars Year 1 Year 2 Year 3 Year 4

Revenue Units 6,000.00 6,600.00 7,260.00 7,986.00


Selling Price Per Unit 100.00 103.00 106.09 109.27

Total Revenue 600,000.00 679,800.00 770,213.40 872,630.22

Material Cost Per Unit 20.00 20.60 21.22 21.85


COGS (Cost of Goods Sold) 120,000.00 135,960.00 154,057.20 174,494.10

D&A 20,000.00 20,000.00 20,000.00 20,000.00


Rent 50,000.00 51,500.00 53,045.00 54,636.00
Salaries 250,000.00 257,500.00 265,225.00 273,181.00
Marketing Expenses 100,000.00 103,000.00 106,090.00 109,273.00

EBIT 60,000.00 111,840.00 171,796.20 241,046.12


Net Operating PAT 36,000.00 67,104.00 103,077.72 144,627.67
D&A 20,000.00 20,000.00 20,000.00 20,000.00

Working Capital 60,000.00 67,980.00 77,021.34 87,263.02


Delta WC at 60,000 -7,980.00 -9,041.34 -10,241.68 -11,609.68

FCFF 48,020.00 78,062.66 112,836.04 153,017.99


Tax at 40% 24,000.00 44,736.00 68,718.48 96,418.45
Investment 100,000.00 100,000.00 100,000.00 100,000.00
Cumilative Depriciation 20,000.00 40,000.00 60,000.00 80,000.00
Net Assets 80,000.00 60,000.00 40,000.00 20,000.00

Funding :-
Equity 40,000.00 40,000.00 40,000.00 40,000.00
Debt 60,000.00 60,000.00 60,000.00 60,000.00

Interst Pay at 10% 6,000.00 6,000.00 6,000.00 6,000.00


Profit After Tax ( PAT ) 30,000.00 61,104.00 97,077.72 138,627.67
D&A 20,000.00 20,000.00 20,000.00 20,000.00
Delta WC at 60,000 -7,980.00 -9,041.34 -10,241.68 -11,609.68
Net Debt 60,000.00 - - -

FCFE 102,020.00 72,062.66 106,836.04 147,017.99


PVIF at 10% 0.9090909091 0.826446281 0.7513148009 0.6830134554
PV of Cash Inflow 92,745.45 59,555.92 80,267.50 100,415.27
PVIF - Present Value
Investment Factor
Year 5
8,784.00
112.56

988,727.04

22.50
197,640.00

20,000.00
56,275.00
281,377.00
112,551.00

320,884.04
192,530.42
20,000.00

98,872.70
98,872.70

311,403.13
128,353.62
100,000.00
100,000.00
-

40,000.00
60,000.00

6,000.00
186,530.42
20,000.00
98,872.70
-60,000.00

245,403.13
0.6209213231
152,376.03

You might also like