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 147,127 145,087 150,172 232,017 236,181 238,569 240,981 243,417 245,877 248,362 250,871 253,406 255,966 258,552 261,163 263,801 266,465 269,555 272,273 275,018 277,790 280,590 283,418 286,274 289,159 292,072 295,015 297,987 300,989 304,021 307,083 310,176 313,300 316,455 319,641 322,859 14,851,536
7
TTM Earnings$1,422,904Monthly Growth %-1.4%3.5%54.5%1.8%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
115,566 113,526 118,611 200,456 204,620 207,008 187,551 189,987 192,447 194,932 197,441 199,976 202,536 205,122 207,733 210,371 213,035 216,126 218,843 221,588 224,360 227,160 229,988 232,844 235,729 238,642 241,585 244,557 247,559 250,591 253,653 256,746 259,870 263,025 266,211 269,430 13,797,131
12
CF Above Hurdle
Exit
13
Management Fee50.0%50.0%Hurdle Rate253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388253882538825388
14
Cumulative Hurdle Rate
253885077676165101553126941152329177717203106228494253882279270304658330047355435380823406211431599456988482376507764533152558540583928609317634705660093685481710869736258761646787034812422837810863199888587913975
15
Entry Multiple33.6x35.7%
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 13,797,131
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 * 52,372 51,187 54,140 101,673 104,091 105,478 94,178 95,593 97,021 98,464 99,922 101,394 102,881 104,382 105,899 107,431 108,978 110,773 112,351 113,945 115,555 117,181 118,824 120,482 122,158 123,850 125,559 127,285 129,028 130,789 132,568 134,364 136,178 138,010 139,861 141,730 6,833,290
30
Total 3,985,000 100.00%Debt Investor 6,666 6,515 6,891 12,941 13,249 13,425 11,987 12,167 12,349 12,533 12,718 12,906 13,095 13,286 13,479 13,674 13,871 14,099 14,300 14,503 14,708 14,915 15,124 15,335 15,548 15,764 15,981 16,201 16,423 16,647 16,873 17,102 17,333 17,566 17,802 18,040 869,748
31
Equity Investors 31,140 30,436 32,191 60,454 61,892 62,717 55,998 56,839 57,688 58,546 59,413 60,288 61,172 62,065 62,967 63,878 64,798 65,865 66,803 67,751 68,709 69,675 70,652 71,638 72,634 73,640 74,657 75,683 76,720 77,767 78,824 79,892 80,971 82,060 83,161 84,272 4,063,037
32
Hurdle Rate Equity Allocation
Cash FlowExitTotal Upside 90,178 88,138 93,222 175,068 179,232 181,620 162,163 164,599 167,059 169,544 172,053 174,588 177,148 179,734 182,345 184,983 187,647 190,737 193,455 196,200 198,972 201,772 204,600 207,456 210,341 213,254 216,197 219,169 222,171 225,203 228,265 231,358 234,482 237,637 240,823 244,041 11,766,076
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 * 58,349 57,165 60,118 107,650 110,069 111,455 100,155 101,570 102,999 104,442 105,899 107,371 108,858 110,360 111,877 113,408 114,956 116,751 118,329 119,923 121,533 123,159 124,801 126,460 128,135 129,827 131,536 133,263 135,006 136,767 138,545 140,341 142,155 143,988 145,838 147,708 7,311,490
37
Total100.0%100.0%Debt Investor 40,104 39,953 40,329 46,379 46,687 46,863 67,294 67,474 67,655 67,839 68,025 68,212 68,401 68,592 68,785 68,980 69,177 69,406 69,607 69,810 70,014 70,221 70,431 70,642 70,855 71,070 71,288 71,507 71,729 71,953 72,180 72,408 72,639 72,873 73,108 73,346 2,074,288
38
Equity Investors 48,674 47,970 49,725 77,988 79,426 80,251 73,532 74,373 75,222 76,080 76,947 77,822 78,706 79,599 80,501 81,412 82,332 83,399 84,337 85,285 86,243 87,209 88,186 89,172 90,168 91,174 92,191 93,217 94,254 95,301 96,358 97,426 98,505 99,594 100,695 101,806 5,465,757
39
Above Hurdle Rate Equity Allocation
Cash FlowExitTotal Cash Flow 147,127 145,087 150,172 232,017 236,181 238,569 240,981 243,417 245,877 248,362 250,871 253,406 255,966 258,552 261,163 263,801 266,465 269,555 272,273 275,018 277,790 280,590 283,418 286,274 289,159 292,072 295,015 297,987 300,989 304,021 307,083 310,176 313,300 316,455 319,641 322,859 14,851,536
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 * 58,349 115,514 175,632 283,282 393,350 504,806 604,961 706,531 809,530 913,972 1,019,871 1,127,243 1,236,101 1,346,461 1,458,338 1,571,746 1,686,702 1,803,452 1,921,781 2,041,704 2,163,236 2,286,395 2,411,197 2,537,656 2,665,792 2,795,619 2,927,156 3,060,418 3,195,424 3,332,191 3,470,736 3,611,077 3,753,233 3,897,220 4,043,059 4,190,766 11,502,256
44
Total100.0%100.0%Debt Investor 40,104 80,057 120,386 166,765 213,451 260,315 327,608 395,082 462,737 530,576 598,601 666,813 735,214 803,807 872,592 941,573 1,010,750 1,080,156 1,149,763 1,219,572 1,289,587 1,359,808 1,430,239 1,500,880 1,571,735 1,642,805 1,714,093 1,785,601 1,857,330 1,929,283 2,001,463 2,073,872 2,146,511 2,219,384 2,292,492 2,365,838 4,440,126
45
Equity Investors 48,674 96,644 146,369 224,357 303,783 384,034 457,565 531,938 607,160 683,241 760,188 838,010 916,717 996,316 1,076,817 1,158,229 1,240,560 1,323,960 1,408,297 1,493,582 1,579,825 1,667,034 1,755,220 1,844,392 1,934,561 2,025,735 2,117,926 2,211,143 2,305,396 2,400,697 2,497,055 2,594,481 2,692,986 2,792,580 2,893,274 2,995,080 8,460,837
46
Debt Investor TermsAnnualMonthlyTotal Cash Flow 147,127 292,215 442,386 674,403 910,585 1,149,154 1,390,135 1,633,551 1,879,428 2,127,789 2,378,660 2,632,066 2,888,032 3,146,584 3,407,747 3,671,547 3,938,012 4,207,568 4,479,840 4,754,858 5,032,648 5,313,238 5,596,655 5,882,929 6,172,087 6,464,160 6,759,174 7,057,161 7,358,150 7,662,171 7,969,254 8,279,430 8,592,729 8,909,184 9,228,825 9,551,684 24,403,220
47
Amount 2,104,080
48
Interest %18.0%1.5%
Cumulative Return %
49
Term (Months) 60 Equity Investors3.5%6.9%10.4%16.0%21.7%27.4%32.6%37.9%43.3%48.7%54.2%59.7%65.4%71.0%76.8%82.6%88.4%94.4%100.4%106.5%112.6%118.8%125.1%131.5%137.9%144.4%151.0%157.6%164.4%171.1%178.0%185.0%192.0%199.1%206.3%213.5%603.2%
50
Equity Kicker %14.0%
51
52
Exit Value
53
Earnings (Month 36) 322,859
54
Exit Multiple46.0x
55
Exit Value 14,851,536
56
Principal Outstanding- 1,283,161
57
Exit Value to Equity Holders
13,568,374
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