Activity

Calculating Conservatorio Financials

Net Operating Income

Download the NOI activity spreadsheet . The first sheet, 'Assumptions and Summary', contains the financial overview for the Maria Inmaculada property. Acquisition expenses and income information is presented for the first year in both dollar and dollar per meter square terms. Lease income is calculated based on information contained in the 'Supporting - Rental Roll' sheet. There are 2 retail units, 12 office units, as well as a cafe and rooftop space within the property. Total revenue and maintenance costs are calculated within this sheet. Values in blue are taken as given.

Within the Rental CF, fill in the Annual Income and Operating Expense information in order to calculate the Net Operating Income.

NOTE: ONLY ADJUST VACANT BLUE CELLS


What is the net operating income for years 1, 5, and 10 for Conservatorio’s Maria Inmaculada property to the nearest dollar

Net Operating Income for Maria Inmaculada

Year 1:
Year 5:
Year 10:
Need a hint?... That is is incorrect. Try giving it another go.
Internal Rate of Return

Download the Sale and Cash Flow activity spreadsheet . The first sheet, 'Assumptions and Summary', contains the financial overview for the Maria Inmaculada property. In addition to acquisition expenses, financing expenses and exit information provided.

NOTE: ONLY ADJUST VACANT BLUE CELLS


What is the sale value of the Maria Inmaculada property in year 10 based on year 11's NOI?

What is the levered and unlevered IRR?

Sale value:
Levered IRR:
%
Unlevered IRR:
%
Need a hint?... That is is incorrect. Try giving it another go.
  •  
  •  
  •  
  •