Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please could you add the step by step on excel 1. Use goal seek function in excel Loan Model Unit Monthly rent 1 2 3
Please could you add the step by step on excel
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 measurementsStep 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