1. The new truck your catering company just purchased has a cost of $90,000 with all the movable carts, storage, and refrigeration built in. You are able to negotiate a loan with your bank with no down payment, 12%, 2 years, with a monthly mortgage. Please complete the amortization schedule for the first two months of this loan.

A.

Month	Beginning Balance	Payment	Interest	Principal	Ending Balance
1	90,000	4,237	42	4,195	85,805
2	85,905	4,237	42	4,195	81,526

B.

Month	Beginning Balance	Payment	Interest	Principal	Ending Balance
1	90,000	3,601	900	2,701	85,705
2	85,705	3,601	857	2,744	82,961

C.

Month	Beginning Balance	Payment	Interest	Principal	Ending Balance
1	76,500	3,601	765	2,836	73,664
2	73,664	3,601	858	2,743	70,921

D.

Month	Beginning Balance	Payment	Interest	Principal	Ending Balance
1	76,500	3,601	36	3,565	72,935
2	72,935	3,601	36	3,565	69,370

• Use the spreadsheet below to answer the following question regarding the methodology used to calculate Index.

	A	B	C	D	E	F	G	H	I	J
1		Subject Property			Competitive Set			Index Numbers
2		Occupancy	ADR	RevPAR	Occupancy	ADR	RevPAR	Occupancy	ADR	RevPAR
3	Sep	98.2	105.80	103.90	82.4	107.42	88.51

2. The RevPAR Index for September (J3) is _____.

		A. 85.2
		B. 96.2
		C. 117.4
		D. 122.7