Apartment Acquisition Financial Model Excel Template

  • Present fundamental measurements of an investment opportunity;
  • Measure operating, capital and financing costs;
  • Present the cash stream of an investment;
  • Create dashboard to present to the bank or clients;
  • Run “whenever sold” situations which permits to pick the best deal date;
  • Perform valuation of an investment property;
  • Assess the attainability of the renegotiating alternative and a measure of take out;
  • Assess a scope of rental and exit scenarios.
  • Assumptions Tab;
  • Annual Cash Flow for 10 years;
  • Debt Schedule, which incorporates the renegotiating and interest-just choice for the loan;
  • Dashboard with primary measurements, charts, and graphs.
  • Cost/Square Footage (Sqm), Sale Price/Unit, Net Rental Revenue;
  • NOI, Debt Service, Net Leveraged Cash Flow;
  • NPV, DCF Valuation;
  • DSCR, Cash on Cash Return, IRR, Equity Multiple, Net Profit.
  • Exit value for the property is determined naturally dependent on NOI for a period and cap rate you expect in your projection.

FINANCIAL MODEL ADVANTAGES

APARTMENT ACQUISITION PRO FORMA EXCEL TEMPLATE REAL ESTATE KEY FEATURES

WHAT WILL I GET WITH APARTMENT ACQUISITION REAL ESTATE SPREADSHEET?

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store