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

$25

Budget

Details

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) 26 reviews

United States
Hummelstown 08:34 PM

104 Jobs Posted
50% Hire Rate, 1 Open Job

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

$7.99/hr Avg Hourly Rate Paid
2,837 Hours

Member Since Nov 11, 2007