Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 measurements

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Healthcare Finance An Introduction To Accounting And Financial Management

Authors: Louis Gapenski

1st Edition

1567930905, 978-1567930900

More Books

Students also viewed these Finance questions