In the pages that follow, you will find a variety of spreadsheets that will help you quickly analyze your apartment transactions.
The Loan Comparison Chart will let you calculate different loan scenarios on a side by side basis. You can see how different loan amounts and interest rates will affect your mortgage payment.
The Commercial Property Loan Quick Qualifier will enable you to quickly calculate the Debt To Service Ratio to see if the property cash flows properly. Use this spreadsheet to quickly filter deals in order to see if there is any need to analyze the property further.
The Automatic Property Cash Flow Analyzer will automatically insert the expenses based on common underwriting guidelines. You may have to adjust some fields, for example the real estate property tax rate will need to mirror your states property tax rate. This form should be used if your property passes the Commercial Property Loan Quick Qualifier test.
If you have any questions, please feel free to contact us.
