The Manning Company has financial statements as shown next, which are representative of the company's historical average. The firm is expecting a 35 percent increase in sales next year, and management is concerned about the company's need for external funds. The increase in sales is expected to be carried out without any expansion of fixed assets, but rather through more efficient asset utilization in the existing store. Among liabilities, only current liabilities vary directly with sales. Sales. Expenses Earnings before interest and taxes Interest Earnings before taxes Taxes Income Statement Earnings after taxes. Dividends Fixed assets Cash Accounts receivable Inventory Current assets Total assets Assets $ 220,000 171,200 $ 48,800 8,300 $ 40,500 16,300 $ 24,200 $7,260 Balance Sheet (in $ millions) $ 110,000 93,000 Liabilities and Stockholders' Equity $8,000 Accounts payable 33,000 Accrued wages 69,000 Accrued taxes Current liabilities Notes payable Long-term debt Common stock Retained earnings $ 203,000 Total liabilities and stockholders' equity $ 23,400 1,850 3,350 $28,600 8,300 21,500 117,000 27,600 $ 203,000 Using the percent-of-sales method, determine whether the company has external financing needs, or a surplus of funds. (Hint: A profit margin and payout ratio must be found from the income statement.) Note: Do not round intermediate calculations. Input your answer as positive a value.

Corporate Fin Focused Approach
5th Edition
ISBN:9781285660516
Author:EHRHARDT
Publisher:EHRHARDT
Chapter12: Corporate Valuation And Financial Planning
Section: Chapter Questions
Problem 2STP
icon
Related questions
Topic Video
Question
S
Problem 4-28 (Algo) Percent-of-sales method [LO4-3]
The Manning Company has financial statements as shown next, which are representative of the company's historical average. The firm
is expecting a 35 percent increase in sales next year, and management is concerned about the company's need for external funds.
The increase in sales is expected to be carried out without any expansion of fixed assets, but rather through more efficient asset
utilization in the existing store. Among liabilities, only current liabilities vary directly with sales.
Sales
Expenses
Earnings before interest and taxes
Interest
Earnings before taxes
Taxes
Earnings after taxes
Dividends
Fixed assets
Income Statement
Cash
Accounts receivable
Inventory
Current assets
Total assets
The firm
Assets
needs
$ 220,000
171,200
$ 48,800
8,300
$ 40,500
16,300
$ 24,200
$ 7,260
Balance Sheet (in $ millions)
$ 110,000
93,000
$8,000 Accounts payable
33,000 Accrued wages
69,000 Accrued taxes
Liabilities and Stockholders' Equity
Current liabilities
Notes payable
Long-term debt
Common stock
Retained earnings
$ 203,000 Total liabilities and stockholders' equity
Using the percent-of-sales method, determine whether the company has external financing needs, or a surplus of funds. (Hint: A profit
margin and payout ratio must be found from the income statement.)
Note: Do not round intermediate calculations. Input your answer as positive a value.
in external funds.
$ 23,400
1,850
3,350
$ 28,600
8,300
21,500
117,000
27,600
$ 203,000
Check my wo
Transcribed Image Text:S Problem 4-28 (Algo) Percent-of-sales method [LO4-3] The Manning Company has financial statements as shown next, which are representative of the company's historical average. The firm is expecting a 35 percent increase in sales next year, and management is concerned about the company's need for external funds. The increase in sales is expected to be carried out without any expansion of fixed assets, but rather through more efficient asset utilization in the existing store. Among liabilities, only current liabilities vary directly with sales. Sales Expenses Earnings before interest and taxes Interest Earnings before taxes Taxes Earnings after taxes Dividends Fixed assets Income Statement Cash Accounts receivable Inventory Current assets Total assets The firm Assets needs $ 220,000 171,200 $ 48,800 8,300 $ 40,500 16,300 $ 24,200 $ 7,260 Balance Sheet (in $ millions) $ 110,000 93,000 $8,000 Accounts payable 33,000 Accrued wages 69,000 Accrued taxes Liabilities and Stockholders' Equity Current liabilities Notes payable Long-term debt Common stock Retained earnings $ 203,000 Total liabilities and stockholders' equity Using the percent-of-sales method, determine whether the company has external financing needs, or a surplus of funds. (Hint: A profit margin and payout ratio must be found from the income statement.) Note: Do not round intermediate calculations. Input your answer as positive a value. in external funds. $ 23,400 1,850 3,350 $ 28,600 8,300 21,500 117,000 27,600 $ 203,000 Check my wo
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning