FPI webinar: Myths Busted: Why DIY Financial Planning Might Not Be Enough
CFA templates in Excel, which I am creating for each reading. Bookmark this website so you can access newly uploaded templates throughout the year.
CFA Level 1:
Calculator tips (Texas Instruments BA II Plus)
Recognition:
Below is a list of useful financial planning templates created on behalf of Centric Wealth Advisory, which is a professional fee-based financial planning practice located in Cape Town, South Africa. These templates are intended for educational or personal use and should not be used to make financial planning decisions without consulting a professional.
Note: Most of the templates have macros embedded so when you download a template and open a file, ensure you enable the macros to "activate" the buttons.
If you are using Microsoft 365 and get this message when you download: 'Microsoft has blocked macros from running because the source of this file is untrusted', then download the templat,e open the file, and then 'save-as' to save a copy where the macros are not blocked. Microsoft 365 automatically blocks macros as part of its security, as the source is from Google Drive.
2025 templates:
Compound interest calculations using the HP10BII+ calculator
Calculating capital gains using the TABC method
Calculating the Accrual claim template
ARTICLES:
An investor's guide to Property in South Africa.
Comparison: Investing directly offshore vs indirectly via a feeder fund
Buying vs renting: an in-depth comparison using a financial model
The challenges of investing offshore without sound financial advice
Tax-Free Savings Accounts and Generational Wealth Creation
BLACKROCK ASSET CLASS RETURNS (2015 - JULY 2024)
Formulae and functions:
1) Engineers, actuaries, accountants Microsoft Excel functions and shortcuts workbook
Budget planning:
2) Budget planner (Monthly and yearly tracked) (Single)
3) Enter your own start date Budget planner (Monthly and yearly tracked)
4) Budget planner (Monthly and yearly tracked) (Married)
Estate Planning:
5) Estate Planning template (in and out of community)
Investment planning:
6) Time Value of Money (TVM): Present to Future & Future to Present
7) Cashflow tracker with option to switch between USD and ZAR currencies
8) Recurring payment future value calculator and cashflow tracker using USD currency
9) Recurring payment future value calculator and cashflow tracker using ZAR currency
10) Currency converter annuity payment tracker
Retirement planning:
11) The Two-Pot System explanation and calculation in Excel
12) Comprehensive Retirement Planning template
Property:
17) Property analysis tool to calculate NPV & IRR and compare to traditional investment
18) Loan amortization schedule template to calculate interest savings or reduction of principal debt