.

.

Trip length (in days)AirfareHotel + food + sightseeing (per day)Total trip costCost per dayTrip Budget:(modify these values as needed)

.

1$1,200.00$300.00$1,500.00$1,500.00Airfare:$1,200.00

.

2$1,200.00$300.00$1,800.00$900.00Hotel + food + sightseeing (per day):$300.00

.

3$1,200.00$300.00$2,100.00$700.00

.

4$1,200.00$300.00$2,400.00$600.00To get this page in spreadsheet format to play around with the numbers:

.

5$1,200.00$300.00$2,700.00$540.00Open Office:http://spreadsheets.google.com/pub?key=p6kCkg12C2mzF2nS0Kw_mJw&output=ods

.

6$1,200.00$300.00$3,000.00$500.00Excel:http://spreadsheets.google.com/pub?key=p6kCkg12C2mzF2nS0Kw_mJw&output=xls

.

7$1,200.00$300.00$3,300.00$471.43

.

8$1,200.00$300.00$3,600.00$450.00

.

9$1,200.00$300.00$3,900.00$433.33

.

10$1,200.00$300.00$4,200.00$420.00

.

11$1,200.00$300.00$4,500.00$409.09

.

12$1,200.00$300.00$4,800.00$400.00

.

13$1,200.00$300.00$5,100.00$392.31

.

14$1,200.00$300.00$5,400.00$385.71

.

15$1,200.00$300.00$5,700.00$380.00

.

16$1,200.00$300.00$6,000.00$375.00

.

17$1,200.00$300.00$6,300.00$370.59

.

18$1,200.00$300.00$6,600.00$366.67

.

19$1,200.00$300.00$6,900.00$363.16

.

20$1,200.00$300.00$7,200.00$360.00

.

21$1,200.00$300.00$7,500.00$357.14

.

22$1,200.00$300.00$7,800.00$354.55

.

23$1,200.00$300.00$8,100.00$352.17

.

24$1,200.00$300.00$8,400.00$350.00

.

25$1,200.00$300.00$8,700.00$348.00

.

26$1,200.00$300.00$9,000.00$346.15

.

27$1,200.00$300.00$9,300.00$344.44

.

28$1,200.00$300.00$9,600.00$342.86

.

29$1,200.00$300.00$9,900.00$341.38

.

30$1,200.00$300.00$10,200.00$340.00

.

31$1,200.00$300.00$10,500.00$338.71