What formula do you use on Excel/Sheets when asked to find a payment for a loan? Write the formula out fully and with the correct notation.
Question 2
2.
When using the =PMT formula for a loan is the present value zero or is the future value zero?
Question 3
3.
What formula do you use on Excel/Sheets when asked to find a payment for a savings situation? Write the formula out fully and with the correct notation.
Question 4
4.
When using the =PMT formula for a savings situation is the present value zero or is the future value zero?
Question 5
5.
What formula do you use to find the effective rate or compare accounts with different compound periods?
Question 6
6.
What formula do you need to use in order to find out how much you need to deposit as a lump sum today?
Question 7
7.
What formula do you use in order to find what the account balance will be in a compound interest situation (except continuous)?
Question 8
8.
What formula do you use in order to find what the account balance will be in a compound interest continuously situation?