Problem
Virginia is considering taking out a loan to purchase more products to 6 rent to customers. In order to purchase the products she needs, she has determined that she needs to borrow $10,000. She would like you to help her determine her monthly payment based on the loan amount, an interest rate of 5.5% with a repayment of the loan after 5 years.
On the LoanData worksheet, in cell B6, determine the monthly payment.
In cell B6, edit the formula to return an absolute value.