08b_dynamic_present_value_spreadsheet

08b_dynamic_present_value_spreadsheet - 85.37 83.29 81.06...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
year payment forward zero price PV of paymPV 0 0 1.06 0 120.24 1 9 1.06 0.94 8.49 118.45 2 9 1.06 0.89 8.01 116.56 3 9 1.06 0.84 7.56 114.55 4 9 1.06 0.79 7.13 112.43 5 9 1.06 0.75 6.73 110.17 6 9 1.06 0.7 6.34 107.78 7 9 1.07 0.67 5.99 105.25 8 9 1.07 0.62 5.59 103.62 9 9 1.07 0.58 5.23 101.87 10 109 0.54 59.17 120.24 initial balance 100 cpn rate 0.07 year 1 2 3 4 5 6 payment 8.06 8.06 8.06 8.06 8.06 8.06 8.06 balance 100 98.94 97.81 96.6 95.3 93.91 92.43 error 0 error^2 0 int rate 0.09 PV of rem payments 82.79 82.18 81.52 80.8 80.01 79.16 78.22
Background image of page 1

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

View Full DocumentRight Arrow Icon
7 8 9 10 11 12 13 14 15 16 8.06 8.06 8.06 8.06 8.06 8.06 8.06 8.06 8.06 8.06 90.84 89.14 87.32
Background image of page 2
Background image of page 3

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

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

Unformatted text preview: 85.37 83.29 81.06 78.68 76.13 73.4 70.48 77.2 76.09 74.88 73.56 72.13 70.56 68.85 66.99 64.96 62.75 17 18 19 20 21 22 23 24 25 26 8.06 8.06 8.06 8.06 8.06 8.06 8.06 8.06 8.06 8.06 67.35 64.01 60.43 56.6 52.5 48.12 43.43 38.41 33.04 27.3 60.33 57.71 54.84 51.72 48.31 44.6 40.56 36.15 31.35 26.11 27 28 29 30 8.06 8.06 8.06 8.06 21.15 14.57 7.53 20.4 14.18 7.39...
View Full Document

Page1 / 4

08b_dynamic_present_value_spreadsheet - 85.37 83.29 81.06...

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

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