please fill in all the yellow, green, and light green highlighted boxes based on the information provided *with excel formulas please*

N20 x x D B F G H E Income Statement Gross Rey $ Rctums & Allowances $ Investment Income $ Net Rev 580,000.00 1,480,000.00 1,000,000.00 2,030,000.00 (30,000.00) 45,750.00 Ratios ROA ROE P/E M/B Current Quick Inv Turnover FA Tumover Debt ratio X-interest $ $ S 292,000.00 965,000.00 (23,500.00) 1,640,000.00 2,476,000.00 1,314,000.00 (20,500.00) Beg Inventory Purchase Returns & Allowances GAS End Inventory Total CGS S 360,000.00 Gross Profit 1 Balance Sheet 2 Current Assets 3 Cash & Equivalents $ 4 AR $ 5 Inventry $ 6 Total C.A. 7 Non-CA 8 Land $ 9 Blde $ 10 Plant & Equip $ 11 Depreciation S 12 Total Non-CA 13 Miscellaneous 14 Total Assets 15 16 Current List 17 AP $ 18 Notes Payable $ 19 Salaries $ 20 Interest PMT $ 21 Thes $ 22 TotalCL 23 Non-CL 24 More $ 25 Bonds Payable $ 26 Total Non-CL 27 Total Liab 28 29 Equity 30 Miscellaneous 31 Totall Lahkquity 32 Stock Data Stock P $ 132.00 Book P/Share # Outstanding 160,000.00 EPS 540,000.00 448,000.00 200,000.00 148,140,00 Salaries Rent of Utilities Admin Depreciation Total Oper Expenses $ S S S $ 200,000.00 36,000.00 12,000.00 28,500.00 20,500.00 Rational P BP EPS S $ Operating Income EBIT 1.28.5,000.00 2,007,000.00 148,140.00 Interest PMT Taxes Net Profit 8,800,000.00 4.50 87.50 19