Please help by giving the formulas and the answers

Buff and Tuff GymDate Prepared:10/6/2015ClientMembershipCostLockerAnnual Total YearsTotal Due Down Payment Balance onthly PaymentAndrewsDeluxe$575 Yes$65010BakerIndividual$300 Yes$3752Err:522CarterFamily$1,500 No$1,5003Err:522DudleyDeluxe$575 No$5752Err:522EvansDeluxe$575 Yes$6503Err:522FoustIndividual$300 No$3001Err:522GardnerIndividual$300 No$3002Err:522HartIndividual$300 No$3003Err:522IvansIndividual$300 Yes$3753Err:522Totals$4,725$5,025MembershipCostown PaymentSummary StatisticsDeluxe$575 $250Number of New MembersFamily$1,500 $700Lowest Monthly PaymentIndividual$300 $150Average Monthly PaymentMaxium Monthly PaymentLocker Fee$75Median Monthly PaymentInterest Rate5.75%Months Per Year12

CMP 117Exploring - Excel Chapter 2: Homework Project 1P a g e1 | 2Formulas and FunctionsProject Description:DUE TUESDAY SEPTEMBER 22, 2015 Before ClassUpload assignment Excel Sheet upon completion. How ? Go to Blackboard, open course link, openAssignment link. In Submission area, upload excel sheet.In the following project, you will perform preliminary work on the gym worksheet. You will then calculate cost,annual total, and total due. You will also determine the down payment and balance of gym membership. Yourlast steps will be to calculate the monthly payment and finalized the workbook.Instructions:For the purpose of grading the project you are required to perform the following tasks:StepInstructionsPointsPossible1Download and open the file namedcmp117_hw1.xlsx, and then save the file ascmp117_h1_LastFirst. Click OK in the message regarding the circular reference.Where LastFirst is your Lastname Firstname (Capitalize first initial letter in both)22Insert a function to enter the current date in cell B2.53In Column C from C5 to C13 Type in the appropriate Cost, depending on whether Membershiptype is Deluxe, Family, or Individual.54Insert a function in cell E5 to calculate total amount. The function should add the Cost ofmembership plus the locker fee. The locker fee is found in B22.75In cell G5 Calculate the total due based on the annual total and years of membership incolumn F.56Copy the formula in E and G down their respective columns.57In Column H from H5 to H13 Type in the appropriate Down Payment, depending on whetherMembership type is Deluxe, Family, or Individual.58Locate and correct the circular reference for the balance in cell I5. The balance should becalculated as the difference between total due and the down payment.79Copy the formula in I down the column.5

Attachments:

• 1496035095-cmp117_H1_McQuadeJohn.xlsx
• 1496035097-CMP117_HW1_instructions.pdf