Why hel

Welcome! This Sheet is designed to make life easy for you, give you a wholistic gl
Everything is as automated as possible, data entry takes place once a month and is min
Please read the disclaimer before continuing and please share the link to this sheet wi

The newest version and future up

Due to the number of feature/bug requests I've received for this sheet since initial rele
versions 2.4+ onwards. I've spent a lot of time on this sheet and I think it's the fair
developing this sheet and make it even better, but also reimburse me for the time put i
coffees ($8) and should make it back 10x for you!

If you would like access to the new v2.5 sheet and future updates, please shout me a f
and I'll promply add you to the new version!

V2.5+ includes:
- Monthly/Weekly/2-week pay support
- Property/Mortgage, Crypto, Rental & Side Income Supp
- Ongoing bug fixes (including lots of fixes to v2.3)
- Aesthetic overall and usability improvements
- Google Calender/Email Investment Reminders
- Improved Stock/LIC support (similar to current ETF supp
- International Stock/ETF support
- Currency Support
- Improved budgetting
- Sheet Optimisations making the sheet more responsive/load
- Mortgage/Investment Algorithmic Optimisation (In the w
- Leveraged Investment Support (In the works)
- Tracking for partners (In the works)
- Better Tax Support (In the works)
- Better Debt Management (Coming soon)
- Pocketbook CSV Support (In the works)
- Further automations
- Some quality approach to this sheet, but with more time de

Paypal Link: https://paypal.me/googleshe

Contact me via compiledsanity@gmail.com or /u/CompiledSanity if you
(Please include your Gmail address in the description or PM me so I

Side Income / Rental Income Tracking Improved Stock & Internat

 Why hello and welcome!
r you, give you a wholistic glimpse of your financial position and if you're a stats nerd tell you where you're heading.
place once a month and is minimal. Please note to use this Sheet you must have a Google Account. Thanks for visiting :)
share the link to this sheet with anyone you think might use it!

n and future updates! Some examples of v2.4+ features

Monthly Networth & Saving Email Breakdowns

d for this sheet since initial release I've created a paid sheet for
s sheet and I think it's the fair way to make sure I can keep
eimburse me for the time put in. That being said, it's for just 2
d make it back 10x for you!

e updates, please shout me a few coffees using the link below

d you to the new version!

includes:
ly/2-week pay support
to, Rental & Side Income Support
ncluding lots of fixes to v2.3) Weekly/2-week Salary & Side Income Support
nd usability improvements
mail Investment Reminders
rt (similar to current ETF support)
l Stock/ETF support
ency Support
ved budgetting
he sheet more responsive/load faster
ithmic Optimisation (In the works) Automatic Google Calender/Email Investment Reminders
ent Support (In the works)
artners (In the works)
pport (In the works)
agement (Coming soon)
Support (In the works)
r automations
s sheet, but with more time devoted
Property and Loan Support
paypal.me/googlesheet/8
m or /u/CompiledSanity if you have any questions.
the description or PM me so I can invite you)

Improved Stock & International Exchange Support

where you're heading. Disclaimer
anks for visiting :) The information & guidance on this sheet is for general information only.

It should not be taken as constituting professional advice from the Sheet owner. I
am NOT a financial advisor or qualified in finance.

You should consider seeking independent legal, financial, taxation or other

advice to check how information & outputs from this sheet relates to your unique
2.4+ features circumstances.

Email Breakdowns The Sheet owner is not liable for any loss caused, whether due to negligence or
otherwise arising from the use of, or reliance on, the information provided directly
or indirectly, by use of this sheet.

The calculators and tools on this sheet are provided for your information and to
illustrate scenarios. The results should not be taken as a substitute for
professional advice. This sheet may contain mistakes and therefore you must
perform your own due diligence to validate and confirm outputs.

All reasonable care has been taken in preparing and designing the calculators
and tools; however, the Sheet owner provides no warranties and makes no
representation that the information provided by the calculators and tools is
appropriate for your particular circumstances or indicates you should follow a
de Income Support particular course of action.

Further use of this sheet indicates acceptance of these terms.

l Investment Reminders
Shout me some coffee! ☕
This Sheet took a long while to make, so if you
found this sheet useful please consider shouting
me some coffees ($8+) for coffee via Paypal!

