Novattione Group LTD Financial Plan

Financ
Financial Plan
Particulars Year 1 Year 2 Year 3
Payroll Growth Rate 35.00% 35.00% 35.00%
Rent Growth Rate 10.00% 10.00% 10.00%
Marketing Growth Rate 20.00% 20.00% 20.00%
Other Expenses Growth Rate 5.00% 5.00%
Cost of Sales 40.00%
Income Tax Rate 25.00%
Year 4 Year 5
35.00% 35.00%
10.00% 10.00%
20.00% 20.00%
5.00% 5.00%
Monthly Depreciation Amount Dep. Rate Mon 1 Mon 2
Digital Assets £20,000 5% £83 £83
Furniture & Fixtures £15,000 5% £63 £63
Equipment £8,000 5% £33 £33
Motor Vehicles £12,000 5% £50 £50
Other Long-Term Assets £5,000 5% £21 £21
Total £60,000 - £250 £250
Additional Assets Year 2 Year 3 Year 4 Year 5

Digital Assets £0 £0 £0 £0
Furniture & Fixtures £0 £0 £0 £0
Equipment £0 £0 £0 £0
Motor Vehicles £0 £0 £0 £0
Other Long-Term Assets £0 £0 £0 £0
Total £0 £0 £0 £0
YEAR 1
Yearly Depreciation Cost Addition Total Cost Dep. Exp.
Digital Assets £20,000 £0 £20,000 £1,000
Furniture & Fixtures £15,000 £0 £15,000 £750
Equipment £8,000 £0 £8,000 £400
Motor Vehicles £12,000 £0 £12,000 £600
Other Long-Term Assets £5,000 £0 £5,000 £250
Total £60,000 £0 £60,000 £3,000
Depreciable Assets (Written Down Value) Mon 1 Mon 2

Digital Assets £19,917 £19,833
Furniture & Fixtures £14,938 £14,875
Equipment £7,967 £7,933
Motor Vehicles £11,950 £11,900
Other Long-Term Assets £4,979 £4,958
Total £59,750 £59,500
Mon 3 Mon 4 Mon 5 Mon 6 Mon 7 Mon 8
£83 £83 £83 £83 £83 £83
£63 £63 £63 £63 £63 £63
£33 £33 £33 £33 £33 £33
£50 £50 £50 £50 £50 £50
£21 £21 £21 £21 £21 £21
£250 £250 £250 £250 £250 £250
YEAR 2
Cum. Dep WDV Yearly Depreciation Cost
£1,000 £19,000 Digital Assets £20,000
£750 £14,250 Furniture & Fixtures £15,000
£400 £7,600 Equipment £8,000
£600 £11,400 Motor Vehicles £12,000
£250 £4,750 Other Long-Term Assets £5,000
£3,000 £57,000 Total £60,000

£19,750 £19,667 £19,583 £19,500 £19,417 £19,333
£14,813 £14,750 £14,688 £14,625 £14,563 £14,500
£7,900 £7,867 £7,833 £7,800 £7,767 £7,733
£11,850 £11,800 £11,750 £11,700 £11,650 £11,600
£4,938 £4,917 £4,896 £4,875 £4,854 £4,833
£59,250 £59,000 £58,750 £58,500 £58,250 £58,000
£83 £83 £83 £83 £83 £83
£63 £63 £63 £63 £63 £63
£33 £33 £33 £33 £33 £33
£50 £50 £50 £50 £50 £50
£21 £21 £21 £21 £21 £21
£250 £250 £250 £250 £250 £250
Addition Total Cost Dep. Exp. Cum. Dep WDV

£0 £20,000 £1,000 £2,000 £18,000
£0 £15,000 £750 £1,500 £13,500
£0 £8,000 £400 £800 £7,200
£0 £12,000 £600 £1,200 £10,800
£0 £5,000 £250 £500 £4,500
£0 £60,000 £3,000 £6,000 £54,000

£19,250 £19,167 £19,083 £19,000 £18,917 £18,833
£14,438 £14,375 £14,313 £14,250 £14,188 £14,125
£7,700 £7,667 £7,633 £7,600 £7,567 £7,533
£11,550 £11,500 £11,450 £11,400 £11,350 £11,300
£4,813 £4,792 £4,771 £4,750 £4,729 £4,708
£57,750 £57,500 £57,250 £57,000 £56,750 £56,500
£83 £83 £83 £83 £83 £83
£63 £63 £63 £63 £63 £63
£33 £33 £33 £33 £33 £33
£50 £50 £50 £50 £50 £50
£21 £21 £21 £21 £21 £21
£250 £250 £250 £250 £250 £250
YEAR 3
Digital Assets £20,000 £0 £20,000 £1,000
Equipment £8,000 £0 £8,000 £400
Motor Vehicles £12,000 £0 £12,000 £600
Total £60,000 £0 £60,000 £3,000

£18,750 £18,667 £18,583 £18,500 £18,417 £18,333
£14,063 £14,000 £13,938 £13,875 £13,813 £13,750
£7,500 £7,467 £7,433 £7,400 £7,367 £7,333
£11,250 £11,200 £11,150 £11,100 £11,050 £11,000
£4,688 £4,667 £4,646 £4,625 £4,604 £4,583
£56,250 £56,000 £55,750 £55,500 £55,250 £55,000
£83 £83 £83 £83 £83 £83
£63 £63 £63 £63 £63 £63
£33 £33 £33 £33 £33 £33
£50 £50 £50 £50 £50 £50
£21 £21 £21 £21 £21 £21
£250 £250 £250 £250 £250 £250
YEAR 4
Cum. Dep WDV Yearly Depreciation Cost
£3,000 £17,000 Digital Assets £20,000
£2,250 £12,750 Furniture & Fixtures £15,000
£1,200 £6,800 Equipment £8,000
£1,800 £10,200 Motor Vehicles £12,000
£750 £4,250 Other Long-Term Assets £5,000
£9,000 £51,000 Total £60,000

£18,250 £18,167 £18,083 £18,000 £17,917 £17,833
£13,688 £13,625 £13,563 £13,500 £13,438 £13,375
£7,300 £7,267 £7,233 £7,200 £7,167 £7,133
£10,950 £10,900 £10,850 £10,800 £10,750 £10,700
£4,563 £4,542 £4,521 £4,500 £4,479 £4,458
£54,750 £54,500 £54,250 £54,000 £53,750 £53,500
£83 £83 £83 £83 £83 £83
£63 £63 £63 £63 £63 £63
£33 £33 £33 £33 £33 £33
£50 £50 £50 £50 £50 £50
£21 £21 £21 £21 £21 £21
£250 £250 £250 £250 £250 £250
Addition Total Cost Dep. Exp. Cum. Dep WDV

£0 £20,000 £1,000 £4,000 £16,000
£0 £15,000 £750 £3,000 £12,000
£0 £8,000 £400 £1,600 £6,400
£0 £12,000 £600 £2,400 £9,600
£0 £5,000 £250 £1,000 £4,000
£0 £60,000 £3,000 £12,000 £48,000

£17,750 £17,667 £17,583 £17,500 £17,417 £17,333
£13,313 £13,250 £13,188 £13,125 £13,063 £13,000
£7,100 £7,067 £7,033 £7,000 £6,967 £6,933
£10,650 £10,600 £10,550 £10,500 £10,450 £10,400
£4,438 £4,417 £4,396 £4,375 £4,354 £4,333
£53,250 £53,000 £52,750 £52,500 £52,250 £52,000
£83 £83 £83 £83 £83 £83
£63 £63 £63 £63 £63 £63
£33 £33 £33 £33 £33 £33
£50 £50 £50 £50 £50 £50
£21 £21 £21 £21 £21 £21
£250 £250 £250 £250 £250 £250
YEAR 5
Digital Assets £20,000 £0 £20,000 £1,000
Equipment £8,000 £0 £8,000 £400
Motor Vehicles £12,000 £0 £12,000 £600
Total £60,000 £0 £60,000 £3,000

£17,250 £17,167 £17,083 £17,000 £16,917 £16,833
£12,938 £12,875 £12,813 £12,750 £12,688 £12,625
£6,900 £6,867 £6,833 £6,800 £6,767 £6,733
£10,350 £10,300 £10,250 £10,200 £10,150 £10,100
£4,313 £4,292 £4,271 £4,250 £4,229 £4,208
£51,750 £51,500 £51,250 £51,000 £50,750 £50,500
£83 £83 £83 £83 £83 £83
£63 £63 £63 £63 £63 £63
£33 £33 £33 £33 £33 £33
£50 £50 £50 £50 £50 £50
£21 £21 £21 £21 £21 £21
£250 £250 £250 £250 £250 £250
Cum. Dep WDV

£5,000 £15,000
£3,750 £11,250
£2,000 £6,000
£3,000 £9,000
£1,250 £3,750
£15,000 £45,000

£16,750 £16,667 £16,583 £16,500 £16,417 £16,333
£12,563 £12,500 £12,438 £12,375 £12,313 £12,250
£6,700 £6,667 £6,633 £6,600 £6,567 £6,533
£10,050 £10,000 £9,950 £9,900 £9,850 £9,800
£4,188 £4,167 £4,146 £4,125 £4,104 £4,083
£50,250 £50,000 £49,750 £49,500 £49,250 £49,000
£83 £83 £83 £83 £83 £83
£63 £63 £63 £63 £63 £63
£33 £33 £33 £33 £33 £33
£50 £50 £50 £50 £50 £50
£21 £21 £21 £21 £21 £21
£250 £250 £250 £250 £250 £250

£16,250 £16,167 £16,083 £16,000 £15,917 £15,833
£12,188 £12,125 £12,063 £12,000 £11,938 £11,875
£6,500 £6,467 £6,433 £6,400 £6,367 £6,333
£9,750 £9,700 £9,650 £9,600 £9,550 £9,500
£4,062 £4,042 £4,021 £4,000 £3,979 £3,958
£48,750 £48,500 £48,250 £48,000 £47,750 £47,500
£83 £83 £83 £83 £83 £83
£63 £63 £63 £63 £63 £63
£33 £33 £33 £33 £33 £33
£50 £50 £50 £50 £50 £50
£21 £21 £21 £21 £21 £21
£250 £250 £250 £250 £250 £250

£15,750 £15,667 £15,583 £15,500 £15,417 £15,333
£11,813 £11,750 £11,688 £11,625 £11,563 £11,500
£6,300 £6,267 £6,233 £6,200 £6,167 £6,133
£9,450 £9,400 £9,350 £9,300 £9,250 £9,200
£3,937 £3,917 £3,896 £3,875 £3,854 £3,833
£47,250 £47,000 £46,750 £46,500 £46,250 £46,000
Mon 57 Mon 58 Mon 59 Mon 60
£83 £83 £83 £83
£63 £63 £63 £63
£33 £33 £33 £33
£50 £50 £50 £50
£21 £21 £21 £21
£250 £250 £250 £250

£15,250 £15,167 £15,083 £15,000
£11,438 £11,375 £11,313 £11,250
£6,100 £6,067 £6,033 £6,000
£9,150 £9,100 £9,050 £9,000
£3,813 £3,792 £3,771 £3,750
£45,750 £45,500 £45,250 £45,000
Staff Payroll Plan Monthly Pay Monthly Pay Monthly Pay Monthly Pay
(Monthly) Year 1 Year 2 Year 3 Year 4
Owner £5,000 £6,750 £9,113 £12,302
Manager £3,500 £4,725 £6,379 £8,611
Misc. Staff £2,000 £2,700 £3,645 £4,921
Total £10,500 £14,175 £19,136 £25,834
Headcount Mon 1 Mon 2 Mon 3 Mon 4

