Today’s episode looks at a handy tool in Microsoft Excel called Goal Seek.
It can be used to create a loan schedule with an interest-free period using formulas.
To explain how you do this is CPA Australia’s Excel expert, Neale Blackwood.
Listen now.
Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.
CPA Australia publishes three podcasts, providing commentary and thought leadership across business, finance, and accounting:
Search for them in your podcast service.
You can email the podcast team at podcasts@cpaaustralia.com.au
And you can read more of Neale’s Excel articles online, including the accompanying article to this podcast.