Site hosted by Angelfire.com: Build your free website today!
MONTHLY BUDGET : PROJECTED INCOME STATEMENT FOR  R & S CORPORATION
Month September October November December January February March TOTAL
Estimated units sold 160 300 640 800 1000 760 40 3700
Estimated price per unit $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
TOTAL SALES $16,000.00 $30,000.00 $64,000.00 $80,000.00 $100,000.00 $76,000.00 $4,000.00 $370,000.00
Cost  per unit $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Total cost/units $8,000.00 $15,000.00 $32,000.00 $40,000.00 $50,000.00 $38,000.00 $2,000.00 $185,000.00
Gross Profit $8,000.00 $15,000.00 $32,000.00 $40,000.00 $50,000.00 $38,000.00 $2,000.00 $185,000.00
Fixed Costs $18,000.00 $18,000.00 $18,000.00 $18,000.00 $18,000.00 $18,000.00 $6,000.00 $114,000.00
Variable Costs $1,000.00 $2,500.00 $2,500.00 $2,500.00 $2,000.00 $1,000.00 $1,000.00 $12,500.00
Total Costs $19,000.00 $20,500.00 $20,500.00 $20,500.00 $20,000.00 $19,000.00 $7,000.00 $126,500.00
Profit/(Loss) before taxes $11,000.00 $5,500.00 $11,500.00 $19,500.00 $30,000.00 $19,000.00 $5,000.00 $58,500.00
Loan Payment $12,000.00 $12,000.00
TOTAL $46,500.00
  Less Taxes (25% Estimated) $11,625.00
Total sales = Units sold * Unit Selling Price Net profit $34,875.00
Total Cost per Unit = Units sold * Cost per Unit
Gross Profit = Total Sales - Total Cost/ units
Fixed Costs= Commercial+Rent+Newspaper adds+ Salaries
Variable Cost = Multiple variable costs
Total Costs = Fixed Costs + Variable Costs
Profit/(Loss) before taxes = Gross Profit- Total Costs
Taxes = Profit * .25