Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me solve for the empty cells for 1. Both Tests: Max Loan About and Debt Service Payment 2. 1,400,000 down payment: Loan Amount
Please help me solve for the empty cells for
1. Both Tests: Max Loan About and Debt Service Payment
2. 1,400,000 down payment: Loan Amount and Debt Service Payment
Inputs Annual Interest Rate Minimum DSCR Maximum LTV Down Payment Asking Price NOI 2015 5.75% IO loan, 5-year balloon Income Test Maximum Annual Mortgage Payment Maximum Loan Amount $640,372.50 $11,136,913.04 1.20 95% $1,400,000.00 $11,822,261.54 $768,447.00 Collateral Test Maximum Loan Amount w/ downpayment $26,600,000.00 Both tests Maximum Loan Amount Debt Service Payment Ann makes a $1,400,000 downpayment Loan amount to buy the property Debt Service PaymentStep 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