• Post category:StudyBullet-4
  • Reading time:9 mins read


What you will learn

How to define personal finance

How to set financial goals based on your personal life situation

Explain the difference between finance, economics, and accounting

Define time value of money concepts and how they can be used in long-term planning

Calculate present value using multiple methods including Excel

Calculate future value using multiple methods including Excel

Calculate present value of an annuity using multiple methods including Excel

Calculate future value of an annuity using multiple methods including Excel

Description

This course will cover the core introductory concepts related to personal finance.

We will include many example problems, both in the format of presentations and Excel worksheet problems. The Excel worksheet presentations will include a downloadable Excel workbook with at least two tabs, one with the answer, the second with a preformatted worksheet that can be completed in a step-by-step process along with the instructional videos.

We will discuss what personal finance is and what the differences between personal finance, corporate finance, economics, and accounting are. Learners will also understand why knowing personal finance concepts is important.

You will know how to set goals using a formal structure and process based on your personal life situations.


Get Instant Notification of New Courses on our Telegram channel.


We will also cover time value of money concepts, including present value and future value calculations. Time value of money concepts will be important whenever we are making long term plans, such as retirement plans or a child’s college education funding plan.

Human beings are quite good at making the day-to-day decisions, often doing so by instinct and habit. However, we are not so good at making long-term, risk verses reword, decisions. Therefore, a more formal process is often needed for longer-term decisions which could have large impacts. Time value of money concepts will be a critical component of the long-term decision process.

English
language

Content

Presentations – Personal Finance Core Concepts

1010 Personal Financial Planning Overview
1015 Financial Goals & Activities for Various Life Situations
1020 Finance, Economics, & Accounting
1025 Financial Goals
1030 Personal Finance Planning Procedure
1040 Time Value of Money Overview
1045 Present Value
1050 Present Value Months as Period
1055 Future Value
1060 Future Value Months As Period
1065 Future Value vs Present Value
1067 Present Value Annuity
1069 Present Value Annuity Months as Period
1071 Future Value Annuity
1073 Future Value Annuity Months
1075 Present Value Cash Flow Examples
1077 Future Value Cash Flow Examples
1079 Present Value Terms Used In Capital Budgeting
1081 Net Present Value Assumptions

Practice Probs. – Personal Finance Core Concepts

1111 Rule of 72 & Running Balance Calculation
1112 Excel Present Value, Future Value, & Number of Period
1113 Present Value & Future Value Mathematical Formulas
1114 Present Value & Future Value Tables
1115 Rule of 72 & Running Balance Calculation Prob. 2
1116 Excel Functions Present Value, Future Value, & Number of Period
1117 Present Value & Future Value Mathematical Formulas Prob. 2
1118 Present Value & Future Value Tables Prob. 2
1119 Rule of 72 & Running Balance Calculation Prob. 3
1120 Excel Functions Present Value, Future Value, & Number of Period Prob. 3
1121 Present Value & Future Value Mathematical Formulas Prob. 3
1122 Present Value & Future Value Tables Prob. 3
1123 Rate of Increase
1131 Inflation & Estimated Increase in Personal Expenses
1140 Home Cost Estimated Increase
1150 Savings Account Compounding Future Value
1160 Future Value Annuity Investment vs Non-Annuity
1161 Investment to Meet Goal Present Value
1162 Annuity Initial Investment Present Value of Annuity
1180 College Savings Calculation
1191 Retirement Savings FV of Annuity
1200 What if We Saved Our $5 a Day Coffee Habit
1210 Option to Receive Money Today vs a Series of Payments
1213 Loan Payment Calculation & Amortization Table
1215 Monthly Loan Payment Calculation & Amortization Table
1217 Annuity Due or Annuity Beginning Period
1218 Present Value Monthly Periods
1222 Present Value Annuity Monthly Periods
1225 Future Value Monthly Periods
1230 Future Value Annuity Monthly Periods
1235 Annuity Due Present Value
1240 Present Value of Annuity using Non Annuity Excel Functions
1245 Future Value of Annuity using Non-Annuity Excel Functions
1255 Retirement Plan Worksheet

Excel Probs. – Personal Finance Core Concepts

1111 Rule of 72 & Running Balance Calculation
1112 Excel Functions Present Value, Future Value, & Number of Periods
1113 Present Value & Future Value Mathematical Formulas
1114 Present Value & Future Value Tables
1115 Rule of 72 & Running Balance Calculation Prob. 2
1116 Excel Functions Present Value, Future Value, & Number of Period
1117 Present Value & Future Value Mathematical Formulas Prob. 2
1118 Present Value & Future Value Tables
1119 Rule of 72 & Running Balance Calculation Prob. 3
1120 Excel Functions Present Value, Future Value, & Number of Period Prob. 3
1121 Present Value & Future Value Mathematical Formulas Prob. 3
1122 Present Value & Future Value Tables
1123 Rate of Increase
1131 Inflation & Estimated Increase in Personal Expenses
1140 Home Cost Estimated Increase
1150 Savings Account Compounding Interest Future Value
1160 Future Value Annuity Investment vs Non-Annuity
1161 Investment to Meat Goal Present Value
1162 Annuity Initial Investment Present Value of Annuity
1180 College Savings Calculation
1191 Retirement Savings FV of Annuity
1200 What if We Saved Our $5 a Day Coffee Habit
1210 Option to Receive Money Today vs a Series of Payments
1213 Loan Payment Calculation & Amortization Table
1215 Monthly Loan Payment Calculation & Amortization Table
1217 Annuity Due or Annuity Beginning Period
1218 Present Value Monthly Periods
1222 Present Value Annuity Monthly Periods
1225 Future Value Monthly Periods
1230 Future Value Annuity Monthly Periods
1235 Annuity Due Present Value
1240 Present Value of Annuity using Non-Annuity Excel Functions
1245 Future Value of Annuity using Non-Annuity Excel Functions
1250 Home Loan Payment Calculation & Amortization Table
1255 Retirement Plan Worksheet