Question: #3 Assuming the following data, determinethe following : You can purchase a shopping centerfor $5,000,000. The bank has quoted a 65% LTV , and a

#3 Assuming the following data, determinethe
#3 Assuming the following data, determinethe following : You can purchase a shopping centerfor $5,000,000. The bank has quoted a 65% LTV , and a 1.30 DCR (Debt Coverage Ratio) .The loan would be amortized for 30 years, the annual interest rate is 7.5%. The annual NOI is $300,000. a Determine the maximum amountof the loan based on the LTV Determine the monthly payment of the loan using the PMT function in excel Determine the DCR - Debt Coverage Ratio How large of a loan could you obtain using the Debt Coverage Ratio and LTV as the two factors to consider

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 Mathematics Questions!

Q:

3) Assuming the following data, determine the following: You can purchase a shopping center for $5,000,000. The bank has quoted a 65% LTV, and a 1.30 DCR (Debt Coverage Ratio). The loan would be...

Q:

3) Assuming the following data, determine the following: You can purchase a shopping center for $5,000,000. The bank has quoted a 65% LTV, and a 1.30 DCR (Debt Coverage Ratio). The loan would be...

Q:

3) Assuming the following data, determine the following: You can purchase a shopping center for $5,000,000. The bank has quoted a 65% LTV, and a 1.30 DCR (Debt Coverage Ratio). The loan would be...

Q:

3) Assuming the following data, determine the following: You can purchase a shopping center for $5,000,000. The bank has quoted a 65% LTV, and a 1.30 DCR (Debt Coverage Ratio). The loan would be...

Q:

3) Assuming the following data, determine the following: You can purchase a shopping center for $5,000,000. The bank has quoted a 65% LTV, and a 1.30 DCR (Debt Coverage Ratio). The loan would be...

Q:

# 3 Assuming the following data, determine the following: You can purchase a shopping center for $ 5 , 0 0 0 , 0 0 0 . The bank has quoted a 6 0 % LTV , and a 1 . 2 5 DCR ( Debt Coverage Ratio ) ....

Q:

# 3 Assuming the following data, determine the following: You can purchase a shopping center for $ 5 , 0 0 0 , 0 0 0 . The bank has quoted a 6 0 % LTV , and a 1 . 2 5 DCR ( Debt Coverage Ratio ) ....

Q:

# 3 Assuming the following data, determine the following: You can purchase a shopping center for $ 5 , 0 0 0 , 0 0 0 . The bank has quoted a 6 0 % LTV , and a 1 . 2 5 DCR ( Debt Coverage Ratio ) ....

Q:

# 4 Assuming the following data, determine the following: You can purchase an office building for $ 1 5 , 0 0 0 , 0 0 0 . The bank has quoted a 6 0 % LTV , and a 1 . 3 0 DCR ( Debt Coverage Ratio ) ....

Q:

#4 Assuming the following data, determine the following: You can purchase an office building for $15,000,000. The bank has quoted a 60% LTV, and a 1.30 DCR (Debt Coverage Ratio). The loan would be...

Q:

A) What should be the amount to be invested : i) To receive Rs 2,00,000 per annum in perpetuity at an interest rate of 8 %. ii) In addition to conditions of point (i) above, if growth rate of 3% is...

Q:

Here are data for height and weight among 10 male college students. Height (cm) Weight (kg) 159 ........................ 48 162 ........................ 50 161 ........................ 52 175...

Q:

Which statement regarding top - heavy plans is CORRECT? A ) An accelerated vesting schedule is used when a defined benefit plan is top heavy. B ) For a top - heavy plan, a key employee is any...

Q:

The accompanying frequency distribution summarizes sample data consisting of ages of randomly selected inmates in federal prisons. Use the data to construct a 90% confidence interval estimate of the...