Which company looks better to a lender?

Also did I enter in the ratios correctly?

Company 1 55.48 Which looks better to a lender? Ratio Average Collection Period Company 2 37.52 Company 1 Company 2 .08 .05 Return on Assets (ROA) Company 1 Company 2 39.60 68.39 Gross Profit Percentage Company 1 Company 2 I .90 .84 Current Ratio Company 1 Company 2 .59 .55 Quick (Acid- test) Ratio Company 1 Company 2 Company 2 CMCSA 12/31/19 Using excel formulas that reference the cells in columns Band D. Calculate the rotos below in the space provided. I've provided an example below (debt ratio) that will automatically calculate when you've filled out columns 8 and for your assigned companies My example: : Company 1 1 any you were assigned here DIS year ending date you were assigned for each company 9/30/19 wediocely below, type the correct value from the income statement and or the company and year assigned hool Finance. http://finance.yahoo.com) Company 1 DIS Total Revenue/Sales (aka Net Credit Sales) 69570000 Cost of Goods Sold/Cost of Revenue 42018000 Operating Income 11851000 Income Tax Expense/Tax Provision 3031000 Net Income 11054000 Cash and Cash Equivalents 5418000 Other Short Term Investments/Short Term Investments 0 Accounts Rec/Net Receivables (for the assigned fiscal year) 12882000 e./Net Receivables (for the year prior to assigned fiscal year) 8268000 Inventory 1649000 Total Current Assets 28124000 Net Property Plant and Equipment 31603000 Goodwill 80293000 Total Assets (for the assigned fiscal year) 193984000 Total Assets (for the year prior to assigned fiscal year) 98598000 Accounts Payable 13778000 Total Current Uabilities 31341000 Total abilities 100095000 Retained Earnings 42494000 Total Stockholder Equity 88877000 Company 1 0.475559 Company 2 0.422995 Asset Turnover Ratio Company 2 CMCSA 108942000 34440000 21125000 3673000 13057000 5500000 0 11292000 11104000 0 25392000 48322000 68725000 263414000 251684000 10826000 30292000 179540000 50695000 82726000 You must calculate the following: Company 1 DIS Average Collection Period 55.48189 Return on Assets (ROA) 0.075562 Gross Profit Ratio 0.396033 Current Ratio 0.897355 Quick (Acid-test) Ratio 0.5839 Company 2 CMCSA 3751785 0.050697 0.683868 0.838241 0.554338 Remember to submit your completed file in MS Excel format only * Use only the official formulas from our Textbook or my Power Points