Preparation of accounting records - using formula embedded spreadsheets. Assignment Questions: The unadjusted trial balance columns in the worksheet of ParthKrishna are as follows as of March 31, 2021.

Account Debit Credit Cash $600 Short-Term Investments 1,800 Inventory 2,000 Prepaid Rent 2,900 Prepaid Insurance 4,500 Land 27,500 Building 52,500 Accumulated DepreciationBuilding $7,500 Long-Term Investments 23,000 Accounts Payable 6,000 Current Portion of Long-term Note Payable 2,500 Income Tax Payable 15,630 Long-term Notes Payable 8,000 Owners capital 34170 Service Revenue 41,000 Rent Expense Insurance Expense Salaries Expense Depreciation ExpenseBuilding ________ Totals $114,800 $114,800

(Note: You can copy this table into Excel) Required: 1) Formulate five adjustments (with special attention to dates and months) and journalise the adjusting entries in excel. Adjustments must cover a variety of transactions. For example, Depreciation, unearned revenue and an error requiring a correction entry (enter these adjustments in datasheet only). Your marks depend upon the quality and detail in framing adjustments. 2) Prepare and complete the 10-column worksheet. 3) Prepare the income statement, the statement of changes in owners' equity, and the classified balance sheet. 4) Prepare the closing entries. 5) Calculate the current ratio for the company using formulas. 6) Complete the optional, High-distinction tasks. Prepare a dashboard depicting financial position or financial performance of the business. (These 3 marks are individual, not group marks)