New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey

تمرين 7

You want to take out a loan for $130,000. The annual interest on the loan is 5 percent with payments due monthly. You plan to repay the loan in 15 years. Write the formula to calculate the monthly payment required to completely repay the loan under those conditions.