Question: how do you calculate the total cost of a loan in excel?
Answer: Calculate the total cost of the loan. To do this, simply multiply your "payment per period" value by your "total number of payments" value. For example, if you make 360 payments of $600.00, your total cost of the loan would be $216.000.