Example Of Financial Model - Nohat Digital
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQ
1
Websitename.com
2
Returns Model ($USD)
ADJUSTED FOR INITIAL COSTS
3
Dec 2017 Jan 2018 Feb 2018 Mar 2018 Apr 2018 May 2018 Jun 2018 Jul 2018 Aug 2018 Sep 2018 Oct 2018 Nov 2018 Dec 2018 Jan 2019 Feb 2019 Mar 2019 Apr 2019 May 2019 Jun 2019 Jul 2019 Aug 2019 Sep 2019 Oct 2019 Nov 2019 Dec 2019 Jan 2020 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020
4
ASSUMPTIONSMONTH
5
Acquisition Details123456789101112131415161718192021222324252627282930313233343536EXIT
6
Purchase Price (including overfund)
$3,985,000Earnings 124,711 122,398 127,234 205,132 209,027 211,143 213,281 215,440 217,620 219,822 222,046 224,293 226,562 228,854 231,168 233,506 235,867 238,651 241,060 243,493 245,949 248,431 250,937 253,469 256,025 258,608 261,216 263,850 266,510 269,197 271,911 274,653 277,421 280,217 283,041 285,894 13,151,117
7
TTM Earnings$1,373,455Monthly Growth %-1.9%4.0%61.2%1.9%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.2%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%
8
9
%/Year$/MoPrincipal & Interest-$31,561-$31,561-$31,561-$31,561-$31,561-$31,561-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$53,430-$1,054,405
10
Hurdle Rate15%$25,388
11
Post-Debt Cash Flow
93,150 90,837 95,673 173,571 177,466 179,582 159,851 162,010 164,190 166,392 168,617 170,863 173,132 175,424 177,738 180,076 182,437 185,222 187,630 190,063 192,520 195,001 197,507 200,039 202,596 205,178 207,786 210,420 213,081 215,768 218,482 221,223 223,991 226,787 229,612 232,464 12,096,713
12
CF Above Hurdle
Exit
13
Management Fee50.0%50.0%Hurdle Rate253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388
14
Cumulative Hurdle Rate
253885077676165101553126941152329177717203106228494253882279270304658330047355435380823406211431599456988482376507764533152558540583928609317634705660093685481710869736258761646787034812422837810863199888587913975
15
Entry Multiple34.8x34.5%
16
Exit Multiple46.0x26.1%Shortfall$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Distributable
17
Cumulative Shortfall
$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0Exit Value
18
Purchase Price Allocation
Revised Hurdle Rate
253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388 12,096,713
19
Cash on Balance Sheet (Overfund)
$0
20
Seller Retention$0
Hurdle Rate Cash Flow
21
Broker Fee$478,200Seller - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
22
Cash to Seller$3,506,800GP * 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 5,978 478,200
23
Total Purchase Price$3,985,000Debt Investor 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 1,877 150,136
24
Equity Investors 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 17,534 1,402,720
25
Capital Allocation$%
Total Hurdle Rate CF
25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 25,388 2,031,056
26
Seller - 0.0%
27
GP * 478,200 12.0%Upside
28
Debt Investor 2,104,080 52.8%Seller - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
29
Equity Investors 1,402,720 35.2%GP * 39,353 38,010 40,819 86,059 88,321 89,550 78,091 79,345 80,611 81,890 83,182 84,486 85,804 87,135 88,479 89,837 91,208 92,825 94,224 95,637 97,064 98,505 99,960 101,430 102,915 104,415 105,930 107,459 109,005 110,565 112,141 113,733 115,341 116,965 118,605 120,262 5,845,752
30
Total 3,985,000 100.00%Debt Investor 5,009 4,838 5,195 10,954 11,242 11,398 9,939 10,099 10,260 10,423 10,587 10,754 10,921 11,091 11,262 11,435 11,609 11,815 11,993 12,173 12,354 12,538 12,723 12,910 13,099 13,290 13,483 13,678 13,874 14,073 14,273 14,476 14,681 14,887 15,096 15,307 744,053
31
Equity Investors 23,399 22,601 24,271 51,170 52,515 53,246 46,432 47,178 47,931 48,691 49,459 50,235 51,019 51,810 52,609 53,416 54,232 55,193 56,025 56,865 57,714 58,570 59,436 60,310 61,193 62,085 62,985 63,895 64,814 65,741 66,679 67,625 68,581 69,547 70,522 71,507 3,475,852
32
Hurdle Rate Equity Allocation
Cash FlowExitTotal Upside 67,762 65,448 70,285 148,182 152,078 154,194 134,463 136,622 138,802 141,004 143,228 145,475 147,744 150,036 152,350 154,688 157,049 159,833 162,242 164,675 167,131 169,613 172,119 174,651 177,207 179,790 182,398 185,032 187,692 190,379 193,093 195,835 198,603 201,399 204,223 207,076 10,065,657
33
Seller 0.0%0.0%
34
GP *23.5%23.5%Total Cash Flow
35
Debt Investor7.4%7.4%Seller - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
36
Equity Investors69.1%69.1%GP * 45,331 43,987 46,796 92,036 94,298 95,528 84,068 85,322 86,588 87,867 89,159 90,464 91,782 93,112 94,457 95,814 97,185 98,803 100,201 101,614 103,041 104,482 105,938 107,408 108,893 110,392 111,907 113,437 114,982 116,543 118,119 119,711 121,319 122,943 124,583 126,239 6,323,952
37
Total100.0%100.0%Debt Investor 38,447 38,276 38,633 44,392 44,679 44,836 65,246 65,406 65,567 65,730 65,894 66,060 66,228 66,397 66,568 66,741 66,916 67,121 67,299 67,479 67,661 67,844 68,030 68,217 68,406 68,597 68,789 68,984 69,181 69,379 69,580 69,783 69,987 70,194 70,403 70,614 1,948,594
38
Equity Investors 40,933 40,135 41,805 68,704 70,049 70,780 63,966 64,712 65,465 66,225 66,993 67,769 68,553 69,344 70,143 70,950 71,766 72,727 73,559 74,399 75,248 76,104 76,970 77,844 78,727 79,619 80,519 81,429 82,348 83,275 84,213 85,159 86,115 87,081 88,056 89,041 4,878,572
39
Above Hurdle Rate Equity Allocation
Cash FlowExitTotal Cash Flow 124,711 122,398 127,234 205,132 209,027 211,143 213,281 215,440 217,620 219,822 222,046 224,293 226,562 228,854 231,168 233,506 235,867 238,651 241,060 243,493 245,949 248,431 250,937 253,469 256,025 258,608 261,216 263,850 266,510 269,197 271,911 274,653 277,421 280,217 283,041 285,894 13,151,117
40
Seller 0.0%0.0%
41
GP *58.1%58.1%
Cumulative Cash Flow
42
Debt Investor7.4%7.4%Seller - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
43
Equity Investors34.5%34.5%GP * 45,331 89,318 136,115 228,151 322,449 417,977 502,045 587,367 673,956 761,823 850,983 941,446 1,033,228 1,126,340 1,220,797 1,316,611 1,413,797 1,512,599 1,612,801 1,714,415 1,817,456 1,921,939 2,027,876 2,135,284 2,244,177 2,354,570 2,466,477 2,579,914 2,694,896 2,811,439 2,929,557 3,049,268 3,170,587 3,293,529 3,418,112 3,544,351 9,868,303
44
Total100.0%100.0%Debt Investor 38,447 76,723 115,356 159,748 204,427 249,263 314,509 379,915 445,481 511,211 577,105 643,165 709,393 775,790 842,358 909,099 976,014 1,043,136 1,110,435 1,177,914 1,245,575 1,313,420 1,381,449 1,449,666 1,518,071 1,586,668 1,655,457 1,724,441 1,793,622 1,863,001 1,932,581 2,002,364 2,072,351 2,142,545 2,212,948 2,283,561 4,232,155
45
Equity Investors 40,933 81,068 122,872 191,576 261,626 332,406 396,372 461,084 526,549 592,774 659,768 727,537 796,089 865,433 935,576 1,006,527 1,078,293 1,151,020 1,224,579 1,298,978 1,374,226 1,450,330 1,527,300 1,605,144 1,683,871 1,763,489 1,844,009 1,925,437 2,007,785 2,091,060 2,175,273 2,260,432 2,346,547 2,433,628 2,521,684 2,610,725 7,489,298
46
Debt Investor TermsAnnualMonthlyTotal Cash Flow 124,711 247,109 374,343 579,475 788,502 999,646 1,212,926 1,428,366 1,645,986 1,865,808 2,087,855 2,312,148 2,538,710 2,767,563 2,998,731 3,232,237 3,468,104 3,706,755 3,947,815 4,191,308 4,437,257 4,685,688 4,936,626 5,190,094 5,446,120 5,704,727 5,965,943 6,229,793 6,496,303 6,765,500 7,037,412 7,312,064 7,589,485 7,869,703 8,152,744 8,438,638 21,589,755
47
Amount 2,104,080
48
Interest %18.0%1.5%
Cumulative Return %
49
Term (Months) 60 Equity Investors2.9%5.8%8.8%13.7%18.7%23.7%28.3%32.9%37.5%42.3%47.0%51.9%56.8%61.7%66.7%71.8%76.9%82.1%87.3%92.6%98.0%103.4%108.9%114.4%120.0%125.7%131.5%137.3%143.1%149.1%155.1%161.1%167.3%173.5%179.8%186.1%533.9%
50
Equity Kicker %14.0%
51
52
Exit Value
53
Earnings (Month 36) 285,894
54
Exit Multiple46.0x
55
Exit Value 13,151,117
56
Principal Outstanding- 1,283,161
57
Exit Value to Equity Holders
11,867,956
58
59
79
80
* GP contribution from brokerage fee
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
Loading...
Main menu