Present Value of an Ordinary Annuity
This is an Excel tutorial for my Acct 232B course that teaches students how to use Excel to build a Present Value Of Ordinary Annuity. Students are required to watch this video and practice developing it. They are then required to take an exam in which they are challenged to recreate this schedule in Excel, in 30 minutes or less, without referring to any notes. Therefore, this tutorial has three objectives 1) teach beginning students how to use various built-in Excel functions 2) teach students how to work efficiently with Excel 3) teach students how to build a Present Value Of Ordinary Annuity.
This is an Excel tutorial for my Acct 232B course that teaches students how to use Excel to build a Present Value Of Ordinary Annuity. Students are required to watch this video and practice developing it. They are then required to take an exam in which they are challenged to recreate this schedule in Excel, in 30 minutes or less, without referring to any notes. Therefore, this tutorial has three objectives 1) teach beginning students how to use various built-in Excel functions 2) teach students how to work efficiently with Excel 3) teach students how to build a Present Value Of Ordinary Annuity.