Write an Excel Script to calculate Real Estate Deals

Closed - This job posting has been filled and work has been completed.
Data Science & Analytics Quantitative Analysis Posted 2 years ago

Fixed Price

Delivery by July 4, 2013




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

About the Client

(4.41) 25 reviews

United States
Hummelstown 12:11 PM

103 Jobs Posted
50% Hire Rate, 1 Open Job

Over $20,000 Total Spent
64 Hires, 10 Active

$8.07/hr Avg Hourly Rate Paid
2,788 Hours

Member Since Nov 11, 2007