Calculating External Financing Needs from Financials
Not what you're looking for?
Please see the attached problem.
EFN: The most recent financial statements for Martin, Inc., are shown here:
INCOME STATEMENT BALANCE SHEET
Sales $19,200 Assets $93,000 Debt $20,400
Costs $15550 Equity $72,600
Taxable income $ 3,650 Total $93,000 Total $93,000
Taxes (34%) 1,241
Net income $2,409
Assets and costs are proportional to sales. Debt and equity are not. A dividend of $963.60 was paid, and Martin wishes to maintain a constant payout ratio. Next year's sales are projected to be $23,040. What is the external financing needed?
Purchase this Solution
Solution Summary
External funds needed by a firm are calculated based upon the given financials (income statement and balance sheet).
Solution Preview
See the attached spreadsheet. I've worked step by step to try to explain how this works.
Basically, you'll see that the EFN formula is as follows:
EFN=(Expected Total Assets)-(Expected Total Liabilities)
Expected total assets are easy to calculate as they are said to be a constant percentage of sales.
Last year, sales were $19,200 and assets ...
Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.