Question: I need the right answer in clear hand writing Find the missing cash flows in the following accrual loan problem! Orlando Investments is buying an

I need the right answer in clear hand writing

I need the right answer in clear hand writing Find the missing

Find the missing cash flows in the following accrual loan problem! Orlando Investments is buying an office building in Orlando, FL. . Building's asking price: $2,800,000. The company is planning to accept the asking price and take a loan with an LTV of 80%. The company is estimating the first year's net operating income to be $350.000 The lender is willing to offer an accrual loan to the investor, with a 13% annual accrual rate. The lender requires a 1.45 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 table below, fill in the missing numbers for the investor who's taking the loan! Round to whole dollar. taking the loan! Round to whole dollar. Put negative signs, where necessary. Do NOT put the "$" sign. As always, in order to avoid rounding errors it might be best to build this table in Excel and use correct cell referencing. Year 1 Year 2 Beginning loan balance 2.240.000 Total loan 10% higher than Year 1's loan payment payment Interest payment 294,278 300.089 Principal payment -52,899 Ending loan balance 2,292,899 Find the missing cash flows in the following accrual loan problem! Orlando Investments is buying an office building in Orlando, FL. . Building's asking price: $2,800,000. The company is planning to accept the asking price and take a loan with an LTV of 80%. The company is estimating the first year's net operating income to be $350.000 The lender is willing to offer an accrual loan to the investor, with a 13% annual accrual rate. The lender requires a 1.45 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 table below, fill in the missing numbers for the investor who's taking the loan! Round to whole dollar. taking the loan! Round to whole dollar. Put negative signs, where necessary. Do NOT put the "$" sign. As always, in order to avoid rounding errors it might be best to build this table in Excel and use correct cell referencing. Year 1 Year 2 Beginning loan balance 2.240.000 Total loan 10% higher than Year 1's loan payment payment Interest payment 294,278 300.089 Principal payment -52,899 Ending loan balance 2,292,899

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!