Agenda:

1 Background and Automation Goals

  1. Select-able button with exhaustible financing scenarios for new projects.
  2. Financing assumption table and project variable tables are maintained in the master template.
  3. Once new project is set up and rolled month over month, project cash flow is maintained with minimum effort.
  4. Streamline the cash flow consolidation process reliably
  1. Make use of new HB data and build data connection in existing cash flow files
  2. Automate land cash flow, making use of current financing assumptions
  3. Build similar formatted cash flow files across projects
  4. Develop new template for newer projects, similar to Original goals 1-4.

2 Progress & TO DO

  • Overview:
  1. Single phase automation: 100%HB, 10%Land (OT existing projects, old template)
  2. Multi-phase automation: 30%HB, 10%Land (OT existing projects, old template)
  3. Project To Division: TBD
  4. Division to Consolidation: 90%(old template)
  5. Single phase automation: 60%HB, 0%land (New Template)
  • Acquisitions:
  1. Version 01,(2021.Mar) : static assumptions(unselectable type, fixed financing,crude construction costs), static deposit, land/HB financing combined
  2. version 02,(2021,May) : static assumptions, static deposit, land/HB financing separate
  3. Version 03,(2021, July): static assumptions,multi-phasing, static deposit, Land/Hb financing separate
  4. version 04,(2021, Aug): static assumptions single-phase template with selectable inputs
  5. version 05,(2021, Sep): single-phase template with selectable inputs(home type, financing), HB/Land cashflow waterfalls breakdown, static deposits.
  6. version 06,(2022,Mar-April): two simplified versions of GTA models created for Creekside, Bront River and Summer Valley, static inputs with dynamic deposits, and fine-tuned financing.

  • Automation:

  1. Version 01: Rhythm
    1.1, 2021-Nov: profit reconciliation and data issues such as PS costs, direct construction costs,etc.
    1.2, 2021-Dec: discussion and solving data issues
    1.3, 2022-Jan: static data version is created for Rhythm, and financing is built in specifically for this project.
    1.4, generally: total budget/deposit/financing interaction is not quite clear.

  2. Version 02: Parkview
    2.1, 2022-Jan: polishing up financing, but the budget/deposit interaction has issues: assumption is 5% *( total budget-deposit)
    2.2, generally: Lots have been focused on reconciling total cash flow with total profit

  3. Version 03: Creekside
    3.1, 2022-Jun: dynamic deposit, standard financing for HB, manual lines for costs and financing
    3.2, to date: finish HB.

  4. Version 04: Rhythm
    4.1, 2022-Jul: Integrate HB financing to creekside
    4.2, 2022-Aug: Build in Land cash flow

  5. Version 05: Mer Blue
    5.1, 2022-Sep: Integrate HB financing to rhythm
    5.2, 2022-Oct: Build in land cash flow

  • Land Automation:(build in connection to existing project file)

  1. OTT Land: land CF that has existing HB CF
    1.1, 7 projects: OTL300,OTL400,OTL404,OTL406,OTL500,OTL505,OTL506,

  2. OTT Land: land cash flow under new template
    2.1, 10 projects: OTL302, OTL303, OTL305, OTL402, OTL405, OTL501, OTL504, OTL601, OTL602, OTL603

  • Cash Flow Consolidation
  1. existing template works ok, DIVISION –> CONSOLIDATION
  2. the link file between project and division CF needs to be created once new template are well in use, or alternatively:
  3. cash flow is downloaded into a divisional cash flow file

3 Challenges during developmnent

  1. Single phase model requirement: switch from financial to operational model

  2. multi-phase data integration, but the logic needs to be clarified

  3. some feedback from Ottawa division team: too many excels lead to crash, a choice between excel and database as source.