This is a Google Sheet with the following capabilities to evaluate the profit potential of your real estate investment:
☆ Easy to use templates for due diligence of watch listed properties
☆ Financial model to evaluate attractiveness of investments, incl. ROI, IRR, cash multiple calculations
☆ Projections of year by year cash flows from rent and expenses for better financial planning
☆ Includes a debt amortization calendar to understand how your loan should be repaid - according to your loan amount, interest rates and repayment schedule
Model comes with 4 types of Tabs:
1. RESEARCH: Use this tab for your research of properties in the same city / area under your watchlist. Understand how current listings for sale compare against other rental and recently sold properties. For your reference, I created a sample for the Las Vegas area in a separate tab
2. FINANCIAL MODEL: Once you have a property identified for further analysis, key in estimated financial data to evaluate profit and return potential of a property. Do rental property analysis like a professional!
3. LOAN AMORTIZATION: Based on your loan amount, interest rates and repayment schedule, understand how your loan should be repaid.
4. CHECKLIST: To ensure that nothing is missed during your purchase process, I have created a comprehensive checklist for project management of the due diligence process.