| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | ||||||
2 | rF9 and Dragon to Mars | |||||
3 | $130,000,000 | Falcon 9 & Dragon Price | ||||
4 | $118,181,818 | Falcon 9 & Dragon Cost (10% profit) | ||||
5 | 5 | Passengers per Mars Trip | ||||
6 | $500,000 | Per Person Price for Mars Trip | ||||
7 | $2,500,000 | Per Mars Trip Revenue | ||||
8 | 47 | # of launches of an rF9 to breakeven | ||||
9 | ||||||
10 | ||||||
11 | rF9 to LEO | |||||
12 | $60,000,000 | Falcon 9 Price | ||||
13 | $54,545,455 | Falcon 9 Cost (10% profit) | ||||
14 | 47 | # of launches of an rF9 to break even | ||||
15 | $1,153,846 | Variable Cost per Launch | ||||
16 | $200,000 | Fixed Propellant Cost per launch | ||||
17 | $1,353,846 | Total Cost per Launch | ||||
18 | 10,450 | Falcon 9 Kg to LEO | http://www.spacex.com/falcon9.php | |||
19 | $130 | Breakeven Price per Kg to LEO | ||||
20 | ||||||