AC 313 Statement of Cash Flows Assessment (50 Points) Presented below are the balance sheets of Spitfire Corporation as of December 31, Year 1 and Year 2, and the income statement for the year ended December 31, Year 2. The Income Statement for the year ended December 31, Year 2 as well as additional information from the accounting records are on the next page. All dollars are in thousands. Spitfire Corporation Balance Sheets December 31, Year 1 and Year 2 Year 2 Year 1 Assets Cash S 90 260 $152 269 Accounts receivable Less: Allowance for doubtful accounts Prepaid insurance Inventory Long-term investment Land Buildings and equipment Less: Accumulated depreciation Trademark Total Assets (7) 6 (5) 10 240 70 248 46 170 260 170 296 (80) 30 (109) 28 $1,099 S1.045 Liabilities & Stockholders' Equity Accounts payable Salaries payable Deferred tax liability Lease liability Bonds Payable Less: Discount on bonds Common Stock Paid-In Capital-in excess of par Preferred Stock Retained Earnings Total Liabilities & Stockholders' Equity $ 52 S 37 4 16 20 70 120 280 (27) (25) 300 260 80 110 80 384 380 $1.045 $1.099 Spitfire Corporation Income Statement For the Year Ended December 31, Year 2 Net sales revenue Investment revenue $ 400 14 Operating Expenses: Cost of Goods Salaries expense Depreciation expense Trademark amortization Bad debts expense Insurance expense Bond interest expense Operating Income Other Income (Expense): Loss on sale of building Gain on sale of investments Pre-Tax Income from Continuing Operations Less: Income Tax Expense: $160 60 40 6 22 50 340 S 73 $(30) 6 (24) $50 26 $24 Net Income Additional Information: 1. A building that originally cost $44 million, and which was one-fourth depreciated, was destroyed by fire. Some undamaged parts were sold for $3 million. 2. Investment revenue includes Spitfire Corporation's $8 million share of the net income of Beta Corporation, an equity method investee. 3. $40 million par value of common stock was sold for $70 million, and $80 million of preferred stock was sold at par. 4. A long-term investment in bonds, originally purchased for $32 million, was sold for $38 million. 5. Pretax accounting income exceeded taxable income causing the deferred income tax liability to increase by $4 million. 6. The right to use a building was acquired with a seven-year lease agreement; present value of lease payments, $80 million. Annual lease payments of $10 million are paid at January 1t of each year starting in Year 2. 7. $150 million of bonds were retired at maturity. 8. Shareholders were paid cash dividends of $20 million. Required: Use the EXCEL worksheet template provided. There are three tabs- 1. Direct Method Statement of Cash Flows (SCF). This should be the formal Statement of Cash Flows (see your textbook.) 2. Spreadsheet for preparing the SCFs. This is where you use the spreadsheet method as a tool for preparing the statement. Show ALL your work either with t-accounts, summary entries, or a combination of both. 3. Cash flows from Operating Activities -CFOS Indirect Method A. In the tab labeled Direct Method SCFS, prepare a complete statement of cash flows for Spitfire Corporation using the direct method of reporting cash flows from operating activities for the year ended December 31, Year 2. Show your work in the second tab labeled Spreadsheet for SCFs. Use the spreadsheet method as a tool with supporting t-accounts, summary entries or a combination of both. For both the direct and indirect method you will need to analyze the impact the Allowance for doubtful accounts has on accounts receivable and cash. (25 points) B. In the third tab, prepare the operating activities section only for the statement of cash flows for Ace Corporation using the indirect method for the year ended December 31, Year 2. (25 points) Please follow the Basic Formatting Guidelines for Excel Documents located in the Writing and Excel Assignments folder. AC 313 Statement of Cash Flows Assessment (50 Points) Presented below are the balance sheets of Spitfire Corporation as of December 31, Year 1 and Year 2, and the income statement for the year ended December 31, Year 2. The Income Statement for the year ended December 31, Year 2 as well as additional information from the accounting records are on the next page. All dollars are in thousands. Spitfire Corporation Balance Sheets December 31, Year 1 and Year 2 Year 2 Year 1 Assets Cash S 90 260 $152 269 Accounts receivable Less: Allowance for doubtful accounts Prepaid insurance Inventory Long-term investment Land Buildings and equipment Less: Accumulated depreciation Trademark Total Assets (7) 6 (5) 10 240 70 248 46 170 260 170 296 (80) 30 (109) 28 $1,099 S1.045 Liabilities & Stockholders' Equity Accounts payable Salaries payable Deferred tax liability Lease liability Bonds Payable Less: Discount on bonds Common Stock Paid-In Capital-in excess of par Preferred Stock Retained Earnings Total Liabilities & Stockholders' Equity $ 52 S 37 4 16 20 70 120 280 (27) (25) 300 260 80 110 80 384 380 $1.045 $1.099 Spitfire Corporation Income Statement For the Year Ended December 31, Year 2 Net sales revenue Investment revenue $ 400 14 Operating Expenses: Cost of Goods Salaries expense Depreciation expense Trademark amortization Bad debts expense Insurance expense Bond interest expense Operating Income Other Income (Expense): Loss on sale of building Gain on sale of investments Pre-Tax Income from Continuing Operations Less: Income Tax Expense: $160 60 40 6 22 50 340 S 73 $(30) 6 (24) $50 26 $24 Net Income Additional Information: 1. A building that originally cost $44 million, and which was one-fourth depreciated, was destroyed by fire. Some undamaged parts were sold for $3 million. 2. Investment revenue includes Spitfire Corporation's $8 million share of the net income of Beta Corporation, an equity method investee. 3. $40 million par value of common stock was sold for $70 million, and $80 million of preferred stock was sold at par. 4. A long-term investment in bonds, originally purchased for $32 million, was sold for $38 million. 5. Pretax accounting income exceeded taxable income causing the deferred income tax liability to increase by $4 million. 6. The right to use a building was acquired with a seven-year lease agreement; present value of lease payments, $80 million. Annual lease payments of $10 million are paid at January 1t of each year starting in Year 2. 7. $150 million of bonds were retired at maturity. 8. Shareholders were paid cash dividends of $20 million. Required: Use the EXCEL worksheet template provided. There are three tabs- 1. Direct Method Statement of Cash Flows (SCF). This should be the formal Statement of Cash Flows (see your textbook.) 2. Spreadsheet for preparing the SCFs. This is where you use the spreadsheet method as a tool for preparing the statement. Show ALL your work either with t-accounts, summary entries, or a combination of both. 3. Cash flows from Operating Activities -CFOS Indirect Method A. In the tab labeled Direct Method SCFS, prepare a complete statement of cash flows for Spitfire Corporation using the direct method of reporting cash flows from operating activities for the year ended December 31, Year 2. Show your work in the second tab labeled Spreadsheet for SCFs. Use the spreadsheet method as a tool with supporting t-accounts, summary entries or a combination of both. For both the direct and indirect method you will need to analyze the impact the Allowance for doubtful accounts has on accounts receivable and cash. (25 points) B. In the third tab, prepare the operating activities section only for the statement of cash flows for Ace Corporation using the indirect method for the year ended December 31, Year 2. (25 points) Please follow the Basic Formatting Guidelines for Excel Documents located in the Writing and Excel Assignments folder