Owner 0 0 0 0
Manager 1 1 1 1
Misc. Staff 10 10 10 10
Total 11 11 11 11
Payroll Plan Monthly Mon 1 Mon 2 Mon 3 Mon 4

Owner £0 £0 £0 £0
Manager £3,500 £3,500 £3,500 £3,500
Misc. Staff £20,000 £20,000 £20,000 £20,000
Total £23,500 £23,500 £23,500 £23,500
Payroll Plan Yearly Year 1 Year 2 Year 3 Year 4

Owner £0 £0 £0 £0
Manager £42,000 £56,700 £76,545 £103,336
Misc. Staff £240,000 £499,500 £874,800 £1,476,225
Total £282,000 £556,200 £951,345 £1,579,561
Monthly Pay
Year 5
£16,608
£11,625
£6,643
£34,876

0 0 0 0 0 0
1 1 1 1 1 1
10 10 10 10 10 10
11 11 11 11 11 11

£0 £0 £0 £0 £0 £0
£3,500 £3,500 £3,500 £3,500 £3,500 £3,500
£20,000 £20,000 £20,000 £20,000 £20,000 £20,000
£23,500 £23,500 £23,500 £23,500 £23,500 £23,500
Year 5
£0
£139,503
£2,391,485
£2,530,988
0 0 0 0 0 0
1 1 1 1 1 1
10 10 15 15 15 15
11 11 16 16 16 16

£0 £0 £0 £0 £0 £0
£3,500 £3,500 £4,725 £4,725 £4,725 £4,725
£20,000 £20,000 £40,500 £40,500 £40,500 £40,500
£23,500 £23,500 £45,225 £45,225 £45,225 £45,225
0 0 0 0 0 0
1 1 1 1 1 1
15 15 15 15 15 15
16 16 16 16 16 16

£0 £0 £0 £0 £0 £0
£4,725 £4,725 £4,725 £4,725 £4,725 £4,725
£40,500 £40,500 £40,500 £40,500 £40,500 £40,500
£45,225 £45,225 £45,225 £45,225 £45,225 £45,225
0 0 0 0 0 0
1 1 1 1 1 1
15 20 20 20 20 20
16 21 21 21 21 21

£0 £0 £0 £0 £0 £0
£4,725 £4,725 £6,379 £6,379 £6,379 £6,379
£40,500 £54,000 £72,900 £72,900 £72,900 £72,900
£45,225 £58,725 £79,279 £79,279 £79,279 £79,279
0 0 0 0 0 0
1 1 1 1 1 1
20 20 20 20 20 20
21 21 21 21 21 21

£0 £0 £0 £0 £0 £0
£6,379 £6,379 £6,379 £6,379 £6,379 £6,379
£72,900 £72,900 £72,900 £72,900 £72,900 £72,900
£79,279 £79,279 £79,279 £79,279 £79,279 £79,279
0 0 0 0 0 0
1 1 1 1 1 1
20 20 25 25 25 25
21 21 26 26 26 26

£0 £0 £0 £0 £0 £0
£6,379 £6,379 £8,611 £8,611 £8,611 £8,611
£72,900 £72,900 £123,019 £123,019 £123,019 £123,019
£79,279 £79,279 £131,630 £131,630 £131,630 £131,630
0 0 0 0 0 0
1 1 1 1 1 1
25 25 25 25 25 25
26 26 26 26 26 26

£0 £0 £0 £0 £0 £0
£8,611 £8,611 £8,611 £8,611 £8,611 £8,611
£123,019 £123,019 £123,019 £123,019 £123,019 £123,019
£131,630 £131,630 £131,630 £131,630 £131,630 £131,630
0 0 0 0 0 0
1 1 1 1 1 1
25 25 30 30 30 30
26 26 31 31 31 31

£0 £0 £0 £0 £0 £0
£8,611 £8,611 £11,625 £11,625 £11,625 £11,625
£123,019 £123,019 £199,290 £199,290 £199,290 £199,290
£131,630 £131,630 £210,916 £210,916 £210,916 £210,916
0 0 0 0 0 0
1 1 1 1 1 1
30 30 30 30 30 30
31 31 31 31 31 31

£0 £0 £0 £0 £0 £0
£11,625 £11,625 £11,625 £11,625 £11,625 £11,625
£199,290 £199,290 £199,290 £199,290 £199,290 £199,290
£210,916 £210,916 £210,916 £210,916 £210,916 £210,916
Mon 59 Mon 60
0 0
1 1
30 30
31 31
Mon 59 Mon 60
£0 £0
£11,625 £11,625
£199,290 £199,290
£210,916 £210,916
Loan Amount £500,000
Interest Rate 7.50%
nper 10 years
PMT £5,935
Monthly Loan Schedule Mon 1 Mon 2 Mon 3

Beginning Balance £500,000 £497,190 £494,362
Installment £5,935 £5,935 £5,935
Interest Payment £3,125 £3,107 £3,090
Principal Payment £2,810 £2,828 £2,845
Ending Balance £497,190 £494,362 £491,517
Yearly Loan Schedule Year 1 Year 2 Year 3

Beginning Balance £500,000 £465,095 £427,481
Installment £71,221 £71,221 £71,221
Interest Payment £36,316 £33,607 £30,686
Principal Payment £34,905 £37,614 £40,535
Ending Balance £465,095 £427,481 £386,946
Mon 4 Mon 5 Mon 6 Mon 7 Mon 8
£491,517 £488,654 £485,773 £482,874 £479,957
£5,935 £5,935 £5,935 £5,935 £5,935
£3,072 £3,054 £3,036 £3,018 £3,000
£2,863 £2,881 £2,899 £2,917 £2,935
£488,654 £485,773 £482,874 £479,957 £477,021
Year 4 Year 5 Year 6 Year 7

£386,946 £343,265 £296,192 £245,466
£71,221 £71,221 £71,221 £71,221
£27,540 £24,149 £20,494 £16,556
£43,681 £47,072 £50,727 £54,665
£343,265 £296,192 £245,466 £190,801
£477,021 £474,068 £471,095 £468,105 £465,095
£5,935 £5,935 £5,935 £5,935 £5,935
£2,981 £2,963 £2,944 £2,926 £2,907
£2,954 £2,972 £2,991 £3,009 £3,028
£474,068 £471,095 £468,105 £465,095 £462,067
£462,067 £459,020 £455,954 £452,868 £449,764
£5,935 £5,935 £5,935 £5,935 £5,935
£2,888 £2,869 £2,850 £2,830 £2,811
£3,047 £3,066 £3,085 £3,105 £3,124
£459,020 £455,954 £452,868 £449,764 £446,640
£446,640 £443,496 £440,333 £437,150 £433,947
£5,935 £5,935 £5,935 £5,935 £5,935
£2,791 £2,772 £2,752 £2,732 £2,712
£3,144 £3,163 £3,183 £3,203 £3,223
£443,496 £440,333 £437,150 £433,947 £430,724
£430,724 £427,481 £424,217 £420,934 £417,630
£5,935 £5,935 £5,935 £5,935 £5,935
£2,692 £2,672 £2,651 £2,631 £2,610
£3,243 £3,263 £3,284 £3,304 £3,325
£427,481 £424,217 £420,934 £417,630 £414,305
£414,305 £410,959 £407,592 £404,205 £400,796
£5,935 £5,935 £5,935 £5,935 £5,935
£2,589 £2,568 £2,547 £2,526 £2,505
£3,346 £3,367 £3,388 £3,409 £3,430
£410,959 £407,592 £404,205 £400,796 £397,366
£397,366 £393,914 £390,441 £386,946 £383,430
£5,935 £5,935 £5,935 £5,935 £5,935
£2,484 £2,462 £2,440 £2,418 £2,396
£3,452 £3,473 £3,495 £3,517 £3,539
£393,914 £390,441 £386,946 £383,430 £379,891
£379,891 £376,330 £372,747 £369,142 £365,514
£5,935 £5,935 £5,935 £5,935 £5,935
£2,374 £2,352 £2,330 £2,307 £2,284
£3,561 £3,583 £3,605 £3,628 £3,651
£376,330 £372,747 £369,142 £365,514 £361,863
£361,863 £358,190 £354,493 £350,774 £347,031
£5,935 £5,935 £5,935 £5,935 £5,935
£2,262 £2,239 £2,216 £2,192 £2,169
£3,673 £3,696 £3,720 £3,743 £3,766
£358,190 £354,493 £350,774 £347,031 £343,265
£343,265 £339,475 £335,662 £331,825 £327,963
£5,935 £5,935 £5,935 £5,935 £5,935
£2,145 £2,122 £2,098 £2,074 £2,050
£3,790 £3,813 £3,837 £3,861 £3,885
£339,475 £335,662 £331,825 £327,963 £324,078
£324,078 £320,169 £316,234 £312,276 £308,293 £304,284
£5,935 £5,935 £5,935 £5,935 £5,935 £5,935
£2,025 £2,001 £1,976 £1,952 £1,927 £1,902
£3,910 £3,934 £3,959 £3,983 £4,008 £4,033
£320,169 £316,234 £312,276 £308,293 £304,284 £300,251
£300,251 £296,192 £292,109 £287,999 £283,864
£5,935 £5,935 £5,935 £5,935 £5,935
£1,877 £1,851 £1,826 £1,800 £1,774
£4,059 £4,084 £4,109 £4,135 £4,161
£296,192 £292,109 £287,999 £283,864 £279,703
£279,703 £275,516 £271,303 £267,064 £262,798
£5,935 £5,935 £5,935 £5,935 £5,935
£1,748 £1,722 £1,696 £1,669 £1,642
£4,187 £4,213 £4,239 £4,266 £4,293
£275,516 £271,303 £267,064 £262,798 £258,505
£258,505 £254,186 £249,839 £245,466 £241,065
£5,935 £5,935 £5,935 £5,935 £5,935
£1,616 £1,589 £1,561 £1,534 £1,507
£4,319 £4,346 £4,374 £4,401 £4,428
£254,186 £249,839 £245,466 £241,065 £236,636
£236,636 £232,180 £227,696 £223,184 £218,644 £214,075
£5,935 £5,935 £5,935 £5,935 £5,935 £5,935
£1,479 £1,451 £1,423 £1,395 £1,367 £1,338
£4,456 £4,484 £4,512 £4,540 £4,569 £4,597
£232,180 £227,696 £223,184 £218,644 £214,075 £209,478
£209,478 £204,852 £200,198 £195,514
£5,935 £5,935 £5,935 £5,935
£1,309 £1,280 £1,251 £1,222
£4,626 £4,655 £4,684 £4,713
£204,852 £200,198 £195,514 £190,801
Costs Amount
Fixed Assets:
Digital Assets £20,000
Furniture & Fixtures £15,000
Equipment £8,000
Motor Vehicles £12,000
Other Long-Term Assets £5,000
Current Assets:
Cash (Working Capital) £319,000
Expenses:
Registration and Licenses £250
Legal Fees £500
Website Update £250
Marketing Budget £100,000
Miscellaneous and Unforeseen Costs £20,000
Assets to Fund £379,000

Expenses to Fund £121,000
Total Investment £500,000
Investment Breakup
Total Investment £500,000
Loan Investment £500,000

Capital Investment £0
Loan Investment % 100%

