In this assignment, you will create a pro forma statement to present to your CFO for next year's forecasting using Excel. You will use the information below to help you in your assessment. Current Assets Cash Petty Cash Temporary Investments Accounts Receivable Inventory Supplies Prepaid Insurance Current Liabilities $ 2100 Notes Payable $ 5,000 100 Accounts Payable 35.900 10,000 Wages Payable 8,500 40,500 Interest Payable 2,900 31,000 Taxes Payable 6,100 3,800 Warranty Liability 1,100 1,500 Unearned Revenues Long-Term Liabilities Notes Payable 1,500 20,000 Property, plant & equipment Land Land Improvements Buildings Equipment Less: Accum. Depreciation Intangible assets 5.500 6,500 Bonds Payable 180,000 201,000 56,000 Goodwill 105,000 Trade Names 200,000 Shareholders' Equity Common Stock 110,000 Retained Earnings 220,000 Accum. Other Comprehensive Income 9,000 Less: Treasury Stock 50,000 400,000