1
Feb-15
2
3
figure 3
4
5
Return Analysis
6
nnnn
7
PROJECT RETURNSYear 0Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
8
Aug-15Aug-16Aug-17Aug-18Aug-19Aug-20Aug-21Aug-22Aug-23Aug-24Aug-25Aug-26
9
hey guys
10
Project Cash Flow
11
Contributions (1,241,751)
12
General Partener20% (248,350) (248,350) - - - - - - - - - - -
13
Investor Partner80% (993,401) (993,401) - - - - - - - - - - -
14
Total100% (1,241,751) (1,241,751) - - - - - - - - - - -
15
16
Cash Proceeds for Distribution
 8,835,030 - 49,099 55,563 71,203 87,490 104,449 122,106 140,492 159,629 179,553 200,282 7,665,164
17
18
Project Cash Flows 7,593,279 (1,241,751) 49,099 55,563 71,203 87,490 104,449 122,106 140,492 159,629 179,553 200,282 7,665,164
19
Profit 7,593,279
20
IRR21.74%
21
NPV@8%$2,758,478
22
Multiple 7.11
23
24
Structures
25
Tier 10.0211%Daily rate
26
BoP Balance (1,241,751) (1,292,275) (1,340,095) (1,376,099) (1,398,697) (1,406,462) (1,396,873) (1,368,131) (1,317,952) (1,244,135) (1,143,384)
27
Equity Contribution (1,241,751)
28
Accrual (FV)8.00% - (99,623) (103,382) (107,208) (110,088) (112,214) (112,517) (111,750) (109,450) (105,736) (99,531) (91,471)
29
Paydown - 49,099 55,563 71,203 87,490 104,449 122,106 140,492 159,629 179,553 200,282 1,234,854
30
EoP Balance (1,241,751) (1,292,275) (1,340,095) (1,376,099) (1,398,697) (1,406,462) (1,396,873) (1,368,131) (1,317,952) (1,244,135) (1,143,384) -
31
Cash left for distribution - - - - - - - - - - - 6,430,309
32
IRR Check8.00% (1,241,751) 49,099 55,563 71,203 87,490 104,449 122,106 140,492 159,629 179,553 200,282 1,234,854
33
34
Tier 20.0383%Daily Rate
35
BoP Balance (1,241,751) (1,379,462) (1,530,819) (1,689,238) (1,855,134) (2,029,772) (2,212,132) (2,403,459) (2,604,349) (2,816,595) (3,038,802)
36
Equity Contribution (1,241,751)
37
Accrual (FV)15.00% - (186,810) (206,919) (229,623) (253,386) (279,087) (304,466) (331,820) (360,519) (391,799) (422,489) (455,820)
38
Paydown - 49,099 55,563 71,203 87,490 104,449 122,106 140,492 159,629 179,553 200,282 3,494,623
39
Balance (1,241,751) (1,379,462) (1,530,819) (1,689,238) (1,855,134) (2,029,772) (2,212,132) (2,403,459) (2,604,349) (2,816,595) (3,038,802) -
40
Cash left for distribution - - - - - - - - - - - 4,170,541
41
IRR Check15.00% (1,241,751) 49,099 55,563 71,203 87,490 104,449 122,106 140,492 159,629 179,553 200,282 3,494,623
42
43
Cash Flows to each Tranche
44
I. Pari Passu to 8.00% 2,404,721 - 49,099 55,563 71,203 87,490 104,449 122,106 140,492 159,629 179,553 200,282 1,234,854
45
General Partener20.00% 480,944 - 9,820 11,113 14,241 17,498 20,890 24,421 28,098 31,926 35,911 40,056 246,971
46
Investor Partner80.00% 1,923,777 - 39,279 44,450 56,963 69,992 83,559 97,685 112,394 127,704 143,642 160,226 987,884
47
48
II. Pari Passu to15.00% 2,259,768 - - - - - - - - - - - 2,259,768
49
General Partener20.00% 451,954 - - - - - - - - - - - 451,954
50
Investor Partner80.00% 1,807,815 - - - - - - - - - - - 1,807,815
51
52
III. Pari Passu above15.00% 4,170,541 - - - - - - - - - - - 4,170,541
53
General Partener40.00% 1,668,216 - - - - - - - - - - - 1,668,216
54
Investor Partner60.00% 2,502,325 - - - - - - - - - - - 2,502,325
55
56
57
Cash Flows
58
General Partener
59
Equity Investment (248,350) - - - - - - - - - - -
60
Proceeds - 9,820 11,113 14,241 17,498 20,890 24,421 28,098 31,926 35,911 40,056 2,367,141
61
CF 2,352,764 (248,350) 9,820 11,113 14,241 17,498 20,890 24,421 28,098 31,926 35,911 40,056 2,367,141
62
% of Total Profits30.98%
63
IRR25.90%
64
NPV@8%$909,430
65
Multiple 9.47
66
67
Investor Partner
68
Equity Investment (993,401) - - - - - - - - - - -
69
Proceeds - 39,279 44,450 56,963 69,992 83,559 97,685 112,394 127,704 143,642 160,226 5,298,023
70
CF 5,240,515 (993,401) 39,279 44,450 56,963 69,992 83,559 97,685 112,394 127,704 143,642 160,226 5,298,023
71
% of Total Profits69.02%
72
IRR20.38%
73
NPV@8%$1,849,048
74
Multiple 5.28
75
76
DISCLOSURE:
77
The financial projections and investment analysis represented herein contain estimates and assumptions based on our study of current market conditions. Brooklyn Investments, LLC neither warrants nor guarantees the results of these analysis as unforeseen events and changes may occur.