U1 Warm-Up (10.13 or 10.14)
star
star
star
star
star
Last updated about 6 years ago
8 questions
1
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.
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.
1
When using the =PMT formula for a loan is the present value zero or is the future value zero?
When using the =PMT formula for a loan is the present value zero or is the future value zero?
1
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.
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.
1
When using the =PMT formula for a savings situation is the present value zero or is the future value zero?
When using the =PMT formula for a savings situation is the present value zero or is the future value zero?
1
What formula do you use to find the effective rate or compare accounts with different compound periods?
What formula do you use to find the effective rate or compare accounts with different compound periods?
1
What formula do you need to use in order to find out how much you need to deposit as a lump sum today?
What formula do you need to use in order to find out how much you need to deposit as a lump sum today?
1
What formula do you use in order to find what the account balance will be in a compound interest situation (except continuous)?
What formula do you use in order to find what the account balance will be in a compound interest situation (except continuous)?
1
What formula do you use in order to find what the account balance will be in a compound interest continuously situation?
What formula do you use in order to find what the account balance will be in a compound interest continuously situation?