Question

1.    Calculate the vertical analysis of the following data.

Income Statement

	2018	2019
Sales	$ 800,000	$950,000
Cost of Goods Sold	350,000	600,000
Gross Margin	450,000	350,000
Operating Expenses	250,000	280,000
Net Income	$200,000	$ 70,000

2. From the following Balance sheet of A Co. Ltd., you are required to prepare a Schedule of Changes in Working Capital

Liabilities	2011	2012	Assets	2011	2012
Share Capital	200000	210000	Cash at bank	105000	106000
Profit & loss A/c	20000	23000	Debtors	18000	28000
Creditors	5000	8000	Stock	20000	25000
Long term	-	10000	Plant & Machinery	35000	45000
Short Term Loan	15000	14000	Furniture	60000	60000
			Bills receivable	2000	1000
	240000	265000		240000	265000

3. The following is the Balance Sheet of a company as on 31st March:

Liabilities	Amount	Assets	Amount
Share Capital	800000	Machine	800000
Profit & loss	150000	Stock	4500000
General Reserve	50000	Debtors	200000
15% Debentures	700000	Cash in hand	300000
Creditors	200000	Land	200000
Total	1950,000		1950,000

Calculate

1. Current Assets Ratio
2. Quick Ratio
3. Inventory to Working capital
4. Debt to Equity Ratio

4. Ali, Rehman and Zara are partners sharing profits and losses in the ratio of 7:4:2. They admit Mariam into partnership and give him 1/6th share of profits. Find the new profit-sharing ratio

Note: Answers kindly in word or excel format for the 4 Questions

Answer 1

I		Comparative Income Statement with vertical analysis
			2,018	%	2,019	%
			Amount		Amount
		Sales	8,00,000	100%	9,50,000	100%
		Cost of Goods Sold	3,50,000	44%	6,00,000	63%
		Gross Margin	4,50,000	56%	3,50,000	37%
		Operating Expenses	2,50,000	31%	2,80,000	29%
		Net Income	2,00,000	25%	70,000	7%
II		Changes in Working Capital
			2,011		2,012
		Current Asset
		Cash at bank	1,05,000		1,06,000
		Debtors	18,000		28,000
		stock	20,000		25,000
		Bills Receivable	2,000		1,000
			1,45,000		1,60,000
		Current Liability
		Creditors	5,000		8,000
		Short term loan	15,000		14,000
			20,000		22,000
		Working Capital	1,25,000		1,38,000
		(Current Asset-Current Liability)
		Changes in Working Capital	13,000
		(Increase of working capital of 13000)
