CAN SOMEONE SHOW ME HOW TO DO THIS ON EXCEL AND THE FORMULAS THEY USED?SHOW ME HOW YOU GET THE PERCENTAGES FOR THE COMMON SIZE INCOME STATEMENTS TOO

1) Prepare the Income Statement, Balance Sheet and Statement of Cash Flows for YoyoDyne Propulsion Systems (YPS) using the following information 2) Include Common Size Statements for the Income Statement and the Balance Sheet. 3) Fill in all of the ratios on the final tab. FINANCIAL STATEMENT 2016 2015 COMPONENTS Accounts Payable 18,450 17,260 Accounts Receivable 54,400 55,300 Accumulated Depreciation 30,200 27,900 Cash & Equivalents 10,500 9.700 Common Stock 40,500 40,500 Cost of Goods Sold 107,200 93,250 Depreciation Expense 2,300 2,250 Fixed Expenses 7.700 7.150 Interest Expense 3,400 2,905 42,700 37,800 Inventory 32,155 Long-Term Debt 29, S00 Other Current Assets 6.616 6,385 8,406 8,604 Other Current Liabilities Plant & Equipment 56,945 53,219 Retained Earnings 22,750 18,240 Sales 151,250 138,250 15,500 13,400 Selling, G&A Expense Short-Term Notes 18,700 20.100 Tax Rate 30% 30% Cost of Capital 9.75% 9.75% 20 Income Statement 10 Common-Size Inc Statement 20 Balance Sheet 10 Common-size Balance Sheet 10 Cash Flows 30 Ratios. STUDENTS: Please remind me to show you how to create a "watch window" and an interactive dynamic picture of any area of a spreadsheet viewed anywhere you want. These are very cool features that hardly anyone knows about, but give you powerful views without having to navigate through a model to see the change