Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

problem 11 is the only one i need answered the other 3 pictures are the answer for 10 which are needed for 11. .AT&T Wi-Fi

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed problem 11 is the only one i need answered the other 3 pictures are the answer for 10 which are needed for 11.
.AT&T Wi-Fi 5:25 PM @ 71% Chapter 9 Problem 10QP Done Calculating IRR [LO5] What is the MR. of the following set of cash flows? Year Cash Flow -$13,900 6,400 8,700 5.900 .AT&T Wi-Fi 5:25 PM @ 71% Step 4 of 5 Done The Internal rate of return is the method wherein the net present value of the project is equal to the initial investment of the project. The IRR should always be more than the cost of capital or the required rate of return for a project to be accepted and pursued for the investment. The project provides the following cashflows:- Year Cashflow 0 -$13,900 1 $6,400 2 $8,700 3 $5,9001 .AT&T Wi-Fi 5:25 PM @ 71% Q Step 5 of 5 Done To compute IRR of uneven cashflows, the IRR function of excel would be employed. The syntax of IRR function are as follows:- - IRR(Values, (guess] The following computations would be performed in excel as displayed below:- A Year Cashflow 0 -$13,900 1 $6,4001 2 $8,700 $5,900 IRR =IRR(B2:B5) The following would be the results: - Year Cashflow -$13,900 $6,400 $8,7001 $5,900 6 IRR 24.07% The IRR for the set of cashflows of this project is 24.07% The IRR can be verified by performing the computations as displayed below:- NPV of the investment Cash flow Generated Cash - Initial Cashflow at Year 0 S6,400 $8,700 $5,900 NPV 5-S13,900 (1+0.2407) (1+0.2407) (1+0.2407) $6,400 $8,700 $5,900-$13.900 (1.2407) (1.2407) (1.2407)*** NPV-$5,158.38+$5,651.79+$3,089.24 -$13,900 NPV-SO .AT&T Wi-Fi 5:25 PM @ 71% Chapter 9 Problem 11QP Done Calculating NPV [LO1] For the cash flows in the previous problem, what is the NPV at a discount rate of zero percent? What if the discount rate is 10 percent? If it is 20 percent? If it is 30 percent

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions