| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Cost Optimal Loan Selection 2025 - 2026 rates | |||||
2 | IMPORTANT: Make a copy of the calculator and only modify the orange cells. | |||||
3 | ||||||
4 | Inputs | |||||
5 | ||||||
6 | Loan Amount | $100,000 | ||||
7 | Deferment Period | 30 | <-- the months left in school + 6 | |||
8 | Loan Term (in months) | 120 | ||||
9 | Juno Negotiated Deal or other Private rate | 7.00% | ||||
10 | ||||||
11 | ||||||
12 | Comparison | |||||
13 | Direct Unsubsidized Loan | Grad PLUS loan | Juno Negotiated Deal or other Private | |||
14 | Loan Amount | $100,000 | $100,000 | $100,000 | ||
15 | Interest Rate | 7.94% | 8.94% | 7.00% | ||
16 | Origination Fee (percent) | 1.06% | 4.23% | 0.00% | ||
17 | Origination Fee (dollars) | $1,060 | $4,230 | $0 | ||
18 | Starting Principal | $101,060 | $104,230 | $100,000 | ||
19 | Deferment Period | 30.00 | 30.00 | 30.00 | ||
20 | Interest during Deferment | $20,060 | $23,295 | $17,500 | ||
21 | Principal after Deferment | $121,120 | $127,525 | $117,500 | ||
22 | Loan Term | 120.00 | 120.00 | 120.00 | ||
23 | Monthly Payment | $1,466 | $1,611 | $1,364 | ||
24 | Total Payments | $175,883 | $193,356 | $163,713 | ||
25 | Total Cost | $75,883 | $93,356 | $63,713 | ||
26 | ||||||
27 | Results (Optimal Loan Breakdown) | |||||
28 | ||||||
29 | Is Unsubsidized more affordable than Private? | No | ||||
30 | Is Grad Plus more affordable than Private? | No | ||||
31 | ||||||
32 | Amount from Federal Unsubsidized | $0 | ||||
33 | Amount from Grad Plus | $0 | ||||
34 | Amount from Private Student Loan | $100,000 | ||||
35 | ||||||
36 | ||||||
37 | ||||||