ABCDEFG
1
DO NOT REQUEST EDIT ACCESS TO THE FILE. JUST SAVE A COPY TO YOUR GOOGLE DRIVE WILL DO~ ^^
2
3
License:
4
Created by Gracie @ RinggitFreedom.com and licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
5
Provided for free at ringgitfreedom.com/resources, not for SALE or COMMERCIALIZATION or PROFITS. Appropriate credit/link back must be provided for forks.
6
7
Instructions:
8
Sample data provided for easy reference. Feel free to override default calculations & input your actuals.
9
Fill in the blanks, input cells are highlighted in yellow as per -->
10
Grey calls are formulas, don't edit / touch them -->
11
12
Summary
13
Initial Property Price RM 405,000
14
Today's Market Price RM 500,000
15
Property OwnershipOccupational GainsOpportunity Costs
16
(a.k.a. Minimum Selling Price to Breakeven) Total Costs of Ownership RM 462,731 RM 643,800 RM (220,000) RM 38,931
17
Are you Profiting, or not?Profit!
18
Net Gain / (Losses) RM 37,269
19
ROI %8.05%
20
CAGR %0.65%
21
22
Mortgage & Transactions
23
First, the dates...
24
Start Date / Handover Date (date when Full Loan starts)01/05/2012
25
End Date / Today's Date (date you plan to sell property)01/05/2024
26
Total Months144
27
28
INITIAL SEEDING COSTS
29
Did you pay downpayment for your property? If so, provide the amount below
30
Downpayment RM 63,000
31
32
Did you pay any fees to own the property? (i.e. SPA or Loan Legal Fees, Stamp Duty, Taxes, Memorandom of Title Transfer, Consultation, Agent Commissions)
33
Total Legal, Stamp Duty, RGPT Tax and Misc. Fees RM 28,350
34
35
Did you spend any monies to furnish, repair, or renovate the house?
36
Renovation Fees RM 10,000
37
Furniture / Appliances / Etc. RM 8,350
38
39
Did you take up any mortgage-specific insurances upfront? If so, provide your details below. (e.g. MRTA, MLTA).
40
IGNORE THIS SECTION IF MRTA/MLTA ALREADY FINANCED INTO YOUR MORTGAGE! Only applicable if you buy outside.
41
Lumpsum Payment RM 10,500
42
43
MORTGAGE COSTS
44
Did you take up mortgage? If so, provide your Mortgage Details below
45
Monthly Mortgage (Principal + Interest) RM 1,650
46
Mortgage Loan Amount RM 342,000
47
Current Outstanding Balance RM 250,000
48
Total Paid (Principal + Interests) To Date RM 237,600
49
Loan Capital Paid RM 92,000
50
Loan Interest Paid RM 145,600
51
52
53
RUNNING COSTS
54
Were there any monthly Maintenance Fees / Sinking Funds charged by Building Management to Owners?
55
Monthly Fees RM 150
56
Total RM 21,600
57
58
Were there any yearly taxes/insurances associated to Property Ownership? (i.e. Fire Insurance, Quit Rent/Cukai Tanah, Parcel Rent/Cukai Petak, Assessment Rates/Cukai Taksiran)
59
Yearly Fees RM 1,200 100.00
60
Total RM 14,400
61
62
If you did not take up mortgage specific insurance, did you buy equivalent coverage of life insurance to secure the mortgage loan? If so, provide your details below.
63
IGNORE THIS SECTION IF MRTA/MLTA ALREADY FINANCED INTO YOUR MORTGAGE! Only applicable if you buy outside.
64
Monthly Fees RM -
65
Total RM -
66
SELLING COSTS
67
Do you foresee any other costs with the transaction to sell the property? (i.e. SPA or Loan Legal Fees, Stamp Duty, Taxes, Title Transfer, Consultation, Agent Commissions, Listing Fees)
68
Total Legal, Stamp Duty, RGPT Tax and Misc. Fees RM -
69
70
SUBTOTALS
71
INITIAL SEEDING COSTS RM 120,200
72
MORTGAGE COSTS RM 487,600
73
RUNNING COSTS RM 36,000
74
SELLING COSTS RM -
75
PROPERTY OWNERSHIP TOTAL COST RM 643,800
76
77
Occupational Gains (Own Stay/Rent Out/Vacant)
78
How much is the estimated Monthly Rent for this property? To simplify, we'll only use one input. Average out if the rental rate fluctates over course of time. (i.e. total rental income / total months)
79
Monthly Rent RM 1,667
80
81
Did you rent the property out for income generation?
82
For How Many Months?12
83
Total Rental Earned RM 20,000
84
85
Did you use the property for your / family's own stay? If so, provide estimated cost if you were to rent in similar areas throughout your duration of stay
86
For How Many Months?120
87
Total Rental Avoided RM 200,000
88
89
Did you leave the property vacant due to whatever reasons? (Renovation, Seeking New Tenant, etc.)
90
For How Many Months?12
91
92
Make sure you account for all the months, the number here must tie with above mortgage months
93
OCCUPATIONAL / VACANT MONTHS144Gap0ChecksumTRUE
94
95
Opportunity Costs Calculation
96
Do you want to calculate opportunity cost? There will be various questions below to check assumptions for simulation purposes.
97
ChooseYes
MASTER SWITCH
98
Interest Rate (Annum) Net of Fees5.95%
(e.g. EPF 10-years average 5.9%, Fixed Deposit 3%, etc.)
99
100
Would you need to incur similar rental cost, assuming you didn't have this property? (e.g. if you stay at parent's for free, choose "No". If you need to find / rent similar-priced places, choose "Yes")