show all the work step by step and show the formula. show in Excel as well

You are a loan officer at an NYC investment Bank. You have been asked to review and make a Pre NC NE Homework #11 w Question #1: recommendation on accepting or rejecting a loan application. Lending Assumptions: 10 Year T-Bill Rate: .764 300 Bps Bank Loan Mark-up: Term-Years 10 30 Amortization: Years Loan Type: Balloon DSCR: 1.2 LTV: 70% Property Acquisition Details: 5.05% Asking Price: Cap Rate: Cash Flow: $72,000 Please answer the following 3 Questions: -How much would the bank loan his company? -What would the annual payment be? -Should the bank approve this loan application