Your friend, Abu, has come to you for some assistance in evaluating a company he is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your friend, Abu, has come to you for some assistance in evaluating a company he is considering investing in. Abu has provided you with the income statement, balance sheet and statement of cash flows for the year ended December 31, 2021 as well as some industry standards for select ratios. Abu knows you have taken a financial accounting course & is hoping you can help him decide whether or not he should invest in the company. Required: 1. Calculate 12 ratios to help you analyze the company. 2. Review the Statement of Cash Flows for Genie's Carpets and describe 3 strengths or weaknesses. 3. Based on your answers from Part 1 and 2 would you recommend Abu invests in the company. You must discuss at least 4 ratios in providing your answer. Gross profit margin ratio Net profit margin ratio Rate of return on assets Earnings per Share Current ratio Dividend Yield SHOW YOUR WORK Industry averages-2021 $ 55.00% 7.00% 3% 10.00 1.60 0.11:1 4 GENIE'S CARPETS LIMITED INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2021 Sales Cost of goods sold Selling expenses Administrative expenses Rent expense Depreciation Income from operations Interest expense Income before tax Income tax expense Net income $ 2021 1,385,400 595,722 789,678 659,900 313,500 251,800 319,800 228,600 19,200 7,400 129,778 5,250 124,528 18,680 2020 $ 105,848 $ $1,115,250 501,860 613,390 18,600 5,400 504,400 108,990 1,050 107,940 10,520 97,420 Cash Accounts receivable Inventory Building Accumulated depreciation Land Accounts payable Income taxes payable Wages payable Note payable Shareholder's Equity Common shares Retained Earnings GENIE'S CARPETS LIMITED BALANCE SHEET DECEMBER 31, 2021 ASSETS 2021 $177,798 118,750 101,800 398,348 55,000 15,500 75,000 114,500 LIABILITIES AND SHAREHOLDER'S EQUITY $195,700 18,680 6,050 220,430 105,000 325,430 $512,848 $325,390 10,000 177,418 187,418 2020 $512,848 $122,190 81,500 99,800 303,490 30,000 8,100 21,900 $182,500 10,520 4,800 197,820 21,000 218,820 10,000 96,570 106,570 $325,390 4 Cash flow from operating activities Net income Add depreciation Adjustment to reconcile net income to net cash provided by operating activities Net increase in current assets other than cash, Net increase in current liabilities GENIE'S CARPETS LIMITED STATEMENT OF CASH FLOWS YEAR ENDING DECEMBER 31, 2021 Cash flow from Financing activities Payment of dividends New loan proceeds Repayment of loans Cash flow from investing activities Purchase of land and building Net cash inflow Beginning cash Ending cash Additional information: 5 Selected data from the December 31, 2019 financial statements: Accounts receivable Inventory Accounts payable Total assets Shareholder equity Market price per share December 31, 2021 Market price per share December 31, 2020 Number of shares outstanding No preferred shares 5 5 $ $ 5 $ $ $ 2021 105,848 $ 7,400 39,250- 22,610 96,608 25,000- 89,000 5,000- 59,000 - 100,000 55,608 122,190 77,600 89,760 157,800 219.130 19,150 2020 20.00 15.00 10,000 97,420 5,400 13,940 32,840 121,720 20,000 4,000 24,000 177.798 5 122,190 97,720 24,470 Your friend, Abu, has come to you for some assistance in evaluating a company he is considering investing in. Abu has provided you with the income statement, balance sheet and statement of cash flows for the year ended December 31, 2021 as well as some industry standards for select ratios. Abu knows you have taken a financial accounting course & is hoping you can help him decide whether or not he should invest in the company. Required: 1. Calculate 12 ratios to help you analyze the company. 2. Review the Statement of Cash Flows for Genie's Carpets and describe 3 strengths or weaknesses. 3. Based on your answers from Part 1 and 2 would you recommend Abu invests in the company. You must discuss at least 4 ratios in providing your answer. Gross profit margin ratio Net profit margin ratio Rate of return on assets Earnings per Share Current ratio Dividend Yield SHOW YOUR WORK Industry averages-2021 $ 55.00% 7.00% 3% 10.00 1.60 0.11:1 4 GENIE'S CARPETS LIMITED INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2021 Sales Cost of goods sold Selling expenses Administrative expenses Rent expense Depreciation Income from operations Interest expense Income before tax Income tax expense Net income $ 2021 1,385,400 595,722 789,678 659,900 313,500 251,800 319,800 228,600 19,200 7,400 129,778 5,250 124,528 18,680 2020 $ 105,848 $ $1,115,250 501,860 613,390 18,600 5,400 504,400 108,990 1,050 107,940 10,520 97,420 Cash Accounts receivable Inventory Building Accumulated depreciation Land Accounts payable Income taxes payable Wages payable Note payable Shareholder's Equity Common shares Retained Earnings GENIE'S CARPETS LIMITED BALANCE SHEET DECEMBER 31, 2021 ASSETS 2021 $177,798 118,750 101,800 398,348 55,000 15,500 75,000 114,500 LIABILITIES AND SHAREHOLDER'S EQUITY $195,700 18,680 6,050 220,430 105,000 325,430 $512,848 $325,390 10,000 177,418 187,418 2020 $512,848 $122,190 81,500 99,800 303,490 30,000 8,100 21,900 $182,500 10,520 4,800 197,820 21,000 218,820 10,000 96,570 106,570 $325,390 4 Cash flow from operating activities Net income Add depreciation Adjustment to reconcile net income to net cash provided by operating activities Net increase in current assets other than cash, Net increase in current liabilities GENIE'S CARPETS LIMITED STATEMENT OF CASH FLOWS YEAR ENDING DECEMBER 31, 2021 Cash flow from Financing activities Payment of dividends New loan proceeds Repayment of loans Cash flow from investing activities Purchase of land and building Net cash inflow Beginning cash Ending cash Additional information: 5 Selected data from the December 31, 2019 financial statements: Accounts receivable Inventory Accounts payable Total assets Shareholder equity Market price per share December 31, 2021 Market price per share December 31, 2020 Number of shares outstanding No preferred shares 5 5 $ $ 5 $ $ $ 2021 105,848 $ 7,400 39,250- 22,610 96,608 25,000- 89,000 5,000- 59,000 - 100,000 55,608 122,190 77,600 89,760 157,800 219.130 19,150 2020 20.00 15.00 10,000 97,420 5,400 13,940 32,840 121,720 20,000 4,000 24,000 177.798 5 122,190 97,720 24,470
Expert Answer:
Answer rating: 100% (QA)
Answer PART 1 SNO RATIO FORMULA INDUSRTY STANDARD PATICULARS 2021 PATICULARS 2020 REMARKS 1 CURRENT RATIO CURRENTS ASSETSCURRENT LIABILITIES 16 398348220430 18 303490197820 153 CURRENT RATIO IS RATIO ... View the full answer
Related Book For
Introduction To Federal Income Taxation In Canada
ISBN: 9781554965021
33rd Edition
Authors: Robert E. Beam, Stanley N. Laiken, James J. Barnett
Posted Date:
Students also viewed these accounting questions
-
The statement of cash flows for the year ended December 31, 2013, for Bronco Metals is presented below. Required: Prepare the statement of cash flows assuming that Bronco prepares its financial...
-
Your client, Ashley, has come to you for some advice on computing her net income from property. (a) In February, Ashley sold all her investments and paid off her personal residence mortgage. On March...
-
The statement of cash flows for the year ended December 31, 2014, and other data for Bradley Corporation are shown below: Additional data: a. Bradleys Dividends receivable account decreased by $2,000...
-
Q5] A firm has reported a profit of Rs.1,47,000 for the year ended 31-3-2014 after taking into consideration the following items. (i) The cost of an asset Rs.23,000 has been taken as an expense (ii)...
-
Determine the effective annual interest rate on a $25,000 line of credit with an annual percentage rate of 8.75% compounded monthly. The bank requires that a 1.5% commitment fee be paid on the unused...
-
Why is there a significant difference in the pay of physicians and construction workers? Discuss.
-
Pluto Corporation issued \(\$ 400,000\) of \(7 \%, 20\) year bonds payable on March 31, 2006. The bonds were issued at 100 and pay interest on March 31 and September 30. Record (a) issuance of the...
-
Following is information about Fine Furnitures direct labor hours and wages last period. Actual labor hours at the standard price per hour .... $1,680 Actual labor hours at the actual price per hour...
-
If a company's sales are growing at a rate of 11% per year, how long will it take for sales to triple?
-
Table 1 shows Apple's online orders for the last week. When shoppers place an online order, several "recommended products" (upsells) are shown as at checkout an attempt to upsell See table 2 in cell...
-
Complete the carbon cycle diagram by matching each process with the corresponding arrow. Atmospheric CO OF carbon fossilization decay of organic matter organic matter sediments deforestation...
-
One of the ways that corporations might better take into account their responsibility for being good environmental citizens is to redefine the notion of profit to: Profit = Revenue Cost of Goods...
-
When a manager listens to users, makes adaptations, and continuously tweaks and changes a new information system as it is being implemented, the approach to technological change can be described as...
-
Values are personal beliefs that help determine whether a behaviour is considered ethical or unethical. An example of a terminal value is ____________. (a) ambition (b) self-respect (c) courage (d)...
-
____________ is one of the personality characteristics commonly found among entrepreneurs. (a) External locus of control (b) Inflexibility (c) Self-confidence (d) Low self-reliance
-
When members of a dominant subculture, such as white males, make it hard for members of minority subcultures, such as women, to advance to higher-level positions in the organization, this is called...
-
1.Liquidity is the term that has which of these meanings? a. A measure of the ease with which one asset can be converted into another asset, usually money b. A measure of the ease with which one can...
-
Suppose the government bond described in problem 1 above is held for five years and then the savings institution acquiring the bond decides to sell it at a price of $940. Can you figure out the...
-
Chow Installation and Repair Ltd. ("Chow") is in the business of installing and repairing overhead doors. Chow maintained a list of qualified installers and repair-persons and would contact them as...
-
For each of the following corporations, determine and explain the type of residency, for tax purposes for 2012. (a) ABI, incorporated in Montreal, Quebec, in 1980, carries on a clothing manufacturing...
-
Ms. Sui is an executive of a large public retail corporation, Clothes to You Ltd., situated in Dundas, Ontario. Ms. Sui is not married. However, she has two adopted children, ages 8 and 10, who...
-
The ages of residents of Banks City, Oregon, are given in the following frequency distribution. a. Approximate the mean age. b. Assume all three people aged 9099 were in fact 90 years old. Would this...
-
The following frequency distribution presents the amounts, in dollars, spent for Valentines Day gifts in a survey of 123 U.S. adults. a. Approximate the mean amount spent on Valentines Day gifts. b....
-
The following frequency distribution presents the number of U.S. adults (in thousands) ages 25 to 74 who have earned a Bachelors degree in a recent year. a. Approximate the mean age. b. If the...
Study smarter with the SolutionInn App