1) Consider a project with the cash flows shown below Assume that the required return is 15 Solve what is the Internal Rate of Return and Net Present Value using Excel based on the following data (Please Show The Solution From Excel) Year Cash Flow 0 $95,000 1 24,530 2 22,070 3 50,423 4 42,750 5 2,100 a) Based on the internal rate of return, would you accept or reject this project Solve and explain b) Based on the net present value, would you accept or reject this project Solve and explain

The Answer is in the image, click to view ...

Question: 1) Consider a project with the cash flows shown below. Assume that the required return is 15%. Solve what is the Internal Rate of Return

1) Consider a project with the cash flows shown below. Assume that the required return is 15%. Solve what is the Internal Rate of Return and Net Present Value using Excel based on the following data.

-(Please Show The Solution From Excel)

Year	Cash Flow
0	-$95,000
1	24,530
2	22,070
3	50,423
4	42,750
5	-2,100

a) Based on the internal rate of return, would you accept or reject this project? Solve and explain.

b) Based on the net present value, would you accept or reject this project? Solve and explain.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

1) Consider a project with the cash flows shown below. Assume that the required return is 15%. Solve what is the Internal Rate of Return and Net Present Value using Excel based on the following data....

please show answers and formulas on excel 1) Consider a project with the cash flows shown below. Assume that the required return is 15%. a) Based on the internal rate of return, would you accept or...

1) Consider a project with the cash flows shown below. Assume that the required return is 15%. a) Based on the internal rate of return, would you accept or reject this project? Solve and explain. b)...

Consider a project with the cash flows shown below. Assume that the required return is 11%. a) Based on the internal rate of return, would you accept or reject this project? Solve and explain. b)...

The owner of a hair salon spends $1,000,000 to renovate its premises, estimating that this will increase her cash flow by $220,000 per year. She constructs the above graph, which shows the net...

Philadelphia Fastener Corporation manufactures nails, screws, bolts, and other fasteners. Management is considering a proposal to acquire new material-handling equipment. The new equipment has the...

SUUTE 6 ints eBook Print eferences Check my work Philadelphia Fastener Corporation manufactures nails, screws, bolts, and other fasteners. Management is considering a proposal to acquire new material...

Philadelphia Fastener Corporation manufactures nails, screws, bolts, and other fasteners. Management is considering a proposal to acquire new material handling equipment. The new equipment has the...

Give an example of each type of function. (a) Linear function (b) Power function (c) Exponential function (d) Quadratic function (e) Polynomial of degree 5 (f) Rational function

1.7.1b) determine the orthogonal bundle of curves of y = C e -2x

If the median value of the consumer confidence index is 9 2 , which consumer confidence index value indicates a particularly strong economy? 9 1 9 9 9 3 9 0

Required information [The following information applies to the questions displayed below.] On October 29, Lobo Company began operations by purchasing razors for resale. The razors have a 90-day...