Capital Investment % 0%
Expenses Mon 1 Mon 2
Payroll £23,500 £23,500
Rent £530 £530
Sales & Marketing £65,675 £65,675
Supplies £450 £450
Travelling £700 £700
Miscellaneous Expenses £13,135 £13,135
Interest Expense £3,125 £3,107
Depreciation £250 £250
Total Expenses £107,365 £107,347
Expenses Year 1 Year 2

Payroll £282,000 £556,200
Rent £6,360 £6,996
Sales & Marketing £788,100 £1,063,935
Supplies £5,400 £5,670
Travelling £8,400 £8,820
Depreciation £3,000 £3,000
Total Expenses £1,287,196 £1,891,015

£23,500 £23,500 £23,500 £23,500 £23,500 £23,500
£530 £530 £530 £530 £530 £530
£65,675 £65,675 £65,675 £65,675 £65,675 £65,675
£450 £450 £450 £450 £450 £450
£700 £700 £700 £700 £700 £700
£13,135 £13,135 £13,135 £13,135 £13,135 £13,135
£3,090 £3,072 £3,054 £3,036 £3,018 £3,000
£250 £250 £250 £250 £250 £250
£107,330 £107,312 £107,294 £107,276 £107,258 £107,240
Year 3 Year 4 Year 5

£951,345 £1,579,561 £2,530,988
£7,696 £8,465 £9,312
£1,436,312 £1,939,022 £2,617,679
£5,954 £6,251 £6,564
£9,261 £9,724 £10,210
£287,262 £387,804 £523,536
£30,686 £27,540 £24,149
£3,000 £3,000 £3,000
£2,731,516 £3,961,367 £5,725,437

£23,500 £23,500 £23,500 £23,500 £45,225 £45,225
£530 £530 £530 £530 £583 £583
£65,675 £65,675 £65,675 £65,675 £88,661 £88,661
£450 £450 £450 £450 £473 £473
£700 £700 £700 £700 £735 £735
£13,135 £13,135 £13,135 £13,135 £17,732 £17,732
£2,981 £2,963 £2,944 £2,926 £2,907 £2,888
£250 £250 £250 £250 £250 £250
£107,221 £107,203 £107,184 £107,166 £156,566 £156,547

£45,225 £45,225 £45,225 £45,225 £45,225 £45,225
£583 £583 £583 £583 £583 £583
£88,661 £88,661 £88,661 £88,661 £88,661 £88,661
£473 £473 £473 £473 £473 £473
£735 £735 £735 £735 £735 £735
£17,732 £17,732 £17,732 £17,732 £17,732 £17,732
£2,869 £2,850 £2,830 £2,811 £2,791 £2,772
£250 £250 £250 £250 £250 £250
£156,528 £156,509 £156,489 £156,470 £156,450 £156,431

£45,225 £45,225 £45,225 £58,725 £79,279 £79,279
£583 £583 £583 £583 £641 £641
£88,661 £88,661 £88,661 £88,661 £119,693 £119,693
£473 £473 £473 £473 £496 £496
£735 £735 £735 £735 £772 £772
£17,732 £17,732 £17,732 £17,732 £23,939 £23,939
£2,752 £2,732 £2,712 £2,692 £2,672 £2,651
£250 £250 £250 £250 £250 £250
£156,411 £156,391 £156,371 £169,851 £227,741 £227,721

£79,279 £79,279 £79,279 £79,279 £79,279 £79,279
£641 £641 £641 £641 £641 £641
£119,693 £119,693 £119,693 £119,693 £119,693 £119,693
£496 £496 £496 £496 £496 £496
£772 £772 £772 £772 £772 £772
£23,939 £23,939 £23,939 £23,939 £23,939 £23,939
£2,631 £2,610 £2,589 £2,568 £2,547 £2,526
£250 £250 £250 £250 £250 £250
£227,700 £227,679 £227,659 £227,638 £227,617 £227,595

£79,279 £79,279 £79,279 £79,279 £131,630 £131,630
£641 £641 £641 £641 £705 £705
£119,693 £119,693 £119,693 £119,693 £161,585 £161,585
£496 £496 £496 £496 £521 £521
£772 £772 £772 £772 £810 £810
£23,939 £23,939 £23,939 £23,939 £32,317 £32,317
£2,505 £2,484 £2,462 £2,440 £2,418 £2,396
£250 £250 £250 £250 £250 £250
£227,574 £227,553 £227,531 £227,509 £330,237 £330,215

£131,630 £131,630 £131,630 £131,630 £131,630 £131,630
£705 £705 £705 £705 £705 £705
£161,585 £161,585 £161,585 £161,585 £161,585 £161,585
£521 £521 £521 £521 £521 £521
£810 £810 £810 £810 £810 £810
£32,317 £32,317 £32,317 £32,317 £32,317 £32,317
£2,374 £2,352 £2,330 £2,307 £2,284 £2,262
£250 £250 £250 £250 £250 £250
£330,193 £330,171 £330,149 £330,126 £330,103 £330,081

£131,630 £131,630 £131,630 £131,630 £210,916 £210,916
£705 £705 £705 £705 £776 £776
£161,585 £161,585 £161,585 £161,585 £218,140 £218,140
£521 £521 £521 £521 £547 £547
£810 £810 £810 £810 £851 £851
£32,317 £32,317 £32,317 £32,317 £43,628 £43,628
£2,239 £2,216 £2,192 £2,169 £2,145 £2,122
£250 £250 £250 £250 £250 £250
£330,058 £330,034 £330,011 £329,988 £477,253 £477,229

£210,916 £210,916 £210,916 £210,916 £210,916 £210,916
£776 £776 £776 £776 £776 £776
£218,140 £218,140 £218,140 £218,140 £218,140 £218,140
£547 £547 £547 £547 £547 £547
£851 £851 £851 £851 £851 £851
£43,628 £43,628 £43,628 £43,628 £43,628 £43,628
£2,098 £2,074 £2,050 £2,025 £2,001 £1,976
£250 £250 £250 £250 £250 £250
£477,205 £477,181 £477,157 £477,133 £477,108 £477,084

£210,916 £210,916 £210,916 £210,916
£776 £776 £776 £776
£218,140 £218,140 £218,140 £218,140
£547 £547 £547 £547
£851 £851 £851 £851
£43,628 £43,628 £43,628 £43,628
£1,952 £1,927 £1,902 £1,877
£250 £250 £250 £250
£477,059 £477,034 £477,009 £476,984

Revenue Inputs
VISA Sponsorship
Fee £10,000
No. of Clients 32
Other Services
Monthly Average Revenue £80,000
Revenue Details Mon 1 Mon 2

Visa Sponsorship
No. of Clients 32 32
Inflatable water park £320,000 £320,000
Other Websites Revenue
Dogzncat.com £125,000 £125,000
Novattione.com £310,000 £310,000
Bettingero.com £61,000 £61,000
Casinoslotguides.com £61,500 £61,500
Traveldealsweb.com £315,000 £315,000
Webdesignrise.com £121,000 £121,000
Total Revenue £1,313,500 £1,313,500

32 32 32 32 32 32
£320,000 £320,000 £320,000 £320,000 £320,000 £320,000
£125,000 £125,000 £125,000 £125,000 £125,000 £125,000

£310,000 £310,000 £310,000 £310,000 £310,000 £310,000
£61,000 £61,000 £61,000 £61,000 £61,000 £61,000
£61,500 £61,500 £61,500 £61,500 £61,500 £61,500
£315,000 £315,000 £315,000 £315,000 £315,000 £315,000
£121,000 £121,000 £121,000 £121,000 £121,000 £121,000
£1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500

32 32 32 32 43 43
£320,000 £320,000 £320,000 £320,000 £432,000 £432,000
£125,000 £125,000 £125,000 £125,000 £168,750 £168,750

£310,000 £310,000 £310,000 £310,000 £418,500 £418,500
£61,000 £61,000 £61,000 £61,000 £82,350 £82,350
£61,500 £61,500 £61,500 £61,500 £83,025 £83,025
£315,000 £315,000 £315,000 £315,000 £425,250 £425,250
£121,000 £121,000 £121,000 £121,000 £163,350 £163,350
£1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,773,225 £1,773,225

43 43 43 43 43 43
£432,000 £432,000 £432,000 £432,000 £432,000 £432,000
£168,750 £168,750 £168,750 £168,750 £168,750 £168,750

£418,500 £418,500 £418,500 £418,500 £418,500 £418,500
£82,350 £82,350 £82,350 £82,350 £82,350 £82,350
£83,025 £83,025 £83,025 £83,025 £83,025 £83,025
£425,250 £425,250 £425,250 £425,250 £425,250 £425,250
£163,350 £163,350 £163,350 £163,350 £163,350 £163,350
£1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225

43 43 43 43 58 58
£432,000 £432,000 £432,000 £432,000 £583,200 £583,200
£168,750 £168,750 £168,750 £168,750 £227,813 £227,813

£418,500 £418,500 £418,500 £418,500 £564,975 £564,975
£82,350 £82,350 £82,350 £82,350 £111,173 £111,173
£83,025 £83,025 £83,025 £83,025 £112,084 £112,084
£425,250 £425,250 £425,250 £425,250 £574,088 £574,088
£163,350 £163,350 £163,350 £163,350 £220,523 £220,523
£1,773,225 £1,773,225 £1,773,225 £1,773,225 £2,393,854 £2,393,854

58 58 58 58 58 58
£583,200 £583,200 £583,200 £583,200 £583,200 £583,200
£227,813 £227,813 £227,813 £227,813 £227,813 £227,813

£564,975 £564,975 £564,975 £564,975 £564,975 £564,975
£111,173 £111,173 £111,173 £111,173 £111,173 £111,173
£112,084 £112,084 £112,084 £112,084 £112,084 £112,084
£574,088 £574,088 £574,088 £574,088 £574,088 £574,088
£220,523 £220,523 £220,523 £220,523 £220,523 £220,523
£2,393,854 £2,393,854 £2,393,854 £2,393,854 £2,393,854 £2,393,854

58 58 58 58 79 79
£583,200 £583,200 £583,200 £583,200 £787,320 £787,320
£227,813 £227,813 £227,813 £227,813 £307,547 £307,547

£564,975 £564,975 £564,975 £564,975 £762,716 £762,716
£111,173 £111,173 £111,173 £111,173 £150,083 £150,083
£112,084 £112,084 £112,084 £112,084 £151,313 £151,313
£574,088 £574,088 £574,088 £574,088 £775,018 £775,018
£220,523 £220,523 £220,523 £220,523 £297,705 £297,705
£2,393,854 £2,393,854 £2,393,854 £2,393,854 £3,231,703 £3,231,703

79 79 79 79 79 79
£787,320 £787,320 £787,320 £787,320 £787,320 £787,320
£307,547 £307,547 £307,547 £307,547 £307,547 £307,547

£762,716 £762,716 £762,716 £762,716 £762,716 £762,716
£150,083 £150,083 £150,083 £150,083 £150,083 £150,083
£151,313 £151,313 £151,313 £151,313 £151,313 £151,313
£775,018 £775,018 £775,018 £775,018 £775,018 £775,018
£297,705 £297,705 £297,705 £297,705 £297,705 £297,705
£3,231,703 £3,231,703 £3,231,703 £3,231,703 £3,231,703 £3,231,703

79 79 79 79 106 106
£787,320 £787,320 £787,320 £787,320 £1,062,882 £1,062,882
£307,547 £307,547 £307,547 £307,547 £415,188 £415,188

