Purchase Solution

Preparing forecasted financial statements

Not what you're looking for?

Ask Custom Question

Financing Deficit
Balance Sheet as of December 31, 2013

Cash...........................$ 180,000 Accounts payable.....................$ 360,000
Receivables....................360,000 Notes payable.............................156,000
Inventories......................720,000 Line of credit........................................ 0
Total current assets......$ 1,260,000 Accruals....................................... 180,000
Fixed assets.....................1,440,000 Total current liabilities............$ 696,000
Common stock ............................1, 800, 000
Retained earnings....................... 204,000
Total assets.................... $2,700,000
Total liabilities and equity..........$ 2,700,000

Income Statement for December 31, 2013

Sales $3,600,000
Operating costs 3,279,720
EBIT $ 320,280
Interest 18,280
Pre-ax earnings $ 302,000
Taxes (40%) 120,000
Net income $ 181,200
Dividends $ 108,000

Suppose that in 2014 sales increase by 10% over 2013 sales and that 2014 dividends will increase to $112,000. Forecast the financial statements using the forecasted financial statement method. Assume the firm operated at full capacity in 2013. Use an interest rate of 13%, and assume that any new debt will be added at the end of the yea (so forecast the interest expense based on the debt balance at the beginning of the year). Cash does not earn any interest income. Assume that all new debt will be in the form of a line of credit.

Attachments
Purchase this Solution

Solution Summary

A dynamic Excel sheet shows how to prepare forecasted financial statements using the percentage of Sales Method.
You will see that the forecasting approach is broken down into the following steps:
First Step: Percentage of Sales Calculations
Second Step: Partial Pro-Forma Financial Statements
3rd Step: Calculation of the line of credit needed
Last Step: Pro-Forma Financial Statements

Solution Preview

Hello,

You will find an attachment with a dynamic Excel sheet showing the suggested solution. it shows how to prepare ...

Purchase this Solution


Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media