FIN 725 Assignment 1.xlsx - Initial cost Growth rate Term Discount rate First Year Value of X Growth rate 1000 10 11 years 15 $153.96 $129.36 Discount

FIN 725 Assignment 1.xlsx - Initial cost Growth rate Term...

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

Initial cost 1000 Growth rate 10% Term 11 years Discount rate 15% First Year $153.96 Value of X $129.36 Growth rate Discount rate X 1 1.15 0.87 1.1 1.32 0.83 1.21 1.52 0.80 1.33 1.75 0.76 1.46 2.01 0.73 1.61 2.31 0.70 1.77 2.66 0.67 1.95 3.06 0.64 2.14 3.52 0.61 2.36 4.05 0.58 2.59 4.65 0.56 7.73
Principal 15,000 Term 48 Months Rate 1.25% Monthly Paymen $417.46 Month Principal-BePayment Interest Return Principal - closin 1 ### $ 417.46 ### ### $ 14,770.04 2 ### $ 417.46 ### ### $ 14,537.20 3 ### $ 417.46 ### ### $ 14,301.46 4 ### $ 417.46 ### ### $ 14,062.76 5 ### $ 417.46 ### ### $ 13,821.09 6 ### $ 417.46 ### ### $ 13,576.39 7 ### $ 417.46 ### ### $ 13,328.63 8 ### $ 417.46 ### ### $ 13,077.78 9 ### $ 417.46 ### ### $ 12,823.79 10 ### $ 417.46 ### ### $ 12,566.63 11 ### $ 417.46 ### ### $ 12,306.25 12 ### $ 417.46 ### ### $ 12,042.62 13 ### $ 417.46 ### ### $ 11,775.69 14 ### $ 417.46 ### ### $ 11,505.42 15 ### $ 417.46 ### ### $ 11,231.78 16 ### $ 417.46 ### ### $ 10,954.71 17 ### $ 417.46 ### ### $ 10,674.19 18 ### $ 417.46 ### ### $ 10,390.15 19 ### $ 417.46 ### ### $ 10,102.57 20 ### $ 417.46 ### ### $ 9,811.39 21 ### $ 417.46 ### ### $ 9,516.57 22 ### $ 417.46 ### ### $ 9,218.07 23 ### $ 417.46 ### ### $ 8,915.83 24 ### $ 417.46 ### ### $ 8,609.82 25 ### $ 417.46 ### ### $ 8,299.98 26 ### $ 417.46 ### ### $ 7,986.27 27 ### $ 417.46 ### ### $ 7,668.64 28 ### $ 417.46 ### ### $ 7,347.03 29 ### $ 417.46 ### ### $ 7,021.41 30 ### $ 417.46 ### ### $ 6,691.72 31 ### $ 417.46 ### ### $ 6,357.90 32 ### $ 417.46 ### ### $ 6,019.91 33 ### $ 417.46 ### ### $ 5,677.70 34 ### $ 417.46 ### ### $ 5,331.21 35 ### $ 417.46 ### ### $ 4,980.39 36 ### $ 417.46 ### ### $ 4,625.18 37 ### $ 417.46 ### ### $ 4,265.54 38 ### $ 417.46 ### ### $ 3,901.39 39 ### $ 417.46 ### ### $ 3,532.70

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture