PMT function with a 360 day base instead of 365
We need more information.
How long are your periods? It they're one month or longer, it won't make any
difference whether you use 360-day base, or 365. There are still twelve
months in a year.
Or, build an amortization table as follows:
A1 (Period) = 0
B1 (Payment) = (use the PMT function, or a guess)
C1 (Interest) = Interest Rate
D1 (Balance) = Opening Balance
A2 = A1+1
B2 = B1
C2 = D1*$C$1*#days/360
D2 = D1-B2+C2
Copy down for the term of the loan.
Use the goalseek function to determine the payment such that the balance is
zero at the end of the term.
> Any ideas? I need to calculate an amortization table with a 360 day base
> instead of 365. Can't seem to get it.