Financial Planning Model
It’s been about 2 weeks since I’ve started working on the FP Model. There are several models that makes up the FP Model.
Cash Flow Financial Planning
Current Cash Flow Position
Property Planning
o Property Stats (Property1)
o FP+CF Model (Property1)
o Property Stats (Property2)
o FP+CF Model (Property2)
o Amort Sch (Property2)
o Property Stats (Property3)
o FP+CF Model (Property3)
o Amort Sch (Property3)
Detailed reports include the following:
ADP Payslip Alloc (Net Salary)
AI on FP Models
Lists
Created a new report for simulation only:
Scenario Analysis
In the Cash Flow Financial Planning Model, we’ll be using the following criteria:
End Contributions: 2040
Asset Allocation: 2035
Super (Accum): 2035
Super (FY): 2035
Withdraw from your Super? 2040
Select Year for Simulation: 2035
Description / Input:
End Work Year: 2040
Salary Incr%: 2.5%
SG Cap Limit: 27,500
Stocks MR%: 8.0%
Super MR%: 8.0%
Savings MR%: 5.0%
Start Year: 2024
Asset Alloc:
Super
Stocks
Savings
Property1
Property2
Property3
The reports came out better than expected. Prefer to have some more visual aspects on the report to show the results, and some more tweaking on the numbers after we analyse our financials. Consolidation wise, we’re good.
We’re up to Version 7 on the Summary, and Version 4 on the Detailed. To prevent irrelevant information, we’ll be creating a stopping point at Year 2045.
