Case Study Part 1 asks to “In column G, insert a formula using the PMT function (enter the Pv as a negative).”
TIP 1: Don’t forget to enter the Pv as a negative.
Why a negative? Because that is the amount to BORROW.
TIP 2: When entering the interest rate (E7), make sure and divide it by 12. (E7/12).
Why? Because that is the interest that will be paid on the loan over the year or 12 months so.. /12.
PRINT: Scale this assignment to fit one page.
Make sure the appropriate footer is right aligned with (your name, period, page #, and problem #)