Petrol Car or Diesel Car by fanzhongqing

VIEWS: 5 PAGES: 12

									                  Enter Values below

Diesel Car OTR Cost                                         700,000   Rs
Petrol Car OTR Cost                                         610,000   Rs
Diesel Fuel Cost                                              40.00   Rs/litre
Petrol Fuel Cost                                              54.00   Rs/litre
Diesel Car FE Highway                                          20.0   kms/litre
Petrol Car FE Highway                                          15.5   kms/litre
Diesel Car FE City                                             15.0   kms/litre
Petrol Car FE City                                             11.0   kms/litre
Diesel Car Service Period (service interval)                 15,000   kms
Petrol Car Service Period (service interval)                 15,000   kms
Diesel Car Cost per service                                   2,500   Rs
Petrol Car Cost per service                                   2,000   Rs
Diesel Car extra Maintenance cost if any                      5,000   Rs
Petrol Car extra Maintenance cost if any                      2,500   Rs
Highway Kms in a month                                          600   kms
City Kms in a month                                           1,000   kms
No. of Years of Possession of Car                              5.00   Years
Resale value of Diesel car after that many years            350,000   Rs
Resale value of Petrol car after that many years            305,000   Rs
Insurance Cost for diesel car for remaining years            55,000   Rs
Insurance Cost for petrol car for remaining years            43,000   Rs
Rate of Interest if investing for that many years            7.00%    Percent

Inputs
Optional Inputs
Outputs
                                                        Assumptions:
                                                    1   Resale value has been entered as exactly half of the original purchase pr
                                                    2   Insurance costs will be higher for diesel car compared to petrol because o
                                                    3   More of City vs Highway travelling would effect how sooner you can start
                                                    4   Current diesel & petrol prices have been considered, so over years govt d
                                                    5   When a car is sold at the end of say 5 years, the amount saved initially by
                             Calculated Values Below

             Difference in cost                                                        90,000   Rs
             Difference amount after investing for that many years                   126,230    Rs
             Diesel Car Maintenance cost per km                                          0.22   Rs
             Petrol Car Maintenance cost per km                                          0.16   Rs
             Diesel Car Total Maintenance cost                                         21,000   Rs
             Petrol Car Total Maintenance cost                                         15,300   Rs
             Diesel Car Fuel Cost per km Highway                                         2.00   Rs
             Petrol Car Fuel Cost per km Highway                                         3.48   Rs
             Diesel Car Fuel Cost per km City                                            2.67   Rs
             Petrol Car Fuel Cost per km City                                            4.91   Rs
             Diesel Car Actual Cost per km                                               2.64   Rs
             Petrol Car Actual Cost per km                                               4.53   Rs
             Kms clocked per year (highway + city)                                     19,200   kms
             Total Kms clocked in that many years                                      96,000   kms
             Diesel Car Total Fuel Cost                                              232,000    Rs
             Petrol Car Total Fuel Cost                                              419,965    Rs
             Difference in Total Fuel cost                                           187,965    Rs
             Diesel Car Total Running Cost (includes insurance)                      308,000    Rs
             Petrol Car Total Running Cost (includes insurance)                      478,265    Rs
             Difference In Total Running Cost                                        170,265    Rs
             Diesel Car Actual Cost of ownership                                     658,000    Rs
             Petrol Car Actual Cost of ownership                                     657,035    Rs
             Difference in cost of ownership                                             -965   Rs
             Kms on the ODO when diesel gains start to show up           Not yet keep driving   kms



 entered as exactly half of the original purchase price after 5 years, it can be changed in that cell.
 higher for diesel car compared to petrol because of original cost of the diesel car being higher.
 y travelling would effect how sooner you can start realising those gains.
prices have been considered, so over years govt decisions on subsidised fuel may play a major role later.
he end of say 5 years, the amount saved initially by chosing petrol matures after 5 years.
               Enter Values below

