Question



You work as a financial analyst for the CFO of a Fortune 500 company. You are have been asked to consider the following cash
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Project - 1:

NPV :

B8 fx =NPV(14%,B3:B7) +B2 А B C D E 1 Year 0 cash flow -6000000 2000000 N 3 1 4 2 2000000 2000000 3 5 6 4 2000000 7 5 2000000

IRR:

B8 fox IRR(B2:17) C D А Year 1 B cash flow -6000000 2000000 2 0 3 1 4 2 5 3 2000000 2000000 2000000 6 4 7 5 2000000 8 IRR 19.

Project - 2:

NPV:

B8 fx =NPV(14%,B3:37)+B2 с E D 1 А Year 0 N 3 1 4 2 B cash flow -18000000 5600000 5600000 5600000 5600000 5600000 1225253.43

IRR :

B8 fx EIRR(B2:37) А с D 1 Year B cash flow - 18000000 2 0 3 1 5600000 5600000 4 2 3 5600000 5 6 4 7 5 5600000 5600000 16.80%

IRR = 16.80%

NPV:

Project - 1 = 866,161.94

Project - 2 = 1,225,253.43

IRR:

Project - 1 = 19.86%

Project - 2 = 16.80%

conclusion:

Project - 2 should be selected because it has higher NPV

Add a comment
Know the answer?
Add Answer to:
You work as a financial analyst for the CFO of a Fortune 500 company. You are...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You work as a financial analyst for the CFO of a big company, you have been...

    You work as a financial analyst for the CFO of a big company, you have been asked to consider the following cash flows (Millions) from two mutually exclisive capital budgeting projects. If the firm's WACC is 14%, find the NVP and IRR and select which one you would choose: Project 1: CF0= -6M CF1= 2M . CF2=2m CF3=2M . CF4= 2m Project 2: CF0= -18M CF1= 5.6M CF2= 5.6M CF3= 5.6M CF4= 5.6M CF5= 5.6M Answer Choices: A) Project 1:NVP=...

  • No need for Explanation The CFO of a major corporation is trying to decide on what...

    No need for Explanation The CFO of a major corporation is trying to decide on what project to pursue using different investment criteria: Net Present Value (NPV), Payback Period, Discounted Payback Period, Internal Rate of Return (IRR), and the Profitability Index (PI). The CFO has four projects to choose between: Project W (which is a strip mine - see problem 6), Project X, Project Y, and Project Z. Additional information about each project is summarized below. You can use the...

  • please give a written answer, please do not use excel as it has to be written...

    please give a written answer, please do not use excel as it has to be written out. thank you. You must analyze the cash flows of two projects, S and L. Project S: CFO = -1500; CF1 = 800; CF2 = 700; CF3 = 100; CF4 = 600 Project L: CFO = -1500; CF1 = 200; CF2 = 600; CF3 = 900; CF4 = 700 Given a required rate of return of 10%, what is the IRR of the better...

  • Cannibus Imports Inc. is considering a service contract for its maintenance work. One firm has offered...

    Cannibus Imports Inc. is considering a service contract for its maintenance work. One firm has offered a four-year contract for $215,000 up front, while another firm has offered a six-year contract for $340,000 up front.   The firm will be able to save $81,000 per year under either contract because its employees will no longer have to do the work themselves. a. If the firm's cost of capital is 6%, which project should be selected? Show NPV and EAA capital budgeting...

  • Problem 3: A potential CB project has the following cash flows: CFO = -$500, CF1 =...

    Problem 3: A potential CB project has the following cash flows: CFO = -$500, CF1 = $300, CF2 = $200, CF3 = $150. WACC = 6%. Compute the following: V CPT DPB & NFV CPT (EX) A. Payback Period 3. NPV 86.9610 Accept project 2. IRR 16.4634 76 Accept project.

  • 1. You must analyze the cash flows of two projects, S and L. Project S: CF0...

    1. You must analyze the cash flows of two projects, S and L. Project S: CF0 = -1500; CF1 = 800; CF2 = 700; CF3 = 100; CF4 = 600 Project L: CF0 = -1500; CF1 = 200; CF2 = 600; CF3 = 900; CF4 = 700 Given a required rate of return of 10%, what is the IRR of the better project? (Note: the better project may not be the one with the higher IRR)

  • HOW DO I INPUT THIS ON MY FINANCIAL CALCULATOR? HP10B11+ Model Please provide step by step...

    HOW DO I INPUT THIS ON MY FINANCIAL CALCULATOR? HP10B11+ Model Please provide step by step instructions on financial calculator Problem 6 What is the approximate IRR for a project that costs $110,000 and provides cash inflows of $30,000 for 6 years? Assumptions: Cashflows: CF0 $ (110,000.00) CF1 $ 30,000.00 1 - Frequency CF2 $ 30,000.00 1 - Frequency CF3 $ 30,000.00 1 - Frequency CF4 $ 30,000.00 CF5 $ 30,000.00 CF6 $ 30,000.00 IRR = ? NPV = 0...

  • 1a. Why might a financial analyst use the NPV method for making project decisions instead of...

    1a. Why might a financial analyst use the NPV method for making project decisions instead of the IRR method? ------------------ 1b. Explain the reinvestment rate assumption in the context of a project’s cash flows over time. ------------------ 1c. When we create NPV profiles, what variable is on the y-axis and what variable is on the x-axis? ------------------ 1d. Suppose a firm’s WACC exceeds the IRR for both projects L and S, if the projects are mutually exclusive, which project should...

  • You are a financial analyst for the Ubuntu Inc. The director of capital budgeting has asked...

    You are a financial analyst for the Ubuntu Inc. The director of capital budgeting has asked you to analyse two proposed mutually exclusive capital investment projects, projects X and Y. The cost of capital for each project is 1296.The projects, expected net cash flows are as follows 2. Expected Net Cash Flows Project X 0 $100,000 160,500 230,000 3 30,000 4 10,000 Required: 1. Calculate the payback period (0.5 mark) 2. Calculate the discounted payback period, (0.5 mark) 3. Calculate...

  • You are a financial analyst for the Ubuntu Inc. The director of capital budgeting has asked...

    You are a financial analyst for the Ubuntu Inc. The director of capital budgeting has asked you to analyse two proposed mutually exclusive capital investment projects, Projects X and Y. The cost of capital for each project is 12%The projects' expected net cash flows are as follows: Expected Net Cash Flows 0 ($100,000) ($10,000) 2 4 Year Project X Project Y 60,500 30,000 30,000 10,000 5,500 4,500 3,500 3,500 a. If you apply the payback criterion, which investment will you...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT