Suppose you are interested in evaluating Leeds and Creative companies' financial performance during 2020; both companies...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose you are interested in evaluating Leeds and Creative companies' financial performance during 2020; both companies operate in the technological sector. Given the income statement and the balance sheet of each company, answer the following questions: 1. Compile the Pro forma Income statement for Leeds and Creative companies for the year 2020 using percent of sales method. Use the information provided on the excel sheets. (3 marks) 2. Fill in the missing amounts in Leeds and Creative companies' balance sheets. (3 marks) Given that: Leeds market price per share in 2020 = $8. dividends in 2020 = $22,000. Creative market price per share in 2020 = $10. Financial Ratios Current ratio Quick ratio Inventory turnover Average age of inventory. Average collection period Average payment period Asset turnover Debt ratio Debt to equity ratio Times interest earned ratio Gross profit margin Leeds dividends in 2020 = $34,000. 3. Calculate the financial ratios for both companies in 2020. (3 marks) Note: Purchases were %70 of the cost of goods sold for both companies in 2020. Operating profit margin Net profit margin ROA ROE Leeds company Creative Creative company 4. Analyze the overall financial situation from a cross-sectional viewpoint. Compare each company's ratios with the industry average. What are the strengths and weaknesses of each company? Which company is best to invest in and why? (3 marks) Financial ratio Current ratio Quick ratio Inventory turnover Average age of inventory Average collection period Average payment period Asset turnover Debt ratio Industry Average 2 1.91 8.12 times 42 days 30 days 50 days 0.85 50% Debt to equity ratio 90% Times interest earned ratio 5 Times Gross profit margin 32% 14% 8% 7% 12% Operating profit margin Net profit margin ROA ROE 5. Prepare the cash flow statement for both companies for the year ended December 31st, 2020, using the indirect method. (3 marks) Assets Cash and Cash equivalents Accounts receivable Inventory Prepaid expenses Short term derivative assets Total current assets Property, plant, and equipment Accumulated depreciation Net property, plant, and equipment Goodwill Total Assets Liabilities Leeds company Balance Sheet December 31, 2019 and 2020 Accounts payable Wages payable Current portion of long-term debt Accrued expenses Total Current Liabilities Long-term debt Total Liabilities Owner's Equity Common stock: $2.5 par, shares issued and outstanding in 2019: 60,000; in 2020: 75,000 Paid in capital in excess of par Retained earnings Total Owner's Equity 2019 200,000 50,000 150,000 18,000 30,000 448,000 515,000 5,000 510,000 62,000 1,020,000 22,000 6,000 15,000 7,000 50,000 150,000 200,000 Missing amount 270,000 400,000 Missing amount 2020 230,000 50,500 Missing amount 25,000 40,000 505,500 700,000 5,500 Missing amount 150,000 Missing amount 30,000 6,000 21,000 Missing amount 60,000 90,000 150,000 Missing amount Missing amount Missing amount Missing amount Sales Cost of goods sold Gross Profit Leeds company Income statement December 31, 2019 and 2020 Operating Expense: Selling, general and administrative expenses Research and development expenses Utilities expense Advertisement expenses Depreciation expense Sundry expenses Total operating expenses Operating Income Interest expense Income before Income Taxes Income taxes (25%) Net Income 2019 $1,200,000 $1,500,000 760,000 440,000 120,800 600 20,000 12,000 1,000 35,000 189,400 250,600 18,000 232,600 2020 58,150 $174,450 500 18,000 Assets Cash and Cash equivalents Accounts receivable Inventory Prepaid expenses Marketable securities Total current assets Land Creative company Balance Sheet December 31, 2019 and 2020 Investments & projects Property, machinery and equipment Accumulated depreciation Net Property, machinery and equipment Total Assets Liabilities Accounts payable Notes and loans payable Accrued expenses Total Current Liabilities Long-term debt Total Liabilities Owner's Equity Common stock: $1.75 par, shares issued and outstanding in 2019: 20000; in 2020: 25000 Paid in capital in excess of par Retained earnings Total Owner's Equity 2019 200,000 70,000 50,000 12,000 20,000 352,000 180,000 80,000 400,000 12,000 388,000 1,000,000 70,000 120,000 20,000 210,000 500,000 710,000 Missing amount 85,000 170,000 290,000 2020 Missing amount 90,000 70,000 15,500 38,000 443,500 200,000 70,000 300,000 13,500 286,500 Missing amount 50,000 95,000 15,000 160,000 370,000 530,000 Missing amount Missing amount Missing amount Missing amount Sales Cost of goods sold Gross Profit Creative company Income statement December 31, 2019 and 2020 Operating Expense: Selling, general and administrative expenses Utilities expense Advertisement expenses Depreciation expense Sundry expenses Total operating expenses Operating Income Interest expense Income before Income Taxes Income taxes (25%) Net Income 2019 $800,000 520,000 280,000 80,000 23111.11 22222.22222 500 22222.22 148,056 131,944 25,000 106,944.448 26,736 $80,208 2020 $900,000 2,000 35,000 Suppose you are interested in evaluating Leeds and Creative companies' financial performance during 2020; both companies operate in the technological sector. Given the income statement and the balance sheet of each company, answer the following questions: 1. Compile the Pro forma Income statement for Leeds and Creative companies for the year 2020 using percent of sales method. Use the information provided on the excel sheets. (3 marks) 2. Fill in the missing amounts in Leeds and Creative companies' balance sheets. (3 marks) Given that: Leeds market price per share in 2020 = $8. dividends in 2020 = $22,000. Creative market price per share in 2020 = $10. Financial Ratios Current ratio Quick ratio Inventory turnover Average age of inventory. Average collection period Average payment period Asset turnover Debt ratio Debt to equity ratio Times interest earned ratio Gross profit margin Leeds dividends in 2020 = $34,000. 3. Calculate the financial ratios for both companies in 2020. (3 marks) Note: Purchases were %70 of the cost of goods sold for both companies in 2020. Operating profit margin Net profit margin ROA ROE Leeds company Creative Creative company 4. Analyze the overall financial situation from a cross-sectional viewpoint. Compare each company's ratios with the industry average. What are the strengths and weaknesses of each company? Which company is best to invest in and why? (3 marks) Financial ratio Current ratio Quick ratio Inventory turnover Average age of inventory Average collection period Average payment period Asset turnover Debt ratio Industry Average 2 1.91 8.12 times 42 days 30 days 50 days 0.85 50% Debt to equity ratio 90% Times interest earned ratio 5 Times Gross profit margin 32% 14% 8% 7% 12% Operating profit margin Net profit margin ROA ROE 5. Prepare the cash flow statement for both companies for the year ended December 31st, 2020, using the indirect method. (3 marks) Assets Cash and Cash equivalents Accounts receivable Inventory Prepaid expenses Short term derivative assets Total current assets Property, plant, and equipment Accumulated depreciation Net property, plant, and equipment Goodwill Total Assets Liabilities Leeds company Balance Sheet December 31, 2019 and 2020 Accounts payable Wages payable Current portion of long-term debt Accrued expenses Total Current Liabilities Long-term debt Total Liabilities Owner's Equity Common stock: $2.5 par, shares issued and outstanding in 2019: 60,000; in 2020: 75,000 Paid in capital in excess of par Retained earnings Total Owner's Equity 2019 200,000 50,000 150,000 18,000 30,000 448,000 515,000 5,000 510,000 62,000 1,020,000 22,000 6,000 15,000 7,000 50,000 150,000 200,000 Missing amount 270,000 400,000 Missing amount 2020 230,000 50,500 Missing amount 25,000 40,000 505,500 700,000 5,500 Missing amount 150,000 Missing amount 30,000 6,000 21,000 Missing amount 60,000 90,000 150,000 Missing amount Missing amount Missing amount Missing amount Sales Cost of goods sold Gross Profit Leeds company Income statement December 31, 2019 and 2020 Operating Expense: Selling, general and administrative expenses Research and development expenses Utilities expense Advertisement expenses Depreciation expense Sundry expenses Total operating expenses Operating Income Interest expense Income before Income Taxes Income taxes (25%) Net Income 2019 $1,200,000 $1,500,000 760,000 440,000 120,800 600 20,000 12,000 1,000 35,000 189,400 250,600 18,000 232,600 2020 58,150 $174,450 500 18,000 Assets Cash and Cash equivalents Accounts receivable Inventory Prepaid expenses Marketable securities Total current assets Land Creative company Balance Sheet December 31, 2019 and 2020 Investments & projects Property, machinery and equipment Accumulated depreciation Net Property, machinery and equipment Total Assets Liabilities Accounts payable Notes and loans payable Accrued expenses Total Current Liabilities Long-term debt Total Liabilities Owner's Equity Common stock: $1.75 par, shares issued and outstanding in 2019: 20000; in 2020: 25000 Paid in capital in excess of par Retained earnings Total Owner's Equity 2019 200,000 70,000 50,000 12,000 20,000 352,000 180,000 80,000 400,000 12,000 388,000 1,000,000 70,000 120,000 20,000 210,000 500,000 710,000 Missing amount 85,000 170,000 290,000 2020 Missing amount 90,000 70,000 15,500 38,000 443,500 200,000 70,000 300,000 13,500 286,500 Missing amount 50,000 95,000 15,000 160,000 370,000 530,000 Missing amount Missing amount Missing amount Missing amount Sales Cost of goods sold Gross Profit Creative company Income statement December 31, 2019 and 2020 Operating Expense: Selling, general and administrative expenses Utilities expense Advertisement expenses Depreciation expense Sundry expenses Total operating expenses Operating Income Interest expense Income before Income Taxes Income taxes (25%) Net Income 2019 $800,000 520,000 280,000 80,000 23111.11 22222.22222 500 22222.22 148,056 131,944 25,000 106,944.448 26,736 $80,208 2020 $900,000 2,000 35,000
Expert Answer:
Related Book For
Intermediate Accounting
ISBN: 978-0132162302
1st edition
Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella
Posted Date:
Students also viewed these finance questions
-
A vertical analysis is best used to make comparisons between multiple companies. true False In vertical analysis of the income statement, we usually express each income statement item as a percentage...
-
A firm has initial fund of $800. The market rate of return is 12%. The firm has identified good investment opportunities to invest $640 at an average 25 per cent rate of return. How much dividend...
-
In 2017, Sunrise City signed a contract in the amount of $8,000,000 for the construction of a new city hall. Expenditures were $4,000,000 in 2017 and $2,050,000 in 2018, which included a change to...
-
Refer to the eight weeks of actual data included in the Excel template. a . Use least - squares regression to estimate the fixed electrical cost per week and the variable electrical cost per machine...
-
Balancing a fan on a motor-driven machine has not dropped the overall vibration sufficiently. What is the next step?
-
Bob places $1,000 a year in his IRA for ten years and then invests $2,000 a year for the next ten years. Mary places $2,000 a year in her IRA for ten years and then invests $1,000 a year for the next...
-
Dexter Technology maintains its records using cash-basis accounting. Consider the following: . During the year, the company received cash from customers, $35,000, and paid cash for salaries, $21,000....
-
Where do you stand on the prescription drug pricing standards in place in the United States today? Are we overpaying for prescription drugs? Or are the pricing practices of the pharmaceutical...
-
Discuss the possible explanations for the growth in the numbers of women-owned enterprises varying so much in different countries.
-
Let the three-phase lossless transmission line of Problem 5.31 supply a load of 1000 MVA at 0.8 power factor lagging and at \(500 \mathrm{kV}\). (a) Determine the capacitance/phase and total...
-
Identical series capacitors are installed at both ends of the line in Problem 5.14, providing \(40 \%\) total series compensation. Determine the equivalent \(A B C D\) parameters of this compensated...
-
What is the minimum amount of series capacitive compensation \(N_{\mathrm{C}}\) in percent of the positive-sequence line reactance needed to reduce the number of \(765-\mathrm{kV}\) lines in Example...
-
The maximum power flow for a lossy line is somewhat less than that for a lossless line. (a) True (b) False
-
Consider the following information for the Cornwall Company: Sales price per unit $130 Variable cost per unit 80 Total fixed costs 840,000 How many units must Cornwall sell to break even? a). 8,400...
-
In the synthesis of the keto acid just given, the dicarboxylic acid decarboxylates in a specific way; it gives Explain. HO rather than HO
-
Genius LLP must withdraw $ 50,000 at the beginning of each semiannual period for the next eight years to satisfy its employee pension obligation. Assuming 10% interest with semiannual compounding,...
-
Using the information provided in BE22-15, prepare the investing activities section of Simons cash flow statement. In BE22-15 Simons Products, Inc. reported the following comparative balance sheets...
-
On October 16, Sueco Retailers bought 80 parkas on account at $ 75 each. Terms of the purchase were 2/ 10, n/ 30. It paid for 60 parkas on October 25 and paid for the remaining 20 parkas on November...
-
Natasha Kingery is 30 years old and has a Bachelor of Science degree in computer science. She is currently employed as a Tier 2 field service representative for a telephony corporation located in...
-
This is your second interview with a prestigious brokerage firm for a job as an equity analyst. You survived the morning interviews with the department manager and the vice president of equity....
-
On 1 January 2023, Blue Jay Ltd revalued land from \(\$ 300000\) to \(\$ 500000\). On 1 January 2024, the company subsequently revalued the land to \(\$ 420000\). And on 1 January 2025 , the company...
Study smarter with the SolutionInn App