III
			31-Mar
		Current Asset
		Cash In Hand	3,00,000
		Debtors	2,00,000
		stock	45,00,000
			50,00,000
		Current Liability
		Creditors	2,00,000
			2,00,000
	1	Current Asset Ratio	25
		(Current Asset/Current Liability)
	2	Quick Asset Ratio	2.50
		(Current Asset-Inventory/Current Liability)
	3	Inventory to Working Capital	94%	(4500000/4800000) X 100 ekkarill92 Next > < Previous Related Solutions Income Statement 2019 Common Size Income Statement Details 2019 2018 Sales 30,000,000 Sales/Sales 100.00% 100.00% Less:... Income Statement 2019 Common Size Income Statement Details 2019 2018 Sales 30,000,000 Sales/Sales 100.00% 100.00% Less: Cost of Goods Sold 21,000,000 Cost of Goods Sold/Sales 70.00% 65.90% Gross Profits 9,000,000 Gross Profits/Sales 30.00% 34.10% Less: Operating Expenses Less: Operating Expenses Selling Expense 3,000,000 Selling Expense/Sales 10.00% 12.70% General and Administrative Expenses 1,800,000 General and Administrative Expenses/Sales 6.00% 6.30% Lease Expense 200,000 Lease Expenses/Sales 0.67% 0.60% Depreciation Expense 1,000,000 Depreciation Expense/Sales 3.33% 3.60% Total Operating Expense 6,000,000 Total Operating Expense/Sales 20.00%... Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the... Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $92,316 $104,544 Event-related revenue 135,648 131,648 NASCAR broadcasting revenue 179,922 170,368 Other operating revenue 63,114 77,440 Total revenue $471,000 $484,000 Expenses and other: Direct expense of... Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the... Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Calvin Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $94,400 $107,580 Event-related revenue 138,768 147,189 NASCAR broadcasting revenue 169,448 160,881 Other operating revenue 69,384 73,350 Total revenue $472,000 $489,000 Expenses and other: Direct expense of... Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the... Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Motor Speedways Inc., owner and operator of several major motor speedways. Current Year Previous Year Revenues: Admissions $89,870 $102,690 Event-related revenue 145,684 147,189 NASCAR broadcasting revenue 170,753 161,859 Other operating revenue 66,693 77,262 Total revenues $473,000 $489,000 Expenses and other: Direct expense of events $97,911 $97,800 NASCAR purse and sanction fees 116,358 117,849... Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for two... Vertical Analysis of Income Statement The following comparative income statement (in thousands of dollars) for two recent fiscal years was adapted from the annual report of Speedway Motorsports, Inc. (TRK), owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways. Current Year Previous Year Revenues: Admissions $90,639 $100,694 Event-related revenue 136,900 146,980 NASCAR broadcasting revenue 224,227 217,469 Other operating revenue 60,390 31,320 Total revenues $512,156 $496,463 Expenses and other: Direct expense of... Using the income statement, calculate the vertical and horizontal analysis and insert your answers in the... Using the income statement, calculate the vertical and horizontal analysis and insert your answers in the appropriate spaces provided VERTICAL ANALYSIS HORIZONTAL ANALYSIS Statement of Operations Income Statement 2017 Percent 2018 percent CHANGE PERCENT Sales (net) 8,100,000 10,000,000 Cost of goods sold 5,300,000 6,000,000 Gross Margin 2,800,000 4,000,000 General Expense (1,050,000.00) (1,080,000) Depreciation Expense (300,000.00) (300,000) Operating Income 1,450,000.00 2,620,000 Interest Expense (40,000.00) (50,000) Income Taxes (35%) (507,500.00) (917,000.00) Net Income 902,500.00 1,653,000 Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. Vertical Analysis of Income StatementRevenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current year AmountPrevious year AmountSales$450,000 $387,000 Cost of goods sold$270,000 $212,850 Selling expenses$72,000 $69,660 Administrative expenses$76,500 $61,920 Income tax expense$13,500 $15,480 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers.b. The vertical analysis indicates that the cost... Prepare a vertical analysis of the 2020 income statement data for Duke Company and Lord Company. Here are comparative statement data for Duke Company and Lord Company, two competitors. All balance sheet data are as of December 31, 2020, and December 31, 2019.Duke CompanyLord Company2020201920202019Net sales$1,878,000$559,000Cost of goods sold1,100,508296,829Operating expenses261,04279,937Interest expense9,3904,472Income tax expense54,4626,149Current assets329,000$312,10083,200$78,300Plant assets (net)519,900501,200139,800124,200Current liabilities65,40074,80034,20029,600Long-term liabilities108,80090,40030,20026,000Common stock, $10 par499,500499,500120,500120,500Retained earnings175,200148,60038,10026,400(a)Prepare a vertical analysis of the 2020 income statement data for Duke Company and Lord Company. (Round percentages to 1 decimal place, e.g. 12.1%.)Condensed Income Statementchoose the accounting period                    ... Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent... Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $450,000 $387,000 Cost of goods sold 270,000 212,850 Selling expenses 72,000 69,660 Administrative expenses 76,500 61,920 Income tax expense 13,500 15,480 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation... Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent... Vertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:        Current Year        Previous Year Sales $392,000 $353,000 Cost of goods sold 231,280 180,030 Selling expenses 62,720 70,600 Administrative expenses 70,560 60,010 Income tax expense 11,760 17,650 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions The Earth’s magnetic field undergoes periodic reversals. How was this discovered, and by whom? What is... Note: Present results using fprintf()and comment your code throughout. Write a function that will compute the... ** * Write a recursive function that removes the first k even numbers * from the... With the Cascada project closing out the design phase and ramping up the construction and implementation... According to Erik Erikson, the central psychosocial issue in young adulthood is intimacy vs. isolation. What... GLOBAL MACROTRENDS AND THEIR IMPACT ON SUPPLY CHAIN MANAGEMENT How does shaping demand differ from anticipating... Complete class Cow so that it has: (a) an int attribute to hold a number of... ADVERTISEMENT About @ 2020 WizEdu