EP24: The Lukas Show | Deal Analyse

	B	C	D	F	G	H
1	Purchase			KPIs
2	Purchase Price:	$140,000		Multiple:	8.03
3	Down Payment:	$35,000	25%	Gross Rental Yield:	12.46%
4	Interest Rate:	4.25%		Net Rental Yield (Cap. Rate):	5.50%
5	Loan Term:	25	Years	Cash on Cash Return:	2.23%
6	Mortgage Amount:	$105,000		Cash on Cash (incl. Principal):	8.21%
7	Closing Costs:	$4,480	3.20%	Total Rental Income:	$576,545
8	Repairs:	$0		Total Mortgage Payments:	$170,648
9	Total Investment	$144,480		Total Net Operating Income:	$199,658
10
11				First Year Income and Expense	Monthly	Annual
12	Recurring Operating Expenses (Annually)			Gross Income:	$1,500	$18,000
13	Property Tax:	$5,935	2.00%	Vacancy:	$75	$900
14	Total Insurance:	$800	2.00%	Property Tax:	$495	$5,935
15	Management Fee	$1,260	7%	Total Insurance:	$67	$800
16	Maintenance:	$900	5%	Management Costs:	$105	$1,260
17	Other Costs:	$500	2.00%	Maintenance Cost:	$75	$900
18				Other Cost:	$42	$500
19	Income			Expenses:	$858	$10,295
20	Monthly Income:	$1,500	2.00%	Net Income:	$642	$7,705
21	Other Monthly Income:
22	Vacancy Rate:	5%		Interest:	$372	$4,463
23				Principal:	$197	$2,363
24				Mortgage Pay:	$569	$6,826
25
26				Net Operating Income (NOI):	$642	$7,705
27				Cash Flow:	$73	$879
28				Cash Flow (incl. Principal):	$270	$3,243
29
30
31	The Lukas Show - Episode 24
32	https://youtu.be/FemYWGrC6uA
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
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