Review Ratio Sheet Review the AC499 Financial Report Analysis Unit 4 Ratio Sheet. Step 3: Financial Analysis Complete a financial analysis of the company financials for Quixote Consulting. Use the...

Review Ratio Sheet

Review the AC499 Financial Report Analysis Unit 4 Ratio Sheet.

Step 3: Financial Analysis

Complete a financial analysis of the company financials for Quixote Consulting. Use the Excel Template titled: "Unit 4 Financial Report Analysis Template.” Be sure to review the Excel tab titled “Hints & Instructions” before you attempt the assignment tab.

Hints & Instructions The Unit 4 Assignment is worth 40 Points. Notes: 1) Some of the ratios do NOT have sufficient data to compute a ratio. In those ratios, simply type "Insufficient data to Compute". The objective is to provide you an opportunity to employ critical thinking. You need to be able to discern whether or not all elements are present. 2) In the ratios that require an "Average" - assume that the BEGINNING Account Balance = - 0-. 3) Remember, .50% is NOT the same as 50%. 4) Use all transactions that include "Sales on Account" as "Net Credit Sales". 5) Be sure to include your formulas in the proper cell. If you simply input an answer, feedback may be limited. If you include your computations, additional feedback will be possible when an incorrect answer is given. 6) Complete all ratios in all 3 sections - Parts A, B & C. There are 4 ratios in Part A, 2 in Part B, and 3 in Part C. Ratios Complete the Following rations for Quixote Consulting used in Unis 2 and 3. You may use formulas as needed FormulaCalculationResult (words)(numbers) A.  Liquidity Ratios 1. Current Ratio=== 2. Acid Test Ratio=== 3. Inventory turnover===times 367372.5 4. Accounts Receivable turnover===times 55347.5 55347.5 B.  Solvency Ratios4867.6739726027 1. Debt to Total Asset ratio=== %579879 2. Times-interest-earned ratio=== times C.  Profitability Ratios 1. Profit Margin=== %601690 2. Asset Turnover=== % 3. Return on Assets=== %-24861 1122805