IRR Examples - InvestOrama

	B	C	D	E	F	H	I	O
1
2	WELCOME TO INVESTORAMA PRIVATE CAPITAL
3
4
5
6
7						Magic Yield
8		EXAMPLE 1			EXAMPLE 2	10%
9		Orama Private Income Strategy Fund			Orama Automotive Strategy Fund
10	Year	FLOWS		Year	Garage			TOTAL
11	0	-100	-100	0	-100	-120		-50
12	1	10	0	1	104	104
13	2	10	0	2	1	-29		#VALUE!
14	3	10	0	3	1	41		0
15	4	10	0	4	1	-49		4
16	5	10	0	5	1	31		5
17	6	10	0	6	1	51		106
18	7	10	0	7	1	1		107
19	8	10	0	8	1	21		108
20	9	10	0	9	1	11		9
21	10	110	259	10	1	51
22
23	IRR	10%	10%	IRR	10%	17%		#VALUE!
24
25	Net flows	100	159	Net flows	13			5.5
26
27	Total Value to Paid In	2	2.59	Total Value to Paid In	1.13
28
29
30				This is here to vizualize the impact of SLoC (Standard Line of Credit ) used by PE Firms
31				Borrow to change the cashflows and boost the IRR but at a cost
32
33		EXAMPLE 3			EXAMPLE 4a		EXAMPLE 4b
34		Enhanced Private Income Strategy Fund			Orama Private Equity Fund		Orama Private Equity Fund with SLoC
35	Year	FLOWS		Year	FLOWS	Year	FLOWS
36	0	-20		0	-50	0	0
37	1	0		1	0	1	-50
38	2	-30		2	-50	2	0
39	3	40		3	0	3	-50
40	4	-50		4	0	4	-3
41	5	30		5	0	5	0
42	6	50		6	0	6	0
43	7	0		7	0	7	0
44	8	20		8	100	8	100
45	9	10		9	100	9	100
46	10	50		10	100	10	100
47
48	IRR	21%		IRR	15%	IRR	17%
49
50	Net flows	100		Net flows	200	Net flows	197
51
52	Total Value to Paid In	2		Total Value to Paid In	3	Total Value to Paid In	2.9
53
54
55
56
57	CAGR	21%	10%
58
59	RETURN IN 10Y	667.85	259.37
60
61
62
63
64
65
66		If you invested $100 in the S&P 500 5 years ago, you'd have $182 today
67		With the flows below you'd get $156, but an IRR of 23%
68
69		Year	FLOWS
70		0	-50
71		1	39
72		2	-50
73		3	39
74		4	39
75		5	39
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100