Reference no: EM133113003
You purchased a 16,000 SF warehouse building 6 years ago for $577,000. You are considering refinancing.
Currently, rental rates average $5.25/SF. Market vacancies are 7%. The subject OER is stable around 31%. Market cap rates are now 6.5%.
Your lender has proposed refinancing. Below are the original loan terms from 6 years ago and the new proposed loan terms.
|
ORIGINAL LOAN (OLD)
|
NEW LOAN
|
|
6.5% interest rate
25-year amortization (monthly)
65% LTV ratio
Minimum 1.50 DCR
3% prepayment penalty (3% of loan balance at time of prepayment)
|
4.75% interest rate
30-year amortization (monthly)
75% LTV ratio
Minimum 1.50 DCR
|
Determine the following:
B1. What is the balance on the original loan at the end of year 6?
B2. What is the prepayment penalty for the original loan based on the balance at the end of year 6?
B3. The current NOI based on the current market terms.
B4. The current market value based on the current NOI (from B3) and current market cap rate.
B5. The maximum amount you can borrow today based on the new loan's LTV and the current market value (from B4).
B6. The new annual debt service (ADS) based on the new loan terms.
B7. What is the net disbursement for the new loan based on the max amount borrowed (from B5) and the prepayment penalty for the original/old loan (from B2)?
B8. What is the effective borrowing cost for the new loan based on the new loan terms and the net disbursement (from B7)? (Don't forget to annualize the rate.)
B9. What is the DCR for the new loan based on the current estimated NOI (from B3)?
B10. Does the property qualify for this new loan based on its current income? Why or why not?
|
Determine a reasonable price
: You're evaluating the acquisition of a competitor in your industry. The current market capitalization of the target is 125 M with a 2.5$ stock price.
|
|
Indicate the amount of increases in the accounting equation
: Pay utilities of $4,400 for the current month. Analyze each transaction and indicate the amount of increases and decreases in the accounting equation
|
|
Calculate both the capm and icapm weighted average cost
: Calculate both the CAPM and ICAPM weighted average cost of capital for the following equity risk premium estimate: 7%:
|
|
Partial disability benefit
: Under an income protection policy, Ellen Tucker, who has been disabled, is receiving $4000 a month. Ellen has made a good recovery and is now able to resume som
|
|
What is the balance on the original loan
: B1. What is the balance on the original loan at the end of year 6?
|
|
What will company report as wage expense
: What will Company report as wage expense when it records the payment of wages on Friday, 1/3/Year4? Input this as a positive number
|
|
What are the balances for the machine account
: After the adjustments are recorded and posted at December 31, Year6, what are the balances for the Machine account and the Accumulated Depreciation account
|
|
Calculate the probability of joint default
: A portfolio consists of two bonds. The bond value, default probability, and recovery rate are USD $1,000,000,1%, and 60% for one bond, and USD $400,000, 5%, and
|
|
What is the equivalent annual cost of buying
: Deutsche Transport can lease a truck for four years at a cost of €39,000 annually. It can instead buy a truck at a cost of €89,000, with annual maintenance expe
|