Investment Property Spreadsheets
Provided courtesy of Michael Kelly, www.MortgagesExposed.com
Investment and Mortgage Calculator
Illustrating the effect of using a savings scheme alongside an
interest-only mortgage, and calculating the optimum savings rate from a
given performance estimate. Includes two examples.
(Excel
or Lotus)
Investment Property Returns
A useful spreadsheet for those interested in buy-to-let or commercial
property as an investment. Estimate the return on capital for almost any
scenario. Determine when it pays to borrow and use gearing to enhance your
return.
(Excel
or Lotus)
Project IRR
Take any project with monthly cash flows and calculate the IRR.
(Excel
or Lotus)
Property Portfolio
A dynamic example of how to build up a portfolio of 16 commercial
properties over twenty years using mortgages and re-invested rental income
and, given initial assumptions, immediately calculate the surprising
outcome.
(Excel
or Lotus)
|
