Loan and Property excel project

Take Home Project 1 Loan & Property Analysis

DUE 7/7/2013 ON WEBCOURSES

PLEASE UPLOAD ONE FULLY FUNCTIONAL EXCEL FILE (note needs to be an .xlsm file)

Submit an Excel Workbook with the following items, fully linked, updatable, and functional. Using a single property’s information 1. Amortized loan payment (up to 360 months) 2. Interest Only loan payment 3. Annual effective rate if points present 4. Full amortization schedule (up to 360 months) & ability to find balance at any month 5. Automatic maximum loan amount using both LTV and DSCR restrictions 6. Automatic Breakeven Occupancy Estimator (macro allowed) 7. Automatic NOI calculation (for proforma only)