Please see the attachments for the case study, and for the Excel spreadsheet. I am trying to answer this following question:

7) Return to baseline assumptions. GBF will probably obtain a $1,500,000 simple interest loan from its

bank at a cost of either 7 or 9 percent that it would use to leverage the lease. Should the lessor take the

loan if the interest rate is 7 percent? Should the lessor take the loan if the interest rate is 9 percent?

Justify your answer.