Question

Use the following to answer questions 17-20 bull plans to open a dou lde bathing center in a pinent will cost $56.000. Bill s
0 0
Add a comment Improve this question Transcribed image text
Answer #1

NPV is given by:

NPV = L Rt/(1 + i) ,t varies from 1 ton where Rt = Cash flow netted (Inflow - Outflow) during the period t i = Discount rat

Now, the discount rate at which NPV = 0 is known as IRR

Answer 17)

Payback period: Time in which we will regain our initial investment

Project
Initial Investment 56,000
year Cashflow Cummulative Cashflow
1 15,000 15,000
2 15,000 30,000 (15000 + 15000)
3 15,000 45,000 (15000 + 30000)
4 15,000 60,000 (15000 + 45000)
5 15,000 75,000
6 15,000 90,000
7 15,000 1,05,000
8 15,000 1,20,000

So in year 3 we get $ 45,000 money back of the invested money $ 56000

So remaining money (56000 - 45000) = $ 11000 needs to retrieved from year 4.

Now, in year 4 we are earning $ 15000

Hence, to earn  $ 11000, it will take = $ 11000 / 15000 = 0.73 Years

Hence, total payback period = Year 3 + 0.26 (Year 4) = 3.73 Years (Option C)

==============================

Answer 18)

SUMIE XV fx =NPV(C1,04:C11)+C3 DE В Discount Rate Year 10% Project -$56,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $

C13 fx =NPV(C1,C4:C11)+C3 B co DE Discount Rate 10% Year Project -$56,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15

-------------------------------------------------------

Answer 19)

SUMIE X fx =NPV(C1,04:C11)+c3 A B C D E Discount Rate 20% Year Project oll $56,000] 1 $15,000 $15,000 3 $15,000 $15,000 5 $15

SUMIE XV fx =IRR(C3:C11) A B Discount Rate 20% Year Project 0 $56,000 1 $15,000 $15,000 $15,000 $15,000 $15,000 6 $15,000 7 $

C12 B fx =IRR(C3:011) A D B Discount Rate Year 0 1 2 C 20% Project -$56,000| $15,000 $15,000 $15,000 $15,000 $15,000 $15,000

Hence, IRR is 21% and since IRR > WACC, company should ACCEPT the project.

Hence Option C

-----------------------------------

Answer 20)

Profitability Index = PV of Future Cashflows / Initial Investment

SUMIF , X v fx =NPV(C1,C4:011) АА D L Discount Rate 20% Year Project o l -$56,000 1 $15,000 2 $15,000 3 $15,000 4 $15,000 5 $

012 @ fx =NPV(C1,C4:011) A D B Discount Rate Year 0 2 3 20% Project -$56,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000

Hence, PI = 57557.40 / 56000

PI = 1.02781 = 1.03

Since, PI > 1 we should ACCEPT the project.

Hence OptionD