£762,716 £762,716 £762,716 £762,716 £1,029,667 £1,029,667
£150,083 £150,083 £150,083 £150,083 £202,612 £202,612
£151,313 £151,313 £151,313 £151,313 £204,273 £204,273
£775,018 £775,018 £775,018 £775,018 £1,046,274 £1,046,274
£297,705 £297,705 £297,705 £297,705 £401,902 £401,902
£3,231,703 £3,231,703 £3,231,703 £3,231,703 £4,362,798 £4,362,798

106 106 106 106 106 106

£1,062,882 £1,062,882 £1,062,882 £1,062,882 £1,062,882 £1,062,882
£415,188 £415,188 £415,188 £415,188 £415,188 £415,188

£1,029,667 £1,029,667 £1,029,667 £1,029,667 £1,029,667 £1,029,667
£202,612 £202,612 £202,612 £202,612 £202,612 £202,612
£204,273 £204,273 £204,273 £204,273 £204,273 £204,273
£1,046,274 £1,046,274 £1,046,274 £1,046,274 £1,046,274 £1,046,274
£401,902 £401,902 £401,902 £401,902 £401,902 £401,902
£4,362,798 £4,362,798 £4,362,798 £4,362,798 £4,362,798 £4,362,798

106 106 106 106

£1,062,882 £1,062,882 £1,062,882 £1,062,882
£415,188 £415,188 £415,188 £415,188

£1,029,667 £1,029,667 £1,029,667 £1,029,667
£202,612 £202,612 £202,612 £202,612
£204,273 £204,273 £204,273 £204,273
£1,046,274 £1,046,274 £1,046,274 £1,046,274
£401,902 £401,902 £401,902 £401,902
£4,362,798 £4,362,798 £4,362,798 £4,362,798

Pro Forma Profit and Loss Year 1 Year 2
Total Revenue £15,762,000 £21,278,700
Cost of Sales £6,304,800 £8,511,480
Gross Profit £9,457,200 £12,767,220
Initial Expenses £121,000 £0
Operating Expenses:
Payroll £282,000 £556,200
Sales & Marketing £788,100 £1,063,935
Rent £6,360 £6,996
Supplies £5,400 £5,670
Total Expenses £1,368,880 £1,854,408
EBITDA £8,088,320 £10,912,812
EBTDA £8,052,004 £10,879,205
Depreciation £3,000 £3,000
Earnings before Tax (EBT) £8,049,004 £10,876,205
Tax £2,012,251 £2,719,051
Net Income / (Loss) £6,036,753 £8,157,154
Net Income/Revenue 38.30% 38.33%

£28,726,245 £38,780,431 £52,353,582
£11,490,498 £15,512,172 £20,941,433
£17,235,747 £23,268,258 £31,412,149
£0 £0 £0 ** EBITDA = Earnings before Interest, Tax and Deprecia

** EBIT = Earnings before Interest and Tax
** EBT = Earnings before Tax
£951,345 £1,579,561 £2,530,988
£1,436,312 £1,939,022 £2,617,679
£7,696 £8,465 £9,312
£5,954 £6,251 £6,564
£9,261 £9,724 £10,210
£287,262 £387,804 £523,536
£2,697,830 £3,930,827 £5,698,288
£14,537,917 £19,337,431 £25,713,861
£30,686 £27,540 £24,149
£14,507,231 £19,309,892 £25,689,712
£3,000 £3,000 £3,000
£14,504,231 £19,306,892 £25,686,712
£3,626,058 £4,826,723 £6,421,678
£10,878,173 £14,480,169 £19,265,034
37.87% 37.34% 36.80%

ore Interest, Tax and Depreciation Allowance
Interest and Tax
Assets and Liabilities Year 1 Year 2
Non-Current Assets
Digital Assets £19,000 £18,000
Furniture & Fixtures £14,250 £13,500
Equipment £7,600 £7,200
Motor Vehicles £11,400 £10,800
Other Long-Term Assets £4,750 £4,500
Current Assets
Cash £6,444,848 £14,567,388
Total Assets £6,501,848 £14,621,388

LIABILITIES AND EQUITY:
LIABILITIES
Accounts Payable
Loan £465,095 £427,481
Total Liabilities £465,095 £427,481
EQUITY
Capital £0 £0
Retained Earnings £0 £6,036,753
Profit or loss balance £6,036,753 £8,157,154
TOTAL EQUITY £6,036,753 £14,193,907
TOTAL LIABILITIES AND EQUITY £6,501,848 £14,621,388
£0 £0
£17,000 £16,000 £15,000

£12,750 £12,000 £11,250
£6,800 £6,400 £6,000
£10,200 £9,600 £9,000
£4,250 £4,000 £3,750
£25,408,026 £39,847,514 £59,068,475
£25,459,026 £39,895,514 £59,113,475
£386,946 £343,265 £296,192

£386,946 £343,265 £296,192
£0 £0 £0
£14,193,907 £25,072,080 £39,552,249
£10,878,173 £14,480,169 £19,265,034
£25,072,080 £39,552,249 £58,817,283
£25,459,026 £39,895,514 £59,113,475
£0 £0 £0
Particulars Year 1 Year 2 Year 3
Sales-Revenue £15,762,000 £21,278,700 £28,726,245
Variable Cost £2,800,351 £3,782,986 £5,062,370
Contribution £12,961,649 £17,495,714 £23,663,875

Contribution Margin 82.23% 82.22% 82.38%
Fixed Cost:
Total Selling General and Admin Expenses £577,780 £787,473 £1,258,518
Total Fixed Cost £577,780 £787,473 £1,258,518
Break Even Sales £702,609 £957,743 £1,527,750

Year 4 Year 5
£38,780,431 £52,353,582
£6,765,744 £9,039,357
£32,014,686 £43,314,224
82.55% 82.73%
£1,988,805 £3,077,609
£1,988,805 £3,077,609
£2,409,105 £3,719,883
Particulars Year 1 Year 2
Cash Inflows:
Sales Revenue £15,762,000 £21,278,700
Capital and Loan Proceeds £500,000 £0
Total Inflows £16,262,000 £21,278,700
Cash Outflows:
Initial Expenses £121,000 £0
Cost of Sales £6,304,800 £8,511,480
Payroll £282,000 £556,200
Sales & Marketing £788,100 £1,063,935
Rent £6,360 £6,996
Supplies £5,400 £5,670
Tax Paid £2,012,251 £2,719,051
Purchase of Assets £60,000 £0
Loan Repayment £71,221 £71,221
Total Outflows £9,817,152 £13,156,160
Net Cash generated £6,444,848 £8,122,540
Opening Cash Balance £0 £6,444,848

Ending Cash Balance £6,444,848 £14,567,388
£0 £0
£28,726,245 £38,780,431 £52,353,582

£0 £0 £0
£28,726,245 £38,780,431 £52,353,582
£0 £0 £0
£11,490,498 £15,512,172 £20,941,433
£951,345 £1,579,561 £2,530,988
£1,436,312 £1,939,022 £2,617,679
£7,696 £8,465 £9,312
£5,954 £6,251 £6,564
£9,261 £9,724 £10,210
£287,262 £387,804 £523,536
£3,626,058 £4,826,723 £6,421,678
£0 £0 £0
£71,221 £71,221 £71,221
£17,885,607 £24,340,943 £33,132,620
£10,840,638 £14,439,487 £19,220,962
£14,567,388 £25,408,026 £39,847,514

£25,408,026 £39,847,514 £59,068,475
£0 £0 £0
Pro Forma Profit and Loss Mon 1 Mon 2 Mon 3
Total Revenue £1,313,500 £1,313,500 £1,313,500
Cost of Sales £525,400 £525,400 £525,400
Gross Profit £788,100 £788,100 £788,100
Initial Expenses £121,000 £0 £0
Operating Expenses:
Payroll £23,500 £23,500 £23,500
Sales & Marketing £65,675 £65,675 £65,675
Rent £530 £530 £530
Supplies £450 £450 £450
Travelling £700 £700 £700
Miscellaneous Expenses £13,135 £13,135 £13,135
Total Expenses £224,990 £103,990 £103,990
EBITDA £563,110 £684,110 £684,110
Interest Expense £3,125 £3,107 £3,090
EBTDA £559,985 £681,003 £681,020
Depreciation £250 £250 £250
Earnings before Tax (EBT) £559,735 £680,753 £680,770
Tax £167,688 £167,688 £167,688
Net Income / (Loss) £392,047 £513,065 £513,083
Net Income/Revenue 29.85% 39.06% 39.06%

£1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500
£525,400 £525,400 £525,400 £525,400 £525,400 £525,400
£788,100 £788,100 £788,100 £788,100 £788,100 £788,100
£0 £0 £0 £0 £0 £0
£23,500 £23,500 £23,500 £23,500 £23,500 £23,500

£65,675 £65,675 £65,675 £65,675 £65,675 £65,675
£530 £530 £530 £530 £530 £530
£450 £450 £450 £450 £450 £450
£700 £700 £700 £700 £700 £700
£13,135 £13,135 £13,135 £13,135 £13,135 £13,135
£103,990 £103,990 £103,990 £103,990 £103,990 £103,990
£684,110 £684,110 £684,110 £684,110 £684,110 £684,110
£3,072 £3,054 £3,036 £3,018 £3,000 £2,981
£681,038 £681,056 £681,074 £681,092 £681,110 £681,129
£250 £250 £250 £250 £250 £250
£680,788 £680,806 £680,824 £680,842 £680,860 £680,879
£167,688 £167,688 £167,688 £167,688 £167,688 £167,688
£513,100 £513,118 £513,136 £513,154 £513,173 £513,191
39.06% 39.06% 39.07% 39.07% 39.07% 39.07%

£1,313,500 £1,313,500 £1,313,500 £1,773,225 £1,773,225 £1,773,225
£525,400 £525,400 £525,400 £709,290 £709,290 £709,290
£788,100 £788,100 £788,100 £1,063,935 £1,063,935 £1,063,935
£0 £0 £0 £0 £0 £0
£23,500 £23,500 £23,500 £45,225 £45,225 £45,225

£65,675 £65,675 £65,675 £88,661 £88,661 £88,661
£530 £530 £530 £583 £583 £583
£450 £450 £450 £473 £473 £473
£700 £700 £700 £735 £735 £735
£13,135 £13,135 £13,135 £17,732 £17,732 £17,732
£103,990 £103,990 £103,990 £153,409 £153,409 £153,409
£684,110 £684,110 £684,110 £910,526 £910,526 £910,526
£2,963 £2,944 £2,926 £2,907 £2,888 £2,869
£681,147 £681,166 £681,184 £907,619 £907,638 £907,657
£250 £250 £250 £250 £250 £250
£680,897 £680,916 £680,934 £907,369 £907,388 £907,407
£167,688 £167,688 £167,688 £226,588 £226,588 £226,588
£513,210 £513,228 £513,247 £680,782 £680,800 £680,820
39.07% 39.07% 39.07% 38.39% 38.39% 38.39%

£1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225
£709,290 £709,290 £709,290 £709,290 £709,290 £709,290
£1,063,935 £1,063,935 £1,063,935 £1,063,935 £1,063,935 £1,063,935
£0 £0 £0 £0 £0 £0
£45,225 £45,225 £45,225 £45,225 £45,225 £45,225

