ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Anomaly Investor Metric Template
2
Use this template for a quick analysis of your rental property purchase!
3
4
5
6
Fill in These Cells
7
Investor Metrics:
These Cells Auto-Calculate
8
Cash on Cash Return (Unlevered)30%
9
Cash on Cash Return (Levered)7%
10
DSCR:2.23
11
Cap Rate:12%
12
Payback Period (Years):3.30
13
14
15
16
Property Financial Summary
17
18
Projected Rent$4,500
Enter MONTHLY. To convert to daily, change formula in cell b19 to 365 days
19
Occupancy %95%
20
Monthly Gross Income $ 4,275.00
21
Monthly Net Cash Flow Unlevered $ 1,833.33
22
Monthly Net Cash Flow Levered $ 426.58
23
24
Yearly Gross Income $ 51,300.00
25
Unlevered Yearly Net Cash Flow $ 22,000.01
26
Levered Yearly Cash Flow $ 5,119.02
27
28
29
Tax Summary*
30
Taxable Income $ 22,000.01 Depreciation Lives
31
Interest Expense$13,101.80 Commercial/STR LTR
32
Tax Depreciation$9,710.40 3927.5
33
Taxable Income (Loss) $ (812.19)
34
35
36
37
*Be sure to consider tax strategies on top of this baseline analysis! The depreciation is for example purposes only and may slightly differ due to land/building allocations and dates placed in service.
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