please show in excel for all questions and answer all questions

Q1

Q2

Q3

Q4

Q5

Please answer each sheet that goes with each Question or "Q"

The following is an Adjusted Trial Balance for Klushman Industries: Common Stock Additional Paid in Capital Retained Earnings Service Revenue Salaries and Wages Expense Supplies Expense Office Expense Depreciation Expense Insurance Expense Income Tax Expense Utilities Expense Interest Expense \begin{tabular}{|r|r|} \hline & 15,000 \\ & 225,000 \\ & 30,000 \\ 180,000 \\ 48,000 & \\ 13,000 & \\ 22,000 & \\ 15,000 & \\ 14,000 & \\ 14,000 & \\ 18,000 & \\ 16,000 & \\ \hline 538,000 & \\ \hline \end{tabular} Total Assets last year: Required: Use the Adjusted Trial Balance to prepare: 1. Income Statement 2. Closing Entry 3. Balance Sheet 4. Current Ratio Note: Maintain the order in which the accounts appear on the Adjusted Trial Balance on the corresponding statements. Klushman Industries Balance Sheet Klushman Industries Balance Sheet Karpeeta Corporation Adjusted Trial Balance At December 31, 20XX 7 8 Cash 9 Accounts Receivable 10 Inventory 11 Prepaid Insurance 12 Supplies 13 Equipment 14 Buildings 15 Notes Receivable 16 Accumulated Depreciation 17 Accounts Payable 18 Income Tax Payable 19 Salaries and Wages Payable 20 Unearned Revenue 21 Notes Payable 22 Common Stock 23 Additional Paid in Capital 7. Required: Use the Adjusted Trial Balance to prepare a Multiple Step Income Statement in good form. Note: Maintain the order in which the accounts appear on the Adjusted Trial Balance on the corresponding statements. Karpeeta Corporation Income Statement Operating Expenses: Nonoperating Income and Expenses: Spensa Corporation was established this year and had the following transactions: a. Issued common stock to investors (example) b. Purchased Inventory on account c. Borrowed cash from a local bank d. Sold merchandise to customers, Gross Profit on sale is 57.6% e. Dividends were paid to common shareholders f. Purchased Land for cash B. Incurred selling expenses paying one fourth in cash and putting the remainder on account h. Paid off the local bank loan and also paid 10% in interest i. Earned interest from the savings account at the local bank 1. Collected amounts owed from customers \begin{tabular}{|lrr|r|} \hline Value: & $ & 90,000 & \\ \hline Value: & $ & 23,000 & \\ \hline Value: & $ & 15,000 & \\ \hline Sales amount: & $ & 12,500 & 57.6% \\ \hline Dividends: & $ & 1,000 & \\ Value: & $ & 11,000 & \\ Amount: & $ & 4,000 & \\ \hline Loan: & $ & 5,000 & 10% \\ Amount: & $ & 500 & \\ Amount: & $ & 2,000 & \\ \hline \end{tabular} Required Complete the table in the spreadsheet for each transaction showing the effect on the balance sheet and income statement, Leave unaffected cells blank and use positive ang negative numbers for increases and decreases. Be sure to enter a formula to calculate column totals, the accounting equation, and net income. Note: Negative amounts or amounts to be deducted should be input and displayed as negative values. All other answers should be input and displayed as positive values. BALANCE SHEET INCOME STATEMENT Dzen International Incorporated has a list of accounts in alphabetical order at the end of its first year of 22 Required: 1. Create an Income Statement. 2. Create a Statement of Stockholders' Equity. 3. Create a Balance Sheet. Dzen International Incorporated Income Statement Sales Revenue Cost of Goods Sold Insurance Expense Interest Expense Rent Expense Utilities Expense Income Tax Expense Note: Negative amounts or amounts to be deducted should be input and displayed as negative values. All other answers should be input and displayed as positive values. Dzen International Incorporated Balance Sheet During its first month of operations ending January 31, 2022, Cuppor International completed the transactions on the schedule shown below. Required: 1. Complete the chart by recording the ending balances in each accot. 2. Use the account balances to create a Classified Balance Sheet for January 31, 2022. Cuppor International Balance Sheet