Topic: Finance
Video/Class
Project 42:
Video to watch: Excel
& Business Math 42: Simple Interest Calculations & Short Term Loans ( 33:55 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo42SimpleInterest.xlsx
Handout to download: ExcelBusinessMathVideo42SimpleInterest.pdf
Assigned Homework: HW #1 - 10 at end of Excel Workbook for this video.
Video/Class
Project 43:
Video to watch: Excel
& Business Math 43: Compound Interest Calculating Future Value of a Lump Sum FV
Excel Function ( 55:30 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo43CompoundInterest.xlsx
Handout to download: ExcelBusinessMathVideo43CompoundInterest.pdf
Assigned Homework: HW #1 - 6 at end of Excel Workbook for this video.
Video/Class
Project 44:
Video to watch: Excel
& Business Math 44: What is Present Value? Calculate Present Value Of Lump Sum
Amount. ( 23:20 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo44PresentValue.xlsx
Handout to download: ExcelBusinessMathVideo44PresentValue.pdf
Assigned Homework: HW #1 - 6 at end of Excel Workbook for this video.
Video/Class
Project 45:
Video to watch: Excel
& Business Math 45: Future Value, Present Value and Periodic Payments for
Annuities ( 51:22 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo45AnnuitiesFVandPV.xlsx
Handout to download: ExcelBusinessMathVideo45AnnuitiesFVandPV.pdf
Assigned Homework: HW #1 - 10 at end of Excel Workbook for this video.