ADDITIONAL FUNDS NEEDED Morrissey Technologies Inc.’s 2016 financial statements are shown here.
Morrissey Technologies Inc.: Balance Sheet as of December 31, 2016
Morrissey Technologies Inc.: Income Statement for December 31, 2016
Sales | $3,600,000 |
Operating costs including depredation | 3,279,720 |
EBIT | $ 320,280 |
Interest | 20,280 |
EBT | $ 300,000 |
Taxes (40%) | 120,000 |
Net Income | $ 180,000 |
Per Share Data: | |
Common stock price | $45.00 |
Earnings per share (EPS) | $ 1.80 |
Dividends per share (DPS) | $ 1.08 |
Suppose that in 2017, sales increase by 10% over 2016 sales. The firm currently has 100,000 shares outstanding. It expects to maintain its 2016 dividend payout ratio and believes that its assets should grow at the same rate as sales. The firm has no excess capacity. However, the firm would like to reduce its operating costs/sales ratio to 87.5% and increase its total liabilities-to-assets ratio to 30%. (It believes its liabilities-to-assets ratio currently is too low relative to the industry average.) The firm will raise 30% of the 2017 forecasted interest- bearing debt as notes payable, and it will issue long-term bonds for the remainder. The firm
- a. Construct the forecasted financial statements assuming that these changes are made. What are the firm’s forecasted notes payable and long-term debt balances? What is the forecasted addition to
retained earnings ? - b. If the profit margin remains at 5% and the dividend payout ratio remains at 60%, at what growth rate in sales will the additional financing requirements be exactly zero? In other words, what is the firm’s sustainable growth rate? (Hint: Set AFN equal to zero and solve for g.)
a.
To construct: The forecasted financial statements for the year 2017 and to calculate the firm’s forecasted notes payable and long-term debts balance and forecasted addition to retained earnings
Introduction:
Financial Statements:
Financial statements are the statements, which tell about the financial activities of the company. A financial statement of a company includes its income statement, balance sheet, and cash flows statement.
Income Statement:
Income statement is a business’s financial statement, which tells the financial performance of a company in an accounting period. It shows the income generated by a company and expenses incurred by a company through its operations.
Balance Sheet:
Balance sheet is the summarize statement of total assets and total liabilities of a company in an accounting period. It is one of the financial statements.
Additional Fund Needed:
Additional fund needed is also known as external financing needed. It is the state in which a company needed finance to increase its operation. Additional fund needed is a method in which a company raises the funds through external resources to increase its assets, which would increase the sales revenue of the firm.
But according to additional fund needed method, a company do not change its financial ratio. Liabilities and retained earnings spontaneously increase with the increase in sales and assets.
Explanation of Solution
Company M | |
Income Statement | |
For the year ended December 31,2017 | |
Particulars |
Amount ($) |
Sales | 3,960,000 |
Less:-Operating costs including depreciation | 3,465,000 |
EBIT | 495,000 |
Less:-Interest | 111,375 |
EBT | 383,625 |
Less:-Taxes | 153,450 |
Net income | 230,175 |
Per Share Data: | |
Common stock price | 45 |
Earnings per share (EPS) | 2.30 |
Dividends per share (DPS) | 1.38 |
Table (1)
Company M | ||
Balance Sheet | ||
For the year ended December 31, 2017 | ||
Assets |
Amount ($) |
Amount ($) |
Current assets: | ||
Cash | 198,000 | |
Accounts receivable | 396,000 | |
Inventories | 792,000 | |
Total current assets | 1,386,000 | |
Fixed assets | 1,584,000 | |
Total Assets | 2,970,000 | |
Liabilities and Owners' Equity | ||
Current Liabilities: | ||
Notes payable | 728,000 | |
Total current Liabilities | 728,000 | |
Long-term debt | 163,000 | |
Total Liabilities | 891,000 | |
Owners' Equity: | ||
Common stock | 1,782,930 | |
Retained Earnings | 296,070 | |
Total Stockholders' Equity | 2,079,000 | |
Total Liabilities and Owners' Equity | 2,970,000 |
Calculation of forecasted notes payable for 2017,
Given,
Notes payable for 2016 are $56,000.
Company will raise notes payable by 30%.
Formula to calculate the forecasted notes payable for 2017,
Substitute $560,000 for notes payable for 2016 and 30% for increment in notes payable.
Calculation of forecasted long term debts for 2017,
Given,
Liabilities (excluding retained earnings and common stock) for 2017 are $891,000 (working notes).
Notes payable for 2017 are $728,000.
Formula to calculate long term debts for 2017,
Substitute $891,000 for liabilities (excluding retained earnings and common stock) and $728,000 for notes payable.
Calculation of addition to retained earnings for the year 2017
Given,
Dividend paid for the year ended 2017 is $138,105.
Net income for the year ended is $230,175.
Formula to calculate addition to retained earnings,
Substitute $230,175 for net income and $138,105 for dividend paid.
Working notes:
Calculation of estimated sales for the year 2017
Given,
Sales for the year 2016 are $3,600,000.
Increment in sales is 10%.
Calculation of estimated sales for 2017,
Calculation of estimated operating costs including depreciation for the year 2017
Given,
The firm would like to reduce its operating cost/sales ratio to 87.5%.
Sales of the year 2017 are $3,960,000.
Calculation of operating costs including depreciation,
Calculation of estimated total assets for 2017,
Given,
Value of total assets for 2016 is $2,700,000.
The assets should grow at the same rate as sales, which is 10%.
Calculation of the total assets,
Calculation of estimated cash for 2017,
Given,
Value of cash for 2016 is $180,000.
The assets should grow at the same rate as sales, which is 10%.
Calculation of estimated cash for 2017,
Calculation of estimated receivable for 2017,
Given,
Value of receivable for 2016 is $360,000.
The assets should grow at the same rate as sales, which is 10%.
Calculation of estimated receivable for 2017,
Calculation of estimated inventories for 2017,
Given,
Value of inventories for 2016 is $720,000.
The assets should grow at the same rate as sales, which is 10%.
Calculation of estimated inventories for 2017,
Calculation of estimated fixed assets for 2017,
Given,
Fixed assets for 2016 are $1,440,000.
The assets should grow at the same rate as sales, which is 10%.
Calculation of estimated fixed assets for 2017,
Calculation of estimated total liabilities (excluding retained earnings and common stock) for 2017,
Given,
The liabilities-to-assets ratio for 2017 is 30%.
Estimated assets for 2017 are 2,970,000.
Calculation of estimated liabilities (excluding retained earnings and common stock) for 2017,
Calculation of estimated interest for 2017,
Given,
Forecasted notes payable for 2017 are $728,000.
Forecasted long terms debts are $891,000.
Interest rate is 12.5%.
Calculation of estimated interest,
Calculation of taxes
Given,
Tax rate is 40%
EBT for the year 2017 is $383,625.
Calculation of taxes,
Calculation of Earnings per share,
Given,
Estimated net income for 2017 is $230,175.
Shares outstanding are 100,000.
Calculation of EPS,
Calculation of dividend paid in 2016,
Given,
Dividend per share for 2016 is $1.08.
Shares outstanding for 2016 is 100,000
Formula to calculate Dividend paid in 2016,
Calculation of dividend payout ratio,
Given,
Dividend paid for the year 2016 is $108,000.
Net income for the year 2016 is $180,000.
Calculation of the dividend payout ratio,
Calculation of dividend paid during 2017
Given
Dividend payout ratio remains constant, which is 60%.
Net income for the year 2017 is $230,175.
Calculation of dividend paid during 2017,
Calculation of estimated dividend per share for 2017,
Given,
Dividend paid during 2017 is $138,105.
Shares outstanding are 100,000.
Calculation of dividend per share,
Calculation of estimated value of common stock for 2017,
Given,
Estimated total assets for 2017 are $2,970,000.
Estimated liabilities (excluding retained earnings and common stock) are $891,000
Estimated retained earnings for 2017 are $92,070.
Calculation of common stock for 2017,
The forecasted notes payable for 2017 are $728,000, the forecasted long term debts are $163,000 and the addition in retained earnings are 92,070.
b.
To find: Firm’s sustainable growth rate in sales.
Explanation of Solution
Calculation of sustainable growth rate,
Given,
The profit margin is 5%.
The dividend payout ratio is 60%.
Current sales for 2017 are $3,960,000.
Total assets for 2017 are $2,970,000.
Spontaneous current liability for 2017 is $891,000.
Formula to calculate sustainable growth rate in sales,
Substitute 5% (or 0.05) for profit margin, 6% (or 0.6) for payout ratio, $3,960,000 for current sales, $2,970,000 for total assets and $891,000 for spontaneous current liability.
The sustainable growth rate is 3.96%.
Want to see more full solutions like this?
Chapter 16 Solutions
FUND. OF FINANCIAL MGMT CONCISE (LL)
- Refine Assumptions for Dividend and Retained Earnings Forecast Provided below is FY2016 information for Medtronic PLC. Medtronic plc Consolidated Statement of Income ($ millions) Apr. 29, 2016 Net sales $29,277 Costs and expenses Cost of products sold 9,142 Research and development expenses 2,224 Selling, general, and administrative expense 9,469 Special charges (gains), net 70 Restructuring charge, net 290 Certain litigation charges, net 26 Acquisition-related items 283 Amortization of intangiable assets 1,931 Other expense, net 107 Operating profit 5,735 Interest expense, net 955 Income from operations before income taxes 4,780 Provision for income taxes 908 Net income $3,872 Medtronic plc Consolidated Balance Sheet ($ millions) Apr. 29, 2016 Apr. 24, 2015 Current assets Cash and cash equivalents $2,975 $4,942 Investments 9,758 14,637 Accounts receivable 5,562 5,112 Inventories 3,473 3,463 Tax assets 697 1,335 Prepaid expenses and other current assets…arrow_forwardWeighted Average Cost of Capital The December 31, 2018, partial financial statements taken from the annual report for AT&T Inc. (T ) follow. Consolidated Statements of Income Dollars in millions except per share amounts 2018 2017 Operating revenues Service $152,345 $145,597 Equipment 18,411 14,949 Total operating revenues 170,756 160,546 Operating expenses Equipment 19,786 18,709 Broadcast, programming and operations 26,727 21,159 Other cost of services (exclusive of depreciation and amortization show separately below) 32,906 37,942 Selling, general and administrative 36,765 35,465 Abandonment of network assets 46 2,914 Depreciation and amortization 28,430 24,387 Total operating expenses 144,660 140,576 Operating income 26,096 19,970 Other income (expense): Interest expense (7,957) (6,300) Equity in net income of affiliates (48) (128)…arrow_forwardThe following amounts were taken from the financial statements of Concord Corporation: 2017 2016 Total assets $818000 $1020000 Net sales 726000 655000 Gross profit 376000 332000 Net income 118000 130000 Weighted average number of 90200 80000 common shares outstanding Market price of common stock $42 $36 The return on assets for 2017 is 12%. 13%. 14%. 6%.arrow_forward
- The 2017 financial statements for Armstrong and Blair companies are summarized below: Blair Armstrong Company Company Statement of Financial Position $35,000 40,000 100,000 140,000 85,000 $ 22,000 30,000 40,000 400,000 308,000 Cash Accounts receivable (net) Inventory Property, plant, and equipment (net) Other non-current assets Total assets $ 400,000 $ 800,000 $ 100,000 60,000 150,000 30,000 60,000 $ 50,000 70,000 500,000 110,000 70,000 Current liabilities Long-term debt (10%) Share capital Contributed surplus Retained earnings Total liabilities and shareholders' equity $ 400,000 $ 800,000 Statement of Earnings Sales revenue (1/3 on credit) Cost of sales $ 450,000 (245,000) (160,000) $ 810,000 (405,000) (315,000) Expenses (including interest and income tax) Net earnings $ 45,000 $ 90,000 Selected data from the 2016 statements follows: Prev 1 of 2arrow_forwardSelect information from BUI Balance Sheets as of December 31 Current Assets Net Plant and Equipment Total Assets Accounts Payable Notes Payable Accruals Long-Term Bonds Total Common Equity Total Liabilities & Equity Income Statement Earnings before interest and taxes Depreciation and Amortization Interest Taxes 40% Net Income Other Information WACC Number of shares outstanding Price per share What was 2014 EVA? $0 $197,600 $140,000 $57,600 2013 1,200,000 900,000 2,800,000 2,700,000 4,000,000 3,600,000 2014 200,000 216,000 280,000 108,000 120,000 252,000 1,040,000 864,000 2,360,000 2,160,000 4,000,000 3,600,000 2014 1,200,000.0 140,000.0 104,000.0 438,400.0 657,600.0 2014 18.00% 80,000 $22.13arrow_forwardThe following table gives abbreviated balance sheets and income statements for Walmart. At the end of fiscal 2017, Walmart had 3,060 million shares outstanding with a share price of $146. The company's weighted-average cost of capital was about 5%. Assume a tax rate of 35%. Balance Sheet (figures in $ millions) End of Year Start of Year Assets Current assets: Cash and marketable securities $ 6,956 $ 7,067 Accounts receivable 5,814 6,035 Inventories 43,983 43,246 Other current assets 3,711 2,141 Total current assets $ 60,464 $ 58,489 Fixed assets: Net fixed assets $ 115,018 $ 114,378 Other long-term assets 30,240 27,158 Total assets $ 205,722 $ 200,025 Liabilities and Shareholders' Equity Current liabilities: Accounts payable $ 46,292 $ 41,633 Other current liabilities 32,629 25,695 Total current liabilities $ 78,921 $ 67,328 Long-term debt 37,025…arrow_forward
- Estimating Market and Book Values and Cost of Capital MeasuresThe December 31, 2018, partial balance sheet of 3M Company follows (amounts in millions, except share and per share amounts). YCharts.com reported that the total market capitalization of 3M was $108.46 billion and its stock price was $190.54 as of December 31, 2018. Also, YCharts.com estimates its total enterprise value at $119.84 billion, and its market beta at 1.14. 3M’s average pretax borrowing cost is 2.07%, and its assumed statutory tax rate is 21%. Assume that the risk-free rate equals 2.1% and the market premium equals 5%. Liabilities Current liabilities Short-term borrowings and current portion of long-term debt $1,211 Accounts payable 2,266 Accrued payroll 749 Accrued income taxes 243 Other current liabilities 2,775 Total current liabilities 7,244 Long-term debt 13,411 Pension and post-retirement benefits 2,987 Other liabilities 3,010 Total…arrow_forwardEstimating Market and Book Values and Cost of Capital MeasuresThe December 31, 2018, partial balance sheet of 3M Company follows (amounts in millions, except share and per share amounts). YCharts.com reported that the total market capitalization of 3M was $108.46 billion and its stock price was $190.54 as of December 31, 2018. Also, YCharts.com estimates its total enterprise value at $119.84 billion, and its market beta at 1.14. 3M’s average pretax borrowing cost is 2.07%, and its assumed statutory tax rate is 21%. Assume that the risk-free rate equals 2.1% and the market premium equals 5%. Liabilities Current liabilities Short-term borrowings and current portion of long-term debt $1,211 Accounts payable 2,266 Accrued payroll 749 Accrued income taxes 243 Other current liabilities 2,775 Total current liabilities 7,244 Long-term debt 13,411 Pension and post-retirement benefits 2,987 Other liabilities 3,010 Total liabilities 26,652 Equity 3M Company…arrow_forwardFinancial Information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (millions of dollars) 2020 $2,500.0 2,125.0 $375.0 75.0 $300.0 55.0 $ 245.0 98.0 $147.0 $152.1 $117.6 Common dividends Powell Panther Corporation: Balance Sheets as of December 31 (millions of dollars) 2020 Sales Operating costs excluding depreciation and amortization EBITDA Depreciation and amortization Earnings before interest and taxes (EBIT) Interest Earnings before taxes (EBT) Taxes (25%) Net Income Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant and equipment Total assets 2021: $ b. What was the 2021 free cash flow? 2021 $2,875.0 2,444.0 $ 431.0 86.0 $345.0 63.3 $281.7 112.7 $ 169.0 $ -Select- 2021 46.0 450.0 540.0 $1,036.0 863.0 $1,899.0 Liabilities and Equity Accounts payable Accruals Notes payable Total current liabilities $601.5 Long-term bonds 575.0 Total liabilities $1,176.5 661.5 Common…arrow_forward
- FINANCIAL STATEMENT ANALYSIS DATA INFORMATION Statement of Financial Position of cf company 2015 2016 Cash and Cash Equivalents $ 990,000.00 $ 950,000.00 Short Term Marketable Securities $ 10,000.00 $ 15,000.00 Accounts Receivable $ 1,020,000.00 $ 1,550,000.00 Inventory $ 1,005,000.00 $ 1,360,000.00 Other Current Assets $ 870,000.00 $ 1,150,000.00 Total Current Assets $ 3,895,000.00 $ 5,025,000.00 Fixed Assets $ 14,006,000.00 $ 17,605,000.00 Accumulated Depreciation $ -1,280,000.00 $ -1,700,000.00 Net Fixed Assets $ 12,726,000.00 $ 15,905,000.00 Longterm Investments $ 360,000.00 $ 320,000.00 Investments in Other Companies $ 65,000.00 $ - Intangibles and Other Assets $ 100,000.00 $ 110,000.00 Total Non Current Assets $…arrow_forwardThe following table gives abbreviated balance sheets and income statements for Walmart. At the end of fiscal 2019, Walmart had 2,832 million shares outstanding with a share price of $94. The company's weighted-average cost of capital was about 5%. Assume a tax rate of 21%. Assets Current assets: Cash and marketable securities Accounts receivable Inventories Balance Sheet (figures in $ millions) Fiscal 2019 Other current assets Total current assets Fixed assets: Net fixed assets Other long-term assets Total assets ies and Shareholders' Equity Current liabilities: Accounts payable Other current liabilities Total current liabilities Long-term debt Other long-term liabilities Total liabilities Total shareholders' equity Total liabilities and shareholders' equity Net sales Cost of goods sold Selling, general, and administrative expenses Depreciation Other income/expenses Earnings before interest and taxes (EBIT) Interest expense Taxable income Tax Net income Income Statement (figures in $…arrow_forwardDebt Management Ratios Financial statements for Steele Inc. follow. Steele Inc. Consolidated Income Statements (in thousands except per share amounts) 2023 2022 2021 Net sales $7,245,088 $6,944,296 $6,149,218 Cost of goods sold (5,286,253) (4,953,556) (4,355,675) Gross margin $1,958,835 $1,990,740 $1,793,543 General and administrative expenses (1,259,896) (1,202,042) (1,080,843) Special and nonrecurring items 2,617 0 0 Operating income $701,556 $788,698 $712,700 Interest expense (63,685) (62,398) (63,927) Other income 7,308 10,080 11,529 Gain on sale of investments 0 9,117 0 Income before income taxes $645,179 $745,497 $660,302 Provision for income taxes (254,000) (290,000) (257,000) Net income $391,179 $455,497 $403,302 Steele Inc. Consolidated Balance Sheets (in thousands) ASSETS Dec. 31, 2023 Dec. 31, 2022 Current assets: Cash and equivalents $320,558…arrow_forward
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning