Note:Anabsolute cell referenceis used inC6($C$6). As the loan is paid monthly, theInterest Rateis divided by12. You will see theMonthly Interest: Read More:How to Calculate Auto Loan Payment in Excel Step 4 – Calculate the Monthly Payment Use the following formula inE16. =IF((C16+D...