Excel hw

maj94id
Edited.xlsx

New Clients

Health & Fitness Gym
Date Prepared: 12/26/19
Client Membership Cost Locker Annual Total Years Total Due Down Payment Balance Monthly Payment
Andrews Deluxe 575 Yes 650 1 $ 650 $ 250 $ 400 $ 34
Baker Individual 300 Yes 375 2 750 150 600 27
Carter Family 1500 No 1500 3 4,500 700 3,800 115
Dudley Deluxe 575 No 575 2 1,150 250 900 40
Evans Deluxe 575 Yes 650 3 1,950 250 1,700 52
Foust Individual 300 No 300 1 300 150 150 13
Gardner Individual 300 No 300 2 600 150 450 20
Hart Individual 300 No 300 3 900 150 750 23
Ivans Individual 300 Yes 375 3 1,125 150 975 30
Totals $ 11,925 $ 2,200 $ 9,725 $ 352
Membership Cost Down Payment Summary Statistics
Deluxe $ 575 $ 250 Number of New Members 9
Family $ 1,500 $ 700 Lowest Monthly Payment $ 12.89
Individual $ 300 $ 150 Average Monthly Payment $ 39.16
Maxium Monthly Payment $ 115.17
Locker Fee $ 75 Median Monthly Payment $ 29.55
Interest Rate 5.75%
Months Per Year 12