Part 2: Problem Solving and Analysis (7 points) Indicate the formula sed on the column formula Example: Ratie Formula Current Ratio: Current assets/current liabilities Round off final answers to two decimal places. Include your analysis a liquidity, set management, leverage and profitability ratios en year excel sheet Basic Finance Company Descuber Balance Sheets Thund of all 2019 51.000 5000 70,000 Cash and chivales Shun-tema Account Revale Inice Totalt sich Net tiedot Tot 2020 SE2.000 6000 75.000 . 5213000 . S$11,000 SIRS,000 1.000 Lily Aasia Nasle Total cualisht Lengde Total abilities Commons Retained in Total 572.000 16.100 . SIA 100 ED 526.100 90.000 SOLO suu 560,000 15.000 75.00 S150,000 9. 5245.000 90.000 LUX $190. Total abilities and equity AD H. Basic Finance Company December 31 Income Statement Thousands of Dallas Sales COGS except excluding deptandamist Depreciation and Amaturation Other operating EBIT Interest Expense Tane 295 Net ingen 2020 $700.000 525.000 20000 25.00 $130.000 SO $122.000 30.5.20 591.500 2019 5500,000 375.000 18,000 . $85.000 579,000 19.750 559.250 Comuon dividende Addition to retained camnings $36,600 S54,900 $23.700 535350 Other Data Year-end Stock Price of hes Thousands) Lease payment (Thousands of Doll) Sinking fund payment Thousands of Dollars) 20,30 SI 50.00 7.000 525.000 S8.000 $125.00 5.000 525.000 S8,000 Calculate an extended Du Pont analysis for Basic Finance Company for 2012 od 2020 ROF PM THTrare Erainy Mw 2020 2019 * Prepare a common se slysis. 2020 2010 Commen Sie Balance Sheets Assets Cash and cash equivalents Sherler Accounts Receivable leventories Totalment assets Nel fixed assets Totalt Lisbilities and equity Accounts payable Acerwal Notes payable Total current abilities Long term det Total liabilities Common wock Retained Emings Total common equity Total liabilities and equity . Prepare a common se analysis for the income statement 2010 Common Size Incense Statements Sales COGSceptescluding deprand amort. Depreciation and Amortization Other operating expenses FRIT Interest Expense Tee 255 Net Income