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 30 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. Income Statement Sales Expenses Earnings before interest and taxes Interest Earnings before taxes. Taxes Earnings after taxes Dividends Cash Accounts receivable Inventory Current assets Fixed assets Total assets Assets The firm $ 250,000 184,800 $ 65,200 8,600 $ 56,600 16,600 $ 40,000 $ 16,000 Balance Sheet (in $ millions) Liabilities and Stockholders' Equity $ 4,000 Accounts payable Accrued wages 53,000 68,000 Accrued taxes $ 125,000 96,000 Current liabilities Notes payable Long-term debt Common stock Retained earnings $ 221,000 Total liabilities and stockholders' equity $ 23,500 2,000 4,500 $30,000 8,600 23,000 120,000 39,400 $ 221,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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
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 30 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
Income Statement
Fixed assets
Cash
Accounts receivable
Inventory
Current assets
Total assets
Assets
The firm
$ 250,000
184,800
$ 65,200
8,600
$ 56,600
16,600
$ 40,000
$ 16,000
Balance Sheet (in $ millions)
$ 125,000
96,000
Liabilities and Stockholders' Equity
$4,000 Accounts payable
53,000 Accrued wages
68,000 Accrued taxes
Current liabilities
Notes payable
Long-term debt
Common stock
Retained earnings
$ 221,000 Total liabilities and stockholders' equity
$ 23,500
2,000
4,500
$ 30,000
8,600
23,000
120,000
39,400
$ 221,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.
Transcribed Image Text: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 30 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 Income Statement Fixed assets Cash Accounts receivable Inventory Current assets Total assets Assets The firm $ 250,000 184,800 $ 65,200 8,600 $ 56,600 16,600 $ 40,000 $ 16,000 Balance Sheet (in $ millions) $ 125,000 96,000 Liabilities and Stockholders' Equity $4,000 Accounts payable 53,000 Accrued wages 68,000 Accrued taxes Current liabilities Notes payable Long-term debt Common stock Retained earnings $ 221,000 Total liabilities and stockholders' equity $ 23,500 2,000 4,500 $ 30,000 8,600 23,000 120,000 39,400 $ 221,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.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education