In: Accounting
A |
Amount of Note Payable |
$ 1,500,000.00 |
B |
No. of Installments |
3 |
C =A / B |
Annual amount of principal amount of installment |
$ 500,000.00 [1500000 / 3] |
Date |
Beginning Balance |
Interest at 10% |
Principal payment |
Total Installment to be received |
Ending Balance |
[A] |
[B = A x 10%] |
[C = $ 500,000] |
[D = B + C] |
[E = A - C] |
|
Issued |
$ 1,500,000.00 |
||||
31-Dec-14 |
$ 1,500,000.00 |
$ 150,000.00 |
$ 500,000.00 |
$ 650,000.00 |
$ 1,000,000.00 |
31-Dec-15 |
$ 1,000,000.00 |
$ 100,000.00 |
$ 500,000.00 |
$ 600,000.00 |
$ 500,000.00 |
31-Dec-16 |
$ 500,000.00 |
$ 50,000.00 |
$ 500,000.00 |
$ 550,000.00 |
$ - |
Date |
Accounts title |
Debit |
Credit |
01-Jan-14 |
Notes Receivable |
$ 1,500,000.00 |
|
Equipment |
$ 500,000.00 |
||
Gain on Sale |
$ 1,000,000.00 |
||
(Equipment sold and Notes receivables accepted) |
|||
31-Dec-14 |
Cash |
$ 650,000.00 [see Column ‘D’ above] |
|
Interest revenue |
$ 150,000.00 [see Column ‘B’ above] |
||
Notes Receivables |
$ 500,000.00 |
||
(1st installement received) |
|||
31-Dec-15 |
Cash |
$ 600,000.00 [see Column ‘D’ above] |
|
Interest revenue |
$ 100,000.00 [see Column ‘B’ above] |
||
Notes Receivables |
$ 500,000.00 |
||
(2nd installement received) |
|||
31-Dec-16 |
Cash |
$ 550,000.00 [see Column ‘D’ above] |
|
Interest revenue |
$ 50,000.00 [see Column ‘B’ above] |
||
Notes Receivables |
$ 500,000.00 |
||
(3rd and last installement received) |