| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||
2 | AMORTIZATION SCHEDULE | Terms of Use | ||||||||||
3 | DASHBOARD | Visit someka.net for more templates |  | contact@someka.net | ||||||||
4 | ||||||||||||
5 | ||||||||||||
6 | Assumptions | Outputs | ||||||||||
7 | ||||||||||||
8 | Loan Amount | 700,000 | Installment Amount | 54,839 | ||||||||
9 | Interest Rate (as annual interest %) | 2% | Number of Payments | 12 | ||||||||
10 | First Payment Date (dd-mm-yyyy) | 3/27/2023 | Total Interest Paid | 8,063 | ||||||||
11 | Payment Frequency | Monthly | Total Payment | 708,063 | ||||||||
12 | Loan Term (duration in months) | 12 | ||||||||||
13 | Balloon Payment | 50,000 | ||||||||||
14 | ||||||||||||
15 | Payment Period | Payment Due Date | Principal Payable | Interest Payable | Total Installment Payable | Loan Outstanding Balance | ||||||
16 | 1 | 27-Mar-23 | 53,671.93 | 1,166.67 | 54,838.60 | 646,328.07 | ||||||
17 | 2 | 27-Apr-23 | 53,761.38 | 1,077.21 | 54,838.60 | 592,566.69 | ||||||
18 | 3 | 27-May-23 | 53,850.99 | 987.61 | 54,838.60 | 538,715.70 | ||||||
19 | 4 | 27-Jun-23 | 53,940.74 | 897.86 | 54,838.60 | 484,774.96 | ||||||
20 | 5 | 27-Jul-23 | 54,030.64 | 807.96 | 54,838.60 | 430,744.32 | ||||||
21 | 6 | 27-Aug-23 | 54,120.69 | 717.91 | 54,838.60 | 376,623.63 | ||||||
22 | 7 | 27-Sep-23 | 54,210.89 | 627.71 | 54,838.60 | 322,412.74 | ||||||
23 | 8 | 27-Oct-23 | 54,301.24 | 537.35 | 54,838.60 | 268,111.50 | ||||||
24 | 9 | 27-Nov-23 | 54,391.74 | 446.85 | 54,838.60 | 213,719.76 | ||||||
25 | 10 | 27-Dec-23 | 54,482.40 | 356.20 | 54,838.60 | 159,237.36 | ||||||
26 | 11 | 27-Jan-24 | 54,573.20 | 265.40 | 54,838.60 | 104,664.16 | ||||||
27 | 12 | 27-Feb-24 | 54,664.16 | 174.44 | 54,838.60 | 50,000.00 | ||||||
28 | Balloon | 27-Feb-24 | 50,000.00 | 0.00 | 50,000.00 | 0.00 | ||||||
29 | ||||||||||||
30 | Get Full Version Have a license, unlock tables and access many other cool features. | |||||||||||
31 | ||||||||||||