Annual vs Quarterly Rates
When using the PMT function in Excel you typically divide the annual rate by
12 to get monthly compounding. This is OK when the payments are also monthly,
however, how do you calculate quarterly payments with monthly compounding???
|