Question: what is the formula to calculate loan amount in excel?
Answer: pv... The present value, which is the original loan amount, or $100,000 in this example. That is, your formula would be: =PMT(0.005,60,100000). If you were to set up an amortization schedule in Excel, the first and last few periods of your loan would look like the figure shown here.