Publication number: ELQ-60041-1
View all versions & Certificate
Band Mortgage Equity Capitalization or Atkerson format Ellwood
Incorporate and understand a financing's impact on value and compute the cap rate.
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.
- 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
- Cap Rate
- 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
Add to bookmarks
- Jared Pretorius(last updated: 28/12/2017 00:21)
People using this tool also downloaded
Commercial Real Estate Financial ModelCompute a Commercial Real Estate Valuation and Financial Feasibility of your Investment Project - excel modelinvestmentfinancereal estateassumptionsproject financeproperty valuation2,489 remove_red_eyefreeby Will Ferrigno
Property Mortgage CalculatorModel for calculating and tracking mortgage repaymentsbudgetfinanceinterestreal estatemortgagepropertypaymet schedule402 remove_red_eye
Discounted Cash Flow (DCF) Analysis with IRR and NPVSeveral spreadsheets that can be used for the analysis of a real estate investment from various perspectivesacquisitionfinancecash flownpvirrdcfreal estatefinancial analysisinvestingdiscounted cash flow6,204 remove_red_eye
Venture Capital Method (Single Round Financing)A full model enabling an entrepreneur to understand assumptions of both sides of the table in a single round financinginvestmentfinancevaluationfinancingventure capitalassumptionsentrepreneursingle roundunstaged investmentstaged investment5,354 remove_red_eye
Rental Property Investment ModelA model for calculating returns on rental propertiesinvestmentfinancereal estateinvestorpropertysensitivity analysisrental property3,132 remove_red_eye
Cash Flow Waterfall ModelA cash flow model for Real Estate based on a waterfall structurefinancecash flowreal estatewaterfallinvestordeveloper4,329 remove_red_eye
Startup Excel ModelA startup financial model that can be sent to a Venture Capital, Private Equity Firm or Hedge Fund.financecash flowprivate equityfinancial modelstartupfundraisingventure capitalassumptionscapexheadcount8,260 remove_red_eye
Real Estate Excel ModelA Real Estate Financial Model where new property owners purchase their houses outrightfinancereal estatefinancial modelproceedstown housereturnsenior debtmezzanine debt2,420 remove_red_eye
Sustainable Growth TemplateUnderstand the links between the Starting Balance Sheet, Year 1 Income Statement and Ending Balance Sheetfinanceleverageretentionassumptionsentrepreneurstarting balance sheetfinancial resultsending balance sheetoperating margin138 remove_red_eye
Calculate Effective Rent SpreadsheetDetermine effective rent of landlords and tenants while considering discount rates and uneven rent payments.financepresent valuereal estateeffective rentlandlordtenantdiscount ratetemplatefree964 remove_red_eye
Any questions on Band Mortgage Equity Capitalization Or Atkerson Format Ellwood?
The user community and author are here to help. Go ahead!