Course curriculum

    1. 1010 Personal Financial Planning Overview

    2. 1015 Financial Goals & Activities for Various Life Situations

    3. 1020 Finance, Economics, & Accounting

    4. 1025 Financial Goals

    5. 1030 Personal Finance Planning Procedure

    6. 1040 Time Value of Money Overview

    7. 1045 Present Value

    8. 1050 Present Value Months as Period

    9. 1055 Future Value

    10. 1060 Future Value Months As Period

    11. 1065 Future Value vs Present Value

    12. 1067 Present Value Annuity

    13. 1069 Present Value Annuity Months as Period

    14. 1071 Future Value Annuity

    15. 1073 Future Value Annuity Months

    16. 1075 Present Value Cash Flow Examples

    17. 1077 Future Value Cash Flow Examples

    18. 1079 Present Value Terms Used In Capital Budgeting

    19. 1081 Net Present Value Assumptions

    1. 1111 Rule of 72 & Running Balance Calculation

    2. 1112 Excel Present Value, Future Value, & Number of Period

    3. 1113 Present Value & Future Value Mathematical Formulas

    4. 1114 Present Value & Future Value Tables

    5. 1115 Rule of 72 & Running Balance Calculation Prob. 2

    6. 1116 Excel Functions Present Value, Future Value, & Number of Period

    7. 1117 Present Value & Future Value Mathematical Formulas Prob. 2

    8. 1118 Present Value & Future Value Tables Prob. 2

    9. 1119 Rule of 72 & Running Balance Calculation Prob. 3

    10. 1120 Excel Functions Present Value, Future Value, & Number of Period Prob. 3

    11. 1121 Present Value & Future Value Mathematical Formulas Prob. 3

    12. 1122 Present Value & Future Value Tables Prob. 3

    13. 1123 Rate of Increase

    14. 1131 Inflation & Estimated Increase in Personal Expenses

    15. 1140 Home Cost Estimated Increase

    16. 1150 Savings Account Compounding Future Value

    17. 1160 Future Value Annuity Investment vs Non-Annuity

    18. 1162 Annuity Initial Investment Present Value of Annuity

    19. 1180 College Savings Calculation

    20. 1191 Retirement Savings FV of Annuity

    21. 1200 What if We Saved Our $5 a Day Coffee Habit

    22. 1210 Option to Receive Money Today vs a Series of Payments

    23. 1213 Loan Payment Calculation & Amortization Table

    24. 1215 Monthly Loan Payment Calculation & Amortization Table

    25. 1217 Annuity Due or Annuity Beginning Period

    26. 1218 Present Value Monthly Periods

    27. 1222 Present Value Annuity Monthly Periods

    28. 1225 Future Value Monthly Periods

    29. 1230 Future Value Annuity Monthly Periods

    30. 1235 Annuity Due Present Value

    31. 1240 Present Value of Annuity using Non Annuity Excel Functions

    32. 1245 Future Value of Annuity using Non-Annuity Excel Functions

    33. 1255 Retirement Plan Worksheet

    1. 1111 Rule of 72 & Running Balance Calculation

    2. 1112 Excel Functions Present Value, Future Value, & Number of Periods

    3. 1113 Present Value & Future Value Mathematical Formulas

    4. 1114 Present Value & Future Value Tables

    5. 1115 Rule of 72 & Running Balance Calculation Prob. 2

    6. 1116 Excel Functions Present Value, Future Value, & Number of Period

    7. 1117 Present Value & Future Value Mathematical Formulas Prob. 2

    8. 1118 Present Value & Future Value Tables

    9. 1119 Rule of 72 & Running Balance Calculation Prob. 3

    10. 1120 Excel Functions Present Value, Future Value, & Number of Period Prob. 3

    11. 1121 Present Value & Future Value Mathematical Formulas Prob. 3

    12. 1122 Present Value & Future Value Tables

    13. 1123 Rate of Increase

    14. 1131 Inflation & Estimated Increase in Personal Expenses

    15. 1140 Home Cost Estimated Increase

    16. 1150 Savings Account Compounding Interest Future Value

    17. 1160 Future Value Annuity Investment vs Non-Annuity

    18. 1161 Investment to Meat Goal Present Value

    19. 1162 Annuity Initial Investment Present Value of Annuity

    20. 1180 College Savings Calculation

    21. 1191 Retirement Savings FV of Annuity

    22. 1200 What if We Saved Our $5 a Day Coffee Habit

    23. 1210 Option to Receive Money Today vs a Series of Payments

    24. 1213 Loan Payment Calculation & Amortization Table

    25. 1215 Monthly Loan Payment Calculation & Amortization Table

    26. 1217 Annuity Due or Annuity Beginning Period

    27. 1218 Present Value Monthly Periods

    28. 1222 Present Value Annuity Monthly Periods

    29. 1225 Future Value Monthly Periods

    30. 1230 Future Value Annuity Monthly Periods

    31. 1235 Annuity Due Present Value

    32. 1240 Present Value of Annuity using Non-Annuity Excel Functions

    33. 1245 Future Value of Annuity using Non-Annuity Excel Functions

    34. 1250 Home Loan Payment Calculation & Amortization Table

    35. 1255 Retirement Plan Worksheet

    1. 2010 Personal Money Management Overview

    2. 2020 Personal Financial Statements Overview

    3. 2030 Personal Financial Statements & Bookkeeping Tools

    4. 2040 Personal Balance Sheet Creation

    5. 2045 Create Personal Income Statement

    6. 2050 Create a Personal Budget Overview

    7. 2055 Common Personal Finance Ratios

    8. 2060 Budget Example & Recommended Category Percentages

    1. 2110 Balance Sheet Accounts & Accounting Equation

    2. 2120 Balance Sheet Accounts & Accounting Equation Prob. 2

    3. 2130 Personal Financial Statements part 1

    4. 2131 Personal Financial Statements Part 2 Income Statement

    5. 2140 Accounting Equation

    6. 2150 Debt Ratio, Current Ratio, & Other Common Ratios

    7. 2190 Flexible Personal Budget

    8. 2200 Budget vs Actual Performance

    9. 2300 Financial Statement & Budget Part 1 Balance Sheet

    10. 2301 Financial Statement & Budget Part 2 Income Statement

    11. 2302 Financial Statement & Budget Part 3 Budget vs Actual

    12. 2400 Budget for 12 Months

    1. 2110 Balance Sheet Accounts & Accounting Equation

    2. 2120 Balance Sheet Accounts & Accounting Equation Prob. 2

    3. 2130 Personal Financial Statements Part 1

    4. 2131 Personal Financial Statements Part 2 Income Statement

    5. 2140 Accounting Equation

    6. 2150 Debt Ratio, Current Ratio, & Other Common Ratios

    7. 2190 Flexible Personal Budget

    8. 2200 Budget vs Actual Analysis

    9. 2300 Financial Statement & Budget Part 1 Balance Sheet

    10. 2301 Financial Statement & Budget Part 2 Income Statement

    11. 2302 Financial Statement & Budget Part 3 Budget vs Actual

    12. 2400 Budget for 12 Months

    13. 2500 Excel Budget Templates

About this course

  • $75.00
  • 672 lessons
  • 179 hours of video content

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.