Diesel Car OTR Cost                                         700,000   Rs
Petrol Car OTR Cost                                         610,000   Rs
Diesel Car Actual Cost Down payment + All EMIs              764,647   Rs
Petrol Car Actual Cost Down payment + All EMIs              660,102   Rs
Diesel Fuel Cost                                              40.00   Rs/litre
Petrol Fuel Cost                                              54.00   Rs/litre
Diesel Car FE Highway                                          20.0   kms/litre
Petrol Car FE Highway                                          15.5   kms/litre
Diesel Car FE City                                             15.0   kms/litre
Petrol Car FE City                                             11.0   kms/litre
Diesel Car Service Period (service interval)                 15,000   kms
Petrol Car Service Period (service interval)                 15,000   kms
Diesel Car Cost per service                                   2,500   Rs
Petrol Car Cost per service                                   2,000   Rs
Diesel Car extra Maintenance cost if any                      5,000   Rs
Petrol Car extra Maintenance cost if any                      2,500   Rs
Highway Kms in a month                                          600   kms
City Kms in a month                                           1,000   kms
No. of Years of Possession of Car                              5.00   Years
Resale value of Diesel car after that many years            350,000   Rs
Resale value of Petrol car after that many years            305,000   Rs
Insurance Cost for diesel car for remaining years            55,000   Rs
Insurance Cost for petrol car for remaining years            43,000   Rs
Rate of Interest if investing for that many years            7.00%    Percent
Loan Details
Down Payment from your end                                  300,000   Rs
Diesel Car Loan Amount                                      400,000   Rs
Petrol Car Loan Amount                                      310,000   Rs
Rate of Interest of Loan                                      10.00   %
Tenure of Loan in years                                        3.00   Years
Total Interest paid for Diesel Car                           64,647   Rs
Total Interest paid for Petrol Car                           50,102   Rs
                                                                                        DIESEL
                                           Month Opening Principal EMI (D) Principal
                                           May-12           400,000 12,907      9,574
                                           Jun-12           390,426 12,907      9,653
                                            Jul-12          380,773 12,907      9,734
                                           Aug-12           371,039 12,907      9,815
                                           Sep-12           361,224 12,907      9,897
                                           Oct-12           351,328 12,907      9,979
                                           Nov-12           341,349 12,907     10,062
                                           Dec-12           331,286 12,907     10,146
                                           Jan-13           321,140 12,907     10,231
                                           Feb-13           310,910 12,907     10,316
                                           Mar-13           300,594 12,907     10,402
                                           Apr-13           290,192 12,907     10,489
                                           May-13           279,703 12,907     10,576
                                           Jun-13           269,127 12,907     10,664
                                            Jul-13          258,463 12,907     10,753
                                           Aug-13           247,710 12,907     10,843
        Sep-13    236,867    12,907    10,933
        Oct-13    225,934    12,907    11,024
        Nov-13    214,910    12,907    11,116
        Dec-13    203,794    12,907    11,209
        Jan-14    192,586    12,907    11,302
        Feb-14    181,284    12,907    11,396
        Mar-14    169,887    12,907    11,491
        May-14    158,396    12,907    11,587
        Jun-14    146,809    12,907    11,683
         Jul-14   135,126    12,907    11,781
        Aug-14    123,345    12,907    11,879
        Sep-14    111,466    12,907    11,978
        Oct-14     99,488    12,907    12,078
        Nov-14     87,410    12,907    12,178
        Dec-14     75,232    12,907    12,280
        Jan-15     62,952    12,907    12,382
        Feb-15     50,570    12,907    12,485
        Mar-15     38,084    12,907    12,590
        Apr-15     25,495    12,907    12,694
        May-15     12,800    12,907    12,800

Total                       464,647   400,000
              Calculated Values Below

Difference in cost in terms of paying EMI                              104,546    Rs --->
Difference amount after investing for that many years                  132,761    Rs --->
Diesel Car Maintenance cost per km                                         0.22   Rs
Petrol Car Maintenance cost per km                                         0.16   Rs
Diesel Car Total Maintenance cost                                        21,000   Rs
Petrol Car Total Maintenance cost                                        15,300   Rs
Diesel Car Fuel Cost per km Highway                                        2.00   Rs
Petrol Car Fuel Cost per km Highway                                        3.48   Rs
Diesel Car Fuel Cost per km City                                           2.67   Rs
Petrol Car Fuel Cost per km City                                           4.91   Rs
Diesel Car Actual Cost per km                                              2.64   Rs
Petrol Car Actual Cost per km                                              4.53   Rs
Kms clocked per year (highway + city)                                    19,200   kms
Total Kms clocked in that many years                                     96,000   kms
Diesel Car Total Fuel Cost                                             232,000    Rs
Petrol Car Total Fuel Cost                                             419,965    Rs
Difference in Total Fuel cost                                          187,965    Rs
Diesel Car Total Running Cost (includes insurance)                     308,000    Rs
Petrol Car Total Running Cost (includes insurance)                     478,265    Rs
Difference In Total Running Cost                                       170,265    Rs
Diesel Car Actual Cost of ownership                                    722,647    Rs
Petrol Car Actual Cost of ownership                                    700,605    Rs
Difference in cost of ownership                                         -22,042   Rs
Kms on the ODO when diesel gains start to show up          Not yet keep driving   kms

                                                                                  Assumptions:
                                                                             1    Resale value has been entered as exactly ha
