Question

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

Answer 1

Total Assets:	Amt
Current assets	1,03,005
Net property, plant & equipment	22,50,865
Total long term assets	9,89,180
	33,43,050
Dividends paid:
Dividend paid on common stock
Dividend payout ratio	40%
Dividend paid/Net income = 40%
Dividend paid = 87,474 x 40%
Dividend paid	34990
Dividend paid on preferred stock
Dividend paid	50,000 x 4%
Dividend paid	2000
Total dividend Paid:
Common stock Dividend + Preferred dividend	36990
Statement of owner's equity:
Particulars	Common stock	APIC	Preferred stock	Retained earnings	Total equity
Beginning balance	34,000	4,32,900	50,000	66,666	5,83,566
Net income	-	-	-	87,474	87,474
(-)Dividends paid	-	-	-	-36,990	-36,990
Stock issued	6,000	17,100	-		23,100
Ending balance	40,000	4,50,000	50,000	1,17,150	6,57,150
Total Liabilities & Stock holders equity:
Total Current Liabilities	2,85,900
Total Long term Liabilities	24,00,000
Stock holders equity	6,57,150
	33,43,050
Total Assets	33,43,050
Total Liabilities & Stock holders equity	33,43,050