Class03_prep_sheet_key.xlsx - Number of Payments Present...

This preview shows page 1 - 5 out of 5 pages.

Number of Payments 84 Present Value 9925 Payment Amount -743.49 Rate 7.47% =RATE(B1,B3,B2,B5) FV 0
$ 300,000 Present Value $251,057.17 6% APR 240 360 Number of months for payment 0.005 0.005 Monthly Rate $ (1,798.65) ($1,798.65) Monthly Payment =PMT(A4,A3,A1,A6) 0 0 FV Month Payment Interest Principal Balance 1 $2,720.41 $ 1,500.00 $1,220.41 $ 298,779.59 2 $2,720.41 $ 1,493.90 $1,226.51 $ 297,553.08 3 $2,720.41 $ 1,487.77 $1,232.64 $ 296,320.43 4 $2,720.41 $ 1,481.60 $1,238.81 $ 295,081.63 5 $2,720.41 $ 1,475.41 $1,245.00 $ 293,836.62 6 $2,720.41 $ 1,469.18 $1,251.23 $ 292,585.40 7 $2,720.41 $ 1,462.93 $1,257.48 $ 291,327.91 8 $2,720.41 $ 1,456.64 $1,263.77 $ 290,064.14 9 $2,720.41 $ 1,450.32 $1,270.09 $ 288,794.05 10 $2,720.41 $ 1,443.97 $1,276.44 $ 287,517.61 11 $2,720.41 $ 1,437.59 $1,282.82 $ 286,234.79 12 $2,720.41 $ 1,431.17 $1,289.24 $ 284,945.56 13 $2,720.41 $ 1,424.73 $1,295.68 $ 283,649.87 14 $2,720.41 $ 1,418.25 $1,302.16 $ 282,347.71 15 $2,720.41 $ 1,411.74 $1,308.67 $ 281,039.04 16 $2,720.41 $ 1,405.20 $1,315.21 $ 279,723.83 17 $2,720.41 $ 1,398.62 $1,321.79 $ 278,402.04 18 $2,720.41 $ 1,392.01 $1,328.40 $ 277,073.64 19 $2,720.41 $ 1,385.37 $1,335.04 $ 275,738.59 20 $2,720.41 $ 1,378.69 $1,341.72 $ 274,396.88 21 $2,720.41 $ 1,371.98 $1,348.43 $ 273,048.45 22 $2,720.41 $ 1,365.24 $1,355.17 $ 271,693.28 23 $2,720.41 $ 1,358.47 $1,361.94 $ 270,331.34 24 $2,720.41 $ 1,351.66 $1,368.75 $ 268,962.59 25 $2,720.41 $ 1,344.81 $1,375.60 $ 267,586.99 26 $2,720.41 $ 1,337.93 $1,382.48 $ 266,204.51 27 $2,720.41 $ 1,331.02 $1,389.39 $ 264,815.13 28 $2,720.41 $ 1,324.08 $1,396.33 $ 263,418.79 29 $2,720.41 $ 1,317.09 $1,403.32 $ 262,015.48 30 $2,720.41 $ 1,310.08 $1,410.33 $ 260,605.14 31 $2,720.41 $ 1,303.03 $1,417.38 $ 259,187.76 32 $2,720.41 $ 1,295.94 $1,424.47 $ 257,763.29 33 $2,720.41 $ 1,288.82 $1,431.59 $ 256,331.69 34 $2,720.41 $ 1,281.66 $1,438.75 $ 254,892.94 35 $2,720.41 $ 1,274.46 $1,445.95 $ 253,447.00 36 $2,720.41 $ 1,267.23 $1,453.18 $ 251,993.82 37 $2,720.41 $ 1,259.97 $1,460.44 $ 250,533.38
38 $2,720.41 $ 1,252.67 $1,467.74 $ 249,065.64 39 $2,720.41 $ 1,245.33 $1,475.08 $ 247,590.56 40 $2,720.41 $ 1,237.95 $1,482.46 $ 246,108.10 41 $2,720.41 $ 1,230.54 $1,489.87 $ 244,618.23 42 $2,720.41 $ 1,223.09 $1,497.32 $ 243,120.91 43 $2,720.41 $ 1,215.60 $1,504.81 $ 241,616.11 44 $2,720.41 $ 1,208.08 $1,512.33 $ 240,103.78 45 $2,720.41 $ 1,200.52 $1,519.89 $ 238,583.88 46 $2,720.41 $ 1,192.92 $1,527.49 $ 237,056.39 47 $2,720.41 $ 1,185.28 $1,535.13 $ 235,521.27 48 $2,720.41 $ 1,177.61 $1,542.80 $ 233,978.46 49 $2,720.41 $ 1,169.89 $1,550.52 $ 232,427.94 50 $2,720.41 $ 1,162.14 $1,558.27 $ 230,869.67 51 $2,720.41 $ 1,154.35 $1,566.06 $ 229,303.61 52 $2,720.41 $ 1,146.52 $1,573.89 $ 227,729.72 53 $2,720.41 $ 1,138.65 $1,581.76 $ 226,147.96 54 $2,720.41 $ 1,130.74 $1,589.67 $ 224,558.29 55 $2,720.41 $ 1,122.79 $1,597.62 $ 222,960.67 56 $2,720.41 $ 1,114.80 $1,605.61 $ 221,355.06 57 $2,720.41 $ 1,106.78 $1,613.63 $ 219,741.43 58

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture