Learn how to plan your personal finances from a certified public accountant (CPA)
☑ Explain the differences between personal finance and corporate finance
☑ Set personal financial goals for different points in the life cycle, circumstances, and personal preferences
☑ Describe time value of money concepts
☑ Calculate future value using multiple methods
☑ Calculate present value using multiple methods
☑ Describe money managing skills
☑ Compile personal financial statements including a balance sheet and income statement
☑ Create a budget
☑ Create a budget vs actual report
☑ Calculate & analyze common personal financial ratios
This course will cover personal finance concepts, starting from the basics, and moving to complex topics. We will cover each step thoroughly.
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.
Learners will understand the similarities and differenced between personal finance and business finance. We will discuss how to set personal financial goals, taking into consideration the life cycle and specific life situations and preferences.
The course will discuss the differences and overlap in fields necessary to make effective personal financial plans including economics, accounting, and finance.
We will also learn about the concept of time value of money, being able to perform present value and future value calculations and know when such calculations are necessary. Time value of money concepts are some of the most difficult concepts to fully grasp, but they are required when making decisions that will impact future periods like retirement savings decisions. We will go into time value of money concepts early in the course, so we have them ready whenever needed as we move forward in the course.
Learners will also learn about money managing skills, skills related to accounting, compiling financial data into financial reports, and using those reports to construct budgets.
English
Language
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
Practice Probs. – Money Management, Financial Statements, & Budgets
2110 Balance Sheet Accounts & Accounting Equation
2120 Balance Sheet Accounts & Accounting Equation Prob. 2
2130 Personal Financial Statements part 1
2131 Personal Financial Statements Part 2 Income Statement
2140 Accounting Equation
2150 Debt Ratio, Current Ratio, & Other Common Ratios
2190 Flexible Personal Budget
2200 Budget vs Actual Performance
2300 Financial Statement & Budget Part 1 Balance Sheet
2301 Financial Statement & Budget Part 2 Income Statement
Excel Probs. – Money Management, Financial Statements, & Budgets
2110 Balance Sheet Accounts & Accounting Equation
2120 Balance Sheet Accounts & Accounting Equation Prob. 2
2130 Personal Financial Statements Part 1
2131 Personal Financial Statements Part 2 Income Statement
2140 Accounting Equation
2150 Debt Ratio, Current Ratio, & Other Common Ratios
2190 Flexible Personal Budget
2200 Budget vs Actual Analysis
2300 Financial Statement & Budget Part 1 Balance Sheet
2301 Financial Statement & Budget Part 2 Income Statement
2302 Financial Statement & Budget Part 3 Budget vs Actual
2400 Budget for 12 Months
2500 Excel Budget Templates