Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Project 4J Store Furnishings: I have already used goal seek to complete the first half, but I am lost on how to complete the
Excel Project 4J Store Furnishings: I have already used goal seek to complete the first half, but I am lost on how to complete the Payment Table. Here are the instructions and here is my work so far.
PROJECT FILES For Project 4J, you will need the following file: 04J Store_Furnishings You will save your workbook as: Lastname_Firstname 4J_Store_Furnishings Open the file e04J_Store Furnishings and save it as Lastname_Firstname_4J_ Store Furnishings Complete the Store Furnishings Loan worksheet by using Goal Seek to explore two options for reducing the loan payment to approximately $10,000-either by reducing the loan or by increasing the number of years. Complete the Payment Table worksheet by creating a data table to calculate payments over 24-60 months with varying interest rates from 6,0% to 4.0% in .5% increments. Use Note cell style to indicate acceptable options. Include the file name in the footer, add appropriate properties, and submit it as directed. Performance Level Exemplary Proficient Developing Use Financial Functions The PMT function is properly The PMT function is properly The PMT function is not properly applied using the supplied applied to some but notapplied and did not meet the criteria supplied criteria. supplied criteria. Use Goal Seek Both Goal Seek outcomes were achieved using the upplied criteria. One Goal Seek outcome was No Goal Seek outcomes were achieved using the supplied achieved using the supplied criteria. criteria. All the criteria were met in the Data Table used to calculate the loan. Some but not all the criteria The Data Table was not correctly were met in the Data Tablecalculated. used to calculate the loan. Create a Data Table PROJECT FILES For Project 4J, you will need the following file: 04J Store_Furnishings You will save your workbook as: Lastname_Firstname 4J_Store_Furnishings Open the file e04J_Store Furnishings and save it as Lastname_Firstname_4J_ Store Furnishings Complete the Store Furnishings Loan worksheet by using Goal Seek to explore two options for reducing the loan payment to approximately $10,000-either by reducing the loan or by increasing the number of years. Complete the Payment Table worksheet by creating a data table to calculate payments over 24-60 months with varying interest rates from 6,0% to 4.0% in .5% increments. Use Note cell style to indicate acceptable options. Include the file name in the footer, add appropriate properties, and submit it as directed. Performance Level Exemplary Proficient Developing Use Financial Functions The PMT function is properly The PMT function is properly The PMT function is not properly applied using the supplied applied to some but notapplied and did not meet the criteria supplied criteria. supplied criteria. Use Goal Seek Both Goal Seek outcomes were achieved using the upplied criteria. One Goal Seek outcome was No Goal Seek outcomes were achieved using the supplied achieved using the supplied criteria. criteria. All the criteria were met in the Data Table used to calculate the loan. Some but not all the criteria The Data Table was not correctly were met in the Data Tablecalculated. used to calculate the loan. Create a Data Table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started