Assuming the following data, determine the following: You can purchase an office building for $15,000,000. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 amortized for 30 years, the annual interest rate is 4.5%. The annual NOI is $850,000. a) Determine the maximum amount of the loan based on the LTV b) Determine the monthly payment of the loan using the PMT function in excel c) Determine the DCR-Debt Coverage Ratio d) How large of a loan could you obtain using the Debt Coverage Ratio and LTV as the two factors to consider. 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 amortized for 30 years, the annual interest rate is 4.5%. The annual NOI is $850,000. a) Determine the maximum amount of the loan based on the LTV b) Determine the monthly payment of the loan using the PMT function in excel c) Determine the DCR-Debt Coverage Ratio d) How large of a loan could you obtain using the Debt Coverage Ratio and LTV as the two factors to consider.
Expert Answer:
Answer rating: 100% (QA)
Information given Office Building value LTV 1500000000 60 Debt Coverage Ratio 13 Amort... View the full answer
Related Book For
Understanding Financial Accounting
ISBN: 978-1118849385
1st Canadian Edition
Authors: Christopher Burnley, Robert Hoskin, Maureen Fizzell, Donald
Posted Date:
Students also viewed these accounting questions
-
You are considering purchasing an office building for $2,500,000. a. What is the implied first-year overall capitalization rate? b. What is the expected debt coverage ratio in year 1 of operations?...
-
You observe that the U.K. annual interest rate is 2.5 percent, the U.S. annual interest rate is 3.8 percent, the 3-month forward rate is $1.8180/, and the spot rate is $1.8034/. Assuming that...
-
The Angel Corporation acquired an office building for $600,000 12 years ago. The corporation claimed $80,000 of cost recovery deductions before it sold the building for $700,000. a. Determine the...
-
The Archaic period also gave rise to some economic, social and political cooperation, best represented by the emergence of Kingdoms Republics Tyrannies Poleis
-
Conduct a job analysis of a person you know, and write a complete job description according to the principles described in this chapter. In class, be prepared to discuss the method you used for...
-
Astronomers have discovered that, with the exception of a few nearby galaxies, all galaxies in the universe are moving away from us. Moreover, the farther the galaxy, the faster it is moving away....
-
The square plate is deformed into the shape shown by the dashed lines. If DC has a normal strain x = 0.004, DA has a normal strain y = 0.005 and at D, Y xy = 0.02 rad, determine the average normal...
-
The Smelting Department of Kiner Company has the following production data for November. Beginning work in process 2,000 units that are 100% complete as to materials and 20% complete as to conversion...
-
What are the key factors in scaling up bioprocessing operations from laboratory to industrial scale, especially regarding bioreactor design, mass transfer, and process control ?
-
Reconsider the Goferbroke Co. prototype example, including its analysis in Sec. 16.3. With the help of a consulting geologist, some historical data have been obtained that provide more precise...
-
Determine how much the thickness of the ice will change by next year if the volume is expected to reduce from 28,000 to 11,500 and the area is expected to decrease by 30%?
-
What is the prediction of the CAPM with respect to the expected return on any security? Why is the variance of a portfolio of internationally diversified stocks likely to be lower than the variance...
-
Lagoon Plc's Directors are planning to instigate the removal of its auditors, KPNG due to their inability to deliver "quality audit works". However, the Audit Manager has insisted that this move by...
-
Firms A and B are identical in their business activity. Both have following annual data: EBITDA 5,000.00; Depreciation=1,000.00 ; TAX=20% ; OWC=0 and CAPEX=1,000.00 Firm A has no debt; Firm B...
-
The Federal Reserve has dramatically expanded the monetary base over the past several years but the money supply and inflation have not been as impacted as one might think? Why?
-
Demonstrate project management techniques that you would use for the EHR transition to ensure efficient workflow and appropriate outcomes. Select at least two techniques (e.g., Gantt charts,...
-
Required: 1. Insert the following balances in the general ledger as of October 1: 14 Field Supplies 15 Office Supplies 18 Office Equipment 12,300 21 Accounts Payable 1,170 After completing the...
-
Research an article from an online source, such as The Economist, Wall Street Journal, Journal of Economic Perspectives, American Journal of Agricultural Economics, or another academic journal. The...
-
Teeds Manufacturing Corporation has the following shareholders equity at December 1, 2016: Shareholders Equity Share capital $2 preferred shares, no par value, cumulative....... 20,000 Shares...
-
Discuss why a company might pay a special dividend and how that differs from a regular dividend.
-
Explain why a company might want to split its shares.
-
Why is it important to pay attention to cultural differences when interviewing a client?
-
What does the term "unauthorized practice of law" mean, and how does it limit your relationship with a client?
-
Why is it important to acknowledge how a client is feeling at the initial interview?
Study smarter with the SolutionInn App