� https://paypal.me/googlesheet/8
n Support In return for some Coffees I'll invite you to the
paid sheet with all future feature/bug updates and
add in any feature requests!

Thank you for your generosity & support :)

Spread the word!

Please share the benefit you've received from this sheet with others!

Feel free to invite them with this Sheet to try the sheet out:
https://docs.google.com/spreadsheets/d/1tRJzUsKBNE_JoSTiMLT0-
V5zk3cwGW3lpnpboot0IGI/edit?usp=sharing

Thank you for your help!

Please share the benefit you've received from this sheet with others!

Feel free to invite them with this Sheet to try the sheet out:
https://docs.google.com/spreadsheets/d/1tRJzUsKBNE_JoSTiMLT0-
V5zk3cwGW3lpnpboot0IGI/edit?usp=sharing

Thank you for your help!

al information only.

ice from the Sheet owner. I

cial, taxation or other

heet relates to your unique

ether due to negligence or

nformation provided directly

or your information and to

s a substitute for
and therefore you must
m outputs.

designing the calculators

anties and makes no
culators and tools is
tes you should follow a

e terms.

fee! ☕
ng while to make, so if you
ul please consider shouting
$8+) for coffee via Paypal!

pal.me/googlesheet/8

Coffees I'll invite you to the

ure feature/bug updates and
feature requests!

r generosity & support :)

his sheet with others!

ry the sheet out:

UsKBNE_JoSTiMLT0-
p=sharing
 Steps
Welcome! This Sheet is designed to make life easy for you, give you a wholistic gl
Everything is as automated as possible, data entry takes place once a month and is min
Feel free to share the link to this sheet with anyone you think might use it!
Disclaimer: Any advice received in this sheet is not from a financial advisor who

Setup 1. Click File > Make a Copy and save to your Google Drive. Make sure you're using your Google Dri

Setup 2. Press Authorize Scripts below to enable Google Sheets to access external services
You will receive a notification about an unknown developer, click advanced in the bottom left and app

Authorise Sheet

You may receive a popup saying this app isn't verified. This is because the app
hasn't been published and exists as scripts attached to this sheet. Click
advanced and 'Go to PersonalSavingsScript'. Feel free to audit this code
yourself via Tools -> Script Editor.

Setup 3. Read the Disclaimer to your bottom right and click I accept below if you agree to these condition

I accept this Disclaimer

Setup 4. Visit the SheetOptions Tab and update all the yellow values
- Using the Budget Sheet is recommended so that the sheet can autobalance your investments/cas

Setup 5. Working from left to right, go through all the different tabs and update only cells that are yellow
Only these colours
- Remove the sample Share/ETF/Dividend information. This is only there to show you how to fill thin

Setup 6. Hide the History & SheetOptions Sheet (Right click -> Hide Sheet) and any other tabs that you w

7. Just before you're paid each month (ie. the day before payday, your poorest day in the month), u
Ongoing 'Update Networth' button in the Networth Sheet. This sheets scripts will automatically process you
- Never delete tabs, only hide them!
- Look for the dark arrows on cells, this will contain more info if needed.
- As you move into a new month live values will start showing up in graphs/cells. You still need to c
- After a while you'll figure out what tabs have values that are relevant to you and that need updating
- A lot of automations rely on trends to be recorded in this sheet. Therefore to get the maximum benefit
 Steps to initialise Sheet
or you, give you a wholistic glimpse of your financial position and if you're a stats nerd tell you where you're heading.
s place once a month and is minimal. Please note to use this Sheet you must have a Google Account. Thanks for visiting :)
think might use it!
rom a financial advisor who has assessed your situation. Please do your own research.

e you're using your Google Drive file henceforth.

external services
ced in the bottom left and approve source. Permissions are needed for Emails notifications and to crunch data on your behalf.

Description of permissions:
See, Edit, Create spreadsheets - Required for data manipulation in spreadsheet
See, edit, share Calenders - Required to set Google Calender reminders
Connect to an external Service - This is to receive live Stock/ETF prices
Send email as you - This is to email you reminders

f you agree to these conditions.

balance your investments/cash savings. If you choose not to use it then keep your Salary/Savings updated in the SheetOptions

date only cells that are yellow. Everything else is automated (check for formulas if you ever enter anything!)

