How To Link 3 Financial Statements: Financial Model
How To Link 3 Financial Statements: Financial Model
How To Link 3 Financial Statements: Financial Model
2,000,000 - - - - -
1,000,000 - - - - -
- - - - - -
500,000 - - - - -
350,000 - - - - -
50,000 - - - - -
100,000 - - - - -
- - - - - -
- - - - - -
- - - - - -
- - - - - -
9,015,522 11,666,777 12,380,233 13,163,433 14,024,897 14,974,257
68% 83% 82% 82% 81% 81%
500,000.0 - - - - -
- - - - - -
8,515,522 11,666,777 12,380,233 13,163,433 14,024,897 14,974,257
64% 83% 82% 82% 81% 81%
Factors
Projects source1 $ 2,700,000 $ 3,059,100 $ 3,465,960 $ 3,926,933
No of months 12 12 12 12
No of projects/month 15 17 18 20
Av. rev. $ 15,000 $ 15,450 $ 15,914 $ 16,391
Rev. Growth Rate 3% 3% 3%
Project Growth Rate 10% 10% 10%
source3
source4
Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
$ 13,228,184 $ 14,083,299 $ 15,025,016 $ 16,064,042 $ 17,212,479 $ 18,484,016
$ 4,449,215 $ 5,040,961 $ 5,711,408 $ 6,471,026 $ 7,331,672 $ 8,306,785
$ 8,778,969 $ 9,042,338 $ 9,313,608 $ 9,593,016 $ 9,880,807 $ 10,177,231
10,000,000 - - - - -
5% 5% 5% 5% 5% 5%
Year 1 Year 2 Year 3 Year 4 Year 5
Tax - 430,600 - 197,239 212,229 648,561 851,552
PBT - 4,306,000 2,333,610 4,094,683 6,485,608 8,515,522
Tax Rate 10% 10% 10% 10% 10%
Year 6 Year 7 Year 8 Year 9 Year 10
1,166,678 1,238,023 1,316,343 1,402,490 1,497,426
11,666,777 12,380,233 13,163,433 14,024,897 14,974,257
10% 10% 10% 10% 10%
Year 1 Year 2 Year 3 Year 4
Assets
Shot term assets
Cash
Receivable
Liability
Short term
Long term
Shareholder's Equity
Retained earnings
Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
10,000,000 - - - - -
10,000,000
Year 1 Year 2 Year 3 Year 4
Cash Flow From Operating activities - 4,306,000
Net Profit before tax - 4,306,000
Add -
Depreciation of Fixed Assets
Interest on borrowing
Less -
Interest Income
Dividend Income
One time gains