Question

In: Finance

The Rose Hall Resort Ltd. is in the 34% tax bracket with a 15 percent required...

The Rose Hall Resort Ltd. is in the 34% tax bracket with a 15 percent required rate of return (or cost of capital) and is considering a new project. This project involves the acquisition of a portfolio of 4 boutique hotels at a cost of $62,016,176.

Use the data below to calculate the project’s:  

  • Payback
  • NPV
  • PI
  • IRR

                                     Year 1              Year 2              Year 3              Year 4                Year 5v

Gross Profit             $23,700,000     $30,900,000     $38,100,000     $23,700,000     $16,900,000

Depreciation               4,240,000          4,240,000         4,240,000         4,240,000        4,240,000

EBT                          19,460,000       26,660,000       33,860,000       19,460,000       12,660,000

Less: Taxes                  6,616,400         9,064,400       11,512,000         6,616,400         4,304,400

Net Income                12,843,600       17,595,600       22,348,000       12,843,600         8,355,600

Solutions

Expert Solution

We can calculate the desired results in Excel sheet as follows

Formulas used in the excel sheet are

So the Answer are

Payback = 2.87 years

NPV = $ 2,861,601

PI = 5% ( 4.61% Rounded to 2 decimal places )

IRR = 17%

Hope I am able to solve your concern. If you are satisfied hit a thumbs up !!

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

The Dolphin Corporation, a firm in the 40 percent marginal tax bracket with a 9 percent...
The Dolphin Corporation, a firm in the 40 percent marginal tax bracket with a 9 percent cost of capital, is considering a new project. This project involves the introduction of a new product. This project is expected to last 4 years and then to be terminated. Cost of new plant and equipment is $990,000. Shipping and installation costs are $10,000. The company needs to increase its working capital requirement. There will be an initial inventory requirement of $15,000 just to...
The Dolphin Corporation, a firm in the 40 percent marginal tax bracket with a 9 percent...
The Dolphin Corporation, a firm in the 40 percent marginal tax bracket with a 9 percent cost of capital, is considering a new project. This project involves the introduction of a new product. This project is expected to last 4 years and then to be terminated. Cost of new plant and equipment is $990,000. Shipping and installation costs are $10,000. The company needs to increase its working capital requirement. There will be an initial inventory requirement of $15,000 just to...
If Isabella Rodriguez is single and in the 35 percent tax bracket, calculate the tax associated...
If Isabella Rodriguez is single and in the 35 percent tax bracket, calculate the tax associated with each of the following transactions. (Hint: Use the IRS regulations for capital gains in effect in 2018.) Treat each of the following cases as independent of the others. Tax savings should be preceded by a "-" sign. Round the answers to the nearest cent. She sold stock for $3,930 that she purchased for $3,000 4 months earlier. $ _____ She sold bonds for...
Terrier Company is in a 40 percent tax bracket and has a bondoutstanding that yields...
Terrier Company is in a 40 percent tax bracket and has a bond outstanding that yields 10 percent to maturity.a. What is Terrier’s aftertax cost of debt?(Do not round intermediate calculations. Input your answer as a percent rounded to 2 decimal places.)  b. Assume that the yield on the bond goes down by 1 percentage point, and due to tax reform, the corporate tax rate falls to 25 percent. What is Terrier’s new aftertax cost of debt? (Do not round intermediate...
Dahlia is in the 32 percent tax rate bracket and has purchased the following shares of...
Dahlia is in the 32 percent tax rate bracket and has purchased the following shares of Microsoft common stock over the years: Date Purchased Shares Basis 7/10/2008 480 $ 18,240 4/20/2009 380 16,644 1/29/2010 580 18,328 11/02/2012 330 12,276 If Dahlia sells 1,040 shares of Microsoft for $60,320 on December 20, 2018, what is her capital gain or loss in each of the following assumptions? (Do not round intermediate calculations.) b. She uses the specific identification method and she wants...
Grayson is in the 24 percent tax rate bracket and has sold the following stocks in...
Grayson is in the 24 percent tax rate bracket and has sold the following stocks in 2018: (Loss amounts should be indicated by a minus sign.) Description Date Purchased Basis Date Sold Amount Realized Stock A 1/23/1994 $ 8,000 7/22/2018 $ 5,100 Stock B 4/10/2018 15,500 9/13/2018 19,330 Stock C 8/23/2016 12,625 10/12/2018 17,850 Stock D 5/19/2008 5,830 10/12/2018 13,525 Stock E 8/20/2018 7,825 11/14/2018 3,875 a. What is Grayson’s net short-term capital gain or loss from these transactions? b....
Assume the stockholders of Colorado Springs stock are in the 25 percent tax bracket. The closing...
Assume the stockholders of Colorado Springs stock are in the 25 percent tax bracket. The closing price of the stock today was $42.80 a share. The firm pays a quarterly dividend of $1.00 per share. What is the expected opening price of the stock tomorrow if tomorrow is an ex-dividend date? $35.78 $38.91 $42.05 $46.65 $51.23
Grayson is in the 24 percent tax rate bracket and has the sold the following stocks...
Grayson is in the 24 percent tax rate bracket and has the sold the following stocks in 2018: Date Purchased Basis Date Sold Amount Realized Stock A 1/23/1995 $7,250 7/22/2019 $4,500 Stock B 4/10/2019 14,000 9/13/2019 17,500 Stock C 8/23/2017 10,750 10/12/2019 15,300 Stock D 5/19/2009 5,230 10/12/2019 12,400 Stock E 8/20/2019 7,300 11/14/2019 3,500 What is Grayson’s net short-term capital gain or loss from these transactions? What is Grayson’s net long-term gain or loss from these transactions? What is...
1a.An investor is in the 28 percent federal tax bracket. For this investor, a municipal bond...
1a.An investor is in the 28 percent federal tax bracket. For this investor, a municipal bond paying 4 percent interest is equivalent to a corporate bond paying ________ interest. A. 11.79 percent B. 10.17 percent C. 9.08 percent D. 9.68 percent E. 5.56 percent 1b. Which of the following situations would require a decrease in the coupon rate for a bond selling at par? A. The addition of a call provision B. The addition of a convertibility option C. The...
Dahlia is in the 32 percent tax rate bracket and has purchased the following shares of...
Dahlia is in the 32 percent tax rate bracket and has purchased the following shares of Microsoft common stock over the years: Microsoft common stock Date Purchased Shares Basis 7/10/2008 400 $10,000 4/20/2009 300 $11,000 1/29/2010 500 $12,230 11/02/2012 250 $7,300 If Dahlia sells 800 shares of Microsoft for $40,000 on December 20, 2020, what is her capital gain or loss if she uses the FIFO method? Dahlia is in the 32 percent tax rate bracket and has purchased the...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT