Questions 25 points (CHAPTER 12) Find the missing cash flows in the following accrual loan problem Orlando Investments is buying an office building in Orlando, FL Buildings asking price: $2.000.000 The company is planning to accept the asking price and take a loan with an LTV of 72 The company is estimating the first year's net operating income to be $250.000 The lender is willing to offer an accrualloan to the investor with a 14 annual accrual rate. The lender requires a 10 first year's debt coverage ratio. The lender also requires that the payments on the loan are made monthly The lender also requires that the 2nd year's loan payment is 10% higher than the 1st year's loan payment in the missing numbers Round to whole dollar. Put negative signs, where necessary, Do NOT put the sign. As way, in order to avoid round it might be to be De and use correct cell referencia Year 1 Year Beginning loan balance 1,440,000 1,46456 Total loan payment to higher than Year 1 loan payment Interest Dayment 202137 Principal payment nding loan balance Questions 25 points (CHAPTER 12) Find the missing cash flows in the following accrual loan problem Orlando Investments is buying an office building in Orlando, FL Buildings asking price: $2.000.000 The company is planning to accept the asking price and take a loan with an LTV of 72 The company is estimating the first year's net operating income to be $250.000 The lender is willing to offer an accrualloan to the investor with a 14 annual accrual rate. The lender requires a 10 first year's debt coverage ratio. The lender also requires that the payments on the loan are made monthly The lender also requires that the 2nd year's loan payment is 10% higher than the 1st year's loan payment in the missing numbers Round to whole dollar. Put negative signs, where necessary, Do NOT put the sign. As way, in order to avoid round it might be to be De and use correct cell referencia Year 1 Year Beginning loan balance 1,440,000 1,46456 Total loan payment to higher than Year 1 loan payment Interest Dayment 202137 Principal payment nding loan balance