Question

In: Finance

Use the following information to answer the next three questions. Show ALL your work! Consider the...

Use the following information to answer the next three questions. Show ALL your work!

Consider the cash flows from two mutually exclusive projects:

Cash Flow
Year Project A Project B
0 -$420,000 -$420,000
1 $150,000 $390,000
2 $230,000 $110,000
3 $321,000 $140,000

The appropriate discount rate is 11.7%.

-Calculate the net present value (NPV) for both projects, and determine which project should be accepted based on NPV. Round both NPVs to the nearest dollar.

-Calculate the internal rate of return (IRR) for both projects, and determine which project should be accepted based on IRR.

-Calculate the net present value (NPV) for both projects using the crossover rate as your discount rate. Round both NPVs to the nearest dollar.

Solutions

Expert Solution

Computation of NPV of Both Projects:

Present Value of Cash Flow
Year Project A Project B PVF @ 11.7% Project A Project B
1        1,50,000        3,90,000 0.89525515    1,34,288.27      3,49,149.51
2        2,30,000        1,10,000 0.80148178    1,84,340.81         88,163.00
3        3,21,000        1,40,000 0.71753069    2,30,327.35      1,00,454.30
Present Value of Cash Inflows 5,48,956.43     5,37,766.80
Cash OutFlow        -4,20,000          -4,20,000
NPV         9,68,956           9,57,767

Conclusion: Based on NPV Project A has to be selected as NPV is Higher.


Related Solutions

Use the following information to answer the questions in this quiz. Please show your work by...
Use the following information to answer the questions in this quiz. Please show your work by submitting a Word, Excel, or JPEG file in the "Project 2 Drop Box". INFORMATION OLD MACHINE: Original Purchase Price $     550,000.00 Original Life 10 YEARS Remaining Life 5 YEARS Straight line depreciation in use Salvage Value $      50,000.00 Current Fair Market Value $     260,000.00 INFORMATION NEW MACHINE A: Purchase Price      $895,000.00 Estimated Life 5 YEARS Use Straight Line Depreciation Method Estimated Salvage Value...
Use the following information to answer the next three questions. Consider the following cash flows: Year...
Use the following information to answer the next three questions. Consider the following cash flows: Year Cash Flow 0 -$2,110,000 1 1,000,000 2 450,000 3 790,000 4 890,000 Assume a discount rate of 17.5 percent. What is the payback period? Round your answer to two decimal places. What is the net present value (NPV) rounded to the nearest dollar? What is the internal rate of return? please show work.
Use the following information to answer the next three questions. Consider the following cash flows: Year...
Use the following information to answer the next three questions. Consider the following cash flows: Year Cash Flow 0 -$2,110,000 1 1,000,000 2 450,000 3 790,000 4 890,000 Assume a discount rate of 17.5 percent. What is the payback period? Round your answer to two decimal places. What is the net present value (NPV) rounded to the nearest dollar? What is the internal rate of return? please show work
Answer the following questions and use Excel or this document to show your work. 1. Consider...
Answer the following questions and use Excel or this document to show your work. 1. Consider the following results for two samples randomly taken from two normal populations with equal variances. Sample I Sample II Sample Size 28 35 Sample Mean 48 44 Population Standard Deviation 9 10 a. Develop a 95% confidence interval for the difference between the two population means. b. Is there conclusive evidence that one population has a larger mean? Explain.
Use the following information to answer the next three questions. Consider the cash flows from two...
Use the following information to answer the next three questions. Consider the cash flows from two mutually exclusive projects: Cash Flow Year Project A Project B 0 -$470,000 -$460,000 1 $120,000 $392,000 2 $210,000 $110,000 3 $375,000 $120,000 The appropriate discount rate is 11.7%. Calculate the net present value (NPV) for both projects, and determine which project should be accepted based on NPV. Round both NPVs to the nearest dollar. Calculate the internal rate of return (IRR) for both projects,...
Answer the following questions. Show all work leading to your answer. On a network with an...
Answer the following questions. Show all work leading to your answer. On a network with an IP address of 140.133.28.72 and a subnet mask of 255.248.0.0, what is the network ID? You have decided to create 254 subnets on your Class B network. What subnet mask will you use to accomplish this? What is the maximum number of hosts you can assign to any single subnet? Your workstation's IP address is 10.35.88.12, and your supervisor's workstation's IP address is 10.35.91.4....
Use the following information to answer the next three questions: The following information is available from...
Use the following information to answer the next three questions: The following information is available from the records of Aggies R Us, Inc. at the end of the 2017 calendar year.  Assume this is Aggies’ 1st year of operation. Accounts Receivable           $102,200        Notes Payable                       $???? Cash                                        70,890              Salary Expense                   320,000 Building                                    75,000           Retained earnings ???? Advertising Expense                60,000             Accounts Payable                  62,800                                    Dividends                                 12,200             Income Tax Expense             23,100 Service Revenues                  460,000             Common Stock                    120,000            Office Equipment                     22,500             Wages Payable                     15,450 Determine Aggies’ Net Income for the year ended December 31, 2017: A. $36,900 B. $80,000 C. $56,900 D. $44,700...
For the Following Questions, show all work Use equations not computer a) Consider a typical $1,000,000...
For the Following Questions, show all work Use equations not computer a) Consider a typical $1,000,000 Canadian mortgage contract. Suppose that the current nominal interest rate is 6% and the maturity is set at 20 years. The rollover period is 3 years. The borrower and lender agree to an annual mortgage payment scheme. Find (i) the annual payments on this mortgage for the first three years and (ii) the amounts for the principal and interest components of each of these...
Use the following information to answer the next four questions: Consider two municipalities, A and B,...
Use the following information to answer the next four questions: Consider two municipalities, A and B, in the same province. Residents in municipality A enjoy attending outdoor music concerts (a public good) held in their public park. Each resident in municipality A has a marginal benefit curve for these concerts given by MB=10-2Q, where Q is the number of outdoor concerts. There are 100 residents in this municipality. Residents in municipality B do not enjoy outdoor music concerts (they are...
Use the following information to answer the next 11 questions. SELECT ALL ANSWERS THAT APPLY. On...
Use the following information to answer the next 11 questions. SELECT ALL ANSWERS THAT APPLY. On May I. Sam Company sold $5,000 of inventory to Bob Company. The sale was made on account and Sam granted Bob credit terms of 2/10. n/30. The inventory cost Sam Company $3,000. On May 3, Bob returned $1,000 of the inventory to Sam. (The inventory returned by Bob cost Sam $600.) On May 9, Bob paid Sam in full for the amount due. 1....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT