Cash Flow Meeting With Mike

---

Meeting Discussion Points:

• Deliverable Requirements: TBD

• Progress within One Month (Aug 10):

  • Existing project only, integrate Homebuilding New Source with existing financing in excel, each project only has one refreshable file (e.g. Fox Run).

  

    * Fox Run (OT300)
    * Conservancy (OT400)
    * The Ridge 1/2 (OT404)
    * Ridge phase 3/4 (OT406)
    * Orleans Village (OT500)
    * Summerside (OT503)
    * Rhythm (OT505)
    * Mer Blue (OT506)
    * GTA, Creekside with standard financing.
    * GTA, Parkview with standard financing.

---

• Blackbox (complexity) of financial modeling for Project cash flow: Major difference of existing model vs new CFA (cash flow automation) model: projections ONLY & All Project Life.

---

********** for Project i in projectSets {FR,BC,TR1/2,TR3/4,OV,SS,RH,MB} **********

* Profit Reconciliation for Deposits, manual costs, profit distribution cash flow and cash balance adjustments to be agreed with total profit, for upload/consolidation purposes. (60%) 
* Draw/Repayment bank financing,Source of Costs for Drawing and Repayment, the order of financing and relevant variables,then complilation the financing table for the template to look up (20%)
* Integration of models (20%)

---

• To-dos for Cash Flow Automation Project:
  • Land Cash Flow
    • Data check (step 1)
    • existing projects that has HB (step2, 6/7 projects)
    • existing projects that has not started HB (step3, 10 projects)
  • New Template to rewrite financing for existing HB, project by project (step4)
  • Build in upload VBA module (step 5)
  • Cash Flow Consolidation for Ottawa (step 6)