Question: Long is considering two projects given below: if the two projects have the same payback period, what would be Project 2's internal rate of return

Long is considering two projects given below: if the two projects

Long is considering two projects given below: if the two projects have the same payback period, what would be Project 2's internal rate of return (IRR)? Hint: you need to find project 1s payback period and find project 2s cash flow at year 0 using project 1s payback period. please show all excel formulas. thanks!

Year Project 1 | Project 2 Cash Flow Cash Flow -$100 ? 30 40 2 50 80 3 40 60 4 50 60

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!

Q2 M/s Sons & Sons is considering two projects, A & B, with cash flows as shown A-Calculate discounted payback period, net present value and internal rate of return for each project using opportunity...

Please answer both questions and in excel format. Struggling with NPV an IRR in Excell and want to see all the work. I appreciate your help. 1. Joon.com is considering two projects given below: If...

Joon.com is considering two projects given below: If the two projects have the same payback period, what would be Project 2s internal rate of return (IRR)? (Hint: You need to find Project 1s Payback...

Please answer both problems and show work in detail. I appreciate your help. Joon.com is considering two projects given below: If the two projects have the same payback period, what would be Project...

Calculate each project's payback period, net present value (NPV), internal rate return (IRR), modified internal rate of return (IRR). Modified internal rate of return (MIRR), and profitability index...

Thomas Industries has $5 million in available cash, which can be used in the next fiscal year for new investments. It is considering two projects. The firm desires an ROI of 12% and a payback period...

Two potential investment projects have the following free cash flows: Both projects have a 14% required rate of return. a. What is the payback period for project 2? b. What is the IRR for Project 2?...

I have an assignment for Finance Management: Payback Periods, Net Present Value, Internal rate of return , NPV, Equivalent Annual Annuity, Estimation CF, Capital Rationing. Please see excel...

urgent Citco Company is considering investing up to $526,000 in a sustainability-enhancing project. its managers hove narrowed their choices to three potential projects. - Project A would redesign...

State the decision rule and the conclusion if H0: 2 = 12.6 is to be tested against H1: 2 12.6 where n =24, s2 = 18.2, and = 0.05.

Write a detailed paper on Social Media & Communication

If your payments are determined by first determining the total interst to be paid, then adding that to the principal, and finally dividing that by the number of payments, which method was used?...

WHAT IS the cash flow statement BBINFIT ,AND HOW WE CAN ANALAYSES

LO9.3 Describe the distinctions between fixed and variable costs and among total, average, and marginal costs.

2. Distinguish among accounting profit, economic profit, and normal profit. Does accounting profit or economic profit determine how entrepreneurs allocate resources between different business...

LO9.1 Explain why economic costs include both explicit (revealed and expressed) costs and implicit (present but not obvious) costs.