Home › Forums › Other › Equity equation in excel › Do you need it in excel?
Do you need it in excel?
They have amortization tables all over the internet.
Here’s one
http://www.google.com/ig/adde?moduleurl=hosting.gmodules.com/ig/gadgets/file/112569394494790159079/mlcalc-gadget.xml&mkhp=1
Year Principal Paid Interest Paid Outstanding loan 2012 $6,334.53 $13,528.28 $345,665.47 2013 $6,584.40 $13,278.41 $339,081.07 2014 $6,844.13 $13,018.69 $332,236.94 2015 $7,114.10 $12,748.71 $325,122.84 2016 $7,394.72 $12,468.09 $317,728.12 2017 $7,686.41 $12,176.40 $310,041.71 2018 $7,989.61 $11,873.21 $302,052.10 2019 $8,304.76 $11,558.05 $293,747.34 2020 $8,632.35 $11,230.47 $285,114.99 2021 $8,972.86 $10,889.96 $276,142.13 2022 $9,326.80 $10,536.02 $266,815.34 2023 $9,694.70 $10,168.12 $257,120.64 2024 $10,077.11 $9,785.70 $247,043.52 2025 $10,474.61 $9,388.20 $236,568.91 2026 $10,887.79 $8,975.02 $225,681.12 2027 $11,317.27 $8,545.55 $214,363.85 2028 $11,763.68 $8,099.13 $202,600.17 2029 $12,227.71 $7,635.10 $190,372.46 2030 $12,710.04 $7,152.77 $177,662.42 2031 $13,211.40 $6,651.42 $164,451.02 2032 $13,732.53 $6,130.29 $150,718.50 2033 $14,274.22 $5,588.60 $136,444.28 2034 $14,837.27 $5,025.54 $121,607.00 2035 $15,422.54 $4,440.27 $106,184.46 2036 $16,030.89 $3,831.92 $90,153.57 2037 $16,663.24 $3,199.57 $73,490.33 2038 $17,320.54 $2,542.28 $56,169.79 2039 $18,003.76 $1,859.06 $38,166.04 2040 $18,713.93 $1,148.89 $19,452.11 2041 $19,452.11 $410.70 $0.00
So assuming your home doesn’t rise or fall, you current have 440-352k = 88k
After 5 years: you will have paid off 34271.88 off of your principal, so add that to your 88k equity
(again assuming home price doesn’t rise or fall).