document.write( "Question 1193606: How many quarterly payments of ₱15,000 will be necessary to pay off
\n" ); document.write( "a debt of ₱175,000 if the interest rate charged is 8% converted
\n" ); document.write( "quarterly
\n" ); document.write( "

Algebra.Com's Answer #848636 by yurtman(42)\"\" \"About 
You can put this solution on YOUR website!
**1. Determine the Quarterly Interest Rate:**\r
\n" ); document.write( "\n" ); document.write( "* Annual Interest Rate: 8%
\n" ); document.write( "* Quarterly Interest Rate: 8% / 4 = 2% or 0.02\r
\n" ); document.write( "\n" ); document.write( "**2. Calculate the Number of Quarterly Payments**\r
\n" ); document.write( "\n" ); document.write( "* **Use a financial calculator or spreadsheet software (like Excel or Google Sheets) to determine the number of payments.**\r
\n" ); document.write( "\n" ); document.write( " * **In Excel, you can use the NPER function:**
\n" ); document.write( " * `=NPER(rate, pmt, pv, [fv], [type])`
\n" ); document.write( " * rate: Quarterly interest rate (0.02)
\n" ); document.write( " * pmt: Payment amount (-15,000)
\n" ); document.write( " * pv: Present value (175,000)
\n" ); document.write( " * fv: Future value (0, as the loan will be fully paid off)
\n" ); document.write( " * type: 0 for payments at the end of each period (default)\r
\n" ); document.write( "\n" ); document.write( " * This will give you the number of quarterly payments required to repay the loan. \r
\n" ); document.write( "\n" ); document.write( "* **Using a financial calculator or spreadsheet, you'll find that it takes approximately 14 quarterly payments to repay the loan.**\r
\n" ); document.write( "\n" ); document.write( "**Therefore, 14 quarterly payments of ₱15,000 will be necessary to pay off a debt of ₱175,000 at an 8% annual interest rate compounded quarterly.**
\n" ); document.write( "
\n" ); document.write( "
\n" );