# AC499 Unit4FinancialReportAnalysisAssignmentFelicia Green

.xlsx
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 limit 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 Pa
Complete the Following rations for Quixote Consulting used in Unis 2 and 3. You may use formulas as needed Formula (words) 1. Current Ratio = Current Assets = Current Liabilities 2. Acid Test Ratio = Quick Assets = Current Liabilities 3. Inventory turnover = Cost of Goods Sold = Average Inventory 4. Accounts Receivable tu = Net Sales = Average Net Accounts Reveivable 1. Debt to Total Asset ratio = Total Debt = Total Assets 2. Times-interest-earned ra = Earnings = Interest Expense 1. Profit Margin = Net Income = Net Sales 2. Asset Turnover = Net Sales = Average Total Assets 3. Return on Assets = Net Income = Average Total Assets A. Liquidity Ratios B. Solvency Ratios C. Profitability Ratios
. Calculation Result (numbers) 17995 = 5.77 3120 8875 + 3450 = 3.95 3120 Insufficient Data = N/A times To Compute 12425 = 7.20 times 1725 3120 = 11.64 % 26795 Insufficient Data = N/A times To Compute 7925 = 63.78 % 12425 12425 = 92.74 % 13397.5 7925 = 59.15 % 13397.5