ere to show you how to fill things in.

and any other tabs that you won't use. DO NOT DELETE any Sheets! Or you will break the scripts/formulas that run this sheet.

r poorest day in the month), update all the yellow values in the relevant tabs and then click the
will automatically process your information
aphs/cells. You still need to click 'Update Networth' the day before payday to record your values.
to you and that need updating. It can really be a 2 minute thing once you figure it out.
ore to get the maximum benefit you must have at least 2 months of data recorded
 CHANGELOG
ts nerd tell you where you're heading. Date Notes
oogle Account. Thanks for visiting :) 10/1/2020 v2 - Original
v2.1 - A whole Release
bunch of fixes that don't fit in
24/1/2020 process, dividend support for shares, fixes f
29/1/2020 Cash
v2.2 -calcs,
Fix toBudget tab improvements,
ETF return Calcs perfo
12/2/2020 v2.3 - Bug fix suggestions from Reddit

v2.5+ - Due to ongoing development future updates w

(Checkout the Welcome Tab!). It inc
fications and to crunch data on your behalf. - Monthly/Weekly/2-week pay supp
- Property/Mortgage, Crypto, Rental & Side In
- Ongoing bug fixes (including lots of fixes
- Aesthetic overall and usability improv
- Google Calender/Email Investment Rem
nipulation in spreadsheet - Improved Stock/LIC support (similar to curren
alender reminders - International Stock/ETF suppor
- Currency Support
Stock/ETF prices - Improved budgetting
- Sheet Optimisations making the sheet more resp
- Mortgage/Investment Algorithmic Optimisatio
- Leveraged Investment Support (In the
- Tracking for partners (In the work
- Better Tax Support (In the works
- Better Debt Management (Coming s
- Pocketbook CSV Support (In the wo
- Further automations
- Some quality approach to this sheet, but with m

Check out the instructions in the Welcome tab if y

Feel free to message at compiledsanity@gmail.com or /u/
any questions.

r Salary/Savings updated in the SheetOptions tab

Shout me some coffe

if you ever enter anything!)

reak the scripts/formulas that run this sheet.

then click the

rd your values. Email signup for future version
Please sign up here if you would like to be emaile
updates:
https://forms.gle/tn5hR7PmHWp7

CONTACT / REPORT BUGS / FEEDBA

Disclaimer
The information & guidance on this sheet is for general info

It should not be taken as constituting professional advice fro

NOT a financial advisor or qualified in finance.

You should consider seeking independent legal, financial, ta

check how information & outputs from this sheet relates to y

The Sheet owner is not liable for any loss caused, whether
otherwise arising from the use of, or reliance on, the inform
indirectly, by use of this sheet.

The calculators and tools on this sheet are provided for you
illustrate scenarios. The results should not be taken as a su
advice. This sheet may contain mistakes and therefore you
diligence to validate and confirm outputs.

All reasonable care has been taken in preparing and design

tools; however, the Sheet owner provides no warranties and
that the information provided by the calculators and tools is
particular circumstances or indicates you should follow a pa

Further use of this sheet indicates acceptance of these term

 Made by u/CompiledSanity
Link to Original Template
CHANGELOG
Notes
Original
- A whole Release
bunch of fixes that don't fit in here. Fixes for initial setup
ess, dividend support for shares, fixes for ETF calculations, fixes for
-calcs,
Fix toBudget tab improvements,
ETF return Calcs performance fixes
- Bug fix suggestions from Reddit

ing development future updates will move to a paid sheet

heckout the Welcome Tab!). It includes:
- Monthly/Weekly/2-week pay support
rty/Mortgage, Crypto, Rental & Side Income Support
ngoing bug fixes (including lots of fixes to v2.3)
Aesthetic overall and usability improvements
Google Calender/Email Investment Reminders
ed Stock/LIC support (similar to current ETF support)
- International Stock/ETF support
- Currency Support
- Improved budgetting
misations making the sheet more responsive/load faster
e/Investment Algorithmic Optimisation (In the works)
Leveraged Investment Support (In the works)
- Tracking for partners (In the works)
- Better Tax Support (In the works)
- Better Debt Management (Coming soon)
- Pocketbook CSV Support (In the works)
- Further automations
lity approach to this sheet, but with more time devoted

he instructions in the Welcome tab if you're interested!

t compiledsanity@gmail.com or /u/CompiledSanity if you have
any questions.

hout me some coffee! ☕

This Sheet took a long while to make, so if you found

this sheet useful please consider shouting me some
coffees ($8+) for coffee via Paypal!

� https://paypal.me/googlesheet/8

In return for some Coffees I'll invite you to the paid

sheet with all future feature/bug updates and add in
any feature requests!

Thank you for your generosity & support :)

 In return for some Coffees I'll invite you to the paid
sheet with all future feature/bug updates and add in
any feature requests!

Thank you for your generosity & support :)

signup for future version updates

ere if you would like to be emailed about future sheet
updates:
tps://forms.gle/tn5hR7PmHWp75GKg7

TACT / REPORT BUGS / FEEDBACK HERE

Disclaimer
ance on this sheet is for general information only.

as constituting professional advice from the Sheet owner. I am

r or qualified in finance.

eeking independent legal, financial, taxation or other advice to

& outputs from this sheet relates to your unique circumstances.

t liable for any loss caused, whether due to negligence or

the use of, or reliance on, the information provided directly or
s sheet.

ols on this sheet are provided for your information and to

e results should not be taken as a substitute for professional
y contain mistakes and therefore you must perform your own due
nd confirm outputs.

s been taken in preparing and designing the calculators and

eet owner provides no warranties and makes no representation
ovided by the calculators and tools is appropriate for your
es or indicates you should follow a particular course of action.

et indicates acceptance of these terms.

 Parcel Optimising (Automaticly updated on Monthly update)
Automatic Investment Amount $0
1/Yearly Frequency (Default: Monthly) 0.0833
Bank Interest Rate 2.1%
Investment Growth (Automatic) 0.0%
Purchase Brokerage (Buy only) $9.50
Current Cash Deficit $0

Investment Choice VGS

Cash Deficit Period 0

Automated Frequency 0
Auto Max Frequency 0
Investment Period (Days) 0
Days to purchase buffer -
0d later Purchase Date: -
Final Purchase Date -
Automatic Parcel Amount $0
Last ETF Purchase Date 27-Dec-2019

Estimated Tax Rate

Employment Salary $70,000

Predicted Annual Dividends $0

Predicted Yearly Earnings $70,000
Days into Financial Year 239
Estimated Tax Rate 32.5%

Monthly Update Date Calc

Next Update (14th) Saturday, March 14, 2020
Bring forward to Weekday 1
Final Weekday Pay Date Err:502

Automatic Saving Distribution - Do not modify!

ETF (Automatic) 0%
Cash (Automatic) 100%
Cash % NW (last month) 0%

Total 100%
 Initialising Settings
Moving Cells Personal Gmail insertemailhere@gmail.com
will break Day of Month Paid 14
Scripts! Use Budget Tab? Yes Recommended as Yes. If set to
Monthly Leftover Savings $2,000.00 If Budget option set to No
Don't move Monthly Salary Deposit $2,000.00 If Budget option set to No
them! Allocation Aggressiveness Normal How aggressively do you want t

Has Accepted Disclaimer No

(I) This section has been improved and expanded for usability,
including a new migration system in v2.5+
nitialising Settings

mended as Yes. If set to Yes, fill out the Budget category as accurately as possible!
et option set to No, fill out how much you would traditionally save in total each month
et option set to No, fill out what Salary pay hits your bank Account
ggressively do you want to keep aligning with your Asset Allocations?
 #NAME? Total Savings Rate/year: $0 No Trend years (~$73,125) until house! Date Savings (ex.S) Super Liabilities Rolling NW NW Growth Sav. Growth Sav. Rate Proj. NW Notes (From Cash Tab)
Assets Feb 2020 $54,500 $18,000 -$20,000 $52,500 - - - - 0
Total ($) Gains ($) Gains (%) Feb 2 020 Mar 202 0 Apr 2 020
Mar 2020 $0 0
ETF's $0 $0 0% 6000054500 Apr 2020 $0 0
Shares $0 $0 0% 0
Crypto $0 $0 0%% 50000 0
Cash Savings $54,500 $0 0% 40000 0
Super $18,000 $1,500 9% 0
30000 0
Total Assets: $72,500 $1,500 2% 20000 0
Savings (wo/Super) $54,500 $0 0%
10000

Total Net Worth: $52,500 0

00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Feb 2020
Linear ()

Cash, Shares & ETF Savings: $54,500

Monthly Savings Savings Rate Linear (Savings Rate)
Liabilities
1 1
Name Debt Paid Total
HELP Debt -$20,000 $0 -$20,000 0.8 0.8

0.6 0.6

Total: -$20,000 $0 -$20,000 0.4 0.4

0.2 0.2

0 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
ETF's Feb 2020
Shares
Crypto
Cash Savings
Super

Assets Allocations
Current % Desired % Deficit %
ETF's 0% 0% 0%
Shares 0% 0% 0%
Fe b20 20 Ma r20 20 Apr 20 20

Crypto 0% 0% 0%
Cash Savings 100% 100% 0% Linear ()

Invest next in: Cash Savings 0

Total Assets: 100% 100% 0
0
Update Button (Update Cash & Super First!) 0
0
0
Cash & Super values NOT UPDATED for this cycle! 0
Script Status: Success! Last Refreshed: ### 0
Last run: ### Alast: 10 0
Sheet Errors? No Todays Date 2/24/2020 0
0
0
0
ERRORS AND STATUS

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
 Bank Account Name Amount
ING Daily Expenses $500.00 Date Total Cash
ING Splurge $500.00 Feb 2020 $54,500
ING Mojo $2,000.00 Mar 2020
UBank Savings $50,000.00 Apr 2020
ETF Broker Cash Balance $1,500.00

Total Cash: $54,500

Last Update: 06/01/2020
Next ETF: -

February Cash savings $0

February Total savings $0
Cash savings/month $0
ETF & Cash savings/month $0
2020 Sum Cash $0
Predicted Cash Savings/Year $0

House Savings Target/Year $17,000

Years to Target? No Trend
House Price Target $650,000
House Deposit Remaining $73,125
House Deposit Saved $32,500
Monthly House Savings Deficit/month -$1,417
Date of Arrival Never - No Cash Trend
Deposit Tracker - 31% saved

EOY Predicted Cash Balance $54,500

On Target? Yes!
EOY Cash Goal $38,000
EOY Goal Deficit/month $1,375

Time to $50000 Cash Goal Negative Growth!

Cash Savings Target $50,000
February 2020 Cash Amount $54,500
Date of Arrival -
 % of Target 109%
Tracker
Cash Savings Target reached!
February 2020 Savings Rate 0%
2020 Savings Rate 0%
3-Month Rate 0%
3-Month Savings Trend Decreasing!
3-Month Saving Rate ±%/Month 0.00%
2020 Recorded Savings $0

2019-2020 Estimated Tax Rate 32.5%

 Historic Cash Savings Values (AUTOMATICALLY FILLED!)
Cash Gain ($) Cash Gain (%) ETF Movements Savings Rate Monthly Savings Projected Cash.
- - $0 0% $0 -
$0
$0
UTOMATICALLY FILLED!)
Monthly Spend Spend Notes
$0
60000
54500 Feb 2020 Mar 2020 Apr 2020

50000

40000

30000

20000

10000

0
0000000000000000000000000000000000000000000000 Linear ()
Feb 2020
 Tick Fund Name Live Price 180D History Held Units Live Value Total Return ($) Total Return (%) Allocation Def. Target Alloc. Current Alloc. MGT Fee Location % - US % - Asia % - Aus % - EU/OtherDiv Yield Div Return %/Year
VGS Global Top 3000 $88.24 0 $0.00 $0.00 0.0% -50% 50% 0% 0.18% World 68% 12% 0% 20% - $0.00 -
VAS Australia ASX200 $90.55 0 $0.00 $0.00 0.0% -35% 35% 0% 0.14% Aus 0% 0% 100% 0% - $0.00 - 10%
VAE Asia exc. Japan $72.17 0 $0.00 $0.00 0.0% -15% 15% 0% 0.40% Asia 0% 100% 0% 0% - $0.00 -

34%
% - US
% - Asia
% - Aus
35%
% - EU/Other

Insert further rows by inserting rows and copying down formulas Current Alloc. 0% 0% 0% 0% 21%
Desired Alloc. 34% 21% 35% 10%

1 1
CURRENT PORFOLIO VALUE $0 Stats
February 2020 March 2020 April 2020
Total Return ($) $0 - $0 CGT Owing Est Ret. %/Year 0% annually Current ETF 0 0.9 0.9
Total Return (%) 0.0% Next Investment Cash Savings ETF Target Count 3
0.8 0.8
2020 ETF Dividends after Tax ($) $0 Target Date - ETF Limit 10
Total ETF Dividends afer Tax ($) $0 1Y Inv. Rate - 0.7 0.7

0.6 0.6
Purchase History Total Brokerage (0%/$0 tot.gain): $0.00
0.5 0.5
Ticker Order Date △ Units Order Price Order Value Live Price Live Value Capital Gain ($) Capital Gain (%) Sold Units Remain Balance Auto Brokerage Total Value
VGS 4-Mar-2019 1 $60.00 $60.00 1 0 0.4 0.4
VAE 29-Mar-2019 0 $65.00 -$10.00
0.3 0.3
VAS 15-Aug-2019 0 $80.00 -$10.00
VGS 27-Dec-2019 -1 $75.00 -$85.00 0.2 0.2

0.1 0.1

0 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0
00000000000000000000000000000000000000000000000
Feb 2020 February 2020

Delete yellow ETF/Shares/Dividend info, 1 1

this is just sample info 0.9 0.9
0.8 0.8
Adding ETF: Fill out rows A-D
0.7 0.7
Selling ETF: Enter in amount of sold units in 0.6 0.6
original purchase (Row J), then add new line
0.5 0.5
with negative number of units as shown. Gain (%) Gain ($)
0.4 0.4

0.3 0.3
0.2 0.2
0.1 0.1
0 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Feb 2020 Feb 2020

Historical Value (Use History Sheet)

Date Total Value Gain ($) Gain (%)
Feb 2020 $0 $0 0.0%
Mar 2020
Apr 2020
#VALUE! 0.0%
% - US
#VALUE! 0.0%
% - Asia
#VALUE! 0.0%
% - Aus
#VALUE! 0.0%
#VALUE! 0.0% % - EU/Other

#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
#VALUE! 0.0%
 ASX Current Price Current P/E Total Units Total Worth
CSL $336.40 50.85 0 $0.00
APT $38.99 - 0 $0.00
ALU $34.41 57.53 0 $0.00
Z1P $3.65 - 0 $0.00

Insert further rows by inserting rows and copying down formulas

CURRENT PORFOLIO VALUE $0

Total Growth ($) $0
Total Growth (%) 0%
Net Dividends after Tax ($) $0
CGT Tax Owing ($) $0

Purchase History
Ticker Purchase Date Volume Bought Price Bought Value
APT 7-Nov-2019 0 $18.00 $0.00
CSL 13-Nov-2019 0 $250.00 $0.00
Allocation Difference Desired Allocation Current Allocation Total Return ($)
0% 0% 0% $0.0
0% 0% 0% $0.0
0% 0% 0% $0.0
0% 0% 0% $0.0

Amount Allocated: 100%

1

0.9

0.8

0.7

0.6

0.5

0.4
Current Value Gain ($) Gain (%)
0.3
$0.00 $0 0%
$0.00 $0 0% 0.2

0.1

0 0000000000000000000000000000000000000
February 2020

0.9

0.8

0.7

0.6

0.5

0.4

0.3

0.2

0.1

0 000000000000000000000000000000000000
February 2020
 Total Return (%)
$0.0
$0.0
$0.0
$0.0

.9

.8

.7

.6

.5
Total Value
.4

.3

.2

.1

0 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
ruary 2020

.9

.8

.7

.6

.5
Gain ($)
.4

.3

.2

.1

0 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
ruary 2020
 Historical Value (Use History Sheet)
Date Total Value Gain ($) Gain (%)
February 2020 $0.00 $0.00 0%
March 2020
April 2020
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
 #VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
#VALUE! 0%
December 1899 $0.00 $0.00 0%
December 1899 $0.00 $0.00 0%
December 1899 $0.00 $0.00 0%
 FY Start: 01/07/2019 to

Historical Dividends
Payment Date ASX Tick ETF/Stock Ex-Dividend Units HeldPrice @ Dividend (Estimate)
09/12/2019 VAS ETF 28/12/2019 0 $86.81
16/12/2019 APT Stocks 01/12/2019 0 $3.37
 to 01/07/2020

s Reinvested? 2019-2020 YEARLY SUMMARY

Net Yield (Mouse over for Net Amount Ticker (Auto) Type
0.00% note)
No $0.00 VAS ETF
0.00% No $0.00 APT Stocks

TOTAL -

PRIOR YEAR SUMMARY (NET)

Auto Date Net ETF Div.
2015-2016 $0.00
2016-2017 $0.00
2017-2018 $0.00
2018-2019 $0.00
2019-2020 $0.00

TOTAL $0.00

1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
0 0 0 0 0 0 0
2015-2016 2016-2017 2017-2018 2018-
YEARLY SUMMARY Dividend Reinvestment
Net Dividends ETA to +1U (Months) NET Year Yield Dividend Freq (m)
$0.00 - - FILL IN
$0.00 - - FILL IN

$0.00

OR YEAR SUMMARY (NET)

Net Share Div. Total Net Div.
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00

$0.00 $0.00

Net Share Div.

Net ETF Div.
 Net Share Div.
Net ETF Div.

0 0 0 0 0 0 0 0 0 0 0 0
2016-2017 2017-2018 2018-2019 2019-2020
vestment
DRP On? DRP Swap?
NO NO
NO NO

Net Share Div.

Net ETF Div.
Net Share Div.
Net ETF Div.
 Super Split Value Historical Value (
Balance $18,000.00 Date
Feb 2020
Mar 2020
Apr 2020

Dashboard reported Gains $1,500.00

Total Value: $18,000
Last Update: 06/01/2020
 Historical Value (Use History Sheet)
Super Setting Total Value Gain from App($) Gain (%) 20000
High Growth 100% $18,000 $1,500.00 9.1% 18000 18000

16000

14000

12000

10000

8000

6000

4000

2000

0 00000000000000000000
Feb 2020

1600
1500
1400

1200

1000

800

600

400

200

0 0000000000000000000000
Feb 2020

0.1
0.09 0.0909090909
0.08
0.07
0.06
0.05
0.04
0.03
0.02
0.01
0 000000000000000000000
Feb 2020
0.05
0.04
0.03
0.02
0.01
0 000000000000000000000
Feb 2020
20000

18000 18000

16000

14000

12000

10000
Total Value
8000

6000

4000

2000

0 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Feb 2020

1600
1500
1400

1200

1000

800
Gain from App($)
600

400

200

0 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Feb 2020

0.1
0.09 0.0909090909
0.08
0.07
0.06
0.05
Gain (%)
0.04
0.03
0.02
0.01
0 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Feb 2020
0.05
Gain (%)
0.04
0.03
0.02
0.01
0 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Feb 2020
 Total Value

0000

Gain from App($)

Gain (%)

000000
 Gain (%)

000000
 MONTHLY BUDGET
Monthly Salary $ 3,500.00 Job Start Date: 1/1/2019
Annual after-tax Income: $ 42,000.00 Auto 6M Emergency Fund: $16,000

If adding new budget item, right click on left number bar and click 'Insert 1 Above' existing budget item. Keep items within coloured areas (ie. General Ex
ITEM % Allocation Monthly Expense Weekly Expense Yearly Expense
General Expenses 1% $ 50.00 $ 11.51 $ 600.00
- Fuel 3% $ 100.00 $ 23.01 $ 1,200.00
- Rent/Mortgage 23% $ 800.00 $ 184.11 $ 9,600.00
- Myki 5% $ 180.00 $ 41.42 $ 2,160.00
- Groceries 17% $ 600.00 $ 138.08 $ 7,200.00
-Media Subscriptions 1% $ 20.00 $ 4.60 $ 240.00
-Haircut 1% $ 30.00 $ 6.90 $ 360.00
- Mobile Phone 1% $ 35.00 $ 8.05 $ 420.00
0% $ - $ -
0% $ - $ -
0% $ - $ -
0% $ - $ -
0% $ - $ -
0% $ - $ -
Automatic - Yearly Expenses 5% $ 170.00 $ 39.12 $ 2,040.00
Splurge/Fun Money 9% $ 300.00 $ 69.04 $ 3,600.00
Emergency Fund Topup (Mojo) 1% $ 50.00 $ 11.51 $ 600.00
Smile/Holiday/Big Purchase Savings 11% $ 380.00 $ 87.45 $ 4,560.00
Automatic - Cash Savings 22% $ 780.00 $ 179.51 $ 9,360.00
Automatic - ETF Savings 0% $ - $ - $ -

House Calculations (All values from Cash sheet) Yearly Expenses

Savings Rate/year $ - Car Rego
House value (target) $ 650,000 Car Insurance
Current Cash $ 54,500 Car Service
~6 months expenses $ 16,000 Birthday/Christmas Gifts
Deposit needed @ 20% $ 105,625
Amount remaining $ 73,125 Orange = Automatic calcs, do not edit!
Years before deposit No Trend years
 - Fuel - Rent/Mortgage - Myki
n coloured areas (ie. General Expenses in white area)
- Groceries -Media Subscriptions -Haircut
Bank Account Category
- Mobile Phone
ING - Daily
Fill Bank
Fill Bank Automatic - Yearly Expenses Splurge/Fun Money

Fill Bank Emergency Fund Topup Smile/Holiday/Big Purchase Automatic - Cash Savings
(Mojo) Savings
Fill Bank
Automatic - ETF Savings
Fill Bank
Fill Bank
Expenses Monthly Expenses:
Fill Bank
$1985
Fill Bank
Fill Bank
Fill Bank
Fill Bank
Fill Bank
Fill Bank
UBank - Savings Yearly Exp.
ING - Splurge Splurge
ING - Mojo 🚨 Savings
UBank - Savings Holiday
UBank - Savings
Savings
UBank - Savings

Year Cost Monthly

Monthly Savings $785
$ 840.00 $ 70.00
$ 770.00 $ 64.17
Annual Savings $9,420
$ 320.00 $ 26.67
 Estimated Savings Rate 22%

c calcs, do not edit!

Automatic Salary Bank Transfers
Automate your incoming pay and send it back out to automate your
savings. This works best with a splurge/expenses account.

Bank Name Amount

ING - Daily $50
Fill Bank $1,765
UBank - Savings $1,330
ING - Splurge $300
ING - Mojo $50
ki
rcut

rge/Fun Money
matic - Cash Savings
 INSTRUCTIONS ON
MOUSE OVER Shares ETF's
Pay Month Ending Shares Value Gain ($) Gain (%) ETF Value
February 2020 $0 $0 0.00% $0
March 2020
April 2020
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
#VALUE! 0.00%
 ETF's Crypto
ETF Changes Gain ($) Gain (%) Crypto Value Gain ($) Gain (%)
$0 $0 0.00% $0 $0 0%

#VALUE! 0.00% #VALUE! #VALUE! 0%

#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% Work out/estimate
#VALUE! how much 0%
#VALUE! you saved from
#VALUE! 0.00% #VALUE! your last Pay0%and put it here
#VALUE!
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
#VALUE! 0.00% #VALUE! #VALUE! 0%
 Cash Super
Cash Value Gain ($) Increase (%) Super Value Gain ($) Gain (%)
$54,500 $0 0% $18,000 $1,500 9.1%

h you saved from

Pay and put it here
 Liabilities Salary
60000
Debt Balance Paid -
54500
-$20,000 $0 $3,500
50000

40000

30000

20000

10000

0 0000000000000000000000000000000000000000000000000000000000000000000000000000000
February 2020

1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0 0000000000000000000000000000000000000000000000000000000000000000000000000000
February 2020

60000
54500
50000

40000

30000

20000

10000

0 0000000000000000000000000000000000000000000000000000000000000000000000000000
February 2020

1
0.9
0.8
0.7
0.6
0.5
 1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0 00000000000000000000000000000000000000000000000000000000000000000000000000000000
February 2020
 Shares Value
ETF Value
Crypto Value
Cash Value

00000000000000000000000000000000000000000000000000000000

ETF Value

000000000000000000000000000000000000000000000000000000000

Cash Value

000000000000000000000000000000000000000000000000000000000

Shares Value
 Shares Value

00000000000000000000000000000000000000000000000000000000