Financial Planning with Excel

Personal financial planning skills are essential because, without them, people can spend their entire lives working for money but never getting ahead. This course will cover personal financial planning concepts, starting from the basics, and moving to complex topics.

We will discuss how to set financial goals, taking into consideration the life cycle and specific life situations and preferences. We will also learn about the concept of the time value of money, being able to perform present value and future value calculations, and know when such calculations are necessary. We will include many example problems, both in the format of presentations and Excel worksheet problems.

By the end of this course, you will have a clear sense of where you are financial, where you want to be—and how you’re going to get there. You’ll feel less stressed about money, and more confident about reaching your goals.

After completion of this program, participants will be better able to:

• Describe financial planning concepts
• Describe time value of money concepts
• Calculate present value, future value, annuity, and perpetuity
• Compile your own complete financial statement including a balance sheet and cash flow statement in excel
• How to calculate your net worth
• How to do a financial health check
• How to calculate income replacement for life insurance and retirement with excel
• How to execute your financial planning