urgent help

profileneacy
l2.xls

Sheet1

iPhone App Forecase of Revenue and Cost
Assumptions
Units Year 1 700
Yearly Increase 100%
Price Per Unit $2.00
Apple Commission 30%
Contribution Margin per Unit $1.40
Loan Payment Per Month $101.00
Profit Projections by Year 5 $5,000.00
Fixed Costs
Developer Cost -Initial $3,500.00 year 1 only
Year Units Contribution Margin Fixed Cost Loan Repayments Profit
1 700 $980.00 $3,500.00 $1,212.00 -$3,732.00
2 1400 1,960.00 0 1,212.00 748.00
3 2800 3,920.00 0 1,212.00 2,708.00
4 5600 7,840.00 0 1,212.00 6,628.00
5 11200 15,680.00 0 1,212.00 14,468.00
Profit/Loss $20,820.00