Question

In: Finance

You will be purchasing a $4,000,000 retail center Bear Avenue. The projected annual NOI is $300,000....

You will be purchasing a $4,000,000 retail center Bear Avenue. The projected annual NOI is $300,000. Your lender will only give you $3,100,000 to finance the purchase. What is the implied minimum DSCR given the following information (rounded to 2 decimal places)? 75% LTV 4.50% rate (monthly compounding) 10 year loan term 30 year amortization

Solutions

Expert Solution

Purchased Price $4,000,000.00
LTV 75.00%
Loan Value = $4000000 x75% $3,000,000.00
Rate 4.50%
Loan $3,000,000.00
Effective Loan rate = Effect(4.50%,12) 4.59%
Period 30
Annual Payment = Debt Service = PMT(4.59%,30,-3000000) $186,216.28
DCR = NOI/ Debt Service
DCR = $300,000/$186,216.28 1.61 times

Related Solutions

Bohemian Apartments can be purchased for $655,000 with initial annual NOI $60,900 that is projected to...
Bohemian Apartments can be purchased for $655,000 with initial annual NOI $60,900 that is projected to grow 2.5% annually. Evaluation of the project must be completed using a discount rate of 9%. The loan used in the purchase shall be at 70% LTV, a 5.50% annual interest rate and a 30 year term. Closing costs shall be 3% and cost of sale 6.5%. Project the cash flows for a 5 year hold and determine the NPV of the project and...
Kimberly has a retail clothing store that makes a net operating income (NOI) of $300,000. She...
Kimberly has a retail clothing store that makes a net operating income (NOI) of $300,000. She originally purchased the property for $2,500,000 and places $500 a month into escrow for replacement reserves. She estimates the land value to be $400,000. She received a mortgage for $1,625,000. The payments each month include principal and interest during year 2 of $45,909 and $88,229 and during year 1 of $56,843 and $99,651 respectively. What is the depreciation for year 1 and 2?
You are interested in purchasing an apartment complex for $2,000,000 that has Net Operating Income (NOI)...
You are interested in purchasing an apartment complex for $2,000,000 that has Net Operating Income (NOI) of $120,000 and is financed with an 80% LTV mortgage at 4% 1. What is the Cap Rate? 2. What is the ROA? 3. What is the leverage ratio? 4. Approximate the ROE
assume that you reached retirement, you have accumlated a 4,000,000 nest. Assume you live on 300,000...
assume that you reached retirement, you have accumlated a 4,000,000 nest. Assume you live on 300,000 per year and you only earn 4% per year. How many years will you run out of money? show work
You purchase a fully-occupied shopping center for $5,000,000. The NOI is $750,000. The property has no...
You purchase a fully-occupied shopping center for $5,000,000. The NOI is $750,000. The property has no debt. You are considering obtaining debt in order to maximize your return. If a Lender is willing to provide a loan at a 75% LTV, 3.00% rate and 20-year amortization schedule, what is your: (a) Unlevered Return, and (b) Levered Return?
You have an opportunity to buy an office building for $125,000 that produces an annual NOI...
You have an opportunity to buy an office building for $125,000 that produces an annual NOI of $10,000. You can obtain an 80% loan from a bank with a 7% interest rate and amortized for 30 years. Your required investor cash on cash return is 12%. You will have to put 20% of the purchase down. What is the value of the office building? A. $140,999 B. $118,242 C. $113,895 D. $125,000
You are considering purchasing a home that requires $300,000 mortgage at 5.25%. The payment on the...
You are considering purchasing a home that requires $300,000 mortgage at 5.25%. The payment on the 30 year mortgage for this amount is $1656.61 per month, the payment for a 15 year maturity is $2411.63 per month. A) What is the total amount that you would pay for the 30 year mortgage, including interest? B) What is the total amount that you would pay for the 15 year mortgage, including interest? C) What is the difference in the total interest...
You and your spouse are considering purchasing your first new house. The house price is $300,000....
You and your spouse are considering purchasing your first new house. The house price is $300,000. You will make 10% down payment. The remaining balance can be financed with a 30 year mortgage loan with an annual interest of 6%. A. What is the monthly mortgage payments? B. How much do you need if you are to pay off the loan after 5 years (right after the 60th payment)? C. How much interest (in $) will you save from paying...
You are purchasing a company that has projected cash flows after taxes of $15,000, $18,000, $22,000,...
You are purchasing a company that has projected cash flows after taxes of $15,000, $18,000, $22,000, $35,000, and $21,000 for Years 1 through 5. In Year 3, you will incur maintenance costs of $50,000. From Years 6 through 10, you expect cash flows to be steady at $25,000 per year. At Year 10, you can sell the firm for $500,000. You will pay dividends out at a growing rate of 2% each year and you will announce a $1.50/share dividend...
You borrowed from the bank $300,000 with an annual interest rate of 6% and a maturity...
You borrowed from the bank $300,000 with an annual interest rate of 6% and a maturity of 30 years.   Determine the monthly mortgage payment.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT