31. Assume that you are interested in acquiring a retail power center leased to Office Depot...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
31. Assume that you are interested in acquiring a retail power center leased to Office Depot and Best Buy for $83M. If you anticipate placing a $51.5M loan on this asset at closing and assume a 30 year amortization, 10 year term and 4.5% interest rate. Assume an exit cap rate of 6% (6pts) Year NOI Cap Exp NCE 1 3 10 $5.00 $5.10 55.28 $5.44 $5.71 $5.94 $6.06 $6.18 16.25 (50.83) (305) (3033) (30.91) (3095) (3099) ($1.01) (31.03) ($1.04) (31.04) 54.25 $4.40 $4.53 $4.76 $4.95 $5.05 $5.35 $5.21 a. What is the leveraged 10-year IRR assuming the cash flows above represent your underwriting? b. At what interest rate does the leverage become negative, everything else equal? 11 3627 ($1.00) 31. Assume that you are interested in acquiring a retail power center leased to Office Depot and Best Buy for $83M. If you anticipate placing a $51.5M loan on this asset at closing and assume a 30 year amortization, 10 year term and 4.5% interest rate. Assume an exit cap rate of 6% (6pts) Year NOI Cap Exp NCE 1 3 10 $5.00 $5.10 55.28 $5.44 $5.71 $5.94 $6.06 $6.18 16.25 (50.83) (305) (3033) (30.91) (3095) (3099) ($1.01) (31.03) ($1.04) (31.04) 54.25 $4.40 $4.53 $4.76 $4.95 $5.05 $5.35 $5.21 a. What is the leveraged 10-year IRR assuming the cash flows above represent your underwriting? b. At what interest rate does the leverage become negative, everything else equal? 11 3627 ($1.00)
Expert Answer:
Answer rating: 100% (QA)
Year NOI Loan Payment NCF 1 500 3356 8356 2 510 3356 8456 3 3528 3356 38636 4 3544 3356 38796 5 3571 ... View the full answer
Related Book For
Financial Accounting
ISBN: 978-1259103285
5th Canadian edition
Authors: Robert Libby, Patricia Libby, Daniel Short, George Kanaan, M
Posted Date:
Students also viewed these business writing questions
-
run a correlation between the resting and after exercising heart rates to determine if a linear relationship exists between the two variables and how strong the relationship is. Steps Open the Heart...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
A marketing researcher wants to estimate the mean amount spent per year ($) on a web site by membership member shoppers. Suppose a random sample of 150 membership member shoppers who recently made a...
-
Apply a five forces analysis. How would you describe Genentech's competitive position?
-
Assume that the equation of state for a certain fluid is given as g = g - (T,P) (for example, this is the case for the IF97 equation of state, but it has also been applied for mixture equations of...
-
Abbott, Inc., plans to issue \(\$ 500,000\) of ten percent bonds that will pay interest semiannually and mature in five years. Assume that the effective interest rate is 12 percent per year...
-
Given the following information regarding a project concerning an initial public offering (IPO), (a) Draw the network. (b) What is the critical path? (c) When will the offering be available...
-
Which of Cervero's 4 positions relative to the interaction between knowledge and practice is based on the idea that theory/knowledge and practice cannot be separated, one informs the other. first...
-
Oswego Clay Pipe Company provides services of $ 5 0 , 0 0 0 to Southeast Water District # 4 5 on April 1 2 of the current year with terms 1 / 1 5 , n / 6 0 . What would Oswego record on April 1 2 ?...
-
How do forward interest rate contracts and interest rate swaps facilitate risk management for corporations and financial institutions, and what impact do these derivative instruments have on overall...
-
Q1. Explain the role of accounting information in strategic management. How does accounting information assist in the formulation and implementation of organizational strategies? Support your answer...
-
Critics refer to them as benevolent paternalism because they argue they force people to eat their vegetables by restricting the freedom to choose. For example, several cities, including New York and...
-
What is financial planning? List the main steps involved in a financial planning process.
-
List the four main concerns of bank asset management.
-
How can you take the material discussed thus far in this class and apply it to a current or future job? Describe one way in which you could use what you have learned.
-
When the concentration of a strong acid is not substantially higher than 1.0 10-7 M, the ionization of water must be taken into account in the calculation of the solution's pH. (a) Derive an...
-
On January 1, 2015, Wong Corporation signed a mortgage note for $ 5,000,000 at 8 percent for a term of five years. Mortgage payments are made semi- annually on June 30 and on December 31. Each...
-
The following are several December 31, 2011, account balances (in millions of dollars) from a recent annual report of Canada Post Corporation, followed by several typical transactions. The...
-
Cardons Boat Yard Inc. repairs, stores, and cleans boats for customers. It is completing the accounting process for the year just ended on November 30, 2015. The transactions during 2015 have been...
-
A job requires ten stages of work. The completion times for each are in the table below. Also listed in the table is the information of which stages cannot begin until other stages are complete,...
-
A large computer program is to be tested and debugged in modules, some of which require other modules to be completely tested before testing on them can proceed. The table below shows the...
-
Finish the proof of Theorem 2 by showing assertion 2: If \((u, v)\) is an omitted edge and \(S(u, v)=0\), then the spanning tree created by substituting \((u, v)\) for the edge \(\left(u_{0}, v...
Study smarter with the SolutionInn App