Question: how do you calculate loan amount in excel?
Answer: rate - The interest rate per period. We divide the value in C5 by 12 since 4.5% represents annual interest: nper - the number of periods comes from cell C7, 60 monthly periods in a 5 year loan. pmt - The payment made each period. This is the known amount $93.22, which comes from cell C6.