Creating a simple income statement


Problem: You are in the business of selling widgets. You retail these fine looking widgets for $25.00 a piece and you have 1,000 of them in inventory. If your total fixed costs are $150,000 and your total variable costs are $10,000 what is:

Your breakeven in units _________

Your breakeven in dollars _________

Prove that this is truly your breakeven figures by creating a simple income statement showing your Revenues, Fixed Costs, Variable Costs, and Net Income.

Please respond in Excel.

Solution Preview :

Prepared by a verified Expert
Finance Basics: Creating a simple income statement
Reference No:- TGS01842274

Now Priced at $25 (50% Discount)

Recommended (92%)

Rated (4.4/5)