Building Blocks for Cashflow
Building Blocks for Cashflow (PDF)(Phase III)
Building Blocks for Cashflow (Excel)(Phase III)
Building Blocks for Cashflow (PDF)(Phase IV)
Building Blocks for Cashflow (Excel)(Phase IV)
Notes:
Phase I-Blocks and Labels [Complete]
Phase II-Asset Allocation [Complete]
Phase III-Asset Allocation(Excel) [Complete]
Phase IV-Combine Matrix+Alloc tables with Cash Flow Model [Complete]
Phase V-Cash Flow (Excel) [Test/Finalize OCT24 Financials]
Notes for Phase IV:
Input fields in Asset + Alloc tables
Created MMMYY for the current month’s adjustments
Switched places for Offset and To for logistical purposes
Created Var Offsets check for validation purposes
Linked Cash+Inv in EFI for transparency and flow
Created Matrix Units of 1.25 and .5 for selected assets
Created 3 input lines for Salary and 7 input lines for Transfers
Notes for Phase V:
May consider including Input Fields for Categories
Highlight rows
Dropdown menu for Categories?
Update +/- with -/+
Switch Offset and To and update calculations as needed
Update Salary to reflect Offset
Set Salary to 2.25K for Monthly Contribution
Ensure no unallocated categories in Var total checks
Notes for Matrix:
Baseline / 20 / 10 / 5 / 2.5
May include 2 / 1 / .25 dependent on OCT24 interests received
