Need help with the following assignment. Numbers can be made up but not out of the ordinary. Typical Concrete company creates revenue of 20 million per year with May-Oct being prime months and Nov-April being slow. I have about half of this completed at home but want to make sure I am even close.

Perform a financial ratio analysis of your company using annual Balance sheet, Income Statement, and statement of cash flow data for a five year period from 2010 to 2015. The analysis will consist of ratios, common size statements, and percentage change statements. All calculations are to be done using Excel and the quantified information must be presented in spreadsheet format. 1. Input the financial statements data (Balance sheet, Income statement, & Statements of Cash Flows) for the five year period into a spreadsheet. 2. Using the statement you have prepared, compute the following ratios: Liquidity Ratios 1. Number of Days Inventory 2. Number of Days Payables 3. Number of Days Receivables 4. Net Operating Cycle 5. Current Ratio 6. Quick Ratio 7. Net Working Capital to Sales Ratio Profitability Ratios 1. Gross Profit Margin 2. Operating Profit Margin 3. Net Profit Margin Activity Ratios 1. Inventory Turnover 2. Accounts Receivable Turnover 3. Total Asset Turnover 4. Fixed Asset Turnover Financial Leverage Ratios 1. Total Debt to Assets Ratio 2. Long Term Debt to Assets Ratio 3. Debt to Equity Ratio 4. Times Interest Coverage Ratio 5. Fixed Charge Coverage ratio Shareholder Ratios 1. Earnings Per Share 2. Price Earnings Ratio 3. Dividends Per Share 4. Dividend Payout Ratio 5. Retention Ratio 6. Dividend Yield Based on your findings from the ratios above, perform a trend analysis and tell a story about your company performance over the last five years. What factors do you think contributed to the trends you obtained? What is management's view of these trends? 3. Prepare common size Balance Sheet and Income Statements for the five year period 2010 through 2015. What do these statements tell you about your company? 4. Prepare percentage change statements for the last four years by using the five year data for your balance sheet and income statement data. (Not required for Statement of Cash Flows). What do the change statements tell you about your company