50.1K

Verified Solution

Link Copied!

Hello, could you please help me do a journal entry (in excel) to payoff the note early just after that month's monthly payment has been made. Any help is highly appreciated and I will give a thumbs up. Thank you in advance.

Old File name: Note Payable Amortization Tablew Video 40k XXb Issue Date: 01/01/12 Note Amount: 40.000 31/01/12 31/12/12 30/06/13 Pmt # Payment Beginning Balance: >> $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 201 $995,40 $995,40 $995,40 23 $995,40 $995,40 25 $995,40 26 $995,40 27 $995,40 $995,40 291 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 37 $995,40 $995,40 39 $995,40 $995,40 41 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 47 $995,40 Interest Rate (Annual): 9% Interest Rate per Monthly payment: 0,7500% #of Monthly Payments: 48 Payment per period: ($995,40) Interest Pre Pays Principal Balance. 40.000 300,00 $695,40 39.305 294,78 $700,62 38.604 289,53 $705,87 37.898 284,24 $711,16 37.187 278,90 $716,50 36.470 273,53 $721,87 35.749 268,11 $727,29 35.021 262,66 $732,74 34.289 257,16 $738,24 33.550 251,63 $743,77 32.807 246,05 $749,35 32.057 240,43 500,00 $754,97 30.802 231,021 $764,38 30.038 225,28 $770,12 29.268 219,51 $775,89 28.492 213,69 $781,71 27.710 207,83 $787,57 26.923 201,92 $793,48 26.129 195,97 $799,43 25.330 189,97 $805,43 24.524 183,93 $811,47 23.713 177,85 $817,55 22.895 171,71 $823,69 22.071 165,54 500,00 $829,86 20.742 155,56 $839,84 19.902 149,26 $846,14 19.056 142,92 $852,48 18.203 136,52 $858,88 17.344 130,08 $865,32 16.479 123,59 $871,81 15.607 117,05 $878,35 14.729 110,47 $884,93 13.844 103,83 $891,57 12.952 97,14 $898,26 12.054 90,41 $904,99 11.149 83,62 500,00 $911,78 9.737 73,03 $922,37 8.815 66,11 $929,291 7.886 59,14 $936,26 6.9491 52,12 $943,28 6.006 45,05 $950,35 5.056 37,92 $957,48 4.098 30,74 $964,66 3.134 23,50 $971,90 2.162 16,21 $979,19 1.183 8,87 $986,53 196 1,47 $993,93 (798) 24 28 30 31 32 33 34 36 38 40 42 43 44 45 46 Old File name: Note Payable Amortization Tablew Video 40k XXb Issue Date: 01/01/12 Note Amount: 40.000 31/01/12 31/12/12 30/06/13 Pmt # Payment Beginning Balance: >> $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 201 $995,40 $995,40 $995,40 23 $995,40 $995,40 25 $995,40 26 $995,40 27 $995,40 $995,40 291 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 37 $995,40 $995,40 39 $995,40 $995,40 41 $995,40 $995,40 $995,40 $995,40 $995,40 $995,40 47 $995,40 Interest Rate (Annual): 9% Interest Rate per Monthly payment: 0,7500% #of Monthly Payments: 48 Payment per period: ($995,40) Interest Pre Pays Principal Balance. 40.000 300,00 $695,40 39.305 294,78 $700,62 38.604 289,53 $705,87 37.898 284,24 $711,16 37.187 278,90 $716,50 36.470 273,53 $721,87 35.749 268,11 $727,29 35.021 262,66 $732,74 34.289 257,16 $738,24 33.550 251,63 $743,77 32.807 246,05 $749,35 32.057 240,43 500,00 $754,97 30.802 231,021 $764,38 30.038 225,28 $770,12 29.268 219,51 $775,89 28.492 213,69 $781,71 27.710 207,83 $787,57 26.923 201,92 $793,48 26.129 195,97 $799,43 25.330 189,97 $805,43 24.524 183,93 $811,47 23.713 177,85 $817,55 22.895 171,71 $823,69 22.071 165,54 500,00 $829,86 20.742 155,56 $839,84 19.902 149,26 $846,14 19.056 142,92 $852,48 18.203 136,52 $858,88 17.344 130,08 $865,32 16.479 123,59 $871,81 15.607 117,05 $878,35 14.729 110,47 $884,93 13.844 103,83 $891,57 12.952 97,14 $898,26 12.054 90,41 $904,99 11.149 83,62 500,00 $911,78 9.737 73,03 $922,37 8.815 66,11 $929,291 7.886 59,14 $936,26 6.9491 52,12 $943,28 6.006 45,05 $950,35 5.056 37,92 $957,48 4.098 30,74 $964,66 3.134 23,50 $971,90 2.162 16,21 $979,19 1.183 8,87 $986,53 196 1,47 $993,93 (798) 24 28 30 31 32 33 34 36 38 40 42 43 44 45 46

Answer & Explanation Solved by verified expert

See Answer