Unit 5 Discussion

profileSkylerreybrasil
ProFormaIncomeStatement-Q3.xlsx

Pro Forma Income Statement

Pro Forma Income Statement
Report Item Quarter 1 Quarter 2 Quarter 3
Gross Profit
Revenues 0 1,878,000 4,011,000
- Rebates 0 35,700 70,000
- Cost of Goods Sold 0 1,209,029 2,113,198
= Gross Profit 0 633,271 1,827,802
Expenses
Research and Development 120,000 60,000 0
+ Advertising 0 131,790 130,449
+ Sales Force Expense 0 124,392 277,391
+ Sales Office Expense 180,000 300,000 200,000
+ Marketing Research 0 15,000 15,000
+ Shipping 0 30,730 52,604
+ Inventory Holding Cost 0 0 4,528
+ Excess Capacity Cost 0 0 0
+ Depreciation 0 25,000 25,000
= Total Expenses 300,000 686,912 704,972
Operating Profit -300,000 -53,641 1,122,830
Miscellaneous Income and Expenses
+ Other Income 0 0 0
- Other Expenses 0 0 0
= Earnings Before Interest and Taxes -300,000 -53,641 1,122,830
+ Interest Income 0 0 3,000
- Interest Charges 0 0 0
= Income Before Taxes -300,000 -53,641 1,125,830
- Loss Carry Forward 0 0 353,641
= Taxable Income 0 0 772,189
- Income Taxes 0 0 308,876
= Net Income -300,000 -53,641 816,954
Earnings per Share -15 -2 20
End of Worksheet