In: Finance
Watkins Technology is purchasing computer software at a cost of $23,000. They are putting a down payment of $3,000 and will borrow the remainder. They will amortize the loan for the software in equal 48 monthly installments at an interest rate of 14%. Prepare an amortization schedule for the first two payments. SHOW ALL WORK!
Payment Number |
Amount of Payment |
Interest for Period |
Portion to Principal |
Principal Balance at End of Period |
0 |
||||
1 |
||||
2 |
Loan amount | $20,000 | |||
Loan term (in years) | 4 | |||
Interest rate | 14.00% | |||
Payment frequency | 12.00 | |||
Monthly Loan payment | $546.53 | |||
Payment number | Amount of payment | Interest for period | Portion to principal | Principal balance at end of period |
0 | $20,000 | |||
1 | $546.53 | $233.33 | $313.20 | $19,686.80 |
2 | $546.53 | $229.68 | $316.85 | $19,369.95 |
Total | $1,093.06 | $463.01 | $630.05 |
Calculations and formulas