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 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 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... 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 $518,000 $471,000 Cost of goods sold 290,080 240,210 Selling expenses 93,240 94,200 Administrative expenses 98,420 80,070 Income tax expense 15,540 23,550 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 $511,000 $439,000 Cost of goods sold 281,050 219,500 Selling expenses 91,980 87,800 Administrative expenses 97,090 79,020 Income tax expense 15,330 21,950 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 $620,000 $539,000 Cost of goods sold 353,400 274,890 Selling expenses 105,400 107,800 Administrative expenses 117,800 91,630 Income tax expense 18,600 26,950 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 Follow up question to the recommendations made to Jerry , how do I get to $44.96?... Communication as a Reminder of Non-Separateness The first Asiacentric proposition is that communication is a process... Contribute Wiki on the topic: Role of information technology to communicate effectively in modern business. Last month Empire Company had a $40,850 profit on sales of $301,000. Fixed costs are $88,580... "The Myth of Sisyphus" Please respond to the following: Explain what Camus means by stating that... Write a program in C++ to find the number of comparisons using binarySearch and the sequential... Case Study Read the case then answer the three questions below: Frank became chief financial officer... ADVERTISEMENT About @ 2020 WizEdu