Learn how to plan your personal finances from a certified public accountant (CPA)

What you will learn

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

Description

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

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


Subscribe to latest coupons on our Telegram channel.

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