A comprehensive guide to financial forecasting, investment and debt management, and budgeting.
In this course you will learn how to calculate budgets at today’s prices and forecast the equivalent inflation adjusted amounts likely required at retirement to cover minimum monthly expenditure.
You will also learn about tools to manage investments such as those held on the stock market, and forecast investment outcomes to determine your ability to retire at your target age.
It will also guide you through more complex financial decision making such as impacts on financial outcomes where a mortgage is paid up early using an investment lump sum or regular repayments.
The financial forecasting tools are included with formulae in an easy-to-use Excel workbook which will be explained in detail throughout this course. All you need to do is enter your own data.
Some additional tips and tricks in Excel are included in the course such as how to link your investment portfolio to an external data source so that prices update in real time.
1 activity • 1 videos • duration: 1h 1m
Accounting Guru
Jason is a Charted Management Account and Certified Public Accountant (CPA) of Australia who has over fifteen years of financial services experience in England and Switzerland in banking and real estate. After his move to Australia, he spent three years working as a lecturer and course designer in the fields of accounting and general business studies. Prior to his move to Australia, he worked as a consultant for a college, designing and rolling out learning programs across South Africa. Programs included simulated work environments to satisfy the work experience requirements of accounting institutes with which students were registered. He set up a non profit organization in South Africa to uplift mathematics and language education standards in rural areas.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
Comes with a handy spreadsheet which I intend to use, but be aware that on the partial withdrawal sheet the surplus/shortfall formula for future years into a retirement does not take into account continued inflation impacts on monthly future expenses.
It was very good with good explanations and useful spreadsheet, however it fails on a few things, and without mention of these factors 1) doesn't recognize inflation on expenses after retirement 2) doesn't take into account other income like CPP and OAS 3) doesn't factor in income tax on withdrawals.
very good spreadsheet, but some portfolios have to be manually added because STOCK button could not find them. Will have to add some of it manually.
very clear...