Inputs                                                                       2    Insurance costs will be higher for diesel car c
Optional Inputs                                                              3    More of City vs Highway travelling would effe
Outputs                                                                      4    Current diesel & petrol prices have been cons
                                                                             5    EMI Difference has to be considered and if in

              DIESEL
Interest                                                  Closing Principal
                                                  3,333                 390,426
                                                  3,254                 380,773
                                                  3,173                 371,039
                                                  3,092                 361,224
                                                  3,010                 351,328
                                                  2,928                 341,349
                                                  2,845                 331,286
                                                  2,761                 321,140
                                                  2,676                 310,910
                                                  2,591                 300,594
                                                  2,505                 290,192
                                                  2,418                 279,703
                                                  2,331                 269,127
                                                  2,243                 258,463
                                                  2,154                 247,710
                                                  2,064                 236,867
 1,974   225,934
 1,883   214,910
 1,791   203,794
 1,698   192,586
 1,605   181,284
 1,511   169,887
 1,416   158,396
 1,320   146,809
 1,223   135,126
 1,126   123,345
 1,028   111,466
   929    99,488
   829    87,410
   728    75,232
   627    62,952
   525    50,570
   421    38,084
   317    25,495
   212    12,800
   107         0

64,647             Total
              Difference in monthly EMI                                                   2,904
              Total Difference = emi x 12 months x no. of years                         104,546
              Future Value if EMI difference invested monthly for duration of loan     115,959
              If above lump sum invested for remainder of life of car                   132,761




 sale value has been entered as exactly half of the original purchase price after 5 years, it can be changed in that cell.
 urance costs will be higher for diesel car compared to petrol because of original cost of the diesel car being higher.
 re of City vs Highway travelling would effect how sooner you can start realising those gains.
 rrent diesel & petrol prices have been considered, so over years govt decisions on subsidised fuel may play a major role later.
MI Difference has to be considered and if invested will fetch returns

                                                                                                                          PETROL
              Opening Principal                                                        EMI (P)
                                                                             310,000    10,003
                                                                             302,581    10,003
                                                                             295,099    10,003
                                                                             287,556    10,003
                                                                             279,949    10,003
                                                                             272,279    10,003
                                                                             264,545    10,003
                                                                             256,747    10,003
                                                                             248,884    10,003
                                                                             240,955    10,003
                                                                             232,960    10,003
                                                                             224,899    10,003
                                                                             216,770    10,003
                                                                             208,573    10,003
                                                                             200,309    10,003
                                                                             191,975    10,003
183,572    10,003
175,099    10,003
166,555    10,003
157,940    10,003
149,254    10,003
140,495    10,003
131,663    10,003
122,757    10,003
113,777    10,003
104,723    10,003
 95,592    10,003
 86,386    10,003
 77,103    10,003
 67,743    10,003
 58,305    10,003
 48,788    10,003
 39,191    10,003
 29,515    10,003
 19,758    10,003
  9,920    10,003

          360,102
 ears, it can be changed in that cell.
ost of the diesel car being higher.
ose gains.
  subsidised fuel may play a major role later.


                                        PETROL
              Principal                                  Interest
                                                 7,419      2,583
                                                 7,481      2,522
                                                 7,544      2,459
                                                 7,607      2,396
                                                 7,670      2,333
                                                 7,734      2,269
                                                 7,798      2,205
                                                 7,863      2,140
                                                 7,929      2,074
                                                 7,995      2,008
                                                 8,061      1,941
                                                 8,129      1,874
                                                 8,196      1,806
                                                 8,265      1,738
                                                 8,334      1,669
                                                 8,403      1,600
  8,473    1,530
  8,544    1,459
  8,615    1,388
  8,687    1,316
  8,759    1,244
  8,832    1,171
  8,906    1,097
  8,980    1,023
  9,055      948
  9,130      873
  9,206      797
  9,283      720
  9,360      643
  9,438      565
  9,517      486
  9,596      407
  9,676      327
  9,757      246
  9,838      165
  9,920       83

310,000   50,102
Closing Principal
                    302,581
                    295,099
                    287,556
                    279,949
                    272,279
                    264,545
                    256,747
                    248,884
                    240,955
                    232,960
                    224,899
                    216,770
                    208,573
                    200,309
                    191,975
                    183,572
175,099
166,555
157,940
149,254
140,495
131,663
122,757
113,777
104,723
 95,592
 86,386
 77,103
 67,743
 58,305
 48,788
 39,191
 29,515
 19,758
  9,920
      0

          Total

								
To top