1. Mary made a loan of P58,000 to supply her new business. It is to be amortized by ten equal payments of P6,300 at the end of each quarter. a. What is the semi-annual interest needed to amortize the loan? b. Make an amortization schedule showing the distribution of the payments.

The payment necessary to amortize a 4.9% loan of $86,000 compounded annually, with 4 annual payments is ​$24,196.70. The total of the payments is ​$96,786.80 with a total interest payment of ​$10,786.80. The borrower made larger payments of ​$25,000.00. Calculate​ (a) the time needed to pay off the​ loan, (b) the total amount of the​ payments, and​ (c) the amount of interest saved.   a. The time needed to pay off the loan with payments of ​$25,000.00 is _____ years. ​(Round up to the nearest​ year.)   b. The total amount of the payments is ​$______ ​(Round to the nearest cent as​ needed.)   c. The amount of interest saved is ​$______. ​(Round to the nearest cent as​ needed.)

Please provide your complete solutions to the given problems. You may use MS Excel for your solutions. 1. A loan is to be amortized for 4 years through equal payments of PhP48,532.49 at the end of every 6- month period. If the loan earns interest at 7% compounded semi-annually, create an amortization schedule and find: a. the present value of the loan b. the outstanding principal after 3 years c. the amount of principal already paid after 3 years (sum of the principal repayment column for the first 3 years) d. the total interest paid on this loan (sum of the interest column)

5. Jenna received a 15 year loan of $375,000 to purchase a house. The interest rate on the loan was 5.10% compounded semi-annually. a. What is the size of the monthly loan payment? b. What is the balance of the loan at the end of year 3? c. By how much will the amortization period shorten if Jenna makes an extra payment of $30,000 at the end of year 3? Answer in years and in months.