Comparison Of Low Budget Car

Transcript

Car Nano omni Suzuki Alto Suzuki Alto 800 Hyundai new Eon Suzuki Eco Hyundai santro xing Price 2.11 2.76 3.52 3.7 3.92 3.99 4.17 Kpl 18.3 14.5 15.16 22.7 21.1 15.1 16.76 Suzuki Alto 800 Hyundai new Eon Suzuki Wagon-R Hyundai i10 Suzuki New Swift Nano 3.7 3.92 4.58 6.31 7.11 2.11 22.7 21.1 20.51 19.81 18.6 18.3 chevrolet spark 4.22 18 chevrolet spark 4.22 18 Suzuki Estilo Suzuki Wagon-R Suzuki A star Hyundai Accent chevrolet beat Ford Figo Hyundai i10 Indica Vista Suzuki New Swift 4.52 4.58 4.78 5.52 6.01 6.17 6.31 6.91 7.11 13.55 20.51 13.79 16.36 13.5 15.6 19.81 16.7 18.6 Hyundai santro xing Indica Vista Hyundai Accent Ford Figo Suzuki Alto Suzuki Eco omni Suzuki A star Suzuki Estilo chevrolet beat 4.17 6.91 5.52 6.17 3.52 3.99 2.76 4.78 4.52 6.01 16.76 16.7 16.36 15.6 15.16 15.1 14.5 13.79 13.55 13.5 Indica ev2 Indigo eCS Toyota Etios Liva Suzuki Ritz Suzuki New Swift Dzire 4.93 6.32 6.44 6.55 7.64 25 25 23.5 23.2 23.4 Indica ev2 Indigo eCS Toyota Etios Liva Suzuki New Swift Dzire Suzuki Ritz 4.93 6.32 6.44 7.64 6.55 25 25 23.5 23.4 23.2 Nano omni Suzuki Alto Suzuki Alto 800 Hyundai new Eon Suzuki Eco Hyundai santro xing 2.11 2.76 3.52 3.7 3.92 3.99 4.17 18.3 14.5 15.16 22.7 21.1 15.1 16.76 chevrolet spark 4.22 18 Suzuki Estilo Suzuki Wagon-R Suzuki A star Hyundai Accent chevrolet beat Ford Figo Hyundai i10 Indica Vista Suzuki New Swift 4.52 4.58 4.78 5.52 6.01 6.17 6.31 6.91 7.11 13.55 20.51 13.79 16.36 13.5 15.6 19.81 16.7 18.6 Indica ev2 Indigo eCS Toyota Etios Liva Suzuki Ritz Suzuki New Swift Dzire 4.93 6.32 6.44 6.55 7.64 25 25 23.5 23.2 23.4 Hyundai new Eon 3.92 chevrolet spark 4.22 4.97 18 4.61 Suzuki Wagon-R 4.58 5.34 20.51 Hyundai new Eon Suzuki Wagon-R 3.92 4.58 4.61 5.34 21.1 20.51 chevrolet spark 4.22 4.97 18 Indica ev2 4.93 5.81 21.1 25 Petrol Price Diesel Price Diff in Price 76.04 52.64 23.40 Distance Per Month Mileage Petrol Car Mileage Diesel Car Pertrol Cost per Day Diesel Cost per Day Diff in Fuel Cost per Day Pertrol Cost per Month Diesel Cost per Month Diff in Fuel Cost per Month After deduction of maintenance diff 10 600 21.1 25 72.0758 42.112 29.9638 2162.27 1263.36 898.915 -101.09 Petrol Car Price Diesel Car Price Diff in Car Price 461000 581000 120000 Loan Calculator Printer friendly Spreadsheet for creating a loan amortization schedule Excel Template by Excely.com Loan Data $3,000 Loan Amount $ 120,000.00 Annual Interest Rate 11.75% Loan Period in Years 5 Number of Payments Per Year 12 Start Date 12-Sep-2007 $2,500 $2,000 $1,500 Summary Payment No. 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 35 36 37 38 39 40 Payment Date 12-Sep-2007 12-Oct-2007 12-Nov-2007 12-Dec-2007 12-Jan-2008 12-Feb-2008 12-Mar-2008 12-Apr-2008 12-May-2008 12-Jun-2008 12-Jul-2008 12-Aug-2008 12-Sep-2008 12-Oct-2008 12-Nov-2008 12-Dec-2008 12-Jan-2009 12-Feb-2009 12-Mar-2009 12-Apr-2009 12-May-2009 12-Jun-2009 12-Jul-2009 12-Aug-2009 12-Sep-2009 12-Oct-2009 12-Nov-2009 12-Dec-2009 12-Jan-2010 12-Feb-2010 12-Mar-2010 12-Apr-2010 12-May-2010 12-Jun-2010 12-Jul-2010 12-Aug-2010 12-Sep-2010 12-Oct-2010 12-Nov-2010 12-Dec-2010 12-Jan-2011 $ $ 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 Principal $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,479.20 1,493.68 1,508.31 1,523.08 1,537.99 1,553.05 1,568.26 1,583.61 1,599.12 1,614.78 1,630.59 1,646.56 1,662.68 1,678.96 1,695.40 1,712.00 1,728.76 1,745.69 1,762.78 1,780.04 1,797.47 1,815.07 1,832.85 1,850.79 1,868.92 1,887.22 1,905.69 1,924.35 1,943.20 1,962.22 1,981.44 2,000.84 2,020.43 2,040.21 2,060.19 2,080.36 2,100.73 2,121.30 2,142.07 2,163.05 Interest $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Developed by Excely.com (c) 2007 1,175.00 1,160.52 1,145.89 1,131.12 1,116.21 1,101.15 1,085.94 1,070.59 1,055.08 1,039.42 1,023.61 1,007.64 991.52 975.24 958.80 942.20 925.44 908.51 891.42 874.16 856.73 839.13 821.35 803.41 785.28 766.98 748.51 729.85 711.00 691.98 672.76 653.36 633.77 613.99 594.01 573.84 553.47 532.90 512.13 491.15 Interest Extra Payments Apr-11 Jan-11 Jul-10 Oct-10 Apr-10 Jan-10 Jul-09 Oct-09 Apr-09 Jan-09 Principal Payment $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Jul-08 $0 Oct-08 $500 Apr-08 $ $1,000 2,654.20 60 60 39,251.91 32.71% 159,251.91 Oct-07 $ Jan-08 Payment (per period) Number of Payments Actual Number of Payments Total Interest Paid Total Interest Total Extra Payments Total Payment Payment No. 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Payment Date 12-Feb-2011 12-Mar-2011 12-Apr-2011 12-May-2011 12-Jun-2011 12-Jul-2011 12-Aug-2011 12-Sep-2011 12-Oct-2011 12-Nov-2011 12-Dec-2011 12-Jan-2012 12-Feb-2012 12-Mar-2012 12-Apr-2012 12-May-2012 12-Jun-2012 12-Jul-2012 12-Aug-2012 12-Sep-2012 Payment $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.20 2,654.11 Principal $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2,184.23 2,205.62 2,227.21 2,249.02 2,271.04 2,293.28 2,315.73 2,338.41 2,361.31 2,384.43 2,407.78 2,431.35 2,455.16 2,479.20 2,503.47 2,527.99 2,552.74 2,577.74 2,602.98 2,628.37 Interest $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Developed by Excely.com (c) 2007 469.97 448.58 426.99 405.18 383.16 360.92 338.47 315.79 292.89 269.77 246.42 222.85 199.04 175.00 150.73 126.21 101.46 76.46 51.22 25.74 Extra Payments Payment No. Payment Date Payment Principal Developed by Excely.com (c) 2007 Interest Extra Payments Jul-12 Apr-12 Oct-11 Jan-12 Jul-11 Apr-11 Balance $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 120,000.00 118,520.80 117,027.12 115,518.81 113,995.73 112,457.74 110,904.69 109,336.43 107,752.82 106,153.70 104,538.92 102,908.33 101,261.77 99,599.09 97,920.13 96,224.73 94,512.73 92,783.97 91,038.28 89,275.50 87,495.46 85,697.99 83,882.92 82,050.07 80,199.28 78,330.36 76,443.14 74,537.45 72,613.10 70,669.90 68,707.68 66,726.24 64,725.40 62,704.97 60,664.76 58,604.57 56,524.21 54,423.48 52,302.18 50,160.11 47,997.06 Developed by Excely.com (c) 2007 Balance $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 45,812.83 43,607.21 41,380.00 39,130.98 36,859.94 34,566.66 32,250.93 29,912.52 27,551.21 25,166.78 22,759.00 20,327.65 17,872.49 15,393.29 12,889.82 10,361.83 7,809.09 5,231.35 2,628.37 - Developed by Excely.com (c) 2007 Balance Developed by Excely.com (c) 2007