Apartment/Multi-Family Building Acquisition and Renovation Financial Modeling Self-Study Video Tutorial with Excel File
AptProduct1

Apartment/Multi-Family Building Acquisition and Renovation Financial Modeling Self-Study Video Tutorial with Excel File

$199.00

Academic Price – $99.00

To get Academic pricing, click Academic Verification in the header and follow the instructions. Once you have Academic status, the discounted pricing will show in your cart.

Sample Content

Product Description

An interactive Video Tutorial that teaches you how to model the acquisition and individual unit renovation of a multi-family rental building with ground-floor retail and income-producing parking. Allows you to understand the risks and income generation/cost savings copportunities inherent in performing a value-add renovation program while continuing to operate the building.  Also applies to the acquisition of distressed or foreclosed properties. Includes fully-assembled, fully-unlocked Excel file and hands-on Tutorial exercises and accompanying solutions.

Product includes the following items, which never expire:

 Online access to an easily navigated 75-minute Video Tutorial, playable on any device including PC, Mac, phones and tablets

SelfStudy750pxwide

 Accompanying fully-unlocked, annotated Excel file, compatible with both PC and Mac, which you can repurpose for future analyses

Excel file includes the following tabs:

  • Rent Growth Variables
  • Assumptions Overview block diagram
  • Rent Roll
  • Assumptions
  • Renovation Timing
  • Cash Flow Overview block diagram
  • Monthly Cash Flow Exercise
  • Amortized Renovated Unit Losses
  • Monthly Cash Flow Solution
  • Annual Cash Flow
  • Amortization Schedule for Acquisition Loan
  • Amortization Schedule for Permanent Loan

PDFs of slide presentation and Offering Memorandum for a Miami Beach, FL apartment complex

What You Will Learn

A mastery of Excel-based technical financial projection modeling skills for the acquisition and individual unit renovations (with continued operation) of a rental apartment building with ground-floor retail. The principles and skills taught apply equally to duplexes and 1,000-unit complexes. Topics covered include:

  • Integration of historical property data and existing rent roll into your pro-forma
  • Modeling of future lease expirations and renewals and the individual unit renovation program
  • Modeling of operating expense savings gained from the renovation/greening of apartment units
  • Modeling of acquisition loan financing, residual equity requirement, and permanent take-out loan/refinancing
  • Constructing amortization tables and using the VLOOKUP function efficiently
  • Property Disposition modeling
  • Running of sensitivity analyses around key variables in 2-way Data Tables.

The Half-Yearly sale is here! 40% off all digital products with coupon code: 201740
left to take 50% off with coupon code: yearend50