ABCDEFGHIJKLMNO
1
Please Read Before Using This Spreadsheet
2
3
4
5
6
Welcome to your new Personal Finance Management Spreadsheet. This comprehensive tool is designed to assist you in taking control of your financial future. Here’s what you can expect:
7
8
Net Worth Tracker: Easily keep track of your assets and liabilities to see your total net worth at a glance. Basic Version
9
FIRE Retirement Projection: Plan your path to financial independence and early retirement with projections based on your current financial situation. Premium Version Only
10
Buy vs Rent Calculator: Make informed decisions about whether to buy a home or continue renting, based on detailed financial comparisons. Premium Version Only
11
Budgeting Section: Manage your monthly income and expenses to better understand your spending habits and savings potential. Premium Version Only
12
Sankey Diagram Generator: Visualise your financial flows, providing a clear picture of how your money moves. Premium Version Only
13
Helpful Links: Gain quick access to resources and advice that can help you deepen your financial knowledge. Premium Version Only
14
15
To purchase the Premium Version, please visit this link.
16
17
For detailed instructions on how to use each feature, please see the sections below on this main page. Whether you're planning for retirement, managing your monthly budget, or assessing your investment decisions, this tool is here to support your journey towards financial wellness.
18
19
20
1. Net Worth Tracker
Basic Version
21
22
23
24
How To:
25
1. Set Time Periods
26
i. Replace column A with your desired time period cadence
27
28
2. Set Assets & Liabilities
29
ii. Set as many asset and liability types as you'd like on row 29
30
31
3. Replace Placeholder Data
32
iii. Add your own data and watch the charts reflect it. Input your data in the white cells.
33
34
4. Migrate to PopaDex for better tracking
35
iv. Export the Migration tab to CSV to keep all of your data and upload to your account on https://popadex.com
36
37
38
39
40
41
42
43
44
45
Tired of using spreadsheets? Join other users who are optimising their financial health by privately and automatically aggregating their accounts on PopaDex.
46
47
Try PopaDex πŸš€
48
49
50
2. Retirement Calculator & Projection
Premium Only
51
52
53
54
55
How To:
56
1. Set Inputs, Goals, and Assumptions
57
i. All cells with a white background can be changed to suit your personal situation or modelling.
58
59
2. Results
60
ii. The model will output the age at which you can achieve LeanFIRE, FIRE, and FatFIRE, which are terms used to describe financial independence from lower to higher income levels, respectively.
61
You can then view your results in the Retirement Projection chart.
62
63
This model is inclusive of:
64
βœ… Inflation
65
βœ… Mortgage
66
βœ… Tax
67
βœ… Pension
68
69
70
71
72
73
74
75
3. Rent Vs BuyPremium Only
76
77
78
79
80
How To:
81
1. Set User Inputs
82
i. This model takes in 26 different inputs to help you assess whether it makes more financial sense to buy or rent real estate in any given scenario. All placeholder values can be altered.
83
84
2. Results
85
ii. The model will output a cost comparison of buying and renting under the criteria you give, helping you make an informed decision.
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
4. BudgetPremium Only