Health & Fitness Gym Date Prepared Annual Toth Years Balance Locher Monthly Payment Client Andrews Membership Del Dudley Evans Total De Down Payment 10000 7500 5000 100.00 125.00 50.00 75.00 90.00 100.00 Gardner Individ Individual Individual 1228 lins Total Membership Delue Family Individual 5 Cost Down Payment 290 1.500 5 00 5 150 3 Summary Statistics Number of New Members Lowest Monthly Payment Average Monthly Payment Madum Monthly Payment Median Monthly Pavert Loder Fee Interest Rate Monthser Year 575% instructions In Call C5 Use the Vlookup function to return the cost associated with each membership. The data for the Mookup table starts in Bell A18 Copy the Vlookup function to cells C to C13 In Call Es create a formula to calculate the annual total which is the membership and the locker a Copy the formula to cel E13 In Cell G5 create a formula to calculate total due which is the annual total multiplied by the number of years Copy the formula to cell G13 In Cell 16 create a formula to calculate the balance which is the annual tot mirus the the down payment Caphy the formula to 113 in Cell use the PMT finction to calore the monty payment based on the balance and the data located in cells B.23 and 24 Use absolute cell addresses els 618-622 use the appropriate functions to return the data requested Total Points for Question One Health & Fitness Gym Date Prepared Annual Toth Years Balance Locher Monthly Payment Client Andrews Membership Del Dudley Evans Total De Down Payment 10000 7500 5000 100.00 125.00 50.00 75.00 90.00 100.00 Gardner Individ Individual Individual 1228 lins Total Membership Delue Family Individual 5 Cost Down Payment 290 1.500 5 00 5 150 3 Summary Statistics Number of New Members Lowest Monthly Payment Average Monthly Payment Madum Monthly Payment Median Monthly Pavert Loder Fee Interest Rate Monthser Year 575% instructions In Call C5 Use the Vlookup function to return the cost associated with each membership. The data for the Mookup table starts in Bell A18 Copy the Vlookup function to cells C to C13 In Call Es create a formula to calculate the annual total which is the membership and the locker a Copy the formula to cel E13 In Cell G5 create a formula to calculate total due which is the annual total multiplied by the number of years Copy the formula to cell G13 In Cell 16 create a formula to calculate the balance which is the annual tot mirus the the down payment Caphy the formula to 113 in Cell use the PMT finction to calore the monty payment based on the balance and the data located in cells B.23 and 24 Use absolute cell addresses els 618-622 use the appropriate functions to return the data requested Total Points for Question One