Band Mortgage Equity Capitalization or Atkerson format Ellwood

Incorporate and understand a financing's impact on value and compute the cap rate.

assumptionsatkersoncap ratecapitalizationellwoodfinancemortgagenoireal estate

Description
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.

Inputs:
- NOI Year 1
- NOI Growth Rate Per Year
- Equity Yield Target
- Mortgage Rate
- Amortization Term Yrs
- Loan to Value ratio
- Holding Period
- Transactions costs at sale

Outputs:
- Cap Rate
- Value
- Debt Coverage Ratio (DCR)

- Prof. Norm Miller, PhD

This business tool includes
1 Excel Model

Prof. Norm Miller, PhD offers you this business tool for free!

Download for free

Ask a question

Reviews

  • No review yet!

Any questions on Band Mortgage Equity Capitalization Or Atkerson Format Ellwood?

The user community and author are here to help. Go ahead!

please wait...