£88,661 £88,661 £88,661 £88,661 £88,661 £88,661
£583 £583 £583 £583 £583 £583
£473 £473 £473 £473 £473 £473
£735 £735 £735 £735 £735 £735
£17,732 £17,732 £17,732 £17,732 £17,732 £17,732
£153,409 £153,409 £153,409 £153,409 £153,409 £153,409
£910,526 £910,526 £910,526 £910,526 £910,526 £910,526
£2,850 £2,830 £2,811 £2,791 £2,772 £2,752
£907,676 £907,696 £907,715 £907,735 £907,754 £907,774
£250 £250 £250 £250 £250 £250
£907,426 £907,446 £907,465 £907,485 £907,504 £907,524
£226,588 £226,588 £226,588 £226,588 £226,588 £226,588
£680,839 £680,858 £680,877 £680,897 £680,917 £680,936
38.40% 38.40% 38.40% 38.40% 38.40% 38.40%

£1,773,225 £1,773,225 £1,773,225 £2,393,854 £2,393,854 £2,393,854
£709,290 £709,290 £709,290 £957,542 £957,542 £957,542
£1,063,935 £1,063,935 £1,063,935 £1,436,312 £1,436,312 £1,436,312
£0 £0 £0 £0 £0 £0
£45,225 £45,225 £58,725 £79,279 £79,279 £79,279

£88,661 £88,661 £88,661 £119,693 £119,693 £119,693
£583 £583 £583 £641 £641 £641
£473 £473 £473 £496 £496 £496
£735 £735 £735 £772 £772 £772
£17,732 £17,732 £17,732 £23,939 £23,939 £23,939
£153,409 £153,409 £166,909 £224,819 £224,819 £224,819
£910,526 £910,526 £897,026 £1,211,493 £1,211,493 £1,211,493
£2,732 £2,712 £2,692 £2,672 £2,651 £2,631
£907,794 £907,814 £894,334 £1,208,821 £1,208,842 £1,208,862
£250 £250 £250 £250 £250 £250
£907,544 £907,564 £894,084 £1,208,571 £1,208,592 £1,208,612
£226,588 £226,588 £226,588 £302,171 £302,171 £302,171
£680,956 £680,976 £667,496 £906,400 £906,420 £906,441
38.40% 38.40% 37.64% 37.86% 37.86% 37.87%

£2,393,854 £2,393,854 £2,393,854 £2,393,854 £2,393,854 £2,393,854
£957,542 £957,542 £957,542 £957,542 £957,542 £957,542
£1,436,312 £1,436,312 £1,436,312 £1,436,312 £1,436,312 £1,436,312
£0 £0 £0 £0 £0 £0
£79,279 £79,279 £79,279 £79,279 £79,279 £79,279

£119,693 £119,693 £119,693 £119,693 £119,693 £119,693
£641 £641 £641 £641 £641 £641
£496 £496 £496 £496 £496 £496
£772 £772 £772 £772 £772 £772
£23,939 £23,939 £23,939 £23,939 £23,939 £23,939
£224,819 £224,819 £224,819 £224,819 £224,819 £224,819
£1,211,493 £1,211,493 £1,211,493 £1,211,493 £1,211,493 £1,211,493
£2,610 £2,589 £2,568 £2,547 £2,526 £2,505
£1,208,883 £1,208,904 £1,208,925 £1,208,946 £1,208,967 £1,208,988
£250 £250 £250 £250 £250 £250
£1,208,633 £1,208,654 £1,208,675 £1,208,696 £1,208,717 £1,208,738
£302,171 £302,171 £302,171 £302,171 £302,171 £302,171
£906,461 £906,482 £906,503 £906,524 £906,545 £906,567
37.87% 37.87% 37.87% 37.87% 37.87% 37.87%

£2,393,854 £2,393,854 £2,393,854 £3,231,703 £3,231,703 £3,231,703
£957,542 £957,542 £957,542 £1,292,681 £1,292,681 £1,292,681
£1,436,312 £1,436,312 £1,436,312 £1,939,022 £1,939,022 £1,939,022
£0 £0 £0 £0 £0 £0
£79,279 £79,279 £79,279 £131,630 £131,630 £131,630

£119,693 £119,693 £119,693 £161,585 £161,585 £161,585
£641 £641 £641 £705 £705 £705
£496 £496 £496 £521 £521 £521
£772 £772 £772 £810 £810 £810
£23,939 £23,939 £23,939 £32,317 £32,317 £32,317
£224,819 £224,819 £224,819 £327,569 £327,569 £327,569
£1,211,493 £1,211,493 £1,211,493 £1,611,453 £1,611,453 £1,611,453
£2,484 £2,462 £2,440 £2,418 £2,396 £2,374
£1,209,010 £1,209,031 £1,209,053 £1,609,034 £1,609,056 £1,609,078
£250 £250 £250 £250 £250 £250
£1,208,760 £1,208,781 £1,208,803 £1,608,784 £1,608,806 £1,608,828
£302,171 £302,171 £302,171 £402,227 £402,227 £402,227
£906,588 £906,610 £906,631 £1,206,557 £1,206,579 £1,206,601
37.87% 37.87% 37.87% 37.34% 37.34% 37.34%

£3,231,703 £3,231,703 £3,231,703 £3,231,703 £3,231,703
£1,292,681 £1,292,681 £1,292,681 £1,292,681 £1,292,681
£1,939,022 £1,939,022 £1,939,022 £1,939,022 £1,939,022
£0 £0 £0 £0 £0
£131,630 £131,630 £131,630 £131,630 £131,630

£161,585 £161,585 £161,585 £161,585 £161,585
£705 £705 £705 £705 £705
£521 £521 £521 £521 £521
£810 £810 £810 £810 £810
£32,317 £32,317 £32,317 £32,317 £32,317
£327,569 £327,569 £327,569 £327,569 £327,569
£1,611,453 £1,611,453 £1,611,453 £1,611,453 £1,611,453
£2,352 £2,330 £2,307 £2,284 £2,262
£1,609,101 £1,609,123 £1,609,145 £1,609,168 £1,609,191
£250 £250 £250 £250 £250
£1,608,851 £1,608,873 £1,608,895 £1,608,918 £1,608,941
£402,227 £402,227 £402,227 £402,227 £402,227
£1,206,624 £1,206,646 £1,206,669 £1,206,691 £1,206,714
37.34% 37.34% 37.34% 37.34% 37.34%

£3,231,703 £3,231,703 £3,231,703 £3,231,703 £4,362,798
£1,292,681 £1,292,681 £1,292,681 £1,292,681 £1,745,119
£1,939,022 £1,939,022 £1,939,022 £1,939,022 £2,617,679
£0 £0 £0 £0 £0
£131,630 £131,630 £131,630 £131,630 £210,916

£161,585 £161,585 £161,585 £161,585 £218,140
£705 £705 £705 £705 £776
£521 £521 £521 £521 £547
£810 £810 £810 £810 £851
£32,317 £32,317 £32,317 £32,317 £43,628
£327,569 £327,569 £327,569 £327,569 £474,857
£1,611,453 £1,611,453 £1,611,453 £1,611,453 £2,142,822
£2,239 £2,216 £2,192 £2,169 £2,145
£1,609,214 £1,609,237 £1,609,260 £1,609,284 £2,140,676
£250 £250 £250 £250 £250
£1,608,964 £1,608,987 £1,609,010 £1,609,034 £2,140,426
£402,227 £402,227 £402,227 £402,227 £535,140
£1,206,737 £1,206,760 £1,206,783 £1,206,807 £1,605,286
37.34% 37.34% 37.34% 37.34% 36.79%

£4,362,798 £4,362,798 £4,362,798 £4,362,798 £4,362,798
£1,745,119 £1,745,119 £1,745,119 £1,745,119 £1,745,119
£2,617,679 £2,617,679 £2,617,679 £2,617,679 £2,617,679
£0 £0 £0 £0 £0
£210,916 £210,916 £210,916 £210,916 £210,916

£218,140 £218,140 £218,140 £218,140 £218,140
£776 £776 £776 £776 £776
£547 £547 £547 £547 £547
£851 £851 £851 £851 £851
£43,628 £43,628 £43,628 £43,628 £43,628
£474,857 £474,857 £474,857 £474,857 £474,857
£2,142,822 £2,142,822 £2,142,822 £2,142,822 £2,142,822
£2,122 £2,098 £2,074 £2,050 £2,025
£2,140,700 £2,140,724 £2,140,748 £2,140,772 £2,140,796
£250 £250 £250 £250 £250
£2,140,450 £2,140,474 £2,140,498 £2,140,522 £2,140,546
£535,140 £535,140 £535,140 £535,140 £535,140
£1,605,310 £1,605,334 £1,605,358 £1,605,382 £1,605,406
36.80% 36.80% 36.80% 36.80% 36.80%

£4,362,798 £4,362,798 £4,362,798 £4,362,798 £4,362,798
£1,745,119 £1,745,119 £1,745,119 £1,745,119 £1,745,119
£2,617,679 £2,617,679 £2,617,679 £2,617,679 £2,617,679
£0 £0 £0 £0 £0
£210,916 £210,916 £210,916 £210,916 £210,916

£218,140 £218,140 £218,140 £218,140 £218,140
£776 £776 £776 £776 £776
£547 £547 £547 £547 £547
£851 £851 £851 £851 £851
£43,628 £43,628 £43,628 £43,628 £43,628
£474,857 £474,857 £474,857 £474,857 £474,857
£2,142,822 £2,142,822 £2,142,822 £2,142,822 £2,142,822
£2,001 £1,976 £1,952 £1,927 £1,902
£2,140,821 £2,140,845 £2,140,870 £2,140,895 £2,140,920
£250 £250 £250 £250 £250
£2,140,571 £2,140,595 £2,140,620 £2,140,645 £2,140,670
£535,140 £535,140 £535,140 £535,140 £535,140
£1,605,431 £1,605,455 £1,605,480 £1,605,505 £1,605,530
36.80% 36.80% 36.80% 36.80% 36.80%

Mon 60
£4,362,798
£1,745,119
£2,617,679
£0
£210,916
£218,140
£776
£547
£851
£43,628
£474,857
£2,142,822
£1,877
£2,140,945
£250
£2,140,695
£535,140
£1,605,555
36.80%
Assets and Liabilities Mon 1 Mon 2 Mon 3
Non-Current Assets
Digital Assets £19,917 £19,833 £19,750
Furniture & Fixtures £14,938 £14,875 £14,813
Equipment £7,967 £7,933 £7,900
Motor Vehicles £11,950 £11,900 £11,850
Other Long-Term Assets £4,979 £4,958 £4,938
Current Assets
Cash £829,487 £1,339,975 £1,850,462
Total Assets £889,237 £1,399,475 £1,909,712

LIABILITIES AND EQUITY:
LIABILITIES
Accounts Payable
Loan £497,190 £494,362 £491,517
Total Liabilities £497,190 £494,362 £491,517
EQUITY
Capital £0 £0 £0
Retained Earnings £0 £392,047 £905,112
Profit or loss balance £392,047 £513,065 £513,083
TOTAL EQUITY £392,047 £905,112 £1,418,195
TOTAL LIABILITIES AND EQUITY £889,237 £1,399,475 £1,909,712
£0 £0 £0
£19,667 £19,583 £19,500 £19,417 £19,333 £19,250

£14,750 £14,688 £14,625 £14,563 £14,500 £14,438
£7,867 £7,833 £7,800 £7,767 £7,733 £7,700
£11,800 £11,750 £11,700 £11,650 £11,600 £11,550
£4,917 £4,896 £4,875 £4,854 £4,833 £4,813
£2,360,949 £2,871,437 £3,381,924 £3,892,411 £4,402,899 £4,913,386
£2,419,949 £2,930,187 £3,440,424 £3,950,661 £4,460,899 £4,971,136
£488,654 £485,773 £482,874 £479,957 £477,021 £474,068

