fm3_problems30 - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16...

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

View Full Document Right Arrow Icon
USING DATA TABLE TO GRAPH A FUNCTION x 3 f(x) 6 ### x 6 ### -6 105 -5 70 -4 41 -3 18 -2 1 -1 -10 0 -15 1 -14 2 -7 3 6 4 25 5 50 6 81 7 118 Finding the zeros: If you set x positive (say, x = 5), then Solver will find the first zero. If you set x negative (say x = -3), Solver will find the second zero First zero x 2.59 f(x) 0 Second zero x -1.93 f(x) 0 These answers were inserted by copying the Solver results and using Paste Special|Values. -8 -6 -4 -2 0 2 4 6 8 0 1 2 3 4 5 6 7 A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
Image of page 1

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

View Full Document Right Arrow Icon
J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
Image of page 2
DATA TABLE AND PV Rate 15% Number of periods 15 Payment -10 To get a positive PV, we let the payment be negative (see Chapt Present value $58.47 #MACRO? Rate $58.47 #MACRO? 0% 150.00 2% 128.49 4% 111.18 6% 97.12 8% 85.59 10% 76.06 12% 68.11 14% 61.42 16% 55.75 18% 50.92 20% 46.75 0% 2% 4% 6% 8% 10% 12% 14% 16% 0 10 20 30 40 50 60 70 A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Image of page 3

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

View Full Document Right Arrow Icon
ters 1 & 34) 18% 20% G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Image of page 4
NPV, DISCOUNT AND GROWTH RATES Growth rate 10% Discount rate 15% Cost 500 Year 1 cash flow 100 Year 0 1 2 3 4 5 Cash flow -500.00 100.00 110.00 121.00 133.10 146.41 NPV (101.42) ### IRR 6.60% ### #MACRO? Growth ($101.42) 0% 3% 6% 9% 12% 0% 0.00 30.91 63.71 98.47 135.28 Discount rate 3% -42.03 -14.56 14.55 45.38 78.01 6% -78.76 -54.26 -28.30 -0.84 28.21 9% -111.03 -89.08 -65.85 -41.28 -15.33 12% -139.52 -119.78 -98.91 -76.86 -53.57 15% -164.78 -146.97 -128.15 -108.28 -87.32 18% -187.28 -171.15 -154.13
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