Purchase Solution

Calculating External Financing Needs from Financials

Not what you're looking for?

Ask Custom Question

Please see the attached problem.

EFN: The most recent financial statements for Martin, Inc., are shown here:


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
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Basics of corporate finance

These questions will test you on your knowledge of finance.