£488,654 £485,773 £482,874 £479,957 £477,021 £474,068
£0 £0 £0 £0 £0 £0
£1,418,195 £1,931,296 £2,444,414 £2,957,550 £3,470,705 £3,983,877
£513,100 £513,118 £513,136 £513,154 £513,173 £513,191
£1,931,296 £2,444,414 £2,957,550 £3,470,705 £3,983,877 £4,497,068
£2,419,949 £2,930,187 £3,440,424 £3,950,661 £4,460,899 £4,971,136
£0 £0 £0 £0 £0 £0
£19,167 £19,083 £19,000 £18,917 £18,833 £18,750

£14,375 £14,313 £14,250 £14,188 £14,125 £14,063
£7,667 £7,633 £7,600 £7,567 £7,533 £7,500
£11,500 £11,450 £11,400 £11,350 £11,300 £11,250
£4,792 £4,771 £4,750 £4,729 £4,708 £4,688
£5,423,873 £5,934,361 £6,444,848 £7,122,851 £7,800,855 £8,478,858
£5,481,373 £5,991,611 £6,501,848 £7,179,601 £7,857,355 £8,535,108
£471,095 £468,105 £465,095 £462,067 £459,020 £455,954

£471,095 £468,105 £465,095 £462,067 £459,020 £455,954
£0 £0 £0 £0 £0 £0
£4,497,068 £5,010,278 £5,523,506 £6,036,753 £6,717,534 £7,398,335
£513,210 £513,228 £513,247 £680,782 £680,800 £680,820
£5,010,278 £5,523,506 £6,036,753 £6,717,534 £7,398,335 £8,079,154
£5,481,373 £5,991,611 £6,501,848 £7,179,601 £7,857,355 £8,535,108
£0 £0 £0 £0 £0 £0
£18,667 £18,583 £18,500 £18,417 £18,333 £18,250

£14,000 £13,938 £13,875 £13,813 £13,750 £13,688
£7,467 £7,433 £7,400 £7,367 £7,333 £7,300
£11,200 £11,150 £11,100 £11,050 £11,000 £10,950
£4,667 £4,646 £4,625 £4,604 £4,583 £4,563
£9,156,861 £9,834,865 £10,512,868 £11,190,871 £11,868,874 £12,546,878
£9,212,861 £9,890,615 £10,568,368 £11,246,121 £11,923,874 £12,601,628
£452,868 £449,764 £446,640 £443,496 £440,333 £437,150

£452,868 £449,764 £446,640 £443,496 £440,333 £437,150
£0 £0 £0 £0 £0 £0
£8,079,154 £8,759,993 £9,440,851 £10,121,728 £10,802,625 £11,483,542
£680,839 £680,858 £680,877 £680,897 £680,917 £680,936
£8,759,993 £9,440,851 £10,121,728 £10,802,625 £11,483,542 £12,164,478
£9,212,861 £9,890,615 £10,568,368 £11,246,121 £11,923,874 £12,601,628
£0 £0 £0 £0 £0 £0
£18,167 £18,083 £18,000 £17,917 £17,833 £17,750

£13,625 £13,563 £13,500 £13,438 £13,375 £13,313
£7,267 £7,233 £7,200 £7,167 £7,133 £7,100
£10,900 £10,850 £10,800 £10,750 £10,700 £10,650
£4,542 £4,521 £4,500 £4,479 £4,458 £4,438
£13,224,881 £13,902,884 £14,567,388 £15,470,774 £16,374,161 £17,277,547
£13,279,381 £13,957,134 £14,621,388 £15,524,524 £16,427,661 £17,330,797
£433,947 £430,724 £427,481 £424,217 £420,934 £417,630

£433,947 £430,724 £427,481 £424,217 £420,934 £417,630
£0 £0 £0 £0 £0 £0
£12,164,478 £12,845,434 £13,526,410 £14,193,907 £15,100,307 £16,006,727
£680,956 £680,976 £667,496 £906,400 £906,420 £906,441
£12,845,434 £13,526,410 £14,193,907 £15,100,307 £16,006,727 £16,913,168
£13,279,381 £13,957,134 £14,621,388 £15,524,524 £16,427,661 £17,330,797
£0 £0 £0 £0 £0 £0
£17,667 £17,583 £17,500 £17,417 £17,333 £17,250

£13,250 £13,188 £13,125 £13,063 £13,000 £12,938
£7,067 £7,033 £7,000 £6,967 £6,933 £6,900
£10,600 £10,550 £10,500 £10,450 £10,400 £10,350
£4,417 £4,396 £4,375 £4,354 £4,333 £4,313
£18,180,934 £19,084,320 £19,987,707 £20,891,093 £21,794,480 £22,697,866
£18,233,934 £19,137,070 £20,040,207 £20,943,343 £21,846,480 £22,749,616
£414,305 £410,959 £407,592 £404,205 £400,796 £397,366

£414,305 £410,959 £407,592 £404,205 £400,796 £397,366
£0 £0 £0 £0 £0 £0
£16,913,168 £17,819,629 £18,726,111 £19,632,615 £20,539,139 £21,445,684
£906,461 £906,482 £906,503 £906,524 £906,545 £906,567
£17,819,629 £18,726,111 £19,632,615 £20,539,139 £21,445,684 £22,352,251
£18,233,934 £19,137,070 £20,040,207 £20,943,343 £21,846,480 £22,749,616
£0 £0 £0 £0 £0 £0
£17,167 £17,083 £17,000 £16,917 £16,833 £16,750

£12,875 £12,813 £12,750 £12,688 £12,625 £12,563
£6,867 £6,833 £6,800 £6,767 £6,733 £6,700
£10,300 £10,250 £10,200 £10,150 £10,100 £10,050
£4,292 £4,271 £4,250 £4,229 £4,208 £4,188
£23,601,253 £24,504,640 £25,408,026 £26,611,317 £27,814,607 £29,017,898
£23,652,753 £24,555,890 £25,459,026 £26,662,067 £27,865,107 £29,068,148
£393,914 £390,441 £386,946 £383,430 £379,891 £376,330

£393,914 £390,441 £386,946 £383,430 £379,891 £376,330
£0 £0 £0 £0 £0 £0
£22,352,251 £23,258,839 £24,165,448 £25,072,080 £26,278,637 £27,485,216
£906,588 £906,610 £906,631 £1,206,557 £1,206,579 £1,206,601
£23,258,839 £24,165,448 £25,072,080 £26,278,637 £27,485,216 £28,691,818
£23,652,753 £24,555,890 £25,459,026 £26,662,067 £27,865,107 £29,068,148
£0 £0 £0 £0 £0 £0
£16,667 £16,583 £16,500 £16,417 £16,333 £16,250

£12,500 £12,438 £12,375 £12,313 £12,250 £12,188
£6,667 £6,633 £6,600 £6,567 £6,533 £6,500
£10,000 £9,950 £9,900 £9,850 £9,800 £9,750
£4,167 £4,146 £4,125 £4,104 £4,083 £4,062
£30,221,189 £31,424,479 £32,627,770 £33,831,060 £35,034,351 £36,237,642
£30,271,189 £31,474,229 £32,677,270 £33,880,310 £35,083,351 £36,286,392
£372,747 £369,142 £365,514 £361,863 £358,190 £354,493

£372,747 £369,142 £365,514 £361,863 £358,190 £354,493
£0 £0 £0 £0 £0 £0
£28,691,818 £29,898,441 £31,105,087 £32,311,756 £33,518,447 £34,725,161
£1,206,624 £1,206,646 £1,206,669 £1,206,691 £1,206,714 £1,206,737
£29,898,441 £31,105,087 £32,311,756 £33,518,447 £34,725,161 £35,931,898
£30,271,189 £31,474,229 £32,677,270 £33,880,310 £35,083,351 £36,286,392
£0 £0 £0 £0 £0 £0
£16,167 £16,083 £16,000 £15,917 £15,833 £15,750

£12,125 £12,063 £12,000 £11,938 £11,875 £11,813
£6,467 £6,433 £6,400 £6,367 £6,333 £6,300
£9,700 £9,650 £9,600 £9,550 £9,500 £9,450
£4,042 £4,021 £4,000 £3,979 £3,958 £3,937
£37,440,932 £38,644,223 £39,847,514 £41,449,260 £43,051,007 £44,652,754
£37,489,432 £38,692,473 £39,895,514 £41,497,010 £43,098,507 £44,700,004
£350,774 £347,031 £343,265 £339,475 £335,662 £331,825

£350,774 £347,031 £343,265 £339,475 £335,662 £331,825
£0 £0 £0 £0 £0 £0
£35,931,898 £37,138,659 £38,345,442 £39,552,249 £41,157,535 £42,762,845
£1,206,760 £1,206,783 £1,206,807 £1,605,286 £1,605,310 £1,605,334
£37,138,659 £38,345,442 £39,552,249 £41,157,535 £42,762,845 £44,368,179
£37,489,432 £38,692,473 £39,895,514 £41,497,010 £43,098,507 £44,700,004
£0 £0 £0 £0 £0 £0
£15,667 £15,583 £15,500 £15,417 £15,333 £15,250

£11,750 £11,688 £11,625 £11,563 £11,500 £11,438
£6,267 £6,233 £6,200 £6,167 £6,133 £6,100
£9,400 £9,350 £9,300 £9,250 £9,200 £9,150
£3,917 £3,896 £3,875 £3,854 £3,833 £3,813
£46,254,501 £47,856,248 £49,457,994 £51,059,741 £52,661,488 £54,263,235
£46,301,501 £47,902,998 £49,504,494 £51,105,991 £52,707,488 £54,308,985
£327,963 £324,078 £320,169 £316,234 £312,276 £308,293

£327,963 £324,078 £320,169 £316,234 £312,276 £308,293
£0 £0 £0 £0 £0 £0
£44,368,179 £45,973,537 £47,578,919 £49,184,326 £50,789,757 £52,395,212
£1,605,358 £1,605,382 £1,605,406 £1,605,431 £1,605,455 £1,605,480
£45,973,537 £47,578,919 £49,184,326 £50,789,757 £52,395,212 £54,000,692
£46,301,501 £47,902,998 £49,504,494 £51,105,991 £52,707,488 £54,308,985
£0 £0 £0 £0 £0 £0
Mon 58 Mon 59 Mon 60
£15,167 £15,083 £15,000

£11,375 £11,313 £11,250
£6,067 £6,033 £6,000
£9,100 £9,050 £9,000
£3,792 £3,771 £3,750
£55,864,981 £57,466,728 £59,068,475
£55,910,481 £57,511,978 £59,113,475
£304,284 £300,251 £296,192

£304,284 £300,251 £296,192
£0 £0 £0
£54,000,692 £55,606,197 £57,211,727
£1,605,505 £1,605,530 £1,605,555
£55,606,197 £57,211,727 £58,817,283
£55,910,481 £57,511,978 £59,113,475
£0 £0 £0
Particulars Mon 1 Mon 2 Mon 3 Mon 4
Cash Inflows:
Sales Revenue £1,313,500 £1,313,500 £1,313,500 £1,313,500
Capital and Loan Proceeds £500,000 £0 £0 £0
Total Inflows £1,813,500 £1,313,500 £1,313,500 £1,313,500
Cash Outflows:
Initial Expenses £121,000 £0 £0 £0
Cost of Sales £525,400 £525,400 £525,400 £525,400
Payroll £23,500 £23,500 £23,500 £23,500
Sales & Marketing £65,675 £65,675 £65,675 £65,675
Rent £530 £530 £530 £530
Supplies £450 £450 £450 £450
Travelling £700 £700 £700 £700
Miscellaneous Expenses £13,135 £13,135 £13,135 £13,135
Tax Paid £167,688 £167,688 £167,688 £167,688
Purchase of Assets £60,000 £0 £0 £0
Loan Repayment £5,935 £5,935 £5,935 £5,935
Total Outflows £984,013 £803,013 £803,013 £803,013
Net Cash generated £829,487 £510,487 £510,487 £510,487
Opening Cash Balance £0 £829,487 £1,339,975 £1,850,462

