You have a $1000 to invest with a 10-year horizon and are comparing investing in a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have a $1000 to invest with a 10-year horizon and are comparing investing in a 10-year bond (that has equal risk to the real estate considerations), and unlevered and levered real estate. The bond pays 8% annual coupon. Your buildings provide an NOI of $80 and you expect to buy and sell your buildings for $1000, with no acquisition or selling expense. You are in a 43.4% marginal tax bracket, with a 28.8% depreciation recapture rate and a 23.8% capital gains tax rate. You can take a 30-year straight line depreciation on the buildings (valued at $800 each) and not depreciate the $200 land value. You can get bullet loans for 75% LTV at 5% for 10 years. No PALL's are allowed. Complete the following table of cash flows that will provide the IRR noted. Summarize you computations in appended table. Answer the noted questions after completing you computations. Bond PreTax Post Tax -1000 Unlevered Bldg PreTax 4.5% 0 1 2 3 4 5 6 7 8 9 10 IRR 8.0% Sum of AT CF's What is the Effective Tax Rate for each of these investments? (Show computations for each) -1000 Post Tax 8.0% 4 Levered Bldgs PreTax Post Tax -1000 5.1% 17% 12.5% For this example, what makes the unlevered CRE investment favorable from a tax point of view compared to bonds? How does the leveraged RE further lower the effective tax rate? Using the intuition developed from above answer the following. If rather than a bullet loan, the bank offered only a fully amortizing 10 year loan, also at 5%, would the ATIRR be higher or lower? Why? Would the effective tax rate be higher or lower? Why? Use this table for completing computations for the real estate investment NOI - Mortgage PMT = BTCF - Tax Amount = ATCF NOI - Interest - Depreciation = Taxable Income Tax Rate Tax Amount Sales Price - Mortgage Payoff = BTCF from Sale - Tax on Sale = ATCF on Sale Sales Price - Adjusted Basis = Gain on Sale Depreciation Recapture Dep Recap Tax Capital Gain Capital Gain Tax Tax on Sale You have a $1000 to invest with a 10-year horizon and are comparing investing in a 10-year bond (that has equal risk to the real estate considerations), and unlevered and levered real estate. The bond pays 8% annual coupon. Your buildings provide an NOI of $80 and you expect to buy and sell your buildings for $1000, with no acquisition or selling expense. You are in a 43.4% marginal tax bracket, with a 28.8% depreciation recapture rate and a 23.8% capital gains tax rate. You can take a 30-year straight line depreciation on the buildings (valued at $800 each) and not depreciate the $200 land value. You can get bullet loans for 75% LTV at 5% for 10 years. No PALL's are allowed. Complete the following table of cash flows that will provide the IRR noted. Summarize you computations in appended table. Answer the noted questions after completing you computations. Bond PreTax Post Tax -1000 Unlevered Bldg PreTax 4.5% 0 1 2 3 4 5 6 7 8 9 10 IRR 8.0% Sum of AT CF's What is the Effective Tax Rate for each of these investments? (Show computations for each) -1000 Post Tax 8.0% 4 Levered Bldgs PreTax Post Tax -1000 5.1% 17% 12.5% For this example, what makes the unlevered CRE investment favorable from a tax point of view compared to bonds? How does the leveraged RE further lower the effective tax rate? Using the intuition developed from above answer the following. If rather than a bullet loan, the bank offered only a fully amortizing 10 year loan, also at 5%, would the ATIRR be higher or lower? Why? Would the effective tax rate be higher or lower? Why? Use this table for completing computations for the real estate investment NOI - Mortgage PMT = BTCF - Tax Amount = ATCF NOI - Interest - Depreciation = Taxable Income Tax Rate Tax Amount Sales Price - Mortgage Payoff = BTCF from Sale - Tax on Sale = ATCF on Sale Sales Price - Adjusted Basis = Gain on Sale Depreciation Recapture Dep Recap Tax Capital Gain Capital Gain Tax Tax on Sale
Expert Answer:
Answer rating: 100% (QA)
It appears youre presenting a financial analysis scenario with various investment options and tax co... View the full answer
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date:
Students also viewed these banking questions
-
A bond has 8 years to maturity, pays annual coupons of $110, and has a par value of $1,000. Estimate the bond's market price if its yield to maturity is 5.00%.
-
A bond you are interested in pays an annual coupon of 4 percent, has a yield to maturity of 6 percent and has 13 years to maturity. If interest rates remain unchanged, at what price would you expect...
-
A coupon bond with face value $100, pays out annual coupons of $19. The present value is 132. The yield is 30%. With a strike price of 134, what would be the present value of a put option on this...
-
Solve the Given Requirements by using this Equation: Tangent Lines and Derivatives. x + cos y = 1 a) Find dy b) Evaluate at dx c) Draw the tangent line at 35 1 y = 0 -1 -2 05 1.5 d) Write the...
-
What three conclusions about control risk can be reached based on internal control evaluation? What are the implications of each on the audit approach selected?
-
Assume that we have a lamp that has a radiance of \(95 \mathrm{~W} /\left(\mathrm{cm}^{2} \mathrm{sr}ight)\) at \(\lambda=546 \mathrm{~nm}\). What is the radiance of a \(1 \mathrm{~W}\) Argon laser...
-
In 2015, the city of San Francisco enacted an ordinance that required health warnings on advertisements for certain sugar-sweetened beverages (SSBs) that read: WARNING: Drinking beverages with added...
-
(EPS with Complex Capital Structure) Amy Dyken, controller at Fitzgerald Pharmaceutical Industries, a public company, is currently preparing the calculation for basic and diluted earnings per share...
-
Provide an example of a command for these statement types - data definition language, data manipulation language, and data control language ?
-
Fitz Products Inc. reported $1,075,049 profit in 2023 and declared preferred dividends of $75,100. The following changes in common shares outstanding occurred during the year. Jan. 1 78,000 common...
-
Skipper Company manufactures toy boats and uses an activity-based costing system. The following information is provided for the month of May. Estimated Quantity of Allocation Base 5.000 parts 5.000...
-
How do organizations cultivate a culture of innovation that fosters creativity, experimentation, and risk-taking, while also maintaining alignment with strategic objectives and operational efficiency?
-
Which step of the AMPS model most appropriately addresses the axiom, Your data won t speak unless you ask it the right data analytics questions ? Explain.
-
ABC Company divided all of its costs and expenses into fixed and variable. Data for ABC Co's first year of operations is as follows: Beginning inventory of finished goods 0 Units produced (no WIP)...
-
Define and discuss 2 different types of adoptions estated in the state of Massachusetts. Why is it important to have different types of adoptions in family law? Should access to adoption records be...
-
A completely mixed activated sludge process is designed for 50,000 PE. The design parameters are as follows: Volume of aeration tank Solids Retention Time (SRT) Sludge concentration in aeration tank...
-
The payoffs in the table above, read as (A,B) a) Does A have a dominant strategy? Explain b) Does B have a dominant strategy? Explain c) What's the Nash equilibrium for this game? Explain
-
5. Convert the following ERD to a relational model. SEATING RTABLE Seating ID Nbr of Guests Start TimeDate End TimeDate RTable Nbr RTable Nbr of Seats RTable Rating Uses EMPLOYEE Employee ID Emp...
-
Consider a repeated version of the game in exercise 24.5. In this version, we do not give all the proposal power to one person but rather imagine that the players are bargaining by making different...
-
One of the most famous games treated in early game theory courses is known as the Battle of the Sexes and it bears close resemblance to the game in which you and I choose sides of the street when...
-
Consider again the end-of-chapter problem 8.9 about the impact of international trade on child labor in the developing world. A: Suppose again that households have non-child income Y , that children...
-
On November 15, 20X3, Chow Inc., a U.S. company, ordered merchandise FOB shipping point from a German company for 200,000. The merchandise was shipped and invoiced on December 10, 20X3. Chow paid the...
-
On April 8, 20X3, Trul Corporation purchased merchandise from an unaffiliated foreign company for 10,000 units of the foreign companys local currency. Trul paid the bill in full on March 1, 20X4,...
-
On September 1, 20X1, Cott Corporation received an order for equipment from a foreign customer for 300,000 LCUs when the U.S. dollar equivalent was $96,000. Cott shipped the equipment on October 15,...
Study smarter with the SolutionInn App