a. Calculate cash flows from assets, cash flows to creditors, and cash flows to shareholders for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a. Calculate cash flows from assets, cash flows to creditors, and cash flows to shareholders for 2019. b. Create a statement of cash flow (accounting statement) for 2019. c. Calculate cash cycle. d. Conduct a thorough financial ratio analysis. e. Use the percent-of-sales formula to calculate the amount of external financing needed for year 2020. (Assumptions: Sales are expected to grow by 8 percent in year 2020, the net profit margin is expected to be 12 percent, and the dividend payout ratio is 35 percent. The fixed assets are currently being used at full capacity.) Net sales: Products Services Total net sales Cost of sales: Products Services Total cost of sales Gross margin Operating expenses: Research and development Selling, general and administrative Total operating expenses Operating income Other Incomel(expense), net Income before provision for income taxes Provision for Income taxes Net income Earnings per share: Basic Diluted Shares used in computing eamings per share: Basic Diluted $ September 28, 2019 213,883 $ 46,291 260,174 144,996 16,786 161,782 98,392 16,217 18,245 34,462 63,930 1,807 65,737 10,481 55,256 $ 11.97 $ 11.89 $ 4,617,834 4,648,913 Years ended September 29, 2018 225,847 39,748 265,595 148,164 15,592 163,756 101,839 14,236 16,705 30,941 70,898 2,005 72,903 13,372 59,531 $ $ 12.01 11.91 $ 4,955,377 5,000,100 $ September 30, 2017 196,534 32,700 229,234 126,337 14,711 141,048 88,186 11,581 15,261 26,842 61,344 2,745 64,089 15,738 48,351 9.27 9.21 5,217,242 5,251,602 rent assets; Cash and cash equivalents Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets Jon-current assets: Marketable securities Property, plant and equipment, net Other non-current assets Total non-current assets Total assets Current liabilities: Accounts payable Other current liabilities Deferred revenue Commercial paper Term debt Total current liabilities Non-current liabides: Term debt Other non-current labilities 3 Total non-current abilities Total liabilities 40 F S 4 R % I 16 5 LIABILITIES AND SHAREHOLDERS' EQUITY: || T 17 ^ ASSETS: 6 99+ ASUS 18 Y 03/0 7 2015 home 19h * U 8 S $ September 28, 2019 Fod 48,844 S 51,713 22,926 4,106 22,878 12.352 162,819 105,341 37,378 32,978 175,897 338,516 46,236 $ 37,720 5,522 5,980 10,250 105,718 1 91,507 50,503 142,310 248,028 9 September 29, 2015 ESP 25,913 40,388 23,186 3.956 25,809 12,087 131,339 170,799 41,304 22,283 234,386 365,725 55,808 33.327 5,966 11,964 8,784 93.735 48,914 142.649 Shareholders' equity: Common stock and additional paid-in capital, $0.00001 par value: 12,600,000 shares authorized; 4,443,236 and 4,754,986 shares issued and outstanding, respectively Retained earings Accumulated other comprehensive Income (loss) Total shareholders' equity Total abilities and shareholders' equity $ 45,174 45,898 (584) 90,488 338,516 S 40,201 70,400 (3,454) 107,147 365,725 a. Calculate cash flows from assets, cash flows to creditors, and cash flows to shareholders for 2019. b. Create a statement of cash flow (accounting statement) for 2019. c. Calculate cash cycle. d. Conduct a thorough financial ratio analysis. e. Use the percent-of-sales formula to calculate the amount of external financing needed for year 2020. (Assumptions: Sales are expected to grow by 8 percent in year 2020, the net profit margin is expected to be 12 percent, and the dividend payout ratio is 35 percent. The fixed assets are currently being used at full capacity.) Net sales: Products Services Total net sales Cost of sales: Products Services Total cost of sales Gross margin Operating expenses: Research and development Selling, general and administrative Total operating expenses Operating income Other Incomel(expense), net Income before provision for income taxes Provision for Income taxes Net income Earnings per share: Basic Diluted Shares used in computing eamings per share: Basic Diluted $ September 28, 2019 213,883 $ 46,291 260,174 144,996 16,786 161,782 98,392 16,217 18,245 34,462 63,930 1,807 65,737 10,481 55,256 $ 11.97 $ 11.89 $ 4,617,834 4,648,913 Years ended September 29, 2018 225,847 39,748 265,595 148,164 15,592 163,756 101,839 14,236 16,705 30,941 70,898 2,005 72,903 13,372 59,531 $ $ 12.01 11.91 $ 4,955,377 5,000,100 $ September 30, 2017 196,534 32,700 229,234 126,337 14,711 141,048 88,186 11,581 15,261 26,842 61,344 2,745 64,089 15,738 48,351 9.27 9.21 5,217,242 5,251,602 rent assets; Cash and cash equivalents Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets Jon-current assets: Marketable securities Property, plant and equipment, net Other non-current assets Total non-current assets Total assets Current liabilities: Accounts payable Other current liabilities Deferred revenue Commercial paper Term debt Total current liabilities Non-current liabides: Term debt Other non-current labilities 3 Total non-current abilities Total liabilities 40 F S 4 R % I 16 5 LIABILITIES AND SHAREHOLDERS' EQUITY: || T 17 ^ ASSETS: 6 99+ ASUS 18 Y 03/0 7 2015 home 19h * U 8 S $ September 28, 2019 Fod 48,844 S 51,713 22,926 4,106 22,878 12.352 162,819 105,341 37,378 32,978 175,897 338,516 46,236 $ 37,720 5,522 5,980 10,250 105,718 1 91,507 50,503 142,310 248,028 9 September 29, 2015 ESP 25,913 40,388 23,186 3.956 25,809 12,087 131,339 170,799 41,304 22,283 234,386 365,725 55,808 33.327 5,966 11,964 8,784 93.735 48,914 142.649 Shareholders' equity: Common stock and additional paid-in capital, $0.00001 par value: 12,600,000 shares authorized; 4,443,236 and 4,754,986 shares issued and outstanding, respectively Retained earings Accumulated other comprehensive Income (loss) Total shareholders' equity Total abilities and shareholders' equity $ 45,174 45,898 (584) 90,488 338,516 S 40,201 70,400 (3,454) 107,147 365,725
Expert Answer:
Answer rating: 100% (QA)
Part B a Cash flows from assets Revenue 8000000 Cost of goods sold 4800000 Gross profit 3200000 Oper... View the full answer
Related Book For
Accounting
ISBN: 978-0324188004
21st Edition
Authors: Carl s. warren, James m. reeve, Philip e. fess
Posted Date:
Students also viewed these accounting questions
-
Perform horizontal financial analysis on the income statement and explanation? Statement of Income Year ended September 30 Unaudited Proforma 2019 2018 2017 2016 2015 Sales Convenience sales Gas...
-
Trans Jamaica Corporation wishes to invest in one of three transport infrastructure projects X, Y and Z with initial outlays of $500 million, $390 million and $650 million respectively. Projects are...
-
1) Perform the time trend analysis for each ratio for these two companies over three years What kind of information can be obtained based on the trend analysis? (2) Perform the peer group analysis to...
-
Which statement about sociology as a science is true? A) Most sociologists reject the use of the scientific method. B) Sociologists almost always use hypothesis testing in their research. C) Sociolo...
-
According to the Deloitte study, 57 percent of respondents were unable to free up the anticipated level of internal resources after outsourcing. In comparing traditional internal sourcing with...
-
Pepper Enterprises owns 95 percent of Salt Corporation. On January 1, 20X1, Salt issued $200,000 of five-year bonds at 115. Annual interest of 12 percent is paid semiannually on January 1 and July 1....
-
An engineer in charge of the design of a plant must choose either a batch or a continuous system. The batch system offers a lower initial outlay but, owing to high labor requirements, exhibits a...
-
Conrad Playground Supply underwent a restructuring in 2013. The company conducted a thorough internal audit, during which the following facts were discovered. The audit occurred during 2013 before...
-
Non-current liabilities Bonds payable Equity Share capital-ordinary, 1.00 par, authorized 400,000 shares, issued 295,500 Share premium-ordinary Retained earnings 505,500 295,500 165,500 ? Prepare a...
-
In preparing for the upcoming holiday season, Mandrell Toy Company designed a new doll called Freddy. The fixed cost to produce the doll is $100,000. The variable cost, which includes material,...
-
Without using financial contracts, how can gold producer manage gold price exposure
-
Honest Joe, Corp. has set the following standards for direct materials (DM) costs per unit for the good it manufactures: Standard Quantity: 5.1 ounces per unit Standard Price: $3.90 per ounce During...
-
Each of these individuals would like to report the sale of their property on the installment method. Which taxpayer is eligible to do so? No selling expenses were associated with any of the...
-
Compute the FOBV [ fixed overhead budget variance ] Given Data : Standard rate for FOH = $ 4 per DLH Actual DLHs worked = 4 1 , 0 0 0 DLHs Denominator hours = 4 0 , 0 0 0 DLHs Actual production...
-
Kurtz Logistics provides the following information: Operating income Net sales $1,500,000 $13,000,000 $1,800,000 25% Average total assets Management's target rate of return What is the company's...
-
Nailufar Sdn . ?Bhd . ?is a manufacturer of antique - style souvenir box using an assembly line process. A unit of product passes through two department; Assembly and Finishing department, before it...
-
Write the fractions X 3xy Z 6x2z = = X Z and 3xy 6x2z in terms of the LCM of the denominators.
-
Record the following selected transactions for March in a two-column journal, identifying each entry by letter: (a) Received $10,000 from Shirley Knowles, owner. (b) Purchased equipment for $35,000,...
-
Darigold Co. produces and distributes fiber optic cable for use by telecommunications companies. Darigold Co. issued $18,000,000 of 15-year, 7% bonds on April 1 of the current year, with interest...
-
Earthlink, Inc., is a nationwide Internet Service Provider (ISP). Earthlink provides a variety of services to its customers, including narrowband access, broadband or high-speed access, and Web...
-
The controller of Heritage Ceramics, Inc. wishes to prepare a cost of goods sold budget for June. The controller assembled the following information for constructing the cost of goods sold budget:...
-
The equity section of Atrio Ltd. showed the following: share premium 6,101, share capitalordinary 925, share capitalpreference 58, retained earnings 7,420, and treasury shares 2,828. (All amounts are...
-
The following equity accounts are in the ledger of Eudaley Group at December 31, 2025. Instructions Prepare the equity section of the statement of financial position at December 31, 2025. Share...
-
Travis Mordica asks, Since share dividends dont change anything, why declare them? What is your answer to Travis?
Study smarter with the SolutionInn App