Online Financial Modelling, Budgeting and Forecasting Course

Aggregation Exercise 1

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

In this exercise we want to consolidate a number of buildings we own into a total, but we may want to sell or buy some buildings and we don’t want to have to keep changing the formula.

Question

On the appropriate sheets

  1. Look at the setup and information in Building 1 to Building 4
  2. Note that on each sheet the same type of information is exactly in the same place.
  3. Note the Beg>> and <
  4. Go to the Consolidation sheets and do the following
  5. In G7 row use the Summing Through Sheets formula to add up all the units from Beg to End. You do this because as some stage you may want to remove Building 1 or Building 4 and can’t do it if you refer to them as the first and last part of the formula
  6. In G12 row do the same as above for the revenue
  7. In G13 row do the same as above for opex
  8. Go back to G8 row and calculate the average rent (total rentals / number of units)
  9. Go back to G9 row and calculate the average opex (total opex/ number of units)
  10. Go to H2 row and calculate the rental escalation factor
  11. Go to H3 row and calculate the opex escalation factor
  12. Notice the number in F17
  13. Remove Building 1 from the calculation by dragging the sheet outside of the area between Beg>> and <
  14. Go back to the consolidation sheet and look at F17 again
  15. Play with moving Buildings in and out of the area
  16. Create your own building (copy the sheet exactly), capture some inputs, and add it to the area to see the impact

To see the full course contents click here.

0 of 97 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop