Nothing Special   »   [go: up one dir, main page]

How To Link 3 Financial Statements: Financial Model

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 18

Year 1 Year 2 Year 3 Year 4

Revenue 4,260,000 6,272,700 8,430,972 10,745,549


source1 2,700,000 3,059,100 3,465,960 3,926,933
source2 1,560,000 3,213,600 4,965,012 6,818,616
source3 - - - -
source4 - - - -
COGS 966,000 1,239,090 1,536,289 1,859,942
source1 810,000 917,730 1,039,788 1,178,080
source2 156,000 321,360 496,501 681,862
source3 - - - -
source4 - - - -
GP 3,294,000 5,033,610 6,894,683 8,885,608
GP% 77% 80% 82% 83%

OPEX 7,300,000 2,350,000 2,400,000 1,950,000


A&P 2,000,000 1,000,000 1,000,000 1,000,000
Equipments - - - -
Buildings 5,000,000 1,000,000 1,000,000 500,000
Salary 150,000 200,000 250,000 300,000
Utilities 50,000 50,000 50,000 50,000
General 100,000 100,000 100,000 100,000
- - - -
Non-OPEX - - - -
Source1 - - - -
Source2 - - - -
EBITDA - 4,006,000 2,683,610 4,494,683 6,935,608
EBITDA% -94% 43% 53% 65%
Depriciation 300,000.0 350,000.0 400,000.0 450,000.0
Interest - - - -
EBIT - 4,306,000 2,333,610 4,094,683 6,485,608
EBIT% -101% 37% 49% 60%

PBT - 4,306,000 2,333,610 4,094,683 6,485,608


Tax - - 212,229 648,561
PAT - 4,306,000 2,333,610 3,882,454 5,837,047
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
- - - - - -
- - - - - -
2,212,661 2,416,522 2,644,783 2,900,609 3,187,582 3,509,758
1,334,765 1,512,288 1,713,423 1,941,308 2,199,502 2,492,035
877,897 904,234 931,361 959,302 988,081 1,017,723
- - - - - -
- - - - - -
11,015,522 11,666,777 12,380,233 13,163,433 14,024,897 14,974,257
83% 83% 82% 82% 81% 81%

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%

8,515,522 11,666,777 12,380,233 13,163,433 14,024,897 14,974,257


851,552 1,166,678 1,238,023 1,316,343 1,402,490 1,497,426
7,663,970 10,500,099 11,142,210 11,847,089 12,622,407 13,476,831
Year 1 Year 2 Year 3 Year 4
Revenue $ 4,260,000 $ 6,272,700 $ 8,430,972 $ 10,745,549
source1 $ 2,700,000 $ 3,059,100 $ 3,465,960 $ 3,926,933
source2 $ 1,560,000 $ 3,213,600 $ 4,965,012 $ 6,818,616
source3
source4

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%

Rentals source2 $ 1,560,000 $ 3,213,600 $ 4,965,012 $ 6,818,616


No of months 12 12 12 12
No of events/months 20 20 20 20
No of facilities 1 2 3 4
Av. hours. 10 10 10 10
Av. rev./hours $ 650 $ 670 $ 690 $ 710
Rev. Growth Rate 3% 3% 3%

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

$ 4,449,215 $ 5,040,961 $ 5,711,408 $ 6,471,026 $ 7,331,672 $ 8,306,785


12 12 12 12 12 12
22 24 27 29 32 35
$ 16,883 $ 17,389 $ 17,911 $ 18,448 $ 19,002 $ 19,572
3% 3% 3% 3% 3% 3%
10% 10% 10% 10% 10% 10%

$ 8,778,969 $ 9,042,338 $ 9,313,608 $ 9,593,016 $ 9,880,807 $ 10,177,231


12 12 12 12 12 12
20 20 20 20 20 20
5 5 5 5 5 5
10 10 10 10 10 10
$ 732 $ 754 $ 776 $ 799 $ 823 $ 848
3% 3% 3% 3% 3% 3%
Year 1 Year 2 Year 3 Year 4 Year 5
COGS 966,000 1,239,090 1,536,289 1,859,942 2,212,661
source1 810,000 917,730 1,039,788 1,178,080 1,334,765
source2 156,000 321,360 496,501 681,862 877,897
source3
source4

source1 30% 30% 30% 30% 30%


source2 10% 10% 10% 10% 10%
source3
source4
Year 6 Year 7 Year 8 Year 9 Year 10
2,416,522 2,644,783 2,900,609 3,187,582 3,509,758
1,512,288 1,713,423 1,941,308 2,199,502 2,492,035
904,234 931,361 959,302 988,081 1,017,723

30% 30% 30% 30% 30%


10% 10% 10% 10% 10%
Year 1 Year 2 Year 3 Year 4 Year 5
OPEX 7,300,000 2,350,000 2,400,000 1,950,000 2,000,000
5mn A&P 2,000,000 1,000,000 1,000,000 1,000,000 1,000,000
Equipments
8mn Buildings 5,000,000 1,000,000 1,000,000 500,000 500,000
2mn Salary 150,000 200,000 250,000 300,000 350,000
Utilities 50,000 50,000 50,000 50,000 50,000
General 100,000 100,000 100,000 100,000 100,000
Year 6 Year 7 Year 8 Year 9 Year 10
- - - - -
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
Non-OPEX - - - - - - -
Source1
Source2
Year 8 Year 9 Year 10
- - -
Year 1 Year 2 Year 3 Year 4
Depriciation 300,000 350,000 400,000 450,000
Interest

Assets 6,000,000 7,000,000 8,000,000 9,000,000


Rate of Depriciation 5% 5% 5% 5%
Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
500,000 - - - - -

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

Long term assets 6,000,000 7,000,000 8,000,000 9,000,000


PPE 6,000,000 7,000,000 8,000,000 9,000,000
Land
Lease

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

Working capital Adjustments -


Add -
Decrease in current Assests
Increase in liabilities
Less -
Increase in current Assests
Decrease in liabilities
Year 5 Year 6 Year 7 Year 8 Year 9 Year 10

You might also like