Case Study:

You work in the mergers and acquisitions department of a large conglomerate who is looking to invest in a retail business. Two companies, Fashion Forward and Dream Designs, are the final two options being considered. You have the most recent availableincome statements and two years of balance sheetsfor each company.

Compute the following ratios for each company:

• Profit Margin Ratio
• Return on Assets
• Current Ratio
• Quick Ratio
• AR Turnover Ratio
• Average Collection Period
• Inventory Turnover Ratio
• Average Sales Period
• Debt to Equity Ratio
• For this assignment:Compute all required amounts and explain how the computations were performed
• Evaluate the results for each company and explain what each ratio means
• Compare and contrast the companies.
• Based on your analysis:
• recommend which company the organization should pursue
• Thoroughly support your conclusion, including what other factors should be considered
• Be specific.

AutoSave . Off) A justinerbryant@gmail.com J X H 5110WA7-Financials - Excel File Home Insert Page Layout Formulas Data Review Help 9 Search Share Comments & Cut 1 A" A ae Wrap Text General AutoSum Calibri E AP O Paste [A Copy EEE E Merge & Center $ ~ % 9 70 20 Conditional Format as Cell Insert Delete Format Fill Sort & Find & Ideas Sensitivity Format Painter Formatting * Table Styles Clear Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity A1 X Y BUS 5110 Written Assignment 7 Financials A B C D E F G H J K M N O W N Income Statements Balance Sheets Fashion Forward Dream Designs Fashion Forward Fashion Forward Dream Designs Dream Designs 12/31/2018 12/31/2018 12/31/2018 12/31/2017 12/31/2018 12/31/2017 Revenue Current Assets Credit Sales 2,000,000 4,320,000 Cash and Cash Equivalents 950,000 980,000 1,710,000 1,705,000 Non-Credit Sales 500,000 1,080,000 Accounts Receivable 200,000 150,000 250,000 275,000 Total Revenue 2,500,000 5,400,000 Inventory 112,000 105,000 200,000 215,000 Other Current Assets 35,000 50,000 120,500 100,000 Cost of Sales 1,400,000 3,250,000 Total Current Assets 1,297,000 1,285,000 2,280,500 2,295,000 Gross Profit 1,100,000 2,150,000 Property, Plant and Equipment 635,000 700,000 850,000 900,000 Goodwill 750,000 750,000 1,150,000 1,150,000 Operating Expenses Other Long-Term Assets 65,000 70,000 100,750 105,000 Research and Development 50,000 200,000 Total Assets 2,747,000 2,805,000 4,381,250 4,450,000 15 Selling, General, and Administrative 750,000 ,600,000 16 Total Operating Expenses 800,000 1,800,000 Current Liabilities 17 Accounts Payable 545,000 535,000 845,750 875,000 18 Earnings Before Interest and Taxes 300,000 350,000 Short-Term Debt 25,000 50,000 60,000 19 Other Current Liabilities 600,000 510,000 730,000 740,000 20 Interest Expense (18,000) (50,000) Total Current Liabilities 1,170,000 1,045,000 1,625,750 1,675,000 21 Income Before Tax 282,000 300,000 Long-Term Debt 75,000 120,500 130,000 22 Income Tax Expense (145,500) (87,500) Other Long-Term Liabilities 100,000 75,000 155,000 165,000 23 Net Income 136,500 212,500 Total Liabilities 1,345,000 1,120,000 1,901,250 1,970,000 24 25 Stockholders Equity 26 Common Stock 500,000 775,000 749,500 942,750 27 Preferred Stock 150,000 294,500 390,000 409,250 28 Retained Earnings 752,000 615,500 1,340,500 1,128,000 29 Total Stockholders Equity 1,402,000 1,685,000 2,480,000 2,480,000 30 31 Total Liabilities and Stockholders Equity 2,747,000 2,805,000 4,381,250 4,450,000 32 22 IS + + 90% Type here to search W X 9 9:21 PM 7/26/2020