Docstoc

cost

Document Sample
cost Powered By Docstoc
					FLYING EXPENSES PER PERSON, N 20843

NUMBER OF PILOTS                            1                      2               3               4                        5               6               7                       8               9

ANNUAL FIXED EXP
Tiedown/Hangar               $     1,320.00     $            660.00    $     440.00    $     330.00    $           264.00       $     220.00    $     188.57    $          165.00       $     146.67
Insurance                    $     2,530.00     $          1,265.00    $     843.33    $     632.50    $           506.00       $     421.67    $     361.43    $          316.25       $     281.11
Property Tax                 $       998.00     $            499.00    $     332.67    $     249.50    $           199.60       $     166.33    $     142.57    $          124.75       $     110.89
Annual                       $     1,040.00     $            520.00    $     346.67    $     260.00    $           208.00       $     173.33    $     148.57    $          130.00       $     115.56
Maintenance                  $       500.00     $            250.00    $     166.67    $     125.00    $           100.00       $      83.33    $      71.43    $           62.50       $      55.56
Loan Payments                $         1.05     $              0.53    $       0.35    $       0.26    $             0.21       $       0.18    $       0.15    $            0.13       $       0.12

Cost of Capital (non-cash)   $     1,970.12     $            985.06    $     656.71    $     492.53    $           394.02       $     328.35    $     281.45    $          246.27       $     218.90

 Total Fixed Exp/Yr          $     8,359.17     $          4,179.59    $    2,786.39   $    2,089.79   $        1,671.83        $    1,393.20   $    1,194.17   $        1,044.90       $     928.80

HOURLY OP EXP
Fuel                         $       23.40      $             23.40    $      23.40    $      23.40    $            23.40       $      23.40    $      23.40    $           23.40       $      23.40
Oil                          $        0.26      $              0.26    $       0.26    $       0.26    $             0.26       $       0.26    $       0.26    $            0.26       $       0.26
Engine Reserve               $       10.87      $             10.87    $      10.87    $      10.87    $            10.87       $      10.87    $      10.87    $           10.87       $      10.87
Gen. Maint. Reserve          $        2.00      $              2.00    $       2.00    $       2.00    $             2.00       $       2.00    $       2.00    $            2.00       $       2.00

Total Op Exp/hr              $       36.53      $             36.53    $      36.53    $      36.53    $            36.53       $      36.53    $      36.53    $           36.53       $      36.53

TOTAL HOURLY EXP
50 Hours                     $      203.71      $            120.12    $      92.26    $      78.33    $            69.97       $      64.39    $      60.41    $           57.43       $      55.11
100 Hours                    $      120.12      $             78.33    $      64.39    $      57.43    $            53.25       $      50.46    $      48.47    $           46.98       $      45.82
150 Hours                    $       92.26      $             64.39    $      55.11    $      50.46    $            47.68       $      45.82    $      44.49    $           43.50       $      42.72

Hourly Comml Rental          $       68.00      $             68.00    $      68.00    $      68.00    $            68.00       $      68.00    $      68.00    $           68.00       $      68.00

TOTAL ANNUAL EXP
50 Hours, Own                $    10,185.65     $          6,006.07    $    4,612.87   $    3,916.27   $        3,498.31        $    3,219.67   $    3,020.65   $        2,871.38       $    2,755.28
Own (cash only)              $     8,215.53     $          5,021.01    $    3,956.16   $    3,423.74   $        3,104.29        $    2,891.32   $    2,739.20   $        2,625.11       $    2,536.37
Rent                         $     3,400.00     $          3,400.00    $    3,400.00   $    3,400.00   $        3,400.00        $    3,400.00   $    3,400.00   $        3,400.00       $    3,400.00

100 Hours, Own               $    12,012.13     $          7,832.54    $    6,439.35   $    5,742.75   $        5,324.79        $    5,046.15   $    4,847.12   $        4,697.85       $    4,581.75
Own (cash only)              $    10,042.01     $          6,847.48    $    5,782.64   $    5,250.22   $        4,930.77        $    4,717.80   $    4,565.68   $        4,451.59       $    4,362.85
Rent                         $     6,800.00     $          6,800.00    $    6,800.00   $    6,800.00   $        6,800.00        $    6,800.00   $    6,800.00   $        6,800.00       $    6,800.00


