Effective Lease Rate Rent Calculations with Various Terms

Norm Miller & Jared Rodio

Commercial Real Estate Answers to End of Chapter Questions- Ch 14- Discounted Cash Flow Analysis

Commercial Real Estate Answers to End of Chapter Questions- Ch 17- Mortgage Calculation and Amortization

Commercial Real Estate Answers to End of Chapter Questions- Ch 30- Effective Rent Spreadsheet

Band Mortgage Equity Capitalization or Atkerson format Ellwood

(This is the classic Ellwood Method of deriving a cap rate updated to allow for compounding of NOI over time and useful for examining assumptions behind market cap rates.)

Conversion of rent to minimum affordable home or condo price

(This excel file converts rent to the equivalent break even home price whereby the after tax cost to own for one year is the same as renting.  It is the minimum fundamentally supportable value for the unit, although it ignores future rent increases unless a higher initial rent is assumed)

DCF Proforma

(This is a classic 10 year cash flow proforma with allowance for refinancing.  Useful financial ratios and rates of return are calculated.)

Effective Rent Spreadsheet

(This file adjusts uneven rent payments such that the equivalent period payment known as effective rent has the same present value.  Discount rates and the perspectives of landlords and tenants are considered.)

Mortgage-Calculation-and-Amortization

(This file generates monthly and annual payment summaries.)

PORTFOLIO Calculations

(This is a simple portfolio demonstration)