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

Info iconThis 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
Background image of page 1

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

View Full DocumentRight 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
Background 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
Background image of page 3

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

View Full DocumentRight 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
Background 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? ($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
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/23/2011 for the course FGB 780 taught by Professor Edwardchang during the Spring '09 term at Missouri State University-Springfield.

Page1 / 7

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

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online