Need help doing this. All rules/side notes must be followed. Some hints:

Remember,a Horizontal Analysis is Period over Period,and

a Vertical Analysis (aka Common Sized Financial Statement)is a function of either Total Assets or Total Revenue,depending on whether it's the Balance Sheet or the Income Statement.

PLEASE ENTER YOUR NAME: (Type over the First and Last) First Last Possible Points 20 10 20 10 10 30 100 GRADE 0 0 0 0 0 0 0 Income Statement Common-Size Inc Statement Balance Sheet Common-Size Balance Sheet Cash Flows Ratios 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 COMPONENTS Accounts Payable Accounts Receivable Accumulated Depreciation Cash & Equivalents Common Stock Cost of Goods Sold Depreciation Expense Fixed Expenses Interest Expense Inventory LongTerm Debt Other Current Assets Other Current Liabilities Plant & Equipment Retained Earnings Sales Selling, G&A Expense Short-Term Notes Tax Rate Cost of Capital 2016 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% 2015 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% 20 10 20 10 10 30 100 STUDENTS: Please re "watch window" and area of a spreadsheet These are very cool fe but give you powerfu through a model to se Income Statement Common-Size Inc Statement Balance Sheet Common-Size Balance Sheet Cash Flows 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. Fall that hardly anyone knows about, These areVersion: very cool2016 features but give you powerful views without having to navigate through a model to see the change. YoyoDyne Propulsion Systems Income Statements For the Years 2015 and 2016 Err:509 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 Notes: Tax Rate Err:509 Karl: Check out the formula in this cell. I use text and cell values to create a phrase that Possible automatically updates the years based on 20 below, which 0 are in turn updated the cells from the YPS Data tab. 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 amounts should be entered here. FORMATTING AND PRESENTATION COUNT!! SO MAKE IT LOOK PROFESSIONAL (This applies to ALL financials statements following this page as well.) ments of the xes, and Net if the YPS Data -coded FESSIONAL YoyoDyne Propulsion Systems Common-size Income Statements For the Years 2015 and 2016 2016 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 Notes: Tax Rate Possible 2015 10 0 Now make a Com (aka Vertical Anal exactly like your formulas linking t expressed in perc 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. YoyoDyne Propulsion Systems Balance Sheets For the Years Ended December 31, 2016 and 2015 2016 2015 Assets Cash & Equivalents Accounts Receivable Other Current Assets Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Net Plant & Equipment Total Assets Liabilities & Owner's Equity Accounts Payable Other Current Liabilities Short-Term Notes Total Current Liabilities LongTerm Debt Total Liabilities Common Stock Retained Earnings Total Owner's Equity Total Liab. & Owner's Equity Possible 20 0 For the Balance Sheet, show the following components: Total Current Assets, Net Plant & Equipment, Total Assets Current Liabilities, Total Liabilities, Total Owner's Equity, Total Liabilities & Owner's Equity. And don't forget formatting and styling! And again, all cells should have formulas. Please use the same period assets/liabilities for calculations vs. the average of periods technique. YoyoDyne Propulsion Systems Common-size Balance Sheet For the Years Ended December 31, 2016 and 2015 2016 2015 Assets Cash & Equivalents Accounts Receivable Other Current Assets Inventory Total Current Assets Plant & Equipment Accumulated Depreciation Net Plant & Equipment Total Assets Liabilities & Owner's Equity Accounts Payable Other Current Liabilities Short-Term Notes Total Current Liabilities LongTerm Debt Total Liabilities Common Stock Retained Earnings Total Owner's Equity Total Liab. & Owner's Equity Possible 10 0 Now make a Comm this should be laid Sheet but express Now make a Common Size Balance Sheet. Again, this should be laid out exactly like your Balance Sheet but expressed in percentages. YoyoDyne Propulsion Systems Statement of Cash Flows For the Year Ended December 31, 2016 Cash Flows from Operations Net Income Depreciation Expense Change in Accounts Receivable Change in Other Current Assets Change in Inventory Change in Accounts Payable Change in Other Current Liabilities Total Cash Flows from Operations Cash Flows from Investing Change in Plant & Equipment Total Cash Flows from Investing Cash Flows from Financing Change in Short-Term Notes Change in LongTerm Debt Payment of Dividends Change in Common Stock Total Cash Flows from Financing Net Change in Cash Balance Check figure 2006 Cash from Balance Sheet 2007 Cash from Balance Sheet Net Change in Cash Balance Possible 10 0 Complete the cells c link to values.. Rem Balance Sheet's year (Remember, you need to ADD (HINT: If A/R decreased, then (HINT: If Inventory increased (HINT: If Accounts Payable i (HINT: If Current Liabilities d - 3 0 - 2 0 (HINT: Look at the change in - 3 0 1 0 1 0 0