Global apartment investment analysis
Originally published: 08/09/2020 14:05
Last version published: 08/09/2020 20:23
Publication number: ELQ-47904-2
View all versions & Certificate
certified

Global apartment investment analysis

A model for a real estate fund that allows the integration and forecasting of multiple properties incomes and renovation

Description
This financial model was created to model any number of properties held in a fund structure by multiple investors. The model allows for an unlimited number of properties, purchased at different dates, with waterfall structure of redemptions and different financing options, including blanker financing.
Block 1 - General information (conclusions)
Global Inputs: Fund Start Date, Reinvestment Rate, IRR, GP, LP (calculated field), Interest Rate (%), Number of Years, Number of Payments Per Year, Interest Only Term
Investor Report: EXISTING DEALS, Amount Invested, Cash Out Option, Roll Into Fund Option, % Ownership, TOTAL VALUE REALIZED, (there is an active macro on the page, with which you can select both individual apartments for analysis and get information on all at once)
Cash Flow Summary: NOI, EBIT, Principal, Interest, Annual Debt Service, Cash on Cash Yield %, Participant –°ontributions, Net Summary, Split (there is an active macro on the page, with which you can select both individual apartments for analysis and get information on all at once). * All indicators are calculated automatically using formulas
Loans: all information about borrowed funds (terms, interest, value, sources)
Mortgage Summary: Loan Amount, Interest Rate (%), Number of Years, Number of Payments Per Year, Interest Only Term Start Date (optional). –°omparison of projects as a whole, as well as separately for each project. The page is equipped with formulas.
Block 2 - Cash flow analysis (for all 8 variants)
Block 3 - Investor Report (for all 8 variants)
Block 4 - Information by Apartments


This Best Practice includes
1 Excel Model

Acquire business license for $59.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Global Apartment Investment Analysis?

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


0.0 / 5 (0 votes)

please wait...