Correctly set up an NPER function, assuming you are solving for how many years it will take to pay off a loan. You do not have to do the calculations-just set up the formula based on the facts below:
• NPER(rate,pmt,pv,fv,type)
• The rate per year is 3.5% compounded quarterly.
• The payment (pmt) is -$25,000 per quarter.
• The present value (pv) is $400,000 because the bank has offered to fund all of the capital required for the project.
• The future value (fv) is assumed to be $0 because no mention is made of any residual amounts owed at the end of the loan.
• The type argument is assumed to be the default 0.

Question

Quizplus · Accepted Answer

The Answer of Correctly set up an NPER function, assuming you are solving for how many years it will take to pay off a loan. You do not have to do the calculations-just set up the formula based on the facts below:
• NPER(rate,pmt,pv,fv,type)
• The rate per year is 3.5% compounded quarterly.
• The payment (pmt) is -$25,000 per quarter.
• The present value (pv) is $400,000 because the bank has offered to fund all of the capital required for the project.
• The future value (fv) is assumed to be $0 because no mention is made of any residual amounts owed at the end of the loan.
• The type argument is assumed to be the default 0.

Correctly Set Up an NPER Function, Assuming You Are Solving