Question

In: Finance

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, 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.

show work please

Solutions

Expert Solution

NPV of Project A =PV of Cash Flows-Initial Investment =120000/(1+11.7%)+210000/(1+11.7%)^2+375000/(1+11.7%)^3-470000 =74815.80 or 74816
NPV of Project B =PV of Cash Flows-Initial Investment =392000/(1+11.7%)+110000/(1+11.7%)^2+120000/(1+11.7%)^3-460000=65206.70 or 65207

IRR of Project A using Financial calculator
CF0 =-470000;CF1=120000;CF2=210000;CF3=375000;CPT IRR =19.19%
IRR of Project A using Financial calculator
CF0 =-460000;CF1=392000;CF2=110000;CF3=120000;CPT IRR =22.24%

For Cross over rate
Incremental Cash flow in year 0=-470000-(-460000) =-10000
Incremental Cash flow in year 1=120000-(392000) =-272000
Incremental Cash flow in year 2=210000-(110000) =100000
​​​​​​​Incremental Cash flow in year 3=375000-120000 =255000
IRR using incremental cash flow
CF0=-10000;CF1=-272000;CF3=100000;CF4=255000;CPT IRR =14.12391885%

NPV of cash flows at crossover rate of Project A
=120000/(1+14.12391885%)+210000/(1+14.12391885%)^2+375000/(1+14.12391885%)^3-470000=48677
NPV of cash flows at crossover rate of Project B
=392000/(1+14.12391885%)+110000/(1+14.12391885%)^2+120000/(1+14.12391885%)^3-460000=48677
​​​​​​​

​​​​​​​


Related Solutions

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
Use the following information to answer the next two questions. Consider the after-tax cash flows below:...
Use the following information to answer the next two questions. Consider the after-tax cash flows below: Year 0 1 2 3 4 Cash Flow -$75,000 $5,100 -$1,100 $498,000 -$272,000 The required rate of return is 12 percent. Find an internal rate of return (IRR) for these cash flows. Should you use the IRR you calculated in the previous question to decide whether the project is acceptable? Explain show work please
Use the following information to answer the next four questions. The cash flows for two mutually...
Use the following information to answer the next four questions. The cash flows for two mutually exclusive projects are shown in the following table. Investors require a 16% rate of return for each project. Year Cash Flows: Project S (in millions) Cash Flows: Project T (in millions) 0 -200 -200 1 -20 50 2 45 60 3 70 30 4 -10 -40 5 125 100 6 125 100 7 150 100 Find the profitability index for project S. Round intermediate...
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...
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...
Please use the following information to answer the next question: For BB Incorporated: Cash Flows from...
Please use the following information to answer the next question: For BB Incorporated: Cash Flows from Assets -------------------------------------------------------------------- 100 dollars EBIT (from 1999 INCOME STATEMENT) -------------------------------------------0 dollars Depreciation Expense (from 1999 INCOME STATEMENT) ---------------------- 0 dollars Taxes (from 1999 INCOME STATEMENT) ------------------------------------------ 0 Net Fixed Assets from BALANCE SHEET dated December 31, 1998-------------1400 dollars Net Fixed Assets from BALANCE SHEET dated December 31, 1999------------ 1300 dollars Additions to (Changes in) NWC for 1999 ---------------------------------------------- 0 dollars For KK Incorporated: Cash...
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...
Use the cash flows from the following two projects to answer the questions below. The firms...
Use the cash flows from the following two projects to answer the questions below. The firms required rate of return is 11%. Make sure to show all your computations. Year Project A Project B 0 -$200,000 -$200,000 1 $80,000 $100,000 2 $80,000 $100,000 3 $80,000 $100,000 4 $80,000 Assuming the firm’s required rate of return increases to 16% and that your firm only has $200,000 available to invest, which project of the two above would you chose if you used:...
Use the following information to answer the next Two questions : 2018 2017 Cash 15,000 14,000...
Use the following information to answer the next Two questions : 2018 2017 Cash 15,000 14,000 A/R 24,000 25,000 Inventory 79,000 78,000 Prepaid Insurance 5,000 4,000 Preoperty plant, & Equipment 35,000 30,000 Accumlated Depreciation (7,000) (5,000) Total Assets 151,000 146,000 Account Payable 6,000 9,000 Bonds Payable (mature in yr 2022 45,000 60,000 Common Stock 70,000 60,000 Retaind Earnings 30,000 17,000 Total Liabilities & Equity 151,000 146,000 Sunny Company had the following comparative balance sheet information for 2018, 2017: Sunny reported...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT