Intermediate Accounting I 0 /50 Excel Project Spring 2024 1 You are given a trial balance for Dunn Corporation for December 31, 2024. 2 You will need to calculate the trial balance adjusments for the following items: a Inventory (9 points) 0 b Asset Acquisitions (8 points) 0 3 Post the adjustments for the items in Step 2 (inventory and asset acquisitions), calculate COGS, and post current year depreciation in the Adjustments column on the Trial Balance All adjusting journal entries are dated December 31 - Year End adjustments (3, 4, and 5 worth 14 points) 0 4 Calculate the Adjusted Trial Balance Using formulas in the Adjusted Trial Balance Column 5 Indicatate in column M of the Trial Balance which financial statement each account is presented on. Use the following list: I/S - Net Revenue B/S - Current Assets B/S - Current Liabilities I/S - COGS B/S - LT Investments B/S - Long Term Liabilities I/S - Operating Expenses B/S - PPE B/S - Equity I/S - Other Income/Expense B/S - Intangible Assets I/S - Net Income 6 Prepare the Multi-Step Income Statement, Statement of Retained Earnings, and Classified Balance Sheet (15 points) 0 Refer to Chapters 4 and 5 if necessary. Watch the format and order of each of these Financial Statements. 7 Write the closing entries (4 points) 0 8 Use formulas in excel to calculate and link cells. If not completed, you will not receive full credit. I should be able to change one number and it flow to every tab needed.