Finance Basics 11 - Annuity Due Calculation in Excel - Present Value and Future Value

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

This Excel Video Tutorial shows you how to calculate the Annuity Due in Excel. You will learn how to calculate the annuity due for the present value and future value functions in Excel.

Annuity due simply means that any annuity payments are made at the end of the period instead of the default situation where annuity payments are made at the beginning of the period. This is a great tutorial for all of those just starting out in finance or for people who need to learn how to calculate an annuity due in Excel.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• excel
• finance
• basics
• annuity due
• future value
• present value
• fv
• pv
• functions
• formulas
• pmt
• interest rate
• investments
• tutorial
• help
• calculation

[faYte0607]

so if the question was worded "... at the end of each year at a 5% interest rate," then we'd just use ordinary annuity calculation instead of annuities due? Please let me know!!!

[ExcelisHell]

@faYte0607 Essentially, yes. PM if you have any more questions. HTH

[Seanyboyh]

A truck costing $150000 is expected to be used for 10 years and then sold for $18000. If the truck is to be depreciated by a fixed percentage per annum, what should this percentage be?

Please, please help on this question. Formula used etc.

[alidotakbari]

thanks a bunch

[muky21]

Thank you very much. My teacher just made things more complicated than what this is.

[vlvl21]

dude, my text book really sucks and very thankful that you placed this tutorial. I finished my last two question because of you .... thank you and godbless.