Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. 4) assuming the following data, determine the foll

4) Assuming the following data, determine the following: You can purchase an office building for...

90.2K

Verified Solution

Question

Accounting

image
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 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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students