Global apartment investment analysis

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