1 of 4 istall Microsoft Office and get Cash Flow Template to wave Office installed on your computer now for free or go to hathasit. To installic for free, go to your Microsoft Office 365 homepage and click Once you have Office Installed on your computer, the next step is to go to and download the Cash Flow Template from Chapter 12. Then upload the same to your Microsoft One Drive. On One Drive, rename the file to Your Name Cashflow. On your desktop, delete the template that you just downloaded. We are only using the dotle for this chapter Open the "Your Name Cash Flowse on OneDrive and then inte. Do not edit this one in the browser. We will be using some features that are not available in the browser version. This will open the file on the two softwar e on your computer, butas you make change your doud file be continually updated will be grading this double Once the file is opened in the installed version of well Step Two of this Assignment: On Data 1 sheet: 1 Calculate diferences in Column 2. Decide whether eachine Operating investing ora 3. Make sure the retained Earningsline will balance ng Step Three of this Assignment: Go to Solution 1 tab and make your Cash Flow Statement lookidentical to the one Illustrated on the following page of this handout This mustallbe done with formulas and you must format it for printing Use the following steps. 1 Change the name of the company to Your Na m e1 . Put your name in the title so it is easier for me to grade 2 Use View, New Windows shown in video you can see both tabs at the same time and bring in all your data with formulas. Ales formula fortals on the page to make sure you prove out the change in cash Cash Flow Lecture and Homework - Page 1 3. Follow the Microsoft Excel Checkdison Page of this document am very picky about formatting because I want you to develop profesional presentations as you move along with your career. I will be checking to make sure that you followed each step of the checklist, indluding footers and print i ng this when you do Use the Checklist on Page 3 as well as the video you "Solution a print preview Chow Puro 1 A Paster BI U 610 x V for lille E F Excel Problem 1 Data 5 Cash 6 Accounts receivable 7 Supplies 8 Prepaid Insurance 9 Plant and Equipment 10 Accumulated Depreciation 11 Accounts payable 12 Taxes Payable 13 Long-Term Bank Loan Payable 14 Common Stock 15 Retained Eamings December 31 2020 2019 21,000 18,000 25,000 36,000 15,000 25,000 9,000 6,000 429,000 306,000 100,000 65,000 12,000 10,000 35,000 25,000 85,000 100,000 191,000 141,000 76,000 50,000 17 Net income 18 Dividends 38,000 12,000 C17 EF 1 Your Name Homework 1 2 Statement of Cash Flows 3 For the year ended December 31 5 Cash Flow From Operating Activities Net Income Add: Depreciation Expense Change in Change in Change in Change in Change in Change in Net Cash from Operating Activities 16 Cash Flow From Investing Activities Net Cash from Investing Activites 21 Cash Flow from Financing Activities Net Cash From Financing Activities 26 Net Increase (Decrease) in Cash 28 Cash Balance, December 31, 2019 30 Cash Balance, December 31, 2020 A == = = Loa Calibri (Body) 12 * BIU B16 X fx 28000 AB w Me E F G H Excel Problem 2 Data December 31 2020 2019 Cash 3.000 Accounts receivable Inventory Prepaid Rent Prepaid Property Taxes 10 Land 11 Building 12 Equipment 13 Accumulated Depreciation 14 Accounts payable 15 Income taxes payable 16 | Long-term Loans Payable 17 Bonds Payable 18 Common Stock 19 Retained Eamings 16,000 11,000 7,000 8.000 70,000 310,000 80,000 65,000 12,000 9,000 17.000 9,000 6,000 15,000 75,000 250,000 50.000 30,000 12,500 4,500 25,000 100.000 210,000 49,000 3.000 28.000 60,000 280,000 57,000 Net income Dividends .33,000 25,000 RANRXORNARS88XXX8895 Data 1 Solution 1 Practie 2 Solution 2 + A Paste BIU C14 + x fix C 1 Your name Homework 2 2 Statement of Cash Flows 3 For the year ended December 31 D E F 5 Cash Flow From Operating Activities Net Income Add: Depreciation Expense Change in Change in Change in Change in Change in Net Cash from Operating Activities 14 15 Cash Flow From Investing Activities Net Cash from Investing Activites 19 Cash Flow from Financing Activities Net Cash From Financing Activities 23 Net Increase (Decrease) in Cash 25 Cash Balance, December 31, 2019 27 Cash Balance, December 31, 2020 C eluti