Supposing that the 2022 sales are projected to increase by 25% over the year 2021 sales and that there is proportional relationship between sales to operating costs, interest expenses, current assets and spontaneous liabilities. The company has been operating at full capacity and planned to maintain the dividend ratio and profit margin position of the previous year. Required i. Using the Percentage of Sales proforma method, compute the additional funds needed (AFN), assuming that the company was operating at full capacity in the year 2021. ii. Using the Formula method, compute the additional funds needed, assuming that the company was operating at full capacity in the year 2021.

Supposing that the 2022 sales are projected to increase by 25% over the year 2021 sales and that there is proportional relationship between sales to operating costs, interest expenses, current assets and spontaneous liabilities. The company has been operating at full capacity and planned to maintain the dividend ratio and profit margin position of the previous year. Required i. Using the Percentage of Sales proforma method, compute the additional funds needed (AFN), assuming that the company was operating at full capacity in the year 2021. ii. Using the Formula method, compute the additional funds needed, assuming that the company was operating at full capacity in the year 2021.

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 32BEB

See similar textbooks

Similar questions

Can you do 2022 income statement of this table? Statement of Profit or Loss and Other Comprehensive Income Presentation Currency Nature of Financial Statements Revenue Revenue from Finance Sector Operations Total Revenue Cost of Sales Cost of Finance Sector Operations Total Costs Gross Profit (Loss) from Commercial Operations Gross Profit (Loss) from Finance Sector Operations Gross Profit (Loss) Profit (Loss) From Operating Activities Profit (Loss) Before Financing Income (Expense) Profit (Loss) from Continuing Operations, Before Tax Profit (Loss) from Continuing Operations Profit (Loss) from Discontinued Operations Net Profit (Loss) Profit (Loss) Attributable To, Non- controlling Interests Profit (Loss) Attributable To, Owners of Parent Other Comprehensive Income (Loss) Total Comprehensive Income (Loss) Total Comprehensive Income Attributable To, Non-controlling Interests Total Comprehensive Income Attributable To, Owners of Parent 2020/12 1000TL Consolidated 21.529.210 37.824.578…
Comparitive balance sheet of Hillard Co. as of Dec 31, 2020 and 2021 is as under: Assets 2020 2021 Liabilities Cash Accounts Receivable Inventory Fixed Assets Investments Sales Cost of Goods Sold Gross profit 16,425 12,300 Salaries expenses Depreciation expense Income tax expense Admin. Expenses Net profit 16,100 163,000 13,500 221,325 28,025 10,600 Income statement for the year 2021 is as under: 18,400 206,300 9,200 272,525 829,400 614,450 214,950 12,900 11,600 1,150 164,400 24,900 Accounts Payable Salaries Payable Income tax payable Loans Payable Retained earnings Please prepare the cash flow statement using the indirect method. 2020 26,900 2,400 1,600 106,250 84,175 221,325 2021 33,450 3,100 2,050 113,250 120,675 272,525
Calculate the common-sized percentage 2023. for Gross Margin in
Use the following information to answer this question: Bayside, Incorporated 2021 Income Statement ($ in thousands) Net sales Cost of goods sold Depreciation Earnings before interest and taxes Interest paid Taxable income Taxes Net income Cash Accounts received Inventory Total Net fixed assets Total assets What is the equity multiplier for 2021? Multiple Choice 1.55 times 52 times 1.04 times 2.03 times 2020 Bayside, Incorporated 2020 and 2021 Balance Sheets ($ in thousands) $75 920 2021 $ 180 760 $ 5,920 4,190 320 $ 1,410 27 $ 1,383 290 $ 1,093 1,540 2,000 $ 2,535 $ 2,940 3,550 3,380 $ 6,085 $ 6,320 Accounts payable Long-term debt Common stock Retained earnings Total liabilities & equity 2020 $ 1,420 750 3,105 810 $ 6,085 2021 $ 1,710 540 3,010 1,060 $ 6,320
You have been provided with Leonard Corporation's partial Statement of Financial Position and the Statement of Comprehensive Income for the year ended December 31, 2021. Leonard Corporation Partial Statement of Financial Position For the Year Ended December 31, 2021 Accounts receivable -net Prepaid expenses Inventory Property, Plant & Equipment Accumulated Depreciation Accounts payable Income taxes payable Deferred revenue 2021 Sales....... Cost of goods sold.. Gross Margin. Selling, general and admin Depreciation expense $440,000 482,000 45,000 31,000 825,000 810,000 2,475,000 2,105,000 2020 (866,000) (823,000) 184,000 197,000 38,000 35,000 47,000 42,000 Leonard Corporation Statement of Comprehensive Income For the Year Ended December 31, 2021 Interest expense..... Gain on sale of PPE Net income before taxes Income Tax Expense Net income and comprehensive income... $3,560,000 1,950,000 1,610,000 (595,000) (320,000) (115,300) 55,400 635,100 95,300 .$539,800 Additional information:…
The trial balance of Rollins Inc. included the following accounts as of December 31, 2021: Credits 5, 200, 000 36, 500 Debits Sales revenue Interest revenue Loss on sale of investments Loss on debt investments Gain on projected benefit obligation Cost of goods sold Selling expense Restructuring costs Interest expense General and administrative expense 20, 000 122, 000 225, 000 3,770,000 330,000 145, 000 10, 000 230, 000 The loss on debt investments represents a decrease in the fair value of debt securities and is classified as part of other comprehensive income. Rollins had 100,000 shares of stock outstanding throughout the year. Income tax expense has not yet been accrued. The effective tax rate is 25%. Required Prepare a 2021 single, continuous statement of comprehensive income for Rollins Inc. Use a multiple-step income statement format: (Amounts to be deducted should be indicated with a minus sien. Roind Earnings per share answer to 2 decimal places. ROLLINS INC Statement of…
using the attached data please calculate the Weighted average cost of capital. Revenue Costs of goods sold Gross profit SG&A expense Operating income Interest expense Other income (expense) Income before taxes Income taxes Net income after taxes Adjustments to net income Net income Diluted EPS Dividends per share 2008 9,885,556 6,233,420 3,652,136 2,081,801 1,570,335 323,289 (16,283) 1,230,763 372.587 858,176 (13,251) 844,925 2.61 1.52 Average Historic Yields 1-year 5-year 10-year 2009 10,011,331 6,442,075 3,569,256 2,066,810 1,502,446 275,485 92,922 1,319,883 375,483 944,400 (21,328) 923,072 2.89 1.66 1.21% 2010 10,494,983 6,700,677 3,794,306 2,235,078 1,559,228 250,574 (18,200) 1,290,454 358,514 931,940 30-year Moody's Aaa Moody's Baa 3-month commercial paper Heinz Capital Market Prices of Typical Issues (67,048) 864,892 2003 2004 2005 2006 1.22% 1.55% 3.33% 4.98% 2.85% 3.63% 3.90% 4.92% 3.89% 4.53% 4.21% 5.07% 2.71 1.68 4.79% 5.31% 4.61% 5.17% 5.53% 5.87% 5.21% 5.95% 6.65% 6.58%…
Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes. Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets Sin Comparative Income Statements For Years Ended December 31 2021 $ 420,027 252,856 167,171 59,644 37,802 97,446 69,725 12,969 $ 56,756 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity Assets Current assets Long-term investments Plant assets, net. Total assets Liabilities and Equity Current liabaties Common stock Other paid-in capital Retained earnings Total liabilities and equity 2020 $ 321,775 202,718 KORBIN COMPANY Comparative Balance Sheets December 31 2021 119,057 44,405 28,316 72,721 46,336 9,499 $ 36,837 $ 55,286 0 102,674 $ 157,960 2020 3. Complete the below table to calculate the balance sheet data in trend percents with 2019 as answers to 2 decimal places.) 111.77 % 0.00 $ 37,003 700…
The trial balance of Kroeger Incorporated included the following accounts as of December 31, 2024: Sales revenue Interest revenue Gain on sale of investments Gain on debt securities Loss on projected benefit obligation Cost of goods sold Selling expense Goodwill impairment loss Interest expense General and administrative expense Debits $ 160,000 6,100,000 600,000 500,000 30,000 500,000 Credits $ 8,200,000 60,000 120,000 140,000 The gain on debt securities represents the increase in the fair value of debt securities and is classified a component of other comprehensive income. Kroeger had 300,000 shares of stock outstanding throughout the year. Income tax expense has not yet been recorded. The effective tax rate is 25%. Required: Prepare a 2024 single, continuous statement of comprehensive income for Kroeger Incorporated. Use a multiple-step income statement format. Note: Round earnings per share answer to 3 decimal places.
Use the following information to answer this question: Windswept, Incorporated 2021 Income Statement ($ in millions) Net sales Cost of goods sold Depreciation Earnings before interest and taxes Interest paid Taxable income Taxes Net income Cash Accounts received Inventory Total Net fixed assets Total assets What is the equity multiplier for 2021? Multiple Choice 1.78 times 3.33 times 2.25 times 1.31 times 2.64 times 2020 2021 $ 250 890 $ 9,900 7,650 390 $ 1,860 88 Windswept, Incorporated 2020 and 2021 Balance Sheets ($ in millions) $220 990 1,750 1,655 $ 2,960 $ 2,795 3,360 3,880 $ 6,320 $ 6,675 $ 1,772 372 $1,400 Accounts payable Long-term debt Common stock Retained earnings Total liabilities & equity 2020 $ 1,540 1,010 3,240 530 $ 6,320 2021 $ 1,632 1,293 2,970 780 $ 6,675
This year Last year 1050 Assets Cash 1530 Marketable securities Accounts receivable Inventories Total current assets 1810 1220 2050 1770 2900 2790 8290 6830 Gross fixed assets 29480 28090 Less: Accumulated depreciation 14680 13140 Net fixed assets 14800 14950 Total assets Liabilities and Stockholders' Equity 23090 21780 Accounts payable Notes payable Accruals 1560 1540 2760 2160 190 350 Total current liabilities 4510 4050 Long-term debt Common stock Retained earnings Total stockholders' equity 5220 4970 9950 9950 3410 2810 13360 12760 Total liabilities and stockholders' equity 23090 21780
Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Total stockholders' equity Current liabilities Target Corporation Income Statement Data for Year $65,357 45,583 15,101 707 (94) 1,384 $ 2,488 $18,424 26,109 Balance Sheet Data (End of Year) $44,533 $11,327 17,859 15,347 Walmart Inc. $44,533 $408,214 304,657 79,607 10,512 2,065 (411) 7,139 $ 14,335 $48,331 122,375 $170,706 $55,561 44,089 71,056 $170,706 Beginning-of-Year Balances $44,106 13,712 $163,429 65,682 55,390