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 3 years ago

Fixed Price

Budget: $25
Delivery by July 4, 2013

Start Date

June 7, 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) 27 reviews

United States
Hummelstown 07:05 PM

111 Jobs Posted
48% Hire Rate, 1 Open Job

Over $20,000 Total Spent
70 Hires, 11 Active

$7.97/hr Avg Hourly Rate Paid
2,854 Hours

Member Since Nov 11, 2007