Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Short Version
- ---------------
- Can anyone figure out how Sallie Mae comes up with its loan payment amount?
- Long Version
- -------------
- I have a friend who took out a personal loan with Sallie Mae, and their payment amount is higher than any math i can figure out. I looked over their [Truth in Lending](https://en.wikipedia.org/wiki/Truth_in_Lending_Act) statement, and while it is very clear on everything you'll pay:
- - they don't explain how they come up with their payment amount
- - their payment amount doesn't match any other loan calculator
- - or the math of any [introduction to economics textbook][1]
- Sallie Mae gives an example
- --------------------
- Rather than giving out details of my friend's own personal loan, we can use two [examples from their own web-site][2] ([archive][3])
- > For a typical 60-month term loan of $20,000 at a 15.99% fixed APR,
- > you will make 59 monthly payments of $487.32
- > and one monthly payment of $387.45.
- >
- > For a typical 36-month term loan of $10,000 at 11.99% fixed APR,
- > you will make 35 monthly payments of $332.64
- > and one monthly payment of $308.59.
- I'll start with the second example:
- - **Loan Amount:** $10,000
- - **APR**: 11.99%
- - **Term**: 36 months
- Nowhere in the full set of 12 PDF documents i reviewed did it mention how they come up with their payment schedule (e.g. the if the effective annual rate assumes 6-month compounding) - so a consumer who has signed a loan has as much information as you do right now.
- But assuming the simple answer of compounded monthly:
- - **Monthly interest rate:** 11.99% / 12 = 0.9992% per month
- - **Effective annual rate:** `(1 + 0.9992%)^12 = 12.67% EAR
- Payment Calculation using Excel
- ----------------
- The easiest way to solve it is to create a payment schedule in Excel, and solve for the payment that causes the loan outstanding amount to hit zero at the end of month 36:
- | Period | Starting Balance | Interest | Payment | New Balance |
- |--------|------------------|----------|---------|-------------|
- | 1 | $10,000.00 | $99.92 | $332.10 | $9,767.82 |
- | 2 | $9,767.82 | $97.60 | $332.10 | $9,533.32 |
- | 3 | $9,533.32 | $95.25 | $332.10 | $9,296.48 |
- | 4 | $9,296.48 | $92.89 | $332.10 | $9,057.27 |
- | 5 | $9,057.27 | $90.50 | $332.10 | $8,815.68 |
- | 6 | $8,815.68 | $88.08 | $332.10 | $8,571.66 |
- | 7 | $8,571.66 | $85.65 | $332.10 | $8,325.21 |
- | 8 | $8,325.21 | $83.18 | $332.10 | $8,076.30 |
- | 9 | $8,076.30 | $80.70 | $332.10 | $7,824.90 |
- | 10 | $7,824.90 | $78.18 | $332.10 | $7,570.99 |
- | 11 | $7,570.99 | $75.65 | $332.10 | $7,314.54 |
- | 12 | $7,314.54 | $73.08 | $332.10 | $7,055.53 |
- | 13 | $7,055.53 | $70.50 | $332.10 | $6,793.93 |
- | 14 | $6,793.93 | $67.88 | $332.10 | $6,529.72 |
- | 15 | $6,529.72 | $65.24 | $332.10 | $6,262.87 |
- | 16 | $6,262.87 | $62.58 | $332.10 | $5,993.35 |
- | 17 | $5,993.35 | $59.88 | $332.10 | $5,721.14 |
- | 18 | $5,721.14 | $57.16 | $332.10 | $5,446.20 |
- | 19 | $5,446.20 | $54.42 | $332.10 | $5,168.52 |
- | 20 | $5,168.52 | $51.64 | $332.10 | $4,888.07 |
- | 21 | $4,888.07 | $48.84 | $332.10 | $4,604.82 |
- | 22 | $4,604.82 | $46.01 | $332.10 | $4,318.73 |
- | 23 | $4,318.73 | $43.15 | $332.10 | $4,029.79 |
- | 24 | $4,029.79 | $40.26 | $332.10 | $3,737.96 |
- | 25 | $3,737.96 | $37.35 | $332.10 | $3,443.21 |
- | 26 | $3,443.21 | $34.40 | $332.10 | $3,145.52 |
- | 27 | $3,145.52 | $31.43 | $332.10 | $2,844.85 |
- | 28 | $2,844.85 | $28.42 | $332.10 | $2,541.18 |
- | 29 | $2,541.18 | $25.39 | $332.10 | $2,234.48 |
- | 30 | $2,234.48 | $22.33 | $332.10 | $1,924.71 |
- | 31 | $1,924.71 | $19.23 | $332.10 | $1,611.84 |
- | 32 | $1,611.84 | $16.10 | $332.10 | $1,295.85 |
- | 33 | $1,295.85 | $12.95 | $332.10 | $976.70 |
- | 34 | $976.70 | $9.76 | $332.10 | $654.37 |
- | 35 | $654.37 | $6.54 | $332.10 | $328.81 |
- | 36 | $328.81 | $3.2 9 | $332.10 | $0.00 |
- **Conclusion:** monthly payment of $332.10
- Solve it algebraically
- ---------------
- The above 36 term equation has been solved:
- - ***P***: $10,000 *(present value)*
- - ***i***: 0.9992% *(rate per period)*
- - ***N***: 36 *(number of periods)*
- - ***A***: ? *(amount)*
- The formula is given as:
- A = P * [ i(1+i)^N / ((1+i)^N - 1 ]
- = 10000 * [ 0.009992(1.009992)^36 / (1.009992^36-1) ]
- = 10000 * [ 0.014292166 / 0.43036086 ]
- = 10000 * [ 0.033209534]
- = $332.10
- **Conclusion:** monthly payment of $332.10
- Solve using PMT function
- -------------------
- We can try solving it using the [`PMT`][4] function of every spreadsheet ever.
- =PMT(0.009992, 36, 10000, 0, 0)
- [![enter image description here][5]][5]
- **Conclusion:** monthly payment of $332.10
- Solve using online calculator
- -----------------------
- We can try solving it using online calculators:
- - [**The Calculator Site**][6]: $332.10
- - [**TD Canada Trust**][7]: $332.2
- - [**Calculator.net**][8]: $332.10
- - [**ScotiaBank**][9]: $331.67
- **Conclusion**: monthly payment of $332.10 *(ish)*
- Sallie Mae come up with a loan amount much higher
- =================
- - my calculated monthly payment amount: $332.10
- - Sallie Mae's example payment amount: $332.64
- Sallie Mae seems to have a higher amount than they should:
- | Item |My calculations | Theirs |
- |--------------|---------------------------|-----------------------|
- |
- > For a typical 36-month term loan of $10,000 at 11.99% fixed APR,
- > you will make 35 monthly payments of $332.64
- > and one monthly payment of $308.59.
- [1]: http://a.co/8HsfOz2
- [2]: https://www.salliemae.com/banking/personal-loans/
- [3]: https://archive.fo/qjefe
- [4]: https://support.office.com/en-us/article/pmt-function-0214da64-9a63-4996-bc20-214433fa6441
- [5]: https://i.stack.imgur.com/x15Or.png
- [6]: https://www.thecalculatorsite.com/finance/calculators/loancalculator.php
- [7]: https://www.tdcanadatrust.com/loanpaymentcalc.form
- [8]: https://www.calculator.net/loan-calculator.html?cloanamount=10000&cloanterm=3&cloantermmonth=0&cinterestrate=11.99&ccompound=monthly&cpayback=month&x=120&y=21
- [9]: https://www.scotiabank.com/ca/en/0,,8166,00.html
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement