Please show all the Formulas. Thank You
(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. 20 Income Statement 10 Common-Size Inc Statement 20 Balance Sheet 10 Common-Size Balance Sheet 2018 2017 10 Cash Flows 30 Ratios 100 FINANCIAL STATEMENT COMPONENTS Accounts Payable Accounts Receivable Accumulated Depreciation Cash & Equivalents Common Stock Cost of Goods Sold Depreciation Expense Fixed Expenses Interest Expense Inventory Long-Term Debt Other Current Assets Other Current Liabilities Plant & Equipment Retained Earnings Sales Selling, G&A Expense Short-Term Notes Tax Rate Cost of Capital 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. 18,450 54,400 30,200 10,500 40,500 107,200 2,300 7,700 3,400 42,700 32,155 6,616 8,406 56,945 22,750 151,250 15,500 18,700 30% 9.75% 17,260 55,300 27,900 9,700 40,500) 93,250 2.250 7,150 2,905 37,800 29,800 6,385 8,604 53,219 18,240 138,250 13,400 20,100 30% 9.75% Karl: Check out the formula in this cell. I use text and cell values to create a phrase that automatically updates the years based on the cells below, which are in turn updated from the YPS Data tab. 2017 REMEMBER: Formatting and style count. You should show at least four main segments of the Income Statement: Gross Profit, Net Operating Income or EBIT, Earnings before Taxes, and Net Income Use formulas and links to the YPS Data page so every sheet updates dynamically if the YPS Data change! In other words, every cell should have some kind of equation -- no hard-coded YoyoDyne Propulsion Systems Income Statements For the Years 2017 and 2018 2018 Sales $151,250 Cost of Goods Sold Gross Profit Depreciation Expense Fixed Expenses Selling, G&A Expense Net Operating Income Interest Expense Earnings Before Taxes Taxes Net Income FORMATTING AND PRESENTATION COUNT!! SO MAKE IT LOOK PROFESSIONAL (This applies to ALL financials statements following this page as well.) Notes: Tax Rate Possible 10 2017 Yoyo Dyne Propulsion Systems Common-size Income Statements For the Years 2017 and 2018 2018 Sales Cost of Goods Sold Gross Profit Depreciation Expense Fixed Expenses Selling, G&A Expense Net Operating Income Interest Expense Earnings Before Taxes Taxes Net Income Now make a Common-Size Income Statement (aka Vertical Analysis). This should be laid out exactly like your Income Statement using formulas linking to the Income Statement and expressed in percentages. Notes: Tax Rate (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. 20 Income Statement 10 Common-Size Inc Statement 20 Balance Sheet 10 Common-Size Balance Sheet 2018 2017 10 Cash Flows 30 Ratios 100 FINANCIAL STATEMENT COMPONENTS Accounts Payable Accounts Receivable Accumulated Depreciation Cash & Equivalents Common Stock Cost of Goods Sold Depreciation Expense Fixed Expenses Interest Expense Inventory Long-Term Debt Other Current Assets Other Current Liabilities Plant & Equipment Retained Earnings Sales Selling, G&A Expense Short-Term Notes Tax Rate Cost of Capital 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. 18,450 54,400 30,200 10,500 40,500 107,200 2,300 7,700 3,400 42,700 32,155 6,616 8,406 56,945 22,750 151,250 15,500 18,700 30% 9.75% 17,260 55,300 27,900 9,700 40,500) 93,250 2.250 7,150 2,905 37,800 29,800 6,385 8,604 53,219 18,240 138,250 13,400 20,100 30% 9.75% Karl: Check out the formula in this cell. I use text and cell values to create a phrase that automatically updates the years based on the cells below, which are in turn updated from the YPS Data tab. 2017 REMEMBER: Formatting and style count. You should show at least four main segments of the Income Statement: Gross Profit, Net Operating Income or EBIT, Earnings before Taxes, and Net Income Use formulas and links to the YPS Data page so every sheet updates dynamically if the YPS Data change! In other words, every cell should have some kind of equation -- no hard-coded YoyoDyne Propulsion Systems Income Statements For the Years 2017 and 2018 2018 Sales $151,250 Cost of Goods Sold Gross Profit Depreciation Expense Fixed Expenses Selling, G&A Expense Net Operating Income Interest Expense Earnings Before Taxes Taxes Net Income FORMATTING AND PRESENTATION COUNT!! SO MAKE IT LOOK PROFESSIONAL (This applies to ALL financials statements following this page as well.) Notes: Tax Rate Possible 10 2017 Yoyo Dyne Propulsion Systems Common-size Income Statements For the Years 2017 and 2018 2018 Sales Cost of Goods Sold Gross Profit Depreciation Expense Fixed Expenses Selling, G&A Expense Net Operating Income Interest Expense Earnings Before Taxes Taxes Net Income Now make a Common-Size Income Statement (aka Vertical Analysis). This should be laid out exactly like your Income Statement using formulas linking to the Income Statement and expressed in percentages. Notes: Tax Rate
