Using Excel to Model an Annuity (HSC SSCE Mathematics Standard): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What does the FV function calculate in Excel?
What does the FV function calculate in Excel?
Total value after regular payments
How should you express as a rate argument in Excel functions?
How should you express as a rate argument in Excel functions?
If payments are made monthly for years, what is the nper value?
If payments are made monthly for years, what is the nper value?
How should a payment of 250 USD be entered in Excel financial functions?
How should a payment of 250 USD be entered in Excel financial functions?
What does type indicate in Excel financial functions?
What does type indicate in Excel financial functions?
Payments due at end of period
What must you do to an annual rate of for monthly payments?
What must you do to an annual rate of for monthly payments?
Divide by
Which function calculates what future payments are worth today?
Which function calculates what future payments are worth today?
PV
In PMT function, how should a target of 10,000 USD be entered?
In PMT function, how should a target of 10,000 USD be entered?
What does the PMT function calculate?
What does the PMT function calculate?
Regular payment amount needed