what are the formulas for areas in red

F Home Draw Page Layout Formulas Data Review View Developer H Get Adding pes My Adding Adding > Ed 12 Given Information for Balance Sheet come Statement 2019 Net Revenues Cost of Goods Sold Gross Profit 958 100 498 212 459 888 2019 26.900 L12 800 95500 450.000 1.750,000 450,000 200.000 510 40.000 785,502 270.560 95.500 SG&A Expenses Depreciation Research and Development Other operating expenses Operating Income Account Accounts Payable Accounts Receivable Accrued Salaries Additional Paid in Capital Bank Loans (Mortgages) Bonds Payable Capital Leases Cash Common Stock Equipment Furniture and Fixtures Intangible Asset Copyrights) Inventories Land & Buildings. Les Accumulated Depreciation Long term investments Other Accrued expenses Other Current Assets Other Long term Assets Preferred stock 4% Retained Earnings Short term debt 185.000 65 000 42.000 23 600 144 288 Misc. other losses Misc other income EBIT 1.250 1000 144038 Interest Expense Taxable income 28 940 115098 1,849,30 (054 500) 820.680 112.500 8010 72.000 50 000 Income Tax Expense Net Income 27 624 87474 50 000 Eamings Per Share Operating Cash Flow 1 23 181.414 Prior Year-end Retained Earnings Prior Year-end Common Stock Prior Year-end APIC Prior Year end Preferred Stock 34.000 432 900 Inventory details yen information for Income Statement Raw Materials Work in Process Finished Goods Total Inventories 15.200 23 585 42 900 81.685 Gross Revenues Returns and Allowances Ss Discounts COGS Ratio Depreciation 985.000 5.250 21650 5206 65.000 Short-term 50.000 orating Cashow 101.414 Prior Year end Roland Earnings Prior Year-end Common Stock Prior Year end APIC Prior Year end Preterred Stock BOB 2000 1490 Current Liabilit Accounts Payab Accrued Salane Other Accrueda Shorm debt Total Current L Inventory detais 15.200 Raw Materials Work in Process Finished Goods Total Inventories Given Information for income Statement 42 Ko Long-Term Lia Bank Loans (M Bonds Payable Capital Leases Total Long-Ter Total Liabilitie Gross Revenues Returns and A Sales Discounts COGS Rato Depreciation nt 985.000 5.250 21.650 5209 65.000 185.000 42.000 23,600 1000 1.250 Research and Development Expenses Other operating eens Mis other income Misc. other losses Tax rate COMMY Shares Outstandin Payout Ratio Stockholder's Common Stock Additional Paid referred Stock Retained Earnir Total Stockhol Total Liabilitie 71000 Use this that 400 OOO Mondage on Buildings terest Rate on MORE Bonds Payable Interest Rate on Band 100 000 4596 Average Short term debt interest Rate on ST Debt 20 000 2.25 5 Calculate interest Expense 28 940 : + Dividends on Preferred Stock (round $ Dividends on Common Stock (round 5 Total Ovidends pad 2.000 based on dividend percentage given 4% 3 7474 calculate aner income Statement is complete fround to nearest 39.474 Refer to this calculation when acting Retained Famings Capar r en emancing arrangements on equipment or vehicles Preferred stock form of quitanding that days a regular divided as a far value which is given) Start a search het in Statement of Owner's Equity - 2019 F G Balance Sheet- 12/31/2010 2019 APIC Common Stock 34 DDO Preferred Stock 50.000 958 100 498 212 459 BBS Retained Earnings 66 666 87.474 94 FALL 510 Assets Current Assets Cash Accounts Receivable Inventories Other Current Assets Total Current Assets Total Equity 50.668 87.474 1947 21000 203 514 FALSE Beginning Balance Net Income Didends said Stock Issid Ending Eilance 81,685 2010 103005 185.000 65.000 600D 40,000 50,000 193,514 FALSE 144,28 Deposited e n in de conto balance Men Blace Exide Statement of Owners Ewy Property. Plant, and Equipment Land & Buldings Equipment Furniture and Fixtures Less Accumulatex Depreciation Net Property, Plant, and Equipment 149.303 785,502 270.00 1054,500) 2,250,865 1.000 144,038 28.940 115 098 96.500 72 000 Long-term investments Intangible Assel (Caprights) Other long term Assets Total Long-Term Assets Total Assets 27624 87,474 1.23 Liabities and StockildersEquity Current Liabilities Accounts Payable Accrued Salaries Other Accred expenses Shortcm debt Total Current Liabilities 112.500 285.900 15.2001 23 585 42,900 81.685 Long-Term Liabilities Bank Loans Mortgages Bonds Payable Getalles Total Long-Term Liabilities Total Liabilities 193000 450.000 200,000 2,400,000 Stockholder's Equity Common Stock Adutional Paid in Capital EMAT Se t on this exp 1.250 1.000 14,038 Equipment T Furniture and Fixtures Less Accumulated Depreciation Net Property. Plant, and Equipment 785.502 270 560 (654 500) 2.250.865 28 940 15098 Long-term investments Intangible Asset (Copyrights) Other Long-term Assets Total Long-Term Assets Total Assets 820 680 96.500 72 000 .989.180 27,624 37.474 123 31.414 Liabilities and Stockholders Equity Current Liabilities Accounts Payable Accrued Salanes Other Accrued expenses Short-term debt Total Current Liabilities || 26.900 95,500 112.500 ||50,000 285,900 15.200 23,585 2.900 31685 1750000 Long-Term Liabilities Bank Loans (Mortgages) Bonds Payable capital Leases Total Long Term Liabilities Total Liabilities 450 000 200 000 2,400,000 2,685,900 40.000 450 000 Stockholder's Equity Common Stock Additional Pald-in Capital Preferred Stock 4% Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 154 666 126 Use this that calculation to test balance