1. Business
  2. Accounting
  3. ey ratio calculations 5 1 create a single sheet that...

Question: ey ratio calculations 5 1 create a single sheet that...

Question details

ey Ratio Calculations 5 1. Create a single sheet that calculates the ratios listed below based on the financial statement 2. Please see Demo 1E for suggestions on how to complete this exercise (the ratios demo may not be 6 exactly the same for this assignment. Please make sure to include the ratios listed HERE: a. Ratios: Current, Quick, Inventory Turnover, Average Collection Period, Fixed Assets Turnover Total Asset Turnover, Debt Ratio, Debt to Equity, Times Interest Earned, Gross Profit Margin, Net Profit Margin, Return on Assets, Return on Equity Balance Sheet Liabilities and Owners Equity 10 Current Assets Current Liabilities S 20,000.00 10,000.00 20,000.00 50,000.00 Cash $ 10,000.00 10,000.00 S 20,000.00 12 Accounts Receivable Accounts Payable Notes Payable 14 Total Current Assets 15 16 17 Fixed Assets 18 19 Total Current Liabilities Long Term Debt S 20,000.00 Net Fixed Assets $ 85,000.00 Owners Equity Common Stock and paid-in surplus550,000.00 21 Retained Earning:S 45,000.00 $ 95,000.00 Total Owners Equity 24 Total Assets $135,000.00 Total Liabilities and Owners Equity S 135,000.00 26 27 28 29 Income Statement 31 COGS 32 Depreciation 33 EBIT 34 Interest expense 35 EBT 36 Taxes 37 Net Income 30 Revenue (all sales are credit 100,000.00 45,000.00 15,000.00 40,000.00 5,000.00 35,000.00 10,000.00 $ 25,000.00 39 40 41 EPS 42 Number of shares outstandin 100,000.00 0.25

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution