General Annuity Problems Solved in Excel or Google Sheets – FV & PV: Ordinary (END) & Due (BGN)
This video shows how to solve general annuity problems in Excel (or Google Sheets): Future Value and Present Value problems. It also shows how to calculate periodic rate for general
Simple Annuity in Excel: • Annuity Calculations in Excel – FV, P...
00:00 Introduction to General Annuities
00:20 Future Value Problem
00:45 Periodic Rate for General Annuity
01:37 Calculating Future Value
02:24 Future Value of Annuity Due (BGN mode)
02:48 Total Paid + Interest
03:04 Present Value Problem
03:54 Calculating Present Value
04:33 PV BGN mode and Interest Calculation