Ending Cash Balance £829,487 £1,339,975 £1,850,462 £2,360,949
£0 £0 £0 £0
Mon 5 Mon 6 Mon 7 Mon 8 Mon 9 Mon 10 Mon 11
£1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500

£0 £0 £0 £0 £0 £0 £0
£1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500
£0 £0 £0 £0 £0 £0 £0
£525,400 £525,400 £525,400 £525,400 £525,400 £525,400 £525,400
£23,500 £23,500 £23,500 £23,500 £23,500 £23,500 £23,500
£65,675 £65,675 £65,675 £65,675 £65,675 £65,675 £65,675
£530 £530 £530 £530 £530 £530 £530
£450 £450 £450 £450 £450 £450 £450
£700 £700 £700 £700 £700 £700 £700
£13,135 £13,135 £13,135 £13,135 £13,135 £13,135 £13,135
£167,688 £167,688 £167,688 £167,688 £167,688 £167,688 £167,688
£0 £0 £0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935 £5,935 £5,935
£803,013 £803,013 £803,013 £803,013 £803,013 £803,013 £803,013
£510,487 £510,487 £510,487 £510,487 £510,487 £510,487 £510,487
£2,360,949 £2,871,437 £3,381,924 £3,892,411 £4,402,899 £4,913,386 £5,423,873

£2,871,437 £3,381,924 £3,892,411 £4,402,899 £4,913,386 £5,423,873 £5,934,361
£0 £0 £0 £0 £0 £0 £0
£1,313,500 £1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225

£0 £0 £0 £0 £0 £0
£1,313,500 £1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225
£0 £0 £0 £0 £0 £0
£525,400 £709,290 £709,290 £709,290 £709,290 £709,290
£23,500 £45,225 £45,225 £45,225 £45,225 £45,225
£65,675 £88,661 £88,661 £88,661 £88,661 £88,661
£530 £583 £583 £583 £583 £583
£450 £473 £473 £473 £473 £473
£700 £735 £735 £735 £735 £735
£13,135 £17,732 £17,732 £17,732 £17,732 £17,732
£167,688 £226,588 £226,588 £226,588 £226,588 £226,588
£0 £0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935 £5,935
£803,013 £1,095,222 £1,095,222 £1,095,222 £1,095,222 £1,095,222
£510,487 £678,003 £678,003 £678,003 £678,003 £678,003
£5,934,361 £6,444,848 £7,122,851 £7,800,855 £8,478,858 £9,156,861

£6,444,848 £7,122,851 £7,800,855 £8,478,858 £9,156,861 £9,834,865
£0 £0 £0 £0 £0 £0
£1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225

£0 £0 £0 £0 £0 £0
£1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225 £1,773,225
£0 £0 £0 £0 £0 £0
£709,290 £709,290 £709,290 £709,290 £709,290 £709,290
£45,225 £45,225 £45,225 £45,225 £45,225 £45,225
£88,661 £88,661 £88,661 £88,661 £88,661 £88,661
£583 £583 £583 £583 £583 £583
£473 £473 £473 £473 £473 £473
£735 £735 £735 £735 £735 £735
£17,732 £17,732 £17,732 £17,732 £17,732 £17,732
£226,588 £226,588 £226,588 £226,588 £226,588 £226,588
£0 £0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935 £5,935
£1,095,222 £1,095,222 £1,095,222 £1,095,222 £1,095,222 £1,095,222
£678,003 £678,003 £678,003 £678,003 £678,003 £678,003
£9,834,865 £10,512,868 £11,190,871 £11,868,874 £12,546,878 £13,224,881

£10,512,868 £11,190,871 £11,868,874 £12,546,878 £13,224,881 £13,902,884
£0 £0 £0 £0 £0 £0
£1,773,225 £2,393,854 £2,393,854 £2,393,854 £2,393,854

£0 £0 £0 £0 £0
£1,773,225 £2,393,854 £2,393,854 £2,393,854 £2,393,854
£0 £0 £0 £0 £0
£709,290 £957,542 £957,542 £957,542 £957,542
£58,725 £79,279 £79,279 £79,279 £79,279
£88,661 £119,693 £119,693 £119,693 £119,693
£583 £641 £641 £641 £641
£473 £496 £496 £496 £496
£735 £772 £772 £772 £772
£17,732 £23,939 £23,939 £23,939 £23,939
£226,588 £302,171 £302,171 £302,171 £302,171
£0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935
£1,108,722 £1,490,467 £1,490,467 £1,490,467 £1,490,467
£664,503 £903,387 £903,387 £903,387 £903,387
£13,902,884 £14,567,388 £15,470,774 £16,374,161 £17,277,547

£14,567,388 £15,470,774 £16,374,161 £17,277,547 £18,180,934
£0 £0 £0 £0 £0
£2,393,854 £2,393,854 £2,393,854 £2,393,854 £2,393,854

£0 £0 £0 £0 £0
£2,393,854 £2,393,854 £2,393,854 £2,393,854 £2,393,854
£0 £0 £0 £0 £0
£957,542 £957,542 £957,542 £957,542 £957,542
£79,279 £79,279 £79,279 £79,279 £79,279
£119,693 £119,693 £119,693 £119,693 £119,693
£641 £641 £641 £641 £641
£496 £496 £496 £496 £496
£772 £772 £772 £772 £772
£23,939 £23,939 £23,939 £23,939 £23,939
£302,171 £302,171 £302,171 £302,171 £302,171
£0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935
£1,490,467 £1,490,467 £1,490,467 £1,490,467 £1,490,467
£903,387 £903,387 £903,387 £903,387 £903,387
£18,180,934 £19,084,320 £19,987,707 £20,891,093 £21,794,480

£19,084,320 £19,987,707 £20,891,093 £21,794,480 £22,697,866
£0 £0 £0 £0 £0
£2,393,854 £2,393,854 £2,393,854 £3,231,703 £3,231,703

£0 £0 £0 £0 £0
£2,393,854 £2,393,854 £2,393,854 £3,231,703 £3,231,703
£0 £0 £0 £0 £0
£957,542 £957,542 £957,542 £1,292,681 £1,292,681
£79,279 £79,279 £79,279 £131,630 £131,630
£119,693 £119,693 £119,693 £161,585 £161,585
£641 £641 £641 £705 £705
£496 £496 £496 £521 £521
£772 £772 £772 £810 £810
£23,939 £23,939 £23,939 £32,317 £32,317
£302,171 £302,171 £302,171 £402,227 £402,227
£0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935
£1,490,467 £1,490,467 £1,490,467 £2,028,412 £2,028,412
£903,387 £903,387 £903,387 £1,203,291 £1,203,291
£22,697,866 £23,601,253 £24,504,640 £25,408,026 £26,611,317

£23,601,253 £24,504,640 £25,408,026 £26,611,317 £27,814,607
£0 £0 £0 £0 £0
£3,231,703 £3,231,703 £3,231,703 £3,231,703 £3,231,703

£0 £0 £0 £0 £0
£3,231,703 £3,231,703 £3,231,703 £3,231,703 £3,231,703
£0 £0 £0 £0 £0
£1,292,681 £1,292,681 £1,292,681 £1,292,681 £1,292,681
£131,630 £131,630 £131,630 £131,630 £131,630
£161,585 £161,585 £161,585 £161,585 £161,585
£705 £705 £705 £705 £705
£521 £521 £521 £521 £521
£810 £810 £810 £810 £810
£32,317 £32,317 £32,317 £32,317 £32,317
£402,227 £402,227 £402,227 £402,227 £402,227
£0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935
£2,028,412 £2,028,412 £2,028,412 £2,028,412 £2,028,412
£1,203,291 £1,203,291 £1,203,291 £1,203,291 £1,203,291
£27,814,607 £29,017,898 £30,221,189 £31,424,479 £32,627,770

£29,017,898 £30,221,189 £31,424,479 £32,627,770 £33,831,060
£0 £0 £0 £0 £0
£3,231,703 £3,231,703 £3,231,703 £3,231,703 £3,231,703

£0 £0 £0 £0 £0
£3,231,703 £3,231,703 £3,231,703 £3,231,703 £3,231,703
£0 £0 £0 £0 £0
£1,292,681 £1,292,681 £1,292,681 £1,292,681 £1,292,681
£131,630 £131,630 £131,630 £131,630 £131,630
£161,585 £161,585 £161,585 £161,585 £161,585
£705 £705 £705 £705 £705
£521 £521 £521 £521 £521
£810 £810 £810 £810 £810
£32,317 £32,317 £32,317 £32,317 £32,317
£402,227 £402,227 £402,227 £402,227 £402,227
£0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935
£2,028,412 £2,028,412 £2,028,412 £2,028,412 £2,028,412
£1,203,291 £1,203,291 £1,203,291 £1,203,291 £1,203,291
£33,831,060 £35,034,351 £36,237,642 £37,440,932 £38,644,223

£35,034,351 £36,237,642 £37,440,932 £38,644,223 £39,847,514
£0 £0 £0 £0 £0
£4,362,798 £4,362,798 £4,362,798 £4,362,798 £4,362,798

£0 £0 £0 £0 £0
£4,362,798 £4,362,798 £4,362,798 £4,362,798 £4,362,798
£0 £0 £0 £0 £0
£1,745,119 £1,745,119 £1,745,119 £1,745,119 £1,745,119
£210,916 £210,916 £210,916 £210,916 £210,916
£218,140 £218,140 £218,140 £218,140 £218,140
£776 £776 £776 £776 £776
£547 £547 £547 £547 £547
£851 £851 £851 £851 £851
£43,628 £43,628 £43,628 £43,628 £43,628
£535,140 £535,140 £535,140 £535,140 £535,140
£0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935
£2,761,052 £2,761,052 £2,761,052 £2,761,052 £2,761,052
£1,601,747 £1,601,747 £1,601,747 £1,601,747 £1,601,747
£39,847,514 £41,449,260 £43,051,007 £44,652,754 £46,254,501

£41,449,260 £43,051,007 £44,652,754 £46,254,501 £47,856,248
£0 £0 £0 £0 £0
£4,362,798 £4,362,798 £4,362,798 £4,362,798 £4,362,798

£0 £0 £0 £0 £0
£4,362,798 £4,362,798 £4,362,798 £4,362,798 £4,362,798
£0 £0 £0 £0 £0
£1,745,119 £1,745,119 £1,745,119 £1,745,119 £1,745,119
£210,916 £210,916 £210,916 £210,916 £210,916
£218,140 £218,140 £218,140 £218,140 £218,140
£776 £776 £776 £776 £776
£547 £547 £547 £547 £547
£851 £851 £851 £851 £851
£43,628 £43,628 £43,628 £43,628 £43,628
£535,140 £535,140 £535,140 £535,140 £535,140
£0 £0 £0 £0 £0
£5,935 £5,935 £5,935 £5,935 £5,935
£2,761,052 £2,761,052 £2,761,052 £2,761,052 £2,761,052
£1,601,747 £1,601,747 £1,601,747 £1,601,747 £1,601,747
£47,856,248 £49,457,994 £51,059,741 £52,661,488 £54,263,235