150 Hours, Own               $    13,838.61     $          9,659.02    $    8,265.83   $    7,569.23   $        7,151.27        $    6,872.63   $    6,673.60   $        6,524.33       $    6,408.23
Own (Cash only)              $    11,868.49     $          8,673.96    $    7,609.12   $    7,076.70   $        6,757.25        $    6,544.28   $    6,392.16   $        6,278.07       $    6,189.33
Rent                         $    10,200.00     $         10,200.00    $   10,200.00   $   10,200.00   $       10,200.00        $   10,200.00   $   10,200.00   $       10,200.00       $   10,200.00



                             ASSUMPTIONS:       Tie Down/Month:        $     110.00                    Insurance/yr:            $    2,530.00                                     $
                                                                                                                                                                Personal Property Tax:        998.00

                                                Fuel Cons. (gal/hr):               9                   Fuel Cost ($/gal):       $        2.60                   Oil Cons (qt/hr):                0.13

                                                Aircraft Value:        $   49,254.00                   Loan O/S:                $        1.00                   Loan Interest Rate:               0.1
Engine MOH Cost:   $   12,000.00   Gen Maint Res/hr: $   2.00   Com. Rental/hr:   $   68.00
           10                          11              12              13                     14              15


$     132.00    $                  120.00   $     110.00    $     101.54    $            94.29     $      88.00
$     253.00    $                  230.00   $     210.83    $     194.62    $           180.71     $     168.67
$      99.80    $                   90.73   $      83.17    $      76.77    $            71.29     $      66.53
$     104.00    $                   94.55   $      86.67    $      80.00    $            74.29     $      69.33
$      50.00    $                   45.45   $      41.67    $      38.46    $            35.71     $      33.33
$       0.11    $                    0.10   $       0.09    $       0.08    $             0.08     $       0.07

$     197.01    $                  179.10   $     164.18    $     151.55    $           140.72     $     131.34

$     835.92    $                  759.92   $     696.60    $     643.01    $           597.08     $     557.28


$      23.40    $                   23.40   $      23.40    $      23.40    $            23.40     $      23.40
$       0.26    $                    0.26   $       0.26    $       0.26    $             0.26     $       0.26
$      10.87    $                   10.87   $      10.87    $      10.87    $            10.87     $      10.87
$       2.00    $                    2.00   $       2.00    $       2.00    $             2.00     $       2.00

$      36.53    $                   36.53   $      36.53    $      36.53    $            36.53     $      36.53


$      53.25    $                   51.73   $      50.46    $      49.39    $            48.47     $      47.68
$      44.89    $                   44.13   $      43.50    $      42.96    $            42.50     $      42.10
$      42.10    $                   41.60   $      41.17    $      40.82    $            40.51     $      40.24

$      68.00    $                   68.00   $      68.00    $      68.00    $            68.00     $      68.00


$    2,662.40   $             2,586.40      $    2,523.08   $    2,469.49   $         2,423.56     $    2,383.76
$    2,465.38   $             2,407.30      $    2,358.90   $    2,317.94   $         2,282.84     $    2,252.42
$    3,400.00   $             3,400.00      $    3,400.00   $    3,400.00   $         3,400.00     $    3,400.00

$    4,488.87   $             4,412.88      $    4,349.55   $    4,295.97   $         4,250.04     $    4,210.23
$    4,291.86   $             4,233.78      $    4,185.38   $    4,144.42   $         4,109.32     $    4,078.89
$    6,800.00   $             6,800.00      $    6,800.00   $    6,800.00   $         6,800.00     $    6,800.00


$    6,315.35   $            6,239.36       $    6,176.03   $    6,122.45   $         6,076.52     $    6,036.71
$    6,118.34   $            6,060.26       $    6,011.86   $    5,970.90   $         5,935.80     $    5,905.37
$   10,200.00   $           10,200.00       $   10,200.00   $   10,200.00   $        10,200.00     $   10,200.00



                Annual:                     $    1,040.00                   Maintenance/yr:        $     500.00

                Oil Cost ($/qt):            $        2.00                   Time Before OVH:               1,104

                Loan/Inv. Term (yrs):                   1                   Cost of Capital Rate: $         0.04
Assumptions Used in Creating the Spreadsheet

Commercial Rental Rate             $68       per hour, tax included, for a C-172 from an FBO
Aircraft Base Value           $49,254.00
Loan Amount                       $1.00      A dollar is entered to make the spreadsheet operable
Loan Term                         1 Year     Entered to make spreadsheet operable
Loan Interest Rate                 10%       Entered to make spreadsheet operable
Cost of Capital                     4%       What you loose on money invested in plane rather than in CD
Time before overhaul          1,104 Hours
Engine Overhaul Cost            $12,000
General Maintenance Reserve    $2.00/hour
Shade Port Rental             $110/month
Annual Insurance              $2,530/year
Annual Maintenance Cost        $500/year
Annual Inspection             $1040/year
Personal Property Tax          $998/year
Fuel Consumption               9 gal/hour
Fuel cost per gallon              $2.60      For 100LL
Oil Consumption                 .13 qts/hr
Oil Cost per quart               $2.00/qt

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:49
posted:8/23/2012
language:Unknown
pages:5