We have a loan with monthly payments, an annual interest rate of 6%, paying off the...

Transcribed Image Text:

We have a loan with monthly payments, an annual interest rate of 6%, paying off the $70,000 loan completely in a 10 year period. Payments are scheduled at the end of the period. Using Excel's PMT function, find the value. Pmt ($64.65) Pmt Rate Pmt 0.50% Rate ($2,500.00) We have a loan, making monthly payments of $4,000 and paying off the $60,000 loan completely in a 12 year period. Payments are scheduled at the end of the period. Using Excel's RATE function, find the value. Pmt Rate Rate 7% Nper 0.33% ($4,000.00) We are making monthly payments of $3,000, with an annual interest rate of 4%, paying off the $90,000 loan in a 10 year period. Payments are scheduled at the end of the period. Using Excel's NPER function to find the number of periods to pay off the loan. Nper 0.42% Nper 120 0.42% Pv Nper Pv 144 $ ($3,000.00) We make quarterly payments of $5,000, on a 15 year loan with an annual interest rate of 5%. Payments are scheduled at the end of the period. How much can we borrow? Use the PV function to find your answer. Pv 30 $ 70000 60 Pv 60,000 Pv 120 $ Fv 90,000 Fv ($5,000.00) If we are making $2,500 monthly payments on a $160,000 10 year loan at an annual rate of 5%, how much will we still owe after the 10 year period? Payments are scheduled at the end of the period. Use the FV function to find your answer. Pmt Rate Nper $94,646.45 Fv Fv 0 Fv 0 160,000 ($38,430,318.42) We have a loan with monthly payments, an annual interest rate of 6%, paying off the $70,000 loan completely in a 10 year period. Payments are scheduled at the end of the period. Using Excel's PMT function, find the value. Pmt ($64.65) Pmt Rate Pmt 0.50% Rate ($2,500.00) We have a loan, making monthly payments of $4,000 and paying off the $60,000 loan completely in a 12 year period. Payments are scheduled at the end of the period. Using Excel's RATE function, find the value. Pmt Rate Rate 7% Nper 0.33% ($4,000.00) We are making monthly payments of $3,000, with an annual interest rate of 4%, paying off the $90,000 loan in a 10 year period. Payments are scheduled at the end of the period. Using Excel's NPER function to find the number of periods to pay off the loan. Nper 0.42% Nper 120 0.42% Pv Nper Pv 144 $ ($3,000.00) We make quarterly payments of $5,000, on a 15 year loan with an annual interest rate of 5%. Payments are scheduled at the end of the period. How much can we borrow? Use the PV function to find your answer. Pv 30 $ 70000 60 Pv 60,000 Pv 120 $ Fv 90,000 Fv ($5,000.00) If we are making $2,500 monthly payments on a $160,000 10 year loan at an annual rate of 5%, how much will we still owe after the 10 year period? Payments are scheduled at the end of the period. Use the FV function to find your answer. Pmt Rate Nper $94,646.45 Fv Fv 0 Fv 0 160,000 ($38,430,318.42)

Answer rating: 100% (QA)

Based on the information provided I noticed a discrepancy in the formulas you used for the RATE and ... View the full answer