We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Satsuma Loans - Pre Loaded Interest?
Comments
-
Then you need to multiply by 12, not compound:
Original documentation:
https://msdn.microsoft.com/en-us/vba/excel-vba/articles/worksheetfunction-pmt-method-excel
A worked example:
http://www.exceltactics.com/car-loan-calculator-part-1-collecting-variables-and-calculating-payments-using-the-pmt-function/
What has the PMT function to do with an APR?
PMT is Excel's implementation of the annuity formula - it uses parameters to generate the annuity payment (one of which is the flat periodic rate of interest). An annuity in this instance is the same as a fixed rate loan repayment.
Anyway, as alluded to in my previous post, Satsuma uses an example on their website which quotes an APR consistent with how I described to calculate it above.
And yes, you do need to compound the flat rate.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.9K Banking & Borrowing
- 254.3K Reduce Debt & Boost Income
- 455.2K Spending & Discounts
- 246.9K Work, Benefits & Business
- 603.5K Mortgages, Homes & Bills
- 178.3K Life & Family
- 261.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.7K Read-Only Boards