Question 1194194
my spreadsheet is below.


<img src = "http://theo.x10hosting.com/2022/051701.jpg">


answers to your questions are below.


a. How many regular payments of ₱22,000 are needed?
18 regular payments of 22,000 each are needed.


b. What is the outstanding balance after the eighth payment?
the outstanding balance after the 8th payment is equal to $195,905.60.


c. How much of the ninth payment is interest?
the interest part of the ninth payment is equal to $6,856.70.


d. How much of the ninth payment goes to the payment of the
principal?
the principal part of the ninth payment is equal to 22,000 minus 6,856.70 = $15,143.30.


e. Find the final payment
the final payment is equal to $18,892.42.


all of the required information is in the spreadsheet.
let me know if you have any questions.
theo