Use Excel to complete the following based on the JEs that were completed on 10/11. Remember that we're only reporting for the month of September (1st through 30th). 1. T-Accounts 2. Adjusting entries. For this purpose, assume that the annual interest rate for the bank loan is 10%. You will also have to accrue salaries/wages. If you have office supplies, you'll have to assume an ending balance for supplies at the end of 9/30. Any other assumptions that you make should be clearly stated on the worksheet. 3. Prepare a 10-column worksheet. View only Y. 60% fx General Journal H A 1 Cr 2 Dr 12500 Date Sept. 1 3 125000 4 5 12500 6 Sept. 1 12500 . 9 12500 Sept. 1 12500 10 11 12 13 Sept 1 12500 12500 15 Sept. 5 General Journal Account Name and Description Cash R. Valerio, Common Stock To record cash contribution by owner Cash L. De Asis, Common Stock To record cash contribution by owner Cash G. Eclevia, Common Stock To record cash contribution by owner Cash J. Daniel, Common Stock To record cash contribution by owner Prepaid Rent Cash To record rent paid in advance (one year) Supplies Accounts Payable To record supplies purchased on credit Equipment Accounts Payable To record equipment purchased on credit Furniture Account Payable To record furniture purchased on credit Machinery Accounts Payable To record machinery purchased on credit 24000 16 24000 1 Sep 8 17000 19 20 17000 20 Sep 8 18000 18000 Sep. 8 3000 26 3000 Sep 8 5000 5000 20 21 Sept. 10 50000 50000 20 Sept. 17 1000 1000 Sept. 21 1200 30 Cash Notes Payable Bank Loan Accounts Recievable Service Revenue Invoice for services provided Prepaid Insurance Cash Prepaid one-year Insurance policy Wege Expense Wages Payable Wages paid for two employees Insurance Expense Prepaid Insurance To Adjust prepaid insurance lapsed (1200/12-2003 Rent Expense Prepaid rent To Adjust prepaid rent lapsed (24000/12-2000) 1200 Sept. 26 1400 1400 Sept. 26 200 Sept 30 200 2000 2000