How To Calculate Maximum Loan Amount In Excel?
How to Calculate How Much You Can Borrow Using Excel Enter the monthly interest rate, in decimal format, in cell A1. Enter the number of payments in cell A2. Enter the maximum amount you could comfortably afford paying each month in cell A3. Enter “=PV(A1,A2,A3)” in cell A4 to calculate the maximum amount of the […]