Question

		Campus Travel Trip Options
	Price	Rate	Time	# Pymts	Payment	Total Paid	Total Interest
2 Weeks Eastern Europe	2,000.00	5.50%	1	12
2 Weeks Western Europe	3,000.00	6.00%	1	12
3 Weeks Eastern Europe	3,000.00	6.50%	2	24
3 Weeks Western Europe	3,500.00	5.50%	2	24
4 Weeks Eastern Europe	4,000.00	6.00%	2	24
4 Weeks Western Europe	5,000.00	6.50%	3	36

This problem must be solved in a Spreadsheet format. show the formula used. Thank you

Answer 1

	Campus Travel Trip Options
	Price	Rate	Time	# Pymts	Payment i.e. Sum of Total Paid + Total Interest	Total Paid i.e. Price x Time x No. of Pymts	Total Interest i.e. Rate x Total Paid
2 Weeks Eastern Europe	2,000.00	5.50%	1	12	25320	24000	1320
2 Weeks Western Europe	3,000.00	6.00%	1	12	38160	36000	2160
3 Weeks Eastern Europe	3,000.00	6.50%	2	24	153360	144000	9360
3 Weeks Western Europe	3,500.00	5.50%	2	24	177240	168000	9240
4 Weeks Eastern Europe	4,000.00	6.00%	2	24	203520	192000	11520
4 Weeks Western Europe	5,000.00	6.50%	3	36	575100	540000	35100