Format Font Tools Table Window Help accountant project.docx 100% Tables Charts SmartArt Review Paragraph Styles ? ?? :?,1 u itiRu | | Emphasis Heading 1 Normal Strong This project should be completed using Excel (with formulas and linked data). Below are the deliverables: 1. Prepare a Multi-Step Income Statement for the year ended 2018. This statement should be flexibly 2. Show journal entries, adjusting entries and closing entries for the below additional 3. Prepare a Statement of Retained Earnings for the year ended 2018. This statement should be 4. Prepare a Classifled Balance Sheet dated Dec. 31, 2018. Again, a flexible design is required so any 5. Prepare a Statement of Cash Flows using the indirect method for the year ended 2018. The designed (formulas in cells). To the right of your dollars in this statement, show common-sized percentages based on sales (vertical analysis) information...none of the journal entries for 2018 have been posted to the ledger. flexibly designed changes will automatically update the balance sheet, Statement of Cash Flows (operating section) should automatically change when assumptions are changed Your Name, Inc. Balance Sheet 12/31/2017 Current Assets Cash Markctable Securities (Short-term) Accounts Receivable $18,000 2,000 14,000 (2,000) 15,000 Allowance for Bad Debt Inventory Prepaid Insurance Total Current Assets $52,000 Property, Plant, and Equipment 30,000 150,000 (45,000) 100,000 Land Building Accumulated Dep. -Building Equipment Accumulated Dep. Equipment Total PPE Total Assets 5267,000 Sec 1 Pages1 of 2 Words: 170 of 765L ??- weri @ &