646 Work I.xlsx - PROBLEM 2-1 Given 10 Discount rate Cash...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
PROBLEM 2-1 Given Discount rate 10% Cash Flow Year (s) Factors (cash flow * discount factor a. $500 5 0.6209 b. $500 5 3.7908 c. $500 50 9.9148 d. $500 100 9.9993 tutorials on excel financial functions: FV, PV, PMT, RATE, NPER a = - PV(rate = 10%, nper = 5, pmt = 0, fv = 500,type = 0) Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output https://www.youtube.com/watch?v=3Rzp5B3PZkk
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Solution: Present Value $ 310.46 <-- check excel PV function $ 1,895.39 $ 4,957.41 $ 4,999.64
Image of page 2
PROBLEM 2-2 Solution = Value given in prob Given = Formula/Calculatio = Qualitative analysi Initial investment $ 4,000,000.00 = Goal Seek or Solve Annual Cash Flows 500,000.00 = Crystal Ball Input Project Life 10 = Crystal Ball Outpu a. Year Cash Flow 0 $ (4,000,000.00) 1 $ 500,000.00 2 $ 500,000.00 3 $ 500,000.00 4 $ 500,000.00 5 $ 500,000.00 6 $ 500,000.00 7 $ 500,000.00 8 $ 500,000.00 9 $ 500,000.00 10 $ 500,000.00 Solution: IRR = 4.28% <-- use IRR function to re Given b. Year Cash Flow 0 $ (4,000,000.00) <-- work out cash flows 1 $ 500,000.00 2 $ 500,000.00 3 $ 500,000.00 4 $ 500,000.00 5 $ 300,000.00 -200,000.00 <-- Additional investment 6 $ 500,000.00 7 $ 500,000.00 8 $ 500,000.00 9 $ 500,000.00 10 $ 500,000.00 11 $ 500,000.00 12 $ 500,000.00 13 $ 500,000.00 14 $ 500,000.00 Solution: IRR = 7.94% <-- use IRR function
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
tutorials on excel financial functions, IRR and NPV https://www.youtu https://www.youtube.com/watch?v=3Rzp5B3PZkk
Image of page 4
n Legend blem on/Analysis required is or Short answer required er cell ut eplicate
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern