Following is information on two alternative investments. Beachside Resort is co spa. The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 Pool $ (177,000) 41,700 57,700 81,995 92,100 66,700 Spa $ (122,000) 33,700 51,700 67,700 73,700 25,700 Compute the internal rate of return for each of the projects using excel function Note: Round your answers to 2 decimal places.

I want to answer the question

First United Bank Inc. is evaluating three capital investment projects using the net present value method. Relevant data related to the projects are summarized as follows:   BranchOfficeExpansion ComputerSystemUpgrade ATMKioskExpansion Amount to be invested $686,053   $516,654   $295,458   Annual net cash flows:               Year 1 411,000   288,000   177,000     Year 2 382,000   259,000   122,000     Year 3 349,000   230,000   89,000     Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 7 0.665 0.513 0.452 0.376 0.279 8 0.627 0.467 0.404 0.327 0.233 9 0.592 0.424 0.361 0.284 0.194 10 0.558 0.386 0.322 0.247 0.162 Required: 1.  Assuming that the desired rate of return is 20%, prepare a net present value analysis for each project. Use the…

The HUT is evaluating a 5 year investment projected to yield the following relevant cash flows over its 5 year life:   Given that the firm employs a 12% discount rate, what is the value of each of the three criteria: NPV? Profitability Index? Payback Period? V

Subject :

sanja

For each of the investments below, calculate the rate of return earned over the period. Cash Flow During Period - $900 14,000 5,000 70 1,500 (Click on the icon here in order to copy the contents of the data table above into a spreadsheet.) Investment A B C D E Beginning-of-Period End-of-Period Value Value $1,400 140,000 55,000 500 14,000 $400 115,000 49,000 200 12,600

Compute the payback perlod for an Investment with the following net cash flows. (Round your answer to one decimal place.) Net Cash Flows per Year Cumulative Net Cash Flows $ (101,000) $ (101,000) (90,900) (70,800) Year Initial investment 1. 2. 3. 5. 6. Payback period 10,100 20,100 20,100 26,640 40,100 40,100 years (50,700) (24,060) 16,040 56,140

Please Need Correct Answer with Explanation with calculation

Please complete these charts