I know that I have done something wrong here but I don't know what I am missing. Can you go through the instructions attachment and then solve the actual worksheet?

Ofce 2013 – myitlab:grader – InstructionsExploring Excel Ch. 06 - A1 ProjectWhat-If AnalysisProject Description:You are budgeting for the purchase of a new automobile. You are evaluating your expenses todetermine the monetary resources available for a monthly payment. As part of the project you willperform What-IF Analysis and complete an amortization schedule.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Download and open the ²le namedexploring_e06_grader_a1.xlsx, and then savethe ²le asexploring_e06_grader_a1_LastFirst, replacingLastFirstwith yourname.02Use Goal Seek to set the monthly payment o± the auto loan to$304.69(15% o±available capital) by changing the purchase price in cell E4.Beginning in cell G3, complete the series o± loan amount values ranging ±rom$16,000to$30,000in$500increments in cells G3:G31.53Enter re±erences ±or monthly payment, percent o± total, and insurance premium inthe cell H2, cell I2, cell J2 respectively ±or a one-variable data table.74Complete the one-variable data table using Amount o± Loan as the column inputcell, and then ensure the results ±or monthly payment and insurance premium are±ormatted as Accounting Number Format with two decimal places. Format percento± available income as Percentage Number Format with zero decimal places.45Apply custom number ±ormats to make the ±ormula re±erences appear as the±ollowing descriptive column headings: H2-Monthly Payment, I2-% of AvailableIncome, J2-Insurance Premium.46Copy the loan amount values ±rom the one-variable table (range G3:G31) into thetwo-variable table starting in cell L3.57Type3.00%into cell M2. Complete the series ±rom3.00%to4.25%using.25%increments through R2.58Enter the re±erence to the monthly payment ±ormula in the cell L2 ±or a two-variable data table.59Complete the two-variable data table using cell E7 as the row input cell and E6 asthe column input cell , and then ±ormat the results with Accounting Number Formatwith two decimal places.10Updated: 07/18/20131E_CH06_EXPV2_A1_Instructions.docx

 

Attachments:

• 1494041648-E_CH06_EXPV2_A1_Instructions.docx
• 1494041648-exploring_e06_grader_a1_MayvilleKarlie.xlsx