Purchase Solution

# Pro Forma income statement and determine break even point

Not what you're looking for?

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
Variable expenses . . . . . . .45,000
Fixed expenses . . . . . . . .160,000
Other:
Interest expense . . . . . . . 28,000
Income tax rate . . . . . . . . . 35%

##### 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:
###### Education
• 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"

##### 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.