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

[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.

[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

[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.