On the basis of the data provided at question 6, calculate your levered IRR based on ATCF. O a. 22.12% O b. 17.61% O C. 19.92 O d. 21.12%

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Please only answer practice question 10. 

Answers for question 6, 7 & 8 provided.

Please show workings/explanation.

buestion 6
The following 5 questions are based on this situation: Suppose you are considering the
acquisition of a hotel that is currently trading at $ 67 million. The current return on such
investments on the market is estimated at 10%. The investor's required rate of return is of
11%. The asset's (annual) NOI for the next 5 years [i.e. the current lease term) is $ 6,000,000.
At the end of the current lease, you expect the NOI to increase to $ 6,500,000 for the
foreseeable future. You anticipate selling the property five years from today. The building to
land value ratio is 3:1 and the depreciable life of the property is 39 years. You contacted your
banker who is willing to give you a LTV of 80%. The mortgage loan details are: 7.5% 30-year
monthly amortizing loan. The tax rates are as follows: 22% income tax, 25% depreciation
recapture tax, 20% capital gains tax. Consider straight-line depreciation. The going-in Cap
rate is 7%. 5 years later, 50bps additional risk premium should be applied to estimate the
going-out cap rate. The cost of sales( and purchase) is 3%. What is the taxable income in year
4?
$ 832,534
Oa.
O b. $ 4,093,195
$ 183,158
O d. $ 2,120,996
Transcribed Image Text:buestion 6 The following 5 questions are based on this situation: Suppose you are considering the acquisition of a hotel that is currently trading at $ 67 million. The current return on such investments on the market is estimated at 10%. The investor's required rate of return is of 11%. The asset's (annual) NOI for the next 5 years [i.e. the current lease term) is $ 6,000,000. At the end of the current lease, you expect the NOI to increase to $ 6,500,000 for the foreseeable future. You anticipate selling the property five years from today. The building to land value ratio is 3:1 and the depreciable life of the property is 39 years. You contacted your banker who is willing to give you a LTV of 80%. The mortgage loan details are: 7.5% 30-year monthly amortizing loan. The tax rates are as follows: 22% income tax, 25% depreciation recapture tax, 20% capital gains tax. Consider straight-line depreciation. The going-in Cap rate is 7%. 5 years later, 50bps additional risk premium should be applied to estimate the going-out cap rate. The cost of sales( and purchase) is 3%. What is the taxable income in year 4? $ 832,534 Oa. O b. $ 4,093,195 $ 183,158 O d. $ 2,120,996
Question 7
On the basis of the data provided at question 6, what is the overall gain during the sale of the
Not yet
property?
answered
O a.
$ 10,600,000
Ob.
$ 17,042,308
$ 23,508,974
O d. $19,422,308
Question 8
On the basis of the data provided at Question 6, how much (in $) is the capital gain tax?
answered
$ 9,123,160
O b.
$ 6,671,785
10.00
$ 3,413,333
O d. $ 1,824,632
Question 9
On the basis of the data provided at question 6, calculate your IRR based on BTCF.
Not yet
answered
a.
18.11%
O b. 25.27%
25.72%
Od.
24.17%
Question 10
On the basis of the data provided at question 6, calculate your levered IRR based on ATCF.
Not yet
answered
O a.
22.12%
Ob.
17.61%
19.92
21.12%
Transcribed Image Text:Question 7 On the basis of the data provided at question 6, what is the overall gain during the sale of the Not yet property? answered O a. $ 10,600,000 Ob. $ 17,042,308 $ 23,508,974 O d. $19,422,308 Question 8 On the basis of the data provided at Question 6, how much (in $) is the capital gain tax? answered $ 9,123,160 O b. $ 6,671,785 10.00 $ 3,413,333 O d. $ 1,824,632 Question 9 On the basis of the data provided at question 6, calculate your IRR based on BTCF. Not yet answered a. 18.11% O b. 25.27% 25.72% Od. 24.17% Question 10 On the basis of the data provided at question 6, calculate your levered IRR based on ATCF. Not yet answered O a. 22.12% Ob. 17.61% 19.92 21.12%
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

based on the above exercice - On the basis of the data provided at question 6, calculate your levered IRR based on ATCF.

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education