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.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
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
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education