9

Calculate totals for Annual Total, Total Due, Down Payment, Balance, and Monthly Payment on row 14.

10

Insert the appropriate functions in the Summary Statistics section of the worksheet: cells H18:H22. Format the payments with Accounting number format and format the number of new members appropriately.

11

Format the other column headings on rows 4 and 17 to match the fill color in the range E17:H17. Wrap text for the column headings.

12

Set 0.3'' left and right margins and ensure that the page prints on only one page.

Insert a footer with your name on the left side, the date code in the center, and the file name on the right side.

Health & Fitness Gym
Date Prepared:	2018-03-28
Client	Membership	Cost	Locker	Annual Total	Years	Total Due	Down Payment	Balance	Monthly Payment
Andrews	Deluxe	575	Yes	$ 650	1	$ 650	250	$ 400	$33.34
Baker	Individual	300	Yes	$ 375	2	$ 750	150	$ 600	$25.01
Carter	Family	1500	No	$ 1,500	3	$ 4,500	700	$ 3,800	$105.65
Dudley	Deluxe	575	No	$ 575	2	$ 1,150	250	$ 900	$37.52
Evans	Deluxe	575	Yes	$ 650	3	$ 1,950	250	$ 1,700	$47.26
Foust	Individual	300	No	$ 300	1	$ 300	150	$ 150	$12.50
Gardner	Individual	300	No	$ 300	2	$ 600	150	$ 450	$18.76
Hart	Individual	300	No	$ 300	3	$ 900	150	$ 750	$20.85
Ivans	Individual	300	Yes	$ 375	3	$ 1,125	150	$ 975	$27.11
Totals
Membership	Cost	Down Payment		Summary Statistics
Deluxe	$ 575	$ 250		Number of New Members
Family	$ 1,500	$ 700		Lowest Monthly Payment
Individual	$ 300	$ 150		Average Monthly Payment
				Maxium Monthly Payment
Locker Fee	$ 75			Median Monthly Payment
Interest Rate	5.75%
Months Per Year	12