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.

DO 5 = Lname, Fname Note Amort View Home , Wrap Text General Insert Page Layout Formulas Data Review % Cut Calibri (Body) , 11 A- A- Copy Format BI U SA E , X , fx | Paste ** *3 Merge & Center 9: % M33 I J K L Assignment: 1. Prepare a Note Amortization table thru payoff. 2. Journalize transactions (Click tab below.) Submit to your Canvas Assignment folder. New File Name convention: Lname Fname Note Amort Tables Prepare a Note Amortization table. (This could be your next car loan!) wa AWN OF No ne Tale Ve XX Issue Date: 01/01/12 Note Amount: 40.000 Video Demonstration to create an Note Amortization Table: http://youtu.be/Cx283RIMUS 48 31/01/12 11 2 ou SNUSSE 00,00 SEEEEEEEEE 30/06/13 Interest Rate (Annual): 9% Interest Rate per Monthly payment: 0,7500% #of Monthly Payments: Payment per period: ($995,40) Pmt # Payment Interest Pre Pays Principal Balance. Beginning Balance: >> 40.000 $995,40 300,00 $695,40 39.3051 $995,40 294,78 $700,621 38.604 3 $995,40 289,53 $705,87 37.898 $995,401 284,24 $711,16 37.187 $995,40 278,90 $716,50 36.470 $995,40 273,531 $721,87 35.749 $995,40 268,111 $727,291 35.021 $995,40 262,66 $732,74 34.289 5995,40 257,16 $738,241 33.550 $995,40 2151,63 $743.77 32.8071 $995,40 246,05 $749,35 32.057 $995,40 240,43 $754,97 30.802 $995,40 231,02 $764,38 30.038 $995,40 225,28 $770,12 219.2681 $995,40 219,51 $775,89 28.492 $995,40 213,69 $781,71 27.710 $995,40 207,83 $787,57 26.923 $995,40 201,92 $793,48 26.129 $995,40 195,97 $799,43 25.330 $995,40 189,971 $805,431 24.524 $995,401 183,93 $811,47 23.713 $995,40 177,85 $817,55 22.895 $995,40 171,71 $823,69 22.071 $995,40 165,54 5 00,00 $829,861 20.742 $995,40 155,56 $839,84 19.902 5995,40 149,26 $846,141 19.056 $995,40 142.92 $852.48 18.2031 $995,40 136,52 5858.88 17.344 $995,40 130.08 S181615.32 16.4791 $995,40 123,59 $871,81 15.607 $995,40 117,05 $878,35 14.7291 $995,40 110,47 $884,93 13.844 $995,40 103,83 $891,57 12.952 $995,40 97,14 $898,26 12.054 $995,40 90,411 $904,99 111491 36 $995,40 83,62 500,00 $911,78 9.737 $995,401 73,03 $922,37 8.815 38 $995,401 66,11 $929,29 7.886 39 $995,40 59,14 $936,26 6.949 $995,40 52,121 $943,28 6.006 $995,40 45,05 $950,35 5.056 5995,40 37,92 $957,48 4.098 $995,40 30,74 $964,66 3.134 $995,40 23,50 $971.90 2.162 $995,40 16,21 $979,19 1.183 $995,40 8,87 $986,53 196 $995,40 1,47 $993,93 (798) 29 37 40 41 84 DO 5 = Lname, Fname Note Amort View Home , Wrap Text General Insert Page Layout Formulas Data Review % Cut Calibri (Body) , 11 A- A- Copy Format BI U SA E , X , fx | Paste ** *3 Merge & Center 9: % M33 I J K L Assignment: 1. Prepare a Note Amortization table thru payoff. 2. Journalize transactions (Click tab below.) Submit to your Canvas Assignment folder. New File Name convention: Lname Fname Note Amort Tables Prepare a Note Amortization table. (This could be your next car loan!) wa AWN OF No ne Tale Ve XX Issue Date: 01/01/12 Note Amount: 40.000 Video Demonstration to create an Note Amortization Table: http://youtu.be/Cx283RIMUS 48 31/01/12 11 2 ou SNUSSE 00,00 SEEEEEEEEE 30/06/13 Interest Rate (Annual): 9% Interest Rate per Monthly payment: 0,7500% #of Monthly Payments: Payment per period: ($995,40) Pmt # Payment Interest Pre Pays Principal Balance. Beginning Balance: >> 40.000 $995,40 300,00 $695,40 39.3051 $995,40 294,78 $700,621 38.604 3 $995,40 289,53 $705,87 37.898 $995,401 284,24 $711,16 37.187 $995,40 278,90 $716,50 36.470 $995,40 273,531 $721,87 35.749 $995,40 268,111 $727,291 35.021 $995,40 262,66 $732,74 34.289 5995,40 257,16 $738,241 33.550 $995,40 2151,63 $743.77 32.8071 $995,40 246,05 $749,35 32.057 $995,40 240,43 $754,97 30.802 $995,40 231,02 $764,38 30.038 $995,40 225,28 $770,12 219.2681 $995,40 219,51 $775,89 28.492 $995,40 213,69 $781,71 27.710 $995,40 207,83 $787,57 26.923 $995,40 201,92 $793,48 26.129 $995,40 195,97 $799,43 25.330 $995,40 189,971 $805,431 24.524 $995,401 183,93 $811,47 23.713 $995,40 177,85 $817,55 22.895 $995,40 171,71 $823,69 22.071 $995,40 165,54 5 00,00 $829,861 20.742 $995,40 155,56 $839,84 19.902 5995,40 149,26 $846,141 19.056 $995,40 142.92 $852.48 18.2031 $995,40 136,52 5858.88 17.344 $995,40 130.08 S181615.32 16.4791 $995,40 123,59 $871,81 15.607 $995,40 117,05 $878,35 14.7291 $995,40 110,47 $884,93 13.844 $995,40 103,83 $891,57 12.952 $995,40 97,14 $898,26 12.054 $995,40 90,411 $904,99 111491 36 $995,40 83,62 500,00 $911,78 9.737 $995,401 73,03 $922,37 8.815 38 $995,401 66,11 $929,29 7.886 39 $995,40 59,14 $936,26 6.949 $995,40 52,121 $943,28 6.006 $995,40 45,05 $950,35 5.056 5995,40 37,92 $957,48 4.098 $995,40 30,74 $964,66 3.134 $995,40 23,50 $971.90 2.162 $995,40 16,21 $979,19 1.183 $995,40 8,87 $986,53 196 $995,40 1,47 $993,93 (798) 29 37 40 41 84