BSAD 350 Finance

You are to complete a five-year historical analysis on your selected company of the most recent five years of data in the spreadsheets for your company for the income statement, balance sheet, ratios and segment analysis plus three years for Segment Analysis.

You are to include a table with industry averages that includes only the numbers and ratios below in a through c and then heading for each ratio under discussion with a one to two paragraph of analysis for the areas listed below.  The ratios must come from your historical ratio spreadsheet for your company and should be similar to classwork 3. After reviewing the ratios, write a concise analysis about each ratio under the table on:

1. The Profitability table followed by the write-up that should include the actual ratios and industry averages for:

• Sales – Included only in table but discussed in sales growth

• Sales Growth – You must discuss each year of sales growth for this section to be complete

• Gross Profit Margin

• Return on Sales

• Return on Asset

• Return on Equity

1. The Asset Efficiency table followed by the write-up that should include the actual ratios and industry averages for:

• Inventory DOH

• Accounts Receivable DOH

• Accounts Payable DOH

• Total Asset Turnover

• Liquidity and Leverage – Debt-to-Equity only

When writing the analysis, there should be a discussion of each ratio in the table with a comparison of the final year to the industry average.

DETAILED ASSIGNMENT

20200929181641hw_2