Back To Busn 135  Home Page

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.