** PROJECT INSTRUCTIONS: Create a pivot table from the dataset. Using your pivot table, then create both an income statement and a balance sheet for the business as of year-end The pivot table, income statement and balance sheet must be on the same page Name of the Business => Max Corporation Year-Ending => December 31, 2025 Hints: You might need to change the signs found in the pivot table to create your statements. Do not forget to include net income in the final retained earnings number on the balance sheet. Sum of DR/CR 136275240 4250800 -34500 288000 60000 55000 275000 8000000 -456000 195000 -180000 -65000 -50500 .90000 3 Row labels 100 Cash 115 Accounts Receivable 6 116 Allowance for Doubtful Accounts 120-_-Inventory 8. 130 -Prepaid Insurance 9 135---Prepaid Rent 10. 140---Investments 11 160 --Property, plant, & Equipment 12 165--Accumulated Depreciation 13 170-.-Patent 14200 Accounts Payable 15 205---Salary Payable 16210 Unearned Revenue 117 230-_-Notes Payable (short-term) 18 240 Bonds Payable 19 250 Common Stock 20 255 - Additional Paid-in-Capital - Common Stock 21260- Preferred Stock 22 265 - Additional Paid-in-Capital - Preferred Stock 23 270---Retained Earnings 24 275 Treasury Stock 25 300---Sales 26 307 Sales Discounts 27 308- Sales Returns & Allowances 28 320---Interest Revenue 29 325 --Dividend Revenue 30 330---Gain on Sale of Equipment 31 400- Cost of Goods Sold 32 410---Salary Expense 33 415 Salary Administrative Expenses 34 420-Utilities Expense 35 425 Rent Expense 36 430 --Depreciation Expense 37 440---Amortization Expense. Patent 38 460---Bad Debt Expense 39470--Loss on Sale of Land 40 480 Interest Expense -1600000 7440000 -9000000 -30000 -450000 18915240 500000 - 144798300 6000 12000 -35000 -3600 -45000 32016100 314950 491350 50000 100000 160000 70000 1200 65000 7500 Grand Total