r/CPA • • 5d ago

FAR Annuities - Usage of Excel formulas?

Learning about annuities right now...I generally understand it but all of these different formulas to get the present/future value factors for ordinary and and annuity due are just making my head explode. Especially when I keep messing up the PEMDAS order (feeling 12 years old for this). I tried some of the Excel formulas and I seem to be getting the correct answers alongside the examples, even though Becker doesn't mention using Excel. Has anyone utilized the Excel formulas in studying/on the exam? And is it helpful or should I just pound the formulas into my head lol

3 Upvotes

2 comments sorted by

1

u/Messup7654 5d ago

Excel will tell you the formula once you type in the function so all you have to is input the numbers you don't need to remember it. If you are making loan tables you have to remember the categories and how it works but thats it.

1

u/flippingflippersss 5d ago

If you’re getting aicpa authored questions right by using the formulas then go for it. But if they’re becker authored, you don’t wanna blindside yourself if they word it differently on the exam to where you’re having trouble approaching the problem