Desperate, I need help with questions 2,5,6,7. I got help on the other ones, but I'm desperate for help with these! I know the 1 question limit, but it should be treated all as one question because they tail off of each other. I'd greatly appreciate the help, preferably in excel format! I have included the Journal entries and adjusted journal entries.

Post Description Date Ref. Debit Credit 2019 Cash 45,000 1/1 Capital Stock 45,000 3/1 Cash 20,000 Long-Term Bank Loan 20,000 4/1 7,200 Prepaid Rent Cash 7,200 5/1 4,800 Cash Unearned Rent Revenue 4,800 6/1 Prepaid Insurance 2,400 Cash 2,400 Supplies 6/15 2,570 Cash 2570.00 Inventory 7/1 100000.00 Accounts Payable 100000.00 Accounts Receivable 8/1 165000.00 Sales Revenue 165000.00 Cost of Goods Sold 92000.00 A CCOUNTC ADLICTINIA ADITDnLAL DALANICE Accounts Payable 100000.00 8/1 Accounts Receivable 165000.00 Sales Revenue 165000.00 92000.00 Cost of Goods Sold inventory 92000.00 Cash 105000.00 8/20 Accounts Receivable 105000.00 Accounts Payable 9/1 8000.00 Cash 8000.00 Salaries payable 9/20 1000.00 Salaries Expense 31000.00 32000.00 Cash 10/20 Dividend Expense 8500.00 Cash 8500.00 11/15 Income taxes Payable 3675.00 Cash 3675.00 SMC, Inc Balance Sheet December 31, 2018 Assets Cash. Accounts receivable. Inventory.un Supplies. Total assets. $34,500 25,000 10,000 200 $69.700 Liabilities and Stockholders' Equity Liabilities Accounts payable.. Salaries payable.. $12,000 1,000 3,675 Income taxes payable Total liabilities. Stockholders 'equity Capital stock (10,000 shares outstandingg). Retained earnings. mammnm Total stockholders' equity... Total liabilities and stockholders' equity. $16,675 $25.000 28,025 53,025 $69.700 SMC, Inc. Income Statement Forthe Year Ended December 31, 2018 Sales revenue... $110,000 1,000 Rent $111.000 60.000 51,000 Total revenues Less cost of goods sold Gross Less operating expenses: Supplies expense... Salaries expense... Miscellaneous 400 22.000 4.100 26,500 $24,500 3,675 $20.825 Income before taxes.. Less income taxes.. Net income. $ 2.08 Earnings per share ($20,825/ 10,000 shares) Debits Credits Cash $34,500 Accounts Rece vable. Inventory Supplies Accounts Payable. Salaries Payable. Income Taxes Payable. Captal Stock Retained Earnings Totals 25,000 10.000 200 $12.000 1000 3,675 25,000 28.025 s9.700 $69.700 You are also gven the following information that summarizes the business activity for the currentyear, 2019 a. Issued 10,000 addition al shares of capital stock for $45,000 cash on January 1st b. Borrowed $20,000 on March 1, 2019,from Downtown Bank as along term loan The interest rate on the loanis 5 %and Interest for the year is payable on January 1,2020 c. Paid $7,200cash on April 1to lease a build ing forone ye ar. d. Receved $4,800 on May 1 from a tenant for one year's rent Paid $2,400 on June 1fora one-year insurance policy. . Purchased $2,570 ofsupplies for cash on June 15th Purchased inventory for $100,000 on account on July 1 h August1, sold inventory for $165,000 on account; cost of the merchan di se sold was $92,000. L Collected $105,000cash from cust omers'a ccounts receivable on August 20h September 1Paid $80,000 cash forinventories purchased earlierduringthe year kSeptember 20 paid$32,000for sales reps'salaries, induding $1,000 owedatthe beginning of 2018. L Dividends for $8,500 were paid onOctober 20th m The income taxes payable atthebeginning of 2019 werepaid on November 15th. n. For adjustingentries, allprepaid expenses are initallyrecorded as assets, and all uneamed revenues are initally recorded as liabilities o. At yearend, $600 worth ofsupplies are on hand p At yearend, an additional $9,100 of sales salari es are owed, but have not yet been paid Prepare an adjusting entry to recognize the taxes owed for 2019. The corporate tax rate is 15 % of the income before income taxes. e. You are asked to do the following on anexcelspreadsheet Journalize the trans actionsfor the current year, 2019, using the accounts listed on the financial statements and other appropriate accounts 2. 1 Set up T-accounts and enter the beginning balancesfrom the December 31, 2018, post-dosing trial balance for SMC. Post all current year jounal entries to the T-acco unts 3. Jounaize and post any ne ce ss ary adjusting entries at the end of 2019. (Hint: tems b, G de, o, p, and q require adjust ment.) After the adjusting entries are posted, prepare an adjusted trial balan ce, an income stateme nt statement of retal ned eamings and a balance sheet for 2019. The format of your statements should mirror tho se prepared by the company in 2018. 4. 5. Jounalize and postclosing ent ries for 2019 and prepare a post clos ing trial bala nce. 6. Compute the Current ratio and Debt to Total Asset Ratio for 2018 and 2019 7. Interpretive Que stion What is your overall assessment of the financial health of SMC, Inc.? Post Description Credit Date Ref. Debit 2/31/19 ADJUSTING ENTRIES 833 Interest Expense Interest Payable 833 C Rent Expense 5,400 Prepaid Rent 5,400 D Unearned Rent Revenue 3,200 Rent Revenue 3,200 E Insurance Expense 1,400 Prepaid Incsurance 1,400 O Supplies Expense Supplies 2,170 2,170 P Salaries Expense 9100.00 Salaries Payable 9100.00 Q Income Tax Expense 3945.00 Income Taxes Payable 3945.00 TOTAL 694193.00 694193.00 Post Description Date Ref. Debit Credit 2019 Cash 45,000 1/1 Capital Stock 45,000 3/1 Cash 20,000 Long-Term Bank Loan 20,000 4/1 7,200 Prepaid Rent Cash 7,200 5/1 4,800 Cash Unearned Rent Revenue 4,800 6/1 Prepaid Insurance 2,400 Cash 2,400 Supplies 6/15 2,570 Cash 2570.00 Inventory 7/1 100000.00 Accounts Payable 100000.00 Accounts Receivable 8/1 165000.00 Sales Revenue 165000.00 Cost of Goods Sold 92000.00 A CCOUNTC ADLICTINIA ADITDnLAL DALANICE Accounts Payable 100000.00 8/1 Accounts Receivable 165000.00 Sales Revenue 165000.00 92000.00 Cost of Goods Sold inventory 92000.00 Cash 105000.00 8/20 Accounts Receivable 105000.00 Accounts Payable 9/1 8000.00 Cash 8000.00 Salaries payable 9/20 1000.00 Salaries Expense 31000.00 32000.00 Cash 10/20 Dividend Expense 8500.00 Cash 8500.00 11/15 Income taxes Payable 3675.00 Cash 3675.00 SMC, Inc Balance Sheet December 31, 2018 Assets Cash. Accounts receivable. Inventory.un Supplies. Total assets. $34,500 25,000 10,000 200 $69.700 Liabilities and Stockholders' Equity Liabilities Accounts payable.. Salaries payable.. $12,000 1,000 3,675 Income taxes payable Total liabilities. Stockholders 'equity Capital stock (10,000 shares outstandingg). Retained earnings. mammnm Total stockholders' equity... Total liabilities and stockholders' equity. $16,675 $25.000 28,025 53,025 $69.700 SMC, Inc. Income Statement Forthe Year Ended December 31, 2018 Sales revenue... $110,000 1,000 Rent $111.000 60.000 51,000 Total revenues Less cost of goods sold Gross Less operating expenses: Supplies expense... Salaries expense... Miscellaneous 400 22.000 4.100 26,500 $24,500 3,675 $20.825 Income before taxes.. Less income taxes.. Net income. $ 2.08 Earnings per share ($20,825/ 10,000 shares) Debits Credits Cash $34,500 Accounts Rece vable. Inventory Supplies Accounts Payable. Salaries Payable. Income Taxes Payable. Captal Stock Retained Earnings Totals 25,000 10.000 200 $12.000 1000 3,675 25,000 28.025 s9.700 $69.700 You are also gven the following information that summarizes the business activity for the currentyear, 2019 a. Issued 10,000 addition al shares of capital stock for $45,000 cash on January 1st b. Borrowed $20,000 on March 1, 2019,from Downtown Bank as along term loan The interest rate on the loanis 5 %and Interest for the year is payable on January 1,2020 c. Paid $7,200cash on April 1to lease a build ing forone ye ar. d. Receved $4,800 on May 1 from a tenant for one year's rent Paid $2,400 on June 1fora one-year insurance policy. . Purchased $2,570 ofsupplies for cash on June 15th Purchased inventory for $100,000 on account on July 1 h August1, sold inventory for $165,000 on account; cost of the merchan di se sold was $92,000. L Collected $105,000cash from cust omers'a ccounts receivable on August 20h September 1Paid $80,000 cash forinventories purchased earlierduringthe year kSeptember 20 paid$32,000for sales reps'salaries, induding $1,000 owedatthe beginning of 2018. L Dividends for $8,500 were paid onOctober 20th m The income taxes payable atthebeginning of 2019 werepaid on November 15th. n. For adjustingentries, allprepaid expenses are initallyrecorded as assets, and all uneamed revenues are initally recorded as liabilities o. At yearend, $600 worth ofsupplies are on hand p At yearend, an additional $9,100 of sales salari es are owed, but have not yet been paid Prepare an adjusting entry to recognize the taxes owed for 2019. The corporate tax rate is 15 % of the income before income taxes. e. You are asked to do the following on anexcelspreadsheet Journalize the trans actionsfor the current year, 2019, using the accounts listed on the financial statements and other appropriate accounts 2. 1 Set up T-accounts and enter the beginning balancesfrom the December 31, 2018, post-dosing trial balance for SMC. Post all current year jounal entries to the T-acco unts 3. Jounaize and post any ne ce ss ary adjusting entries at the end of 2019. (Hint: tems b, G de, o, p, and q require adjust ment.) After the adjusting entries are posted, prepare an adjusted trial balan ce, an income stateme nt statement of retal ned eamings and a balance sheet for 2019. The format of your statements should mirror tho se prepared by the company in 2018. 4. 5. Jounalize and postclosing ent ries for 2019 and prepare a post clos ing trial bala nce. 6. Compute the Current ratio and Debt to Total Asset Ratio for 2018 and 2019 7. Interpretive Que stion What is your overall assessment of the financial health of SMC, Inc.? Post Description Credit Date Ref. Debit 2/31/19 ADJUSTING ENTRIES 833 Interest Expense Interest Payable 833 C Rent Expense 5,400 Prepaid Rent 5,400 D Unearned Rent Revenue 3,200 Rent Revenue 3,200 E Insurance Expense 1,400 Prepaid Incsurance 1,400 O Supplies Expense Supplies 2,170 2,170 P Salaries Expense 9100.00 Salaries Payable 9100.00 Q Income Tax Expense 3945.00 Income Taxes Payable 3945.00 TOTAL 694193.00 694193.00