Add a comment
Know the answer?
Add Answer to:
Use the following to answer questions 17-20 bull plans to open a dou lde bathing center...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Use the following information to answer questions 16 through 20. You are analyzing a proposed project...

    Use the following information to answer questions 16 through 20. You are analyzing a proposed project and have compiled the following information Year Cash flow 0 $145,000 1 $33,400 $ 70,500 $ 82,100 Required payback period 3 years Required return 9.50 percent 16. What is the net present value of the proposed project? a. S6,239.12 b. 58.221.29 c. S6,831.84 d. 58,376.91 17. Should the project be accepted based on the internal rate of return (IRRY? Why or why not? a....

  • years, after which he plans to scrap the equipment and retire to the beaches of Nevis....

    years, after which he plans to scrap the equipment and retire to the beaches of Nevis. The first cash inflow occurs at the end of the first year. Assume the required return is 13 percent. What is the project's Pl? Should it be accepted? 8. Calculating Profitability Index Suppose the following two independent investment opportunities are available to Fitz, Inc. The appropriate discount rate is 8.5 percent Project Alpha Project Beta Year wnio -$2,700 1,500 1,300 1,100 - $4,100 900...

  • Use the following information about Company Y to help answer problems 20-22. • Today (T=0), Company...

    Use the following information about Company Y to help answer problems 20-22. • Today (T=0), Company Y proposes to invest in project 1 or project 2 • The appropriate discount rate is 8.0% • Each project's cash flows are forecasted below Project 1 Project 2 T=0$ (340) $ (400) T=1 $ 80 $ 85 T=2 $ 80 $ 90 T=3 $ 80 $ 95 T=4 $ 80 $ 100 T=5 $ 80 $ 105 T=6 $ 80 $ 110 20....

  • Use the information to answer the following questions. ABC Company has been growing at a 10%...

    Use the information to answer the following questions. ABC Company has been growing at a 10% rate, and it just paid a dividend of $3.00. Due to a new product, ABC expects to achieve a dramatic increase in its short-run growth rate, to 20% annually for the next 2 years. After this time, growth is expected to return to the long-run constant rate of 10%. The company's beta is 2.0, the required return on the market is 11%, and the...

  • Use the information in the table below for the following 5 questions. A capital investment project...

    Use the information in the table below for the following 5 questions. A capital investment project is estimated to have the following after-tax cash flows, by year -$35,000 $13,000 $14.000 $15,000$16,000 The company utilizes a discount rate of 8% to evaluate capital projects. You may have rounding errors in your calculations so choose the closest answer. Assume cash flows are received equally over the year. 10) The NET PRESENT VALUE for the project shown above is: a) $13,789 b) $9,672...

  • Use the information to answer the following questions. ABC Company has been growing at a 10%...

    Use the information to answer the following questions. ABC Company has been growing at a 10% rate, and it just paid a dividend of $3.00. Due to a new product, ABC expects to achieve a dramatic increase in its short-run growth rate, to 20% annually for the next 2 years. After this time, growth is expected to return to the long-run constant rate of 10%. The company's beta is 2.0, the required return on the market is 11%, and the...

  • Use the graph below to answer the following two questions Security Market Line (SML) 20% 16%...

    Use the graph below to answer the following two questions Security Market Line (SML) 20% 16% 12% 8% Required Return 4% Risk-Free Rate 096 0.0 0.2 0.4 0.6 0.8 1.0 1.2 1.4 1.6 1.8 2.0 Relative Risk as Measured by Beta 19) A stock plotted in this graphical space that lies ABOVE the solid line would be considered: a. Overpriced b. Underpriced c. Accurately Priced d. Not enough information to answer this questiorn 20) The slope of the solid line...

  • Show your work Use the following to answer questions 31-33. . Over the past six months,...

    Show your work Use the following to answer questions 31-33. . Over the past six months, Seven Flags conducted a marketing study on how to park experience. The study cost $3 million and the results suggested that kids' only roller coaster The equipment for the new roller coaster will cost $30 million install improve their ags add a · S5 million to he equipment will be depreciated st and sold for that amount in 20 years. The marketing team at...

  • Use the information to answer the following questions. • Thames Inc.'s most recent dividend was $2.40...

    Use the information to answer the following questions. • Thames Inc.'s most recent dividend was $2.40 per share. The dividend is expected to grow at 3% per year. • The T-bill rate is 5% and the market return rate is 9%. • The company's beta is 1.3. What is the required rate of return for the stock? Select one: a. 14.0% b. 14.2% c. 10.2% d. 16.7% e. 13.0% Continued from previous question. What is the expected price of the...

  • please answer all O Answer all questions .30 points Circle the letter for the correct answer...

    please answer all O Answer all questions .30 points Circle the letter for the correct answer If an asset is sold for less than is depreciation book value, it is taxed at the capital gain tax rate taxed at ordinary income tax rate. subject to tax savings due to capital loss d. not subject to any income tax consideration Changes in the firm's cash flows that are a dirst consequence of accepting a project are erosion cash flows e Net...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT