need help with ratio analysis

Paste Font Alignment Number E Formatas Table D cell styles Colls Ed $12 4,000 A B D E F RedBear Landscaping Company Adjusted Trial Balance 3 December 31, 4 2021 2020 5 Debit Credit Debit Credit 6 Cash $ 35,120 $ 14,700 7 Accounts Receivable 1,700 1,200 8 Supplies 7,000 10,000 9 Prepaid Expenses 8,400 8,000 10 quipment 22,000 22,000 11 Vehicles 50,000 50,000 12 Office Furniture 5,000 5,000 13 Accumulated Depreciation $ 22,000 $ 11,000 14 Accounts Payable 5,000 4,600 15 Accrued Expenses Payable 2,400 1.800 16 Note Payable (due in six months) 5,000 17 Loan Payable (due in five years) 44,500 44,500 18 Common Stock, $1 par 4,000 19 Additional Paldin Capital 28,000 28,000 20 Retained Earnings 12,000 21 Dividends Declared contra RE) 6,100 1,900 22 Services Revenue 79,200 72.000 23 Wage Expense 31,680 28,800 24 Insurance Expense 8,000 7,200 25 Rent Expense 6.000 6,000 26 Advertising Expense 1,000 1,000 27 Depreciation Expense 11,000 11,000 28 Interest Expens 2.800 3.100 29 Income Tax Expense 1,300 1,000 30 Total $ 197,100 $ 197,100 S 170,900 $ 170,900 31 TUE A group of four students who started a new residential landscaping and snowplowing business, RedBear Landscaping Company (RBLC, has now completed two years of operations. The Adjusted Trial Balance (before closing) reflects both years of business Required: properly formatted ratios correct linking and formulas: narratives that include "what the ratios mean for the company AND "trend" analysis (insufficient just stating ratio increased or decreased, or just stating ratio good or bad; must include why what ratio results mean) Do NOT include how you calculated pad LOTUS Checklist SLA3 Exhibit 13.3 Ratios Ratio Analysis Linked to TB 32 99 + 921 otv W A Paste Font Alignment Conditional Formatting Formatas Table Cell Styles Number Colls Ldit 2 F G Depreciation Expense Interest Expense Income Tax Expense Total B C D E FUUU DU 2,800 3,100 1,300 1,000 $ 197,100 $ 197,100 $ 170,900 $ 170,900 A group of four students who started a new residential landscaping and snowplowing business, RedBear Landscaping Company (RBLC), has now completed two years of operations. The Adjusted Trial Balance (before closing) reflects both years of business. Required: properly formatted ratios, correct linking and formulas; narratives that include "what the ratios mean for the company AND "trend" analysis. (insufficient : Just stating ratio increased or decreased, or just stating ratio good or bad; must include why/What ratio results mean.) Do NOT include how you calculated the ratios, that is demonstrated by correct formulas and linking 4 Add'l info: common shares outstanding for both years (Cs at par/par value per share) 4,000 1. Using the worksheet provided, calculate the following ratios for both years and interpret the results in a ratio analysis narrative, including year over year comparison. Must use formulas and linking to calculate the 5 numerator and the denominator and result 6 a. Current Ratio 7 b. Total Asset Turnover 18 c. Net Profit Margin 39 d. Return on Assets e. Earnings per Share (EPS) 0 42 43 44 45 46 47 48 49 50 51 52 53 55 + Exhibit 13.3 Ratios Checklist SLA3 Ratio Analysis Linked to TB LE w inser Dran Page Layout Formulas Data SLA 3: students $21 View Tell me Review Calibrl Body 12 AA General B 1 A Condition Formas de Col Styles Dees - Ratio Analysis C D Red Landing Company Radio Anale December 31, Ratio Name Ford link to 2011 2020 Results Calendar 2001 2030 Palesplan for the company and to Current Ratio Funer caminado Het is 1 12 Total Assets Tarver erator Tutorial denominato denominator 15 16 17 Net Profit Mergin TO nomine demor remitt 22 Return on At come denominat 24 25 art 27 EPS e de 30 11 ER Conta Checklist SLAS Ratio Analysis anked to to ev 9 MacBook Air TE DOG 60 80 F3 F2 A * CO & 7 9 O % 5 $ 4 # 3 6 5 O U Y T C Excel File Edit View Insert Format Tools Data Window Help Autre BEZ Home Insert Draw Page Layout Formulas Data Review View Tell me SLA students $21 Lo Calibrl Body * 20 General $ % ) 13 Condition format Cell For Tables LA AN C Redker Landing Company Rute Analyse December 11, retleme for rent area former ce que no solo Rai Name Formulai to TO 2031 2000 Results Calendar 2021 Analysis the company and green or Setariationer er Current Radio 706 30 7,400 400 ON 0.72 79.200 307220 72.000 99.900 10 11 12 Total Aset Tuever 13 14 15 16 12 Nero Margin 18 19 022 79.200 de 22 Return on conomia ANNARRARE 27 EPS rutie Checklist Ratio Analysis Linked to TO Exhibit 3.3 Ratios atv MacBook Air Excel File Edit View Insert Format Tools Data Window Autosave Home Insert Draw Page Layout Formulas Data Review Vie Calibri (Body) 11 A A Paste lul C24 $ B C D E F 1 RedBear Landscaping Company 2 Adjusted Trial Balance 3 December 31, 4 2021 2020 5 Debit Credit Debit Credit 6 Cash $ 35,120 s 14,700 7 Accounts Receivable 1,700 1,200 8 Supplies 7,000 10,000 9 Prepaid Expenses 8,400 8,000 10 Equipment 22,000 22,000 11 Vehicles 50,000 50,000 12 Office Furniture 5,000 5,000 13 Accumulated Depreciation 22,000 $ 11,000 14 Accounts Payable 5,000 4,600 15 Accrued Expenses Payable 2,400 1,800 16 Note Payable (due in six months) 5,000 17 Loan Payable (due in five years) 44,500 44,500 18 Common Stock, $1 par 4,000 4,000 19 Additional Paid in Capital 28,000 28,000 20 Retained Earnings 12,000 21 Dividends Declared (contra RE) 6,100 22 Services Revenue 79,200 72,000 23 Wage Expense 31,680 28.800 24 Insurance Expense 3,000 7,200 25 Rent Expense 6.000 6,000 26 Advertising Expense 1,000 1,000 27 Depreciation Expense 11,000 11,000 28 Interest Expense 2.800 3,100 29 Income Tax Expense 1.300 1,000 30 Total 5 197, 1005 197,100 $ 170,900 $ 170.900 31 A group of four students who started a new residential landscaping and snowplowing business, Re 1,900 DES DI Layou Formulas Review View Calibri (Body) 11 Pasto C24 3 D E ET LUI EU EU 28 Interest Expense 2,800 3,100 29 Income Tax Expense 1,300 1,000 30 Total S 192.100 $ 197,100 $ 170,900 $ 170,900 31 A group of four students who started a new residential landscaping and snowplowing business, RedBear Landscaping Company (RBLC), has now completed two years of operations. The Adjusted Trial Balance (before closing) reflects both years of business. 32 Required: properly formatted ratios; correct linking and formulas; narratives that indude "what the ratios mean for the company AND "trend" analysis. (insufficient : Just stating ratio Increased or decreased; or just stating ratio good or bad, must include why/what ratio results mean.) DO NOT include how you calculated 33 the ratios, that is demonstrated by correct formulas and linking. Add' info: common shares outstanding for both years (CS at par/par value per share) - 4,000 1. Using the worksheet provided, calculate the following ratios for both years and interpret the results in a ratio analysis narrative, including year over year comparison. Must use formulas and linking to calculate the 35 numerator and the denominator and result. 36 a. Current Ratio b. Total Asset Turnover 38 c. Net Profit Margin d. Return on Assets e Earnings per Share (EPS) 37 39 40 u + 12 43 44 15 46 47 48 49 SO 51 52 53 54 55 56 Exhibit 13.3 Ratios + Checklist SEAS Ratio Analysis Linked to TB