Purchase Solution

Pro Forma income statement and determine break even point

Not what you're looking for?

Ask Custom Question

Using Excel, create a three year Pro Forma income statement and determine break even point on the data attached.

Based on the organization you have created
a. Using Excel, create a three year Pro Forma income statement for your organization (or product/service).
b. What will be your financial break-even point?

Expected sales revenue . . $2,000,000
Manufacturing costs:
Variable cost of goods sold . 325,000
Fixed overhead . . . . . . . .300,000
Selling expenses:
Variable expenses . . . . . . 140,000
Fixed expenses . . . . . . . . 45,000
Administrative expenses:
Variable expenses . . . . . . .45,000
Fixed expenses . . . . . . . .160,000
Interest expense . . . . . . . 28,000
Income tax rate . . . . . . . . . 35%

Purchase this Solution

Solution Summary

Your tutorial (in excel, attached) assumes that sales volume increases 10% in year 2 and year 3 (although you can alter this assumption by changing the blue cell and all the computations will update). Breakeven is shown for you.

Solution provided by:
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution

Free BrainMass Quizzes
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.

Introduction to Finance

This quiz test introductory finance topics.

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.

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

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.