TCO Petrol and Diesel

Document Sample
TCO Petrol and Diesel Powered By Docstoc
					                  Cost of         Cost of                       Days in a    Distance
                  Vehicle -       Vehicle -                     working      per
                  Petrol          Diesel    Distance Per day    Month        month
                  832000.00       732000.00                  24           20         0
Mileage of
Vehicle                12.00           17.00
Calculated
Value                                                              24             480




                  Cost            Cost           Savings Bank
Year              Petrol          Diesel.        interest
              1            62.2             45                  4.00%
              2              67             45                  4.00%
              3              67             45                  4.00%
              4              67             82                  4.00%
              5             100             82                  4.00%
              6             100             82                  4.00%
              7             100             82                  4.00%
              8             100             82                  4.00%
              9             100             82                  4.00%
             10             100             82                  4.00%
Distance
Per year
         0



     5760
                           Petrol Vehicle
                                            Filters (petrol,oil
Year        Service    tyres    Battery            etc)           Total
        1       2000        0         0                       0     2000
        2       6000        0         0                       0     6000
        3       6000        0         0                       0     6000
        4       6000    20000      5000                       0    31000
        5       9000        0         0                       0     9000
        6       6000        0         0                       0     6000
        7       6000        0         0                       0     6000
        8       9000    20000      5000                       0    34000
        9       6000        0         0                       0     6000
       10       6000        0         0                       0     6000
                                                                  112000



                           Diesel Vehicle
                                            Filters (petrol,oil
Year        Service    tyres    Battery            etc)           Total
        1       2000        0         0                       0     2000
        2     12000         0         0                       0    12000
        3     12000         0         0                       0    12000
        4     16000     20000      9000                       0    45000
        5     12000         0         0                       0    12000
        6     12000         0         0                       0    12000
        7     12000         0         0                       0    12000
        8     16000     20000      9000                       0    45000
        9     12000         0         0                       0    12000
       10     12000         0         0                       0    12000
                                                                  176000
                                                                                                     Petrol Vehic

                          Bank Interest Amount if in                   Distance         Distance Per day(
Year        Amount        4%            Bank               petrol cost travelled (Year) 20 day Month)

        1     832000.00           4.00%        865280.00         62.20             5760.00               24.00
        2     865280.00           4.00%        899891.20         67.00             5760.00               24.00
        3     899891.20           4.00%        935886.85         67.00             5760.00               24.00
        4     935886.85           4.00%        973322.32         67.00             5760.00               24.00
        5     973322.32           4.00%       1012255.21        100.00             5760.00               24.00
        6    1012255.21           4.00%       1052745.42        100.00             5760.00               24.00
        7    1052745.42           4.00%       1094855.24        100.00             5760.00               24.00
        8    1094855.24           4.00%       1138649.45        100.00             5760.00               24.00
        9    1138649.45           4.00%       1184195.43        100.00             5760.00               24.00
       10    1184195.43           4.00%       1231563.25        100.00             5760.00               24.00
                                                                                     57600



                                                                                                     Diesel Vehic

                          Bank Interest Amount if in                   Distance              Distance Per day(
Year        Amount        4%            Bank               Diesel cost travelled             20 day Month)

        1  732000.00              4.00%        761280.00         45.00             5760.00               24.00
        2  761280.00              4.00%        791731.20         45.00             5760.00               24.00
        3  791731.20              4.00%        823400.45         45.00             5760.00               24.00
        4  823400.45              4.00%        856336.47         82.00             5760.00               24.00
        5  856336.47              4.00%        890589.92         82.00             5760.00               24.00
        6  890589.92              4.00%        926213.52         82.00             5760.00               24.00
        7  926213.52              4.00%        963262.06         82.00             5760.00               24.00
        8  963262.06              4.00%       1001792.54         82.00             5760.00               24.00
        9 1001792.54              4.00%       1041864.25         82.00             5760.00               24.00
       10 1041864.25              4.00%       1083538.82         82.00             5760.00               24.00
                                                                                     57600
Petrol Vehicle
                                                                                         Diff Between
                                                                                         Petrol and Diesel
     Distance                                                                            (Tco Petrol -TCO
     Travelled in a                                                                      Diesel) - negative
     Month                Mileage Liters      Fuel Cost    Service charge TCO            means cheaper

                 480.00      12.00   480.00     29856.00          2000.00    897136.00            118608.94
                 480.00      12.00   480.00     32160.00          6000.00    938051.20            119072.94
                 480.00      12.00   480.00     32160.00          6000.00    974046.85            123399.34
                 480.00      12.00   480.00     32160.00         31000.00   1036482.32            107362.33
                 480.00      12.00   480.00     48000.00          9000.00   1069255.21            138881.76
                 480.00      12.00   480.00     48000.00          6000.00   1106745.42            140748.37
                 480.00      12.00   480.00     48000.00          6000.00   1148855.24            145809.65
                 480.00      12.00   480.00     48000.00         34000.00   1220649.45            146073.38
                 480.00      12.00   480.00     48000.00          6000.00   1238195.43            156547.65
                 480.00      12.00   480.00     48000.00          6000.00   1285563.25            162240.90
                                                                   112000



Diesel Vehicle
                                                                                         Diff Between
                                                                                         Petrol and Diesel
     Distance                                                                            (Tco Diesel -TCO
     Travelled in a                                                                      Petrol) - negative
     Month                Mileage Liters      Fuel Cost    Service charge TCO            means cheaper

                 480.00      17.00   338.82     15247.06          2000.00    778527.06            -118608.94
                 480.00      17.00   338.82     15247.06         12000.00    818978.26            -119072.94
                 480.00      17.00   338.82     15247.06         12000.00    850647.51            -123399.34
                 480.00      17.00   338.82     27783.53         45000.00    929120.00            -107362.33
                 480.00      17.00   338.82     27783.53         12000.00    930373.45            -138881.76
                 480.00      17.00   338.82     27783.53         12000.00    965997.05            -140748.37
                 480.00      17.00   338.82     27783.53         12000.00   1003045.59            -145809.65
                 480.00      17.00   338.82     27783.53         45000.00   1074576.07            -146073.38
                 480.00      17.00   338.82     27783.53         12000.00   1081647.78            -156547.65
                 480.00      17.00   338.82     27783.53         12000.00   1123322.35            -162240.90
                                                                   176000

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:13
posted:8/15/2012
language:English
pages:5