Please using the goal seek function, show the excel step by step in what data you added in the goal seek function

and also respond to the identification of decision variables, external variables, policies and restrictions and performance measurements.

1. Use goal seek function in excel Loan Model Unit Monthly rent 1 2 3 4 5 You are a Bank Analyst who works in the Corporate Department. Your boss has assigned you a new client, a construction company, that is requesting a loan. The term of the loan is 180 months, the rate is 8%. The company, a project developer, is requesting the money to build an additional building and is going to use the rent money coming in from actual tenants to pay the new loan. Your bank has agreed to this but has set the limit of responsibility from rent money to 80% (that is the value of the monthly payment cannot be higher than 80% of rent) Using the information on the table. $13 755 $27 905 $11 447 $23 580 $23 580 $26 708 $13 355 $26 526 $13 355 6 7 8 . 9 Build a model to calculate the amount of the loan and the value of the monthly payment Additionally identify: Decision variables External variables Policies and restrictions Performance measurements 1. Use goal seek function in excel Loan Model Unit Monthly rent 1 2 3 4 5 You are a Bank Analyst who works in the Corporate Department. Your boss has assigned you a new client, a construction company, that is requesting a loan. The term of the loan is 180 months, the rate is 8%. The company, a project developer, is requesting the money to build an additional building and is going to use the rent money coming in from actual tenants to pay the new loan. Your bank has agreed to this but has set the limit of responsibility from rent money to 80% (that is the value of the monthly payment cannot be higher than 80% of rent) Using the information on the table. $13 755 $27 905 $11 447 $23 580 $23 580 $26 708 $13 355 $26 526 $13 355 6 7 8 . 9 Build a model to calculate the amount of the loan and the value of the monthly payment Additionally identify: Decision variables External variables Policies and restrictions Performance measurements