Rent Vs Buy Calculator - Assetyogi.xlsx

of 16
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 8 | Pages: 16

Extension: PDF | Download: 1

Share
Description
Description:
Tags
Transcript
  Rent Vs Buy Calculator Analysis Period20Years Renng Monthly Rent 15,000 HRA Tax Beneft20%Eecve Monthly Rent 12,000 Eecve Annual Rent (R ) 144,000 Annual Rental Increase8% Rent (Analysis Period) (R') 6,589,723 Returns on Savings Downpayment (D) 1,000,000 20,989 Expected Returns%12% Afer Analysis PeriodFV o Downpayment (D') 9,646,293 8,683,165 Net Savings (D'+S'-R') 11,739,736 Future Value o Monthly Savings - CalculaonYear12 Monthly Savings (S)(EMI @9% - Monthly Rent)(Calculaon Below) FV o Monthly Savings (S')(Detailed Calculaon Below)  Annual EMI 431,868 431,868 Annual Rent 180,000 194,400 EMI - Rent 251,868 237,468 NPV (EMI-Rent) 900,156 FV o NPV o (EMI-Rent) 8,683,165  By: AssetYogi Enter Figures in Yellow Cells Buying Property Price (P) 5,000,000 Downpayment 1,000,000 Loan Amount 4,000,000 Loan Interest Rate9% EMI (@9%) 35,989 Tax Bracket 20%Eecve Interest Rate7.2% EMI (@7.2%) 31,494 Total Interest Payment (@7.2%) (I) 3,558,553 Maintenance Per Month 2,000 Annual Increase6% 882,854 Total Costs (C = P+I+M) 9,441,407 Sell Afer Analysis Period Annual Appreciaon8% FV o Property (P') 23,304,786 Net Savings (P'-C) 13,863,378 3456 Total Maintenance DuringAnalysis Period (M)   431,868 431,868 431,868 431,868 209,952 226,748 244,888 264,479 221,916 205,120 186,980 167,389
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x