How do you calculate a business loan in Excel?
How do you calculate a business loan in Excel? To do this, we configure the PMT function as follows: rate – The interest rate per period. We divide the value in C6 by 12 since 4.5% represents annual interest, and we need the periodic interest. nper – the number of Read more…