£49,457,994 £51,059,741 £52,661,488 £54,263,235 £55,864,981
£0 £0 £0 £0 £0
Mon 59 Mon 60
£4,362,798 £4,362,798
£0 £0
£4,362,798 £4,362,798
£0 £0
£1,745,119 £1,745,119
£210,916 £210,916
£218,140 £218,140
£776 £776
£547 £547
£851 £851
£43,628 £43,628
£535,140 £535,140
£0 £0
£5,935 £5,935
£2,761,052 £2,761,052
£1,601,747 £1,601,747
£55,864,981 £57,466,728
£57,466,728 £59,068,475
£0 £0
Inputs
Beta 0.88 http://pages.stern.nyu.edu/~adamodar/New_Home_Pag
Risk free Rate 0.574% http://www.worldgovernmentbonds.com/country/italy/
Market Return 5.50%
Debt £0
Equity £58,817,283
Weight of Equity 100.00%
Weight of Debt 0.00%
Cost of Equity 4.91%

Cost of Debt 5%
WACC 4.91%
Year 0 Year 1
Net Income £6,036,753
Add: Depreciation & Amortization £3,000
Less: Working Capital £0
Less: Capital Expenditures £0
Free Cash Flows £6,039,753
Discount Factor 0.95
Discounted Cash Flows 4.91% -£500,000 £5,757,142
NPV £49,215,061
IRR 1180.03%
Perpetuity Growth Rate 1.25%
PV of Future Cash Flows £49,715,061
PV of Terminal Value £419,587,959
Value of the Company £469,303,020

amodar/New_Home_Page/datafile/Betas.html
bonds.com/country/italy/
Year 2 Year 3 Year 4 Year 5

£8,157,154 £10,878,173 £14,480,169 £19,265,034
£3,000 £3,000 £3,000 £3,000
£0 £0 £0 £0
£0 £0 £0 £0
£8,160,154 £10,881,173 £14,483,169 £19,268,034
0.91 0.87 0.83 0.79
£7,414,363 £9,424,080 £11,956,790 £15,162,686

Select a scenario from the list
Base Case
Pro Forma Profit and Loss Year 1 Year 2 Year 3
Total Revenue £15,762,000 £21,278,700 £28,726,245
Cost of Sales £6,304,800 £8,511,480 £11,490,498
Gross Profit £9,457,200 £12,767,220 £17,235,747
Initial Expenses £121,000 £0 £0
Operating Expenses:
Payroll £282,000 £556,200 £951,345
Sales & Marketing £788,100 £1,063,935 £1,436,312
Rent £6,360 £6,996 £7,696
Supplies £5,400 £5,670 £5,954
Travelling £8,400 £8,820 £9,261
Miscellaneous Expenses £157,620 £212,787 £287,262
Interest Expense £36,316 £33,607 £30,686
Depreciation £3,000 £3,000 £3,000
Tax £2,012,251 £2,719,051 £3,626,058
Total Expenses £3,420,447 £4,610,066 £6,357,574
Net Income / (Loss) £12,341,553 £16,668,634 £22,368,671
Net Income/Revenue 78.30% 78.33% 77.87%

Year 4 Year 5 Base Case 0%
£38,780,431 £52,353,582 Low Case -25%
£15,512,172 £20,941,433 High Case 25%
£23,268,258 £31,412,149
£0 £0
£1,579,561 £2,530,988
£1,939,022 £2,617,679
£8,465 £9,312
£6,251 £6,564
£9,724 £10,210
£387,804 £523,536
£27,540 £24,149
£3,000 £3,000
£4,826,723 £6,421,678
£8,788,090 £12,147,115
£29,992,341 £40,206,467
77.34% 76.80%
Financial Ratios Year 1 Year 2
Gross Margin 60.00% 60.00%
Operating Cost Ratio 8.68% 8.71%
Net Margin Ratio 38.30% 38.33%
Return on Equity 100.00% 57.47%
Return on Assets 92.85% 55.79%
Assets Turnover Ratio (Times) 2.42 1.46
60.00% 60.00% 60.00%
9.39% 10.14% 10.88%
37.87% 37.34% 36.80%
43.39% 36.61% 32.75%
42.73% 36.30% 32.59%
1.13 0.97 0.89
Use of Proceeds
£500,000
£450,000
£400,000
£350,000
£300,000
£250,000
£200,000
£150,000
£100,000
£50,000
£0
Assets to Fund Expenses to Fund Total Investment
Net Income
£20,000,000
£18,000,000
£16,000,000
£14,000,000
£12,000,000
£10,000,000
£8,000,000
£6,000,000
£4,000,000
£2,000,000
£0
Year 1 Year 2 Year 3 Year 4 Year 5
Monthly Revenue
£4,500,000
£4,000,000
£3,500,000
£3,000,000
£2,500,000
£2,000,000
£1,500,000
£1,000,000
£500,000
£0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 3
on on on on on on on on on n n n n n n n n n n n n n n n n n n n n n n n n n n
M M M M M M M M M Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo
Monthly Net Income

£1,800,000
£1,600,000
£1,400,000
£1,200,000
£1,000,000
£800,000
£600,000
£400,000
£200,000
£0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58
on on on on on on on on on on on on on on on on on on on on
M M M M M M M M M M M M M M M M M M M M
£200,000
£0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58
on on on n n n n n n n n n n n n n n n n n
M M M Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo Mo
Yearly Total Assets
£60,000,000
£50,000,000
£40,000,000
£30,000,000
£20,000,000
£10,000,000
£0
Monthly Total Assets

£60,000,000
£50,000,000
£40,000,000
£30,000,000
£20,000,000
£10,000,000
£30,000,000
£20,000,000
£10,000,000
£0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58
Break Even Sales
£4,000,000
£3,500,000
£3,000,000
£2,500,000
£2,000,000
£1,500,000
£1,000,000
£500,000
£0
Yearly Cash Balance
£60,000,000
£50,000,000
£40,000,000
£30,000,000
£20,000,000
£50,000,000
£40,000,000
£30,000,000
£20,000,000
£10,000,000
£0
Total Revenue
£60,000,000
£50,000,000
£40,000,000
£30,000,000
£20,000,000
£10,000,000
£0
Total Expenses
£6,000,000
£5,000,000
£4,000,000
£3,000,000
£2,000,000
£1,000,000
£0
nthly Revenue
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 53 55 56 57 58 59 60
n on on on on on on on on on on on on on on on on on on on on on on on on on on on on on on on on
M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M
Monthly Total Expenses

£500,000
£450,000
£400,000
£350,000
£300,000
£250,000
£200,000
£150,000
£100,000
£50,000
£0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58
on on on on on on on on on on on on on on on on on on on on
M M M M M M M M M M M M M M M M M M M M
£50,000
£0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58
Yearly Total Capital
£60,000,000
£50,000,000
£40,000,000
£30,000,000
£20,000,000
£10,000,000
£0
Monthly Total Capital

£60,000,000
£50,000,000
£40,000,000
£30,000,000
£20,000,000
£10,000,000
£30,000,000
£20,000,000
£10,000,000
£0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58
Actual Sales
£60,000,000
£50,000,000
£40,000,000
£30,000,000
£20,000,000
£10,000,000
£0
Monthly Cash Balance

£60,000,000
£50,000,000
£40,000,000
£30,000,000
£20,000,000
£40,000,000
£30,000,000
£20,000,000
£10,000,000
£0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58

Novattione Group LTD Financial Plan

Uploaded by

Document Informationclick to expand document information

Copyright:

Available Formats

Novattione Group LTD Financial Plan

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Novattione Group LTD Financial Plan

Uploaded by

Copyright:

Available Formats

Financ

Additional Assets Year 2 Year 3 Year 4 Year 5

Depreciable Assets (Written Down Value) Mon 1 Mon 2

Mon 3 Mon 4 Mon 5 Mon 6 Mon 7 Mon 8

Addition Total Cost Dep. Exp. Cum. Dep WDV

Mon 9 Mon 10 Mon 11 Mon 12 Mon 13 Mon 14

Mon 15 Mon 16 Mon 17 Mon 18 Mon 19 Mon 20

Mon 21 Mon 22 Mon 23 Mon 24 Mon 25 Mon 26

Addition Total Cost Dep. Exp. Cum. Dep WDV

Mon 27 Mon 28 Mon 29 Mon 30 Mon 31 Mon 32

Mon 33 Mon 34 Mon 35 Mon 36 Mon 37 Mon 38

Cum. Dep WDV

Mon 39 Mon 40 Mon 41 Mon 42 Mon 43 Mon 44

Mon 45 Mon 46 Mon 47 Mon 48 Mon 49 Mon 50

Mon 51 Mon 52 Mon 53 Mon 54 Mon 55 Mon 56

Mon 57 Mon 58 Mon 59 Mon 60

Headcount Mon 1 Mon 2 Mon 3 Mon 4

Payroll Plan Monthly Mon 1 Mon 2 Mon 3 Mon 4

Payroll Plan Yearly Year 1 Year 2 Year 3 Year 4

Mon 5 Mon 6 Mon 7 Mon 8 Mon 9 Mon 10

Mon 5 Mon 6 Mon 7 Mon 8 Mon 9 Mon 10

Mon 11 Mon 12 Mon 13 Mon 14 Mon 15 Mon 16

Mon 17 Mon 18 Mon 19 Mon 20 Mon 21 Mon 22

Mon 23 Mon 24 Mon 25 Mon 26 Mon 27 Mon 28

Mon 29 Mon 30 Mon 31 Mon 32 Mon 33 Mon 34

Mon 35 Mon 36 Mon 37 Mon 38 Mon 39 Mon 40

Mon 41 Mon 42 Mon 43 Mon 44 Mon 45 Mon 46

Mon 47 Mon 48 Mon 49 Mon 50 Mon 51 Mon 52

Mon 53 Mon 54 Mon 55 Mon 56 Mon 57 Mon 58

Monthly Loan Schedule Mon 1 Mon 2 Mon 3

Yearly Loan Schedule Year 1 Year 2 Year 3

Year 4 Year 5 Year 6 Year 7

Assets to Fund £379,000

Loan Investment £500,000

Loan Investment % 100%

Total Expenses £107,365 £107,347

Expenses Year 1 Year 2

Total Expenses £1,287,196 £1,891,015

£107,330 £107,312 £107,294 £107,276 £107,258 £107,240

Year 3 Year 4 Year 5

£2,731,516 £3,961,367 £5,725,437

£107,221 £107,203 £107,184 £107,166 £156,566 £156,547

£156,528 £156,509 £156,489 £156,470 £156,450 £156,431

£156,411 £156,391 £156,371 £169,851 £227,741 £227,721

£227,700 £227,679 £227,659 £227,638 £227,617 £227,595

£227,574 £227,553 £227,531 £227,509 £330,237 £330,215

£330,193 £330,171 £330,149 £330,126 £330,103 £330,081

£330,058 £330,034 £330,011 £329,988 £477,253 £477,229

£477,205 £477,181 £477,157 £477,133 £477,108 £477,084

£477,059 £477,034 £477,009 £476,984

Revenue Details Mon 1 Mon 2

Total Revenue £1,313,500 £1,313,500

£125,000 £125,000 £125,000 £125,000 £125,000 £125,000

£1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,313,500

£125,000 £125,000 £125,000 £125,000 £168,750 £168,750

£1,313,500 £1,313,500 £1,313,500 £1,313,500 £1,773,225 £1,773,225

£168,750 £168,750 £168,750 £168,750 £168,750 £168,750