I need help with these please

Brightspace X New Tab X New Tab X -7 X U X HOME DAIA VIEW * Cut Font Name Font Size * TabStop 2 Wrap Text Insert Column " Delete Column Conditional Formatting Paste Copy B i ma & Us overline 25 Merge Cell 1 3- Insert Row Delete Row Remove Conditional Formats Table CLICK HERE TO SAVE YOUR WORK F57 G RATIO ASSIGNMENT 2 PART A - RATIO CALCULATIONS (64 marks) Which company has 3 Arrow Root Units the more favourable Ratio ratio? LIQUIDITY 5 RECOMMENDATIONS 6 1. Working Capital: Use Excel formulae to calculate your ratios and then selecting the appropriate cell(s) f 7 Current Assets - Current Liabilities Please show your answer in millions 0 00 If a ratio is reported in % form, please ente (i.e.. 5.25 instead of 0.05). 10 11 2. Current Ratio: **#Please be sure to use brackets properly 12 Current Assets For example, (5+2+5) / 2 = 6 which is not th 13 Current Liabilities 14 15 16 3. Quick Ratio: 17 Cash + Short-term Investments + Accounts Receivable 18 Current Liabilities 19 4 4 Instructions Arrow Root Student Calculations New... READY DELL Of Its Excel shutBrightspace X New Tab X New Tab X -> X HOME DATA VIEW X & Cut Font Name * Font Size * TabStop Wrap Text Paste Copy Bi Insert Column '9 Delete Column 4 & u s Overline Conditional Formatting 25 Merge Cell 3- Insert Row Delete Row Remove Conditional Formats Table CLICK HERE TO SAVE YOUR WORK F57 B D 94 Total Liabilities G H 5,143 95 Total Liabilities 96 Shareholders' Equity 97 Preferred Shares * * Shareholders' Equity 379 Preferred Shares * * 98 Common Shares *** 492 662 Common Shares *** 825 99 Retained Earning 2,794 Retained Earning 3,480 00 Total Shareholders' Equity 3,835 Total Shareholders' Equity 101 102 Total liabilities and shareholders' equity 8,978 Total liabilities and shareholders' equity 03 104 ** There were no preferred dividends declared this year. ** There were no preferred dividends declared this year. 105 *** The Weighted Average number of common shares outsta 25,000,000 **The Weighted Average number of common shares outsta 25,000,000 20 06 The Market price per common share is : 20 The Market price per common share is : 107 Instructions Arrow Root Student Calculations New. READY DELL mmBrightspace X New Tab X New Tab X X U HOME DATA VIEW & Cut Font Name . Font Size TabStop p Wrap Text E " Insert Column "" Delete Column Conditional Formatting Paste Copy B i U S Overline Merge Cell 3- Insert Row Delete Row Remove Conditional Formats CLICK HERE TO SAVE YOUR WORK F57 B D M N 11 12 REQUIRED 13 14 This file contains 4 tabs. The tabs "Arrow" and "Root" contain the respective financial statements for Arrow and Root. The "Student Submission" tab is where you may complete your calculations and written work prior to transferring your final answers to your Brightspace course under 15 Assessments - Tests - Ratio Assignment. 16 17 Please see the "Student Calculations" tab to complete Parts A, B, C, and D of the assignment. You must input final answers into the Test area. 18 19 20 21 22 23 24 25 26 27 28 29 14 4 Instructions Arrow Root Student Calculations New. READY DELLCut Font Name Font Size . TabStop 2 Wrap Text " Insert Column "" Delete Column Conditional Formatting Copy Bind&us Overline Merge Cell 3. Insert Row Delete Row Remove Conditional Formats Table HERE TO SAVE YOUR WORK F57 A B D E F G H 3. Quick Ratio: Cash + Short-term Investments + Accounts Receivable Current Liabilities 4. Receivable Turnover: Credit Sales Average (Avg) Accounts Receivable 5. Average Collection Period: 365 Receivable Turnover 30 6. Inventory Turnover: Cost of Goods Sold 33 Avg Inventory 34 35 36 7. Days in Inventory: Instructions Arrow Root Student Calculations New. READY DELLInsert Column "" Delete Column Conditional Formatting Copy Bid & US Overline Merge Cell 3 Insert Row Delete Row Remove Conditional Formats CK HERE TO SAVE YOUR WORK F57 A B C D G 15. Price Earnings: Market Price per Share EPS 83 16. Return on Common Shareholders' Equity 84 Net Income - Preferred Dividends 85 Avg Common Shareholders' Equity 86 87 PART B - RATIO ANALYSIS (3 marks) 88 LIQUIDITY 89 Overall, which company has the most favourable liquidity? 90 91 SOLVENCY 92 Overall, which company has the most favourable solvency? 93 94 PROFITABILITY 95 Overall, which company has the most favourable profitability? 96 Instructions Arrow Root Student Calculations New. READY DELL Can Ity Exeel shutDAIA VIEW & Cut Font Name Font Size | TabStop Wrap Text "Insert Column "Delete Column Paste Copy B S Overline Merge Cell 30 Insert Row * Delete Row CLICK HERE TO SAVE YOUR WORK F57 CANADIAN DOLLARS (millions of dollars) E F G H 96 Shareholders' Equity 97 Preferred Shares * * 400 98 Common Shares * * * 861 99 Retained Earning 2,565 100 Total Shareholders' Equity 3,826 101 102 Total liabilities and shareholders' equity 7,943 103 104 ** There were no preferred dividends declared this year. 105 ***The Weighted Average number of common shares outstanding are: 20,000,000 106 The Market price per common share is : 42 107 1 Instructions Arrow Root Student Calculations New. READY DELL attend ofrightspace X New Tab X New Tab X X U OME DAIA VIEW & Cut Font Name Font Size . TabStop 2 Wrap Text Insert Column ""Delete Column Copy B ina&us overline Conditional Formatting 25 Merge Cell 3- Insert Row Delete Row Remove Conditional Formats Table CK HERE TO SAVE YOUR WORK F57 B C D E G H Property plant, and equipment Property plant, and equipment Land 76 Land 133 Office Building $ 3,021 Office Building $ 4,264 Less: Accumulated depreciation 143 2.878 Less: Accumulated depreciation 317 3,947 Equipment 2,396 Equipment 2,053 Less: Accumulated depreciation 585 1,811 Less: Accumulated depreciation 530 1.523 Vehicles 709 Vehicles 810 Less: Accumulated depreciation 176 533 Less: Accumulated depreciation 39 771 Furniture 245 Furniture 223 Less: Accumulated depreciation 42 203 Less: Accumulated depreciation 54 169 Total property, plant and equipment 5.501 Total property, plant and equipment 72 Intangible assets Intangible assets 73 Trademark 67 Trademark 39 26 Patent Patent 93 Total intangible assets 5 Total intangible assets 76 8,978 Total Assets 77 Total Assets 78 Instructions Arrow Root Student Calculations New. READY Can Ite Excel sheet atterorrightspace X New Tab X New Tab X X TOME DATA VIEW & Cut Font Name * Font Size . TabStop 2 Wrap Text ""Insert Column ""Delete Column Conditional Formatting aste Copy B i Ba&us overline Merge Cell 3- Insert Row Delete Row Remove Conditional Formats Table LICK HERE TO SAVE YOUR WORK F57 A C D G H 36 7. Days in Inventory: 37 365 38 Inventory Turnover 39 40 SOLVENCY 41 42 8. Debt to Total Assets: 43 Total Liabilities 44 Total Assets 45 46 47 9. Times Interest Earned 48 Net Income+Interest Expense+Income Tax Expense 49 Interest Expense 50 51 52 10. Debt to Total Equity: 53 Total Liabilities 54 Total Equity 55 PROFITABILITY 56 Instructions Arrow Root Student Calculations New.. READY DELL Can Ity exeel shut afteryof* Cut Font Name . Font Size . TabStop Wrap Text E "Insert Column "" Delete Column Conditional Formatting Paste Copy Bid & us overline Merge Cell 30 Insert Row Delete Row Remove Conditional Formats CLICK HERE TO SAVE YOUR WORK F57 B E G H 57 58 11. Profit Margin: 59 Net Income 60 Sales 61 62 63 12. ROA: 64 Net Income 65 Avg Total Assets 66 67 68 13. Asset Turnover: 69 Sales 70 Avg Total Assets 71 72 73 14. Earnings Per Share (EPS): 74 Net Income - Preferred Dividends 75 Weighted Average Number of Shares 76 77 1 Instructions Arrow Root Student Calculations New. READYBrightspace X New Tab New Tab X X U HOME DATA VIEW K Cut Font Name Font Size TabStop Wrap Text Insert Column ""Delete Column Paste Copy U S Overline Merge Cell 30 Insert Row Delete Row CLICK HERE TO SAVE YOUR WORK F57 CANADIAN DOLLARS (millions of dollars) F G H 78 Liabilities and Shareholders' Equity 79 80 Current Liabilities 81 Accounts payable 444 82 Accrued liabilities 132 83 Unearned Revenue 523 84 Current portion of bank loan and mortgage payable 557 85 Income Tax payable 424 86 Total Current Liabilities 2,080 87 88 Non-current liabilities 89 Bank loan payable 520 90 Mortgage Payable 318 91 Bond payable 1,199 92 Total Non-current liabilities 2,037 93 94 1,117 Total Liabilities 95 96 Shareholders' Equity 400 97 Preferred Shares ** Instructions Arrow Root Student Calculations New... READY DELLBrightspace X New Tab X New Tab X -7 X U @ HOME DATA VIEW & Cut Font Name Font Size - TabStop 2 Wrap Text Insert Column "Delete Column Conditional Formatting Paste Copy B i Us Overline Merge Cell 3 Insert Row Delete Row Remove Conditional Formats Table CLICK HERE TO SAVE YOUR WORK F57 B c D E G 41 ROOT LTD. ROOT LTD. 42 STATEMENT OF FINANCIAL POSITION STATEMENT OF FINANCIAL POSITION 43 AS AT DECEMBER 31, 2025 AS AT DECEMBER 31, 2024 44 CANADIAN DOLLARS (millions of dollars) CANADIAN DOLLARS (millions of dollars) 45 46 ASSETS ASSETS 47 48 Current assets Current assets 49 Cas $ 1,714 Cash 50 Short-term investments 576 Short-term investments 51 Accounts receivable 385 Accounts receivable 52 Inventory 50 Inventory 53 Spare parts and supplies inventory 90 Spare parts and supplies inventory 54 Prepaid Maintenance 356 Prepaid Maintenance 55 26 Prepaid expenses Prepaid expenses $ 3,197 Total current assets 56 Total current assets 57 187 Investments 58 Investments 59 Property plant, and equipment 60 Property plant, and equipment Instructions Arrow Root Student Calculations New. READY DELLghtspace X New Tab X New Tab X - ME DAIA & Cut Font Name . Font Size * TabStop Wrap Text Copy B "" Insert Column ":" Delete Column in a & us overline Conditional Formatting Merge Cell 3 Insert Row Delete Row Remove Conditional Formats Table CK HERE TO SAVE YOUR WORK F57 B C D G H Total Assets 8,978 Total Assets Liabilities and Shareholders' Equity Liabilities and Shareholders' Equity Current Liabilities Current Liabilities Accounts payable 380 Accounts payable 912 Accrued liabilities 295 Accrued liabilities 128 Unearned Revenue 442 Unearned Revenue 405 Current portion of bank loan and mortgage payable 537 Current portion of bank loan and mortgage payable 463 Income Tax payable 353 Income Tax payable 342 Total Current Liabilities 2,007 Total Current Liabilities Non-current liabilities Non-current liabilities 559 Bank loan payable 417 Bank loan payable 328 Mortgage Payable 398 Mortgage Payable 2,009 Bond payable 2,179 Bond payable 93 Total Non-current liabilities 3,136 Total Non-current liabilities 5,143 Total Liabilities Total Liabilities 95 Instructions Arrow Root Student Calculations New... READY