Corporate Finance Week 7 assigment

Answer in Excel, Attached it question.

QUESTION 6 A project has the following cash flows: Year 0 1 2 ων 3 Cash flows -$85 30 35 40 If the required return is 15%, what is the IRR of this project? 9% 10% 11% 12% 15% Click Save and Submit to save and submit. Click Save All Answers to save all answers.

Hansaben

Following is information on two alternative investments being considered by Jolee Company. The company requires a 8% return from its investments. (PV of $1, FV of $1. PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 Required A Required B Project A $(183,325) a. For each alternative project compute the net present value. b. For each alternative project compute the profitability index. If the company can only select one project, which should it choose? Initial Investment $ Chart Values are Based on: i=P % 45,000 58,000 78,295 87,400 60,000 Complete this question by entering your answers in the tabs below. For each alternative project compute the net present value. Project A 183,325 Project B $(143,960)

QUESTION 23 Reno Company is considering a project that has the following cash flow data. What is the project's IRR? Year Cash flows O a. 14.05% O b. 15.61% OC. 17.34% O d. 19.27% O e. 21.20% 0 -$1,050 1 $400 2 $400 3 $400 4 $400

Question 4: Consider projects A and B: Cash Flows (dollars) Project CO C2 NPV at 11% C1 22,600 22,600 +$6,703 35,000 35,000 +7,938 A -32,000 B -52,000 a. Calculate IRRs for A and B. b. Which project does the IRR rule suggest is best?

Please do not give solution in image format thanku

find pay back period

A limited estimated the expected cash flows for two possible projects. Project 1 Year: 0         1      2        3 .       4.        5          (500) 200. 200.    300.   200.    200 Project 2 Year 0.  1.       2.    3.        4.       5          (400).  100.   100.  100.    500 All figured are in $'000 Select a project when using 1. Payback method 2.NPV @ 25% 3.Profitability index

Project X Project Y Year Cash Flow Cash Flow 0 -$1000 -$1000 1 100 400 2 300 400 3 500 400 4 800 400   The cost of capital is 5 percent.     1. What is each project’s NPV? Which project would you choose based on NPV rule?                 2. What is each project’s IRR? Which project would you choose based on IRR rule?                 3. Why IRR rule and NPV rule lead to different decisions? Which rule is more appropriate to evaluate mutually exclusive projects? Why?

What is the project's MIRR? r = 10.00% 0 Year Cash flows O a. 22.51% O b. 11.75% O c. 17.21% O d. 14.81% O e. 15.65% -$875 1 $300 2 $320 3 $340 $360

MIRR A project has the following cash flows: 0 1 2 3 4 5 $500 $202 -$X $196 $350 $451 ▸ Details This project requires two outflows at Years 0 and 2, but the remaining cash flows are positive. Its WACC is 10%, and its MIRR is 14.14%. What is the Year 2 cash outflow? SHOW ANSWER

What is Project A’s modified internal rate of return (MIRR)? Use 5 decimal places for the factors     18.15% 12.15% 14.49% 7.40% 15.54%

11:52 Investment Appraisal (Year 2 Column 2... 35% 4. An investment has the following cash flows. What is the ARR? Year 0 -90,000 Year 1 45,000 10,000 Year 2 Year 3 30,000 30,000 Year 4 6% 7% 9% 5. Which of the following investments would you choose based on payback? Project 3 years 6 months 5 years 10 months A В ... Activity Chat Teams Assignments More

Provide Answer pls expert

Problem 8-6 Profitability Index (LO3) The following are the cash flows of two projects: Project B $ (350) 250 250 250 Year 0 1 2 434 Project A $ (350) 180 180 180 180 If the opportunity cost of capital is 11%, what is the profitability index for each project? Note: Do not round intermediate calculations. Round your answers to 4 decimal places. Answer is complete but not entirely correct. Profitability Index Project A B 1.5955 1.7455

QUESTION 3 A project has the following cash flows: Year 0 1 2 3 Cash flows -$85 30 35 40 If the required return is 15%, what is the NPV of this project? $6.15 -$6.15 $20 -$20

Problem 8-6 Profitability Index (LO3) The following are the cash flows of two projects: Year Project A Project B $ (270) $ (270) 1 150 170 2 150 170 3 150 170 4 150 If the opportunity cost of capital is 12%, what is the profitability Index for each project? Note: Do not round Intermediate calculations. Round your answers to 4 decimal places. Project A B Profitability Index

Consider projects A and B: Cash Flows (dollars) Project A Co -30,500 C1 C2 21,400 21,400 NPV at 11% +$6,148.00 B -50,500 33,500 33,500 + 6,869.53 a. Calculate IRRS for A and B. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project A B IRR % % b. Which project does the IRR rule suggest is best? O Project A ○ Project B c. Which project is really best? ○ Project A O Project B k

Consider the two projects in the following table: Year 0123 14.65% O 13,70 % What is the crossover point for the two projects? 14.95% Expected Net Cash Flow 13.25% Project A -$22,000 $15,000 $15,000 $15,000 Project B -$20,800 $14,100 $14,100 $14,100

Consider the following two projects: Project Year o Year 1 Year 2 Year 3 Year 4 Discount Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Rate A - 100 40 50 60 N/A 0.1 в - 73 30 30 30 30 0.1 The net present value (NPV) of project B is closest to: O A. 24.3 O B. 55.2 O C. 27.6 O D. 22.1

i need these calculations screenshot with £signs not in dollars  please rewrite this

please be soecific w answer pls complete the box

Question number 5 onlysNot use excel

QUESTION 19 Simkins Renovations Inc. is considering a project that has the following cash flow data. What is the project's IRR? Year Cash flows A. 28.55% O B. 24.50% ○ C. 20.88% O D. 17.63% ○ E. 14.67% ○ F. 11.98% G. 9.51% OH. 7.24% 0 -$850 1 2 3 4 $300 $390 $280 $270

please answer

Question 14 Simms Corp. is considering a project that has the following cash flow data. What is the project's IRR? Year Cash flows O 9.64% O 11.76% O 10.82% O 12.58% O 11.29% 0 -$1,025 1 $425 2 $425 3 $425

Question number 5 onlys Not use excel

Can you please show me what I'm doing keep saying my answers are wrong

Pls help stepwise sir