Write an Excel Script to calculate Real Estate Deals
Closed - This job posting has been filled and work has been completed.
The Excel sheet needs to calculate all those things by simply entering the information and spit out the calculation of each. Also I need those calculations done for both the entire property and also on a per unit basis as well and account for the value of if one is a 2 bedroom 1 bath or something like a studio.
Rental Investment Calculations
1. NOI (Net Operating Income)= Income – Expenses
2. Cash Flow = NOI – Debt Service
3. ROI (Return on Investment) = Cash Flow / Investment Basis
4. Cap Rate (Capitalization Rate) = NOI / Property Price
5. COC (Cash-on-Cash Return) = Cash Flow / Investment Basis
6. Total ROI = Total Return / Investment Basis
7. GRM (Gross Rent Multiplier) = Market Value / Annual Gross Income
8. LTV (Loan to Value) = Loan Amount / Value of Collateral
9. Price per square foot