RTO Calculator .xlsx

	C	D	E	F	G	I	J	K	L	M	N	O	P
1
2	#REF!
3	Statements in Kenyan Shillings
4	Summary
5
6
7	Lease Rentals					Return Rate Sensitivity Analysis
8	Lease Rentals Details	Amounts
9	Studio Apartments (Monthly)	15,000						Rental Increase
10	1 - beds Apartments (Monthly)	27,300					11%	-10%	0%	10%	20%	30%	40%
11	Rent Escalation (% of the initial rent price)	3%				% Deposit	0%	8.8%	10.2%	11.4%	12.7%	13.9%	15%
12	Lease Increase	0%					10%	9.3%	10.7%	12.0%	13.2%	14.5%	16%
13	Escalation Frequency	5 years					20%	9.8%	11.2%	12.6%	13.9%	15.1%	16%
14	TPS Lease Period	25 years					25%	10.1%	11.5%	12.9%	14.2%	15.5%	17%
15							30%	10.4%	11.8%	13.1%	14.4%	15.7%	17%
16	Development Costs
17	Phase Sales Break-Down	Units	Units (SQM)	Total SQM
18	Built Area:
19	Studio Apartments	214	3,852	824,328
20	1 - beds Apartments	235	7520	1,767,200
21
22	Units Details	Price	Discount	Deposit
23
24	Studio Apartments	2,195,000	20%	25%
25	1 - beds Apartments	4,350,000	20%	25%
26
27	Units Details	Price	Discount	Discounted Price	Deposit
28
29	Studio Apartments	2,195,000	439,000	1,756,000	439,000	Calculate the gap to 16% showing the gap
30	1 - beds Apartments	4,350,000	870,000	3,480,000	870,000
31
32	Price/Square Meter	Original Price	Discounted Price			Return to investors
33						Equity schedule for mortgage payments and defauklsts showing individual schedule and equity earned
34	Studio Apartments	121,944	97,556
35	1 - beds Apartments	135,938	108,750
36
37	Project Sale (KES) Millions
38	Sales	Gross Sales	Discount	Net of Discount
39	Studio Apartments	470	94	376
40	1 - beds Apartments	1,022	204	818
41	Total Project Sales	1,492	298	1,194
42
43	Deposit Paid to Developer			298
44	Balance Paid by Funder			895
45	Total Project Sales			1,194
46
47	Funding Structure
48	Funding Type	Asset Backed Security/ I-ReIT
49	Funding Amount Raised	920
50	Funding Return	10.69%
51
52	Use of Funds (KES) Millions
53	Developer Payment	895
54	Transaction Fees	23
55	Total Funds Raised	918
56
57	Tenant Purchase Scheme
58	Description (KES)	Millions
59	Collection Over TPS Life
60	TPF Funding	920
61	Rent Collected	2,692
62	Other Incomes Including Service Charge	708
63	Interest Income	14
64	Total Collection Over TPS Life	4,334
65
66	Payments Over TPF Life
67	Developer Payment	(895)
68	Facility Management	(779)
69	Loan Principal & Interest Repayment	0
70	Transaction Fees	(23)
71	TPS Management Fees	(5)
72	Overdraft Interest	#REF!
73	Total Payments Over TPF Life	(1,702)
74
75	Dividends Pay Out	2,632
76
77	Funding Gap	0
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100