Please complete Problem7-4 and 8-06 from the end of chapter seven in the text using the attached Excel template.

Problem 7-4 Name: Section: Score: 0% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. 1. Year a. Accumulated Depreciation, End of Year Depreciation Expense Book Value, End of Year 1 2 3 4 b. 1 2 3 4 Assets Statement of Cash Flows 2. 3. Cash + Equipment - Balance Sheet = Liabilities Accumulated Depreciation = + + Stockholders' Equity Retained Earnings Income Statement Problem 8-6 Name: Section: Score: 0% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. 1. Plan 1 Plan 2 Plan 1 Plan 2 Earnings before interest and income tax Deduct interest on bonds Income before income tax Deduct income tax Net income Dividends on preferred stock Available for dividends on common stock Divide by shares of common stock outstanding Earnings per share on common stock 2. Earnings before interest and income tax Deduct interest on bonds Income before income tax Deduct income tax Net income Dividends on preferred stock Available for dividends on common stock Divide by shares of common stock outstanding Earnings per share on common stock 3. Plan 1: Plan 2: Plan 3: Plan 3 Plan 3