Question

Problem 2 (Make sure to draw the time line for the project) (Show all work for full credit) The following cash flows are give
0 0
Add a comment Improve this question Transcribed image text
Answer #1

A В D E F G 1 PV factor @15% Present value 2 Cash flow Year 0 -24000 1 -24000 4 1 5000 0.9050 4524.89 4913.90 2 6000 0.8190 6

EXCEL FORMULA:

A В C D E 1 PV factor @15% - 1/ (1+0.105)AB3 1/(1+0.105)^B4 - 1/ (1+0.105)AB5 1/(1+0.105)^B6 - 1/ (1+0.105)AB7 1/(1+0.105)AB8

Add a comment
Know the answer?
Add Answer to:
Problem 2 (Make sure to draw the time line for the project) (Show all work for...
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
  • JUING CALCULATOR WORK AND TIME LINES) FOR FULL CREDIT PROBLEM 1: (Make sure to draw the...

    JUING CALCULATOR WORK AND TIME LINES) FOR FULL CREDIT PROBLEM 1: (Make sure to draw the time line for the project) (Show all work for fun creo The following cash Tows are given for the two mutually exclusive projects X and Y. Both Projects an initial investment of $21,000 in time 'O Year Project X Project Y $9,000 $4,000 5,000 7,000 8,000 9,000 8,000 7,000 5,000 5,000 (a) Calculate the NPV for each project using a discount rate of 15...

  • You must know all the cash flows of an investment project to compute its NPV, IRR,...

    You must know all the cash flows of an investment project to compute its NPV, IRR, PI and payback period OA NPV, PI, IRR ОВ. Ос. OD IRR, PI payback period and discount payback period NPV, IRR, PI payback period, and discount payback period IRR, PI and payback period NPV, IRR, PI and discount payback period OE. OF.

  • 1. We can get multiple IRRS when we draw an NPV profile for a project when:...

    1. We can get multiple IRRS when we draw an NPV profile for a project when: a. The project is riskless. b. The project requires a large investment. c. The project cash flows are uneven and change in sign. d. The project has a balloon payment. e. The opportunity cost of capital is high. 2. The length of time required for an investment to generate cash flows sufficient to recover its initial cost, without taking into account time value of...

  • 1. If a manager were concerned with the time value of money, from which two capital...

    1. If a manager were concerned with the time value of money, from which two capital budgeting methods should the manager choose? Multiple Choice IRR or Payback. BET or IRR. BET or Payback. NPV or ARR. NPV or Payback. 2. Restating future cash flows in terms of present values and then determing the payback period using these present values is known as: Multiple Choice Break-even time (BET) Internal rate of return method. Accounting rate of return method. Net present value...

  • please solve and explain how to find IRR Only. and draw the time line for this problem! thanks! 9.6 Assume that you...

    please solve and explain how to find IRR Only. and draw the time line for this problem! thanks! 9.6 Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments-project X and project Y. Each project requires a net investment outlay of $10,000, and the opportunity cost of capital for each project is 12 percent. The projects' expected net cash flows are as follows: Year Project X ($)...

  • Please submit your work in an Excel file and show all of your calculations. No credit...

    Please submit your work in an Excel file and show all of your calculations. No credit will be earned if you just provide a solution with the calculations to justify how you arrived at the solution. Project A has an initial net investment at time period zero of ($100,000), with $21,000 positive cash flows for the next 7 years. Project A has a cost of capital of 7% APR. Project B has an initial net investment at time period zero...

  • draw time line for answer a 9.6 Assume that you are the chief financial officer at...

    draw time line for answer a 9.6 Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments - project X and project Y. Each project requires a net investment outlay of $10,000, and the opportunity cost of capital for each project is 12 percent. The projects' expected net cash flows are as follows: Year Project X ($) (10,000) 6,500 3,000 3,000 1,000 Project Y ($) (10,000) 3,000...

  • draw time line for answer a Assume that you are the chief financial officer at Porter...

    draw time line for answer a Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments-project X and project Y. Each project requires a net investment outlay of $10,000, and the opportunity cost of capital for each project is 12 percent. The projects' expected net cash flows are as follows: 9.6 Project X (S) (10,000) Year Project Y ($) (10,000) 6,500 1 3,000 3,000 3,000 3,000 3,000...

  • 3. Calculating Discounted Payback An investment project has annual cash inflows of $5,000, $5,500, $6,000, and...

    3. Calculating Discounted Payback An investment project has annual cash inflows of $5,000, $5,500, $6,000, and $7,000, and a discount rate of 12 percent. What is the discounted payback period for these cash flows if the initial cost is $8,000? What if the initial cost is $12,000? What if it is $16,000?

  • I could use some help with the problem below: A project requires an initial outlay of...

    I could use some help with the problem below: A project requires an initial outlay of $50,000,000. The project life is determined to be 5 years at which time it will be discontinued and sold for scrap at $5,000,000. The project will generate net cash in-flows of $20,000,000 every year for the next five years. The projects required rate or discount rat is 11.25% 1. What is the projects Payback period? 2. What is the projects NPV? 3. What is...

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