Cash Flow Analysis

Scott F. Smith
sfsmith@oaktoninternational.com


 

Home
Introduction
Buying a Used Single Engine Aircraft
Engine Research & Installation
Avionics Research & Installation
Air Frame Repair
Finding a Flight School
Negotiating a Lease Back Agreement
Insurance
Maintenance
Commercial Operations
Cash Flow Analysis
Conclusion

Below is a cash flow matrix that shows how many hours the plane has to fly to break even,
and it analyses how 50037 is averaging. The far right column shows how much OIC subsidized
flight hours.

Variables 65.00   6.75% 2%   4.00   6.75% 2%     8.00   6.75% 2%         6 2.91   436.00 35.00 403.00     900.00   7.50    
  per hr.         factor           factor               gals per hr. per. Gal   Maint.current Mo.   per. Mo.     per Mo.   per hr.    
Variables are from Operational averages.         Hourly         Hourly           Hourly     Hourly                          
          Owner         Club           Standard     Owner   Current         Total   Monthly       Owner
Hours Flown Owner Rate Owner Cum Sales Tax Airport Fee Total Due Club Rate  Club Cum Sales Tax Airport Fee Total Due FBO Profit Standard Rate Standard Cum Sales Tax Airport Fee Total Due FBO Profit Hours Flown Income Gal Fuel Price Fuel Cost Maint. Tie Down Insurance Expenses Net Capital Cost Payback Capital Cost + Expenses Prop/Engine Reserve Profit/Loss Subsidy
                                                                 
0 65.00 0.00 0.00 0.00 0.00 69.00 0.00 0.00 0.00 0.00 0.00 73.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0 2.91 0.00 436.00 35.00 403.00 874.00 (874.00) 900.00 1774.00 0.00 (1774.00) 1774.00
1 65.00 65.00 4.39 1.30 70.69 69.00 69.00 4.66 1.38 75.04 4.00 73.00 73.00 4.93 1.46 79.39 8.00 1 65.00 6 2.91 17.46 436.00 35.00 403.00 891.46 (826.46) 900.00 1726.46 7.50 (1733.96) 1733.96
2 65.00 130.00 8.78 2.60 141.38 69.00 138.00 9.32 2.76 150.08 8.00 73.00 146.00 9.86 2.92 158.78 16.00 2 130.00 12 2.91 34.92 436.00 35.00 403.00 908.92 (778.92) 900.00 1678.92 15.00 (1693.92) 846.96
3 65.00 195.00 13.16 3.90 212.06 69.00 207.00 13.97 4.14 225.11 12.00 73.00 219.00 14.78 4.38 238.16 24.00 3 195.00 18 2.91 52.38 436.00 35.00 403.00 926.38 (731.38) 900.00 1631.38 22.50 (1653.88) 551.29
4 65.00 260.00 17.55 5.20 282.75 69.00 276.00 18.63 5.52 300.15 16.00 73.00 292.00 19.71 5.84 317.55 32.00 4 260.00 24 2.91 69.84 436.00 35.00 403.00 943.84 (683.84) 900.00 1583.84 30.00 (1613.84) 403.46
5 65.00 325.00 21.94 6.50 353.44 69.00 345.00 23.29 6.90 375.19 20.00 73.00 365.00 24.64 7.30 396.94 40.00 5 325.00 30 2.91 87.30 436.00 35.00 403.00 961.30 (636.30) 900.00 1536.30 37.50 (1573.80) 314.76
6 65.00 390.00 26.33 7.80 424.13 69.00 414.00 27.95 8.28 450.23 24.00 73.00 438.00 29.57 8.76 476.33 48.00 6 390.00 36 2.91 104.76 436.00 35.00 403.00 978.76 (588.76) 900.00 1488.76 45.00 (1533.76) 255.63
7 65.00 455.00 30.71 9.10 494.81 69.00 483.00 32.60 9.66 525.26 28.00 73.00 511.00 34.49 10.22 555.71 56.00 7 455.00 42 2.91 122.22 436.00 35.00 403.00 996.22 (541.22) 900.00 1441.22 52.50 (1493.72) 213.39
8 65.00 520.00 35.10 10.40 565.50 69.00 552.00 37.26 11.04 600.30 32.00 73.00 584.00 39.42 11.68 635.10 64.00 8 520.00 48 2.91 139.68 436.00 35.00 403.00 1013.68 (493.68) 900.00 1393.68 60.00 (1453.68) 181.71
9 65.00 585.00 39.49 11.70 636.19 69.00 621.00 41.92 12.42 675.34 36.00 73.00 657.00 44.35 13.14 714.49 72.00 9 585.00 54 2.91 157.14 436.00 35.00 403.00 1031.14 (446.14) 900.00 1346.14 67.50 (1413.64) 157.07
10 65.00 650.00 43.88 13.00 706.88 69.00 690.00 46.58 13.80 750.38 40.00 73.00 730.00 49.28 14.60 793.88 80.00 10 650.00 60 2.91 174.60 436.00 35.00 403.00 1048.60 (398.60) 900.00 1298.60 75.00 (1373.60) 137.36
11 65.00 715.00 48.26 14.30 777.56 69.00 759.00 51.23 15.18 825.41 44.00 73.00 803.00 54.20 16.06 873.26 88.00 11 715.00 66 2.91 192.06 436.00 35.00 403.00 1066.06 (351.06) 900.00 1251.06 82.50 (1333.56) 121.23
12 65.00 780.00 52.65 15.60 848.25 69.00 828.00 55.89 16.56 900.45 48.00 73.00 876.00 59.13 17.52 952.65 96.00 12 780.00 72 2.91 209.52 436.00 35.00 403.00 1083.52 (303.52) 900.00 1203.52 90.00 (1293.52) 107.79
13 65.00 845.00 57.04 16.90 918.94 69.00 897.00 60.55 17.94 975.49 52.00 73.00 949.00 64.06 18.98 1,032.04 104.00 13 845.00 78 2.91 226.98 436.00 35.00 403.00 1100.98 (255.98) 900.00 1155.98 97.50 (1253.48) 96.42
14 65.00 910.00 61.43 18.20 989.63 69.00 966.00 65.21 19.32 1,050.53 56.00 73.00 1,022.00 68.99 20.44 1,111.43 112.00 14 910.00 84 2.91 244.44 436.00 35.00 403.00 1118.44 (208.44) 900.00 1108.44 105.00 (1213.44) 86.67
15 65.00 975.00 65.81 19.50 1,060.31 69.00 1,035.00 69.86 20.70 1,125.56 60.00 73.00 1,095.00 73.91 21.90 1,190.81 120.00 15 975.00 90 2.91 261.90 436.00 35.00 403.00 1135.90 (160.90) 900.00 1060.90 112.50 (1173.40) 78.23
16 65.00 1,040.00 70.20 20.80 1,131.00 69.00 1,104.00 74.52 22.08 1,200.60 64.00 73.00 1,168.00 78.84 23.36 1,270.20 128.00 16 1,040.00 96 2.91 279.36 436.00 35.00 403.00 1153.36 (113.36) 900.00 1013.36 120.00 (1133.36) 70.84
17 65.00 1,105.00 74.59 22.10 1,201.69 69.00 1,173.00 79.18 23.46 1,275.64 68.00 73.00 1,241.00 83.77 24.82 1,349.59 136.00 17 1,105.00 102 2.91 296.82 436.00 35.00 403.00 1170.82 (65.82) 900.00 965.82 127.50 (1093.32) 64.31
18 65.00 1,170.00 78.98 23.40 1,272.38 69.00 1,242.00 83.84 24.84 1,350.68 72.00 73.00 1,314.00 88.70 26.28 1,428.98 144.00 18 1,170.00 108 2.91 314.28 436.00 35.00 403.00 1188.28 (18.28) 900.00 918.28 135.00 (1053.28) 58.52
19 65.00 1,235.00 83.36 24.70 1,343.06 69.00 1,311.00 88.49 26.22 1,425.71 76.00 73.00 1,387.00 93.62 27.74 1,508.36 152.00 19 1,235.00 114 2.91 331.74 436.00 35.00 403.00 1205.74 29.26 900.00 870.74 142.50 (1013.24) 53.33
20 65.00 1,300.00 87.75 26.00 1,413.75 69.00 1,380.00 93.15 27.60 1,500.75 80.00 73.00 1,460.00 98.55 29.20 1,587.75 160.00 20 1,300.00 120 2.91 349.20 436.00 35.00 403.00 1223.20 76.80 900.00 823.20 150.00 (973.20) 48.66
21 65.00 1,365.00 92.14 27.30 1,484.44 69.00 1,449.00 97.81 28.98 1,575.79 84.00 73.00 1,533.00 103.48 30.66 1,667.14 168.00 21 1,365.00 126 2.91 366.66 436.00 35.00 403.00 1240.66 124.34 900.00 775.66 157.50 (933.16) 44.44
22 65.00 1,430.00 96.53 28.60 1,555.13 69.00 1,518.00 102.47 30.36 1,650.83 88.00 73.00 1,606.00 108.41 32.12 1,746.53 176.00 22 1,430.00 132 2.91 384.12 436.00 35.00 403.00 1258.12 171.88 900.00 728.12 165.00 (893.12) 40.60
23 65.00 1,495.00 100.91 29.90 1,625.81 69.00 1,587.00 107.12 31.74 1,725.86 92.00 73.00 1,679.00 113.33 33.58 1,825.91 184.00 23 1,495.00 138 2.91 401.58 436.00 35.00 403.00 1275.58 219.42 900.00 680.58 172.50 (853.08) 37.09
24 65.00 1,560.00 105.30 31.20 1,696.50 69.00 1,656.00 111.78 33.12 1,800.90 96.00 73.00 1,752.00 118.26 35.04 1,905.30 192.00 24 1,560.00 144 2.91 419.04 436.00 35.00 403.00 1293.04 266.96 900.00 633.04 180.00 (813.04) 33.88
25 65.00 1,625.00 109.69 32.50 1,767.19 69.00 1,725.00 116.44 34.50 1,875.94 100.00 73.00 1,825.00 123.19 36.50 1,984.69 200.00 25 1,625.00 150 2.91 436.50 436.00 35.00 403.00 1310.50 314.50 900.00 585.50 187.50 (773.00) 30.92
26 65.00 1,690.00 114.08 33.80 1,837.88 69.00 1,794.00 121.10 35.88 1,950.98 104.00 73.00 1,898.00 128.12 37.96 2,064.08 208.00 26 1,690.00 156 2.91 453.96 436.00 35.00 403.00 1327.96 362.04 900.00 537.96 195.00 (732.96) 28.19
27 65.00 1,755.00 118.46 35.10 1,908.56 69.00 1,863.00 125.75 37.26 2,026.01 108.00 73.00 1,971.00 133.04 39.42 2,143.46 216.00 27 1,755.00 162 2.91 471.42 436.00 35.00 403.00 1345.42 409.58 900.00 490.42 202.50 (692.92) 25.66
28 65.00 1,820.00 122.85 36.40 1,979.25 69.00 1,932.00 130.41 38.64 2,101.05 112.00 73.00 2,044.00 137.97 40.88 2,222.85 224.00 28 1,820.00 168 2.91 488.88 436.00 35.00 403.00 1362.88 457.12 900.00 442.88 210.00 (652.88) 23.32
29 65.00 1,885.00 127.24 37.70 2,049.94 69.00 2,001.00 135.07 40.02 2,176.09 116.00 73.00 2,117.00 142.90 42.34 2,302.24 232.00 29 1,885.00 174 2.91 506.34 436.00 35.00 403.00 1380.34 504.66 900.00 395.34 217.50 (612.84) 21.13
30 65.00 1,950.00 131.63 39.00 2,120.63 69.00 2,070.00 139.73 41.40 2,251.13 120.00 73.00 2,190.00 147.83 43.80 2,381.63 240.00 30 1,950.00 180 2.91 523.80 436.00 35.00 403.00 1397.80 552.20 900.00 347.80 225.00 (572.80) 19.09
31 65.00 2,015.00 136.01 40.30 2,191.31 69.00 2,139.00 144.38 42.78 2,326.16 124.00 73.00 2,263.00 152.75 45.26 2,461.01 248.00 31 2,015.00 186 2.91 541.26 436.00 35.00 403.00 1415.26 599.74 900.00 300.26 232.50 (532.76) 17.19
32 65.00 2,080.00 140.40 41.60 2,262.00 69.00 2,208.00 149.04 44.16 2,401.20 128.00 73.00 2,336.00 157.68 46.72 2,540.40 256.00 32 2,080.00 192 2.91 558.72 436.00 35.00 403.00 1432.72 647.28 900.00 252.72 240.00 (492.72) 15.40
33 65.00 2,145.00 144.79 42.90 2,332.69 69.00 2,277.00 153.70 45.54 2,476.24 132.00 73.00 2,409.00 162.61 48.18 2,619.79 264.00 33 2,145.00 198 2.91 576.18 436.00 35.00 403.00 1450.18 694.82 900.00 205.18 247.50 (452.68) 13.72
34 65.00 2,210.00 149.18 44.20 2,403.38 69.00 2,346.00 158.36 46.92 2,551.28 136.00 73.00 2,482.00 167.54 49.64 2,699.18 272.00 34 2,210.00 204 2.91 593.64 436.00 35.00 403.00 1467.64 742.36 900.00 157.64 255.00 (412.64) 12.14
35 65.00 2,275.00 153.56 45.50 2,474.06 69.00 2,415.00 163.01 48.30 2,626.31 140.00 73.00 2,555.00 172.46 51.10 2,778.56 280.00 35 2,275.00 210 2.91 611.10 436.00 35.00 403.00 1485.10 789.90 900.00 110.10 262.50 (372.60) 10.65
36 65.00 2,340.00 157.95 46.80 2,544.75 69.00 2,484.00 167.67 49.68 2,701.35 144.00 73.00 2,628.00 177.39 52.56 2,857.95 288.00 36 2,340.00 216 2.91 628.56 436.00 35.00 403.00 1502.56 837.44 900.00 62.56 270.00 (332.56) 9.24
37 65.00 2,405.00 162.34 48.10 2,615.44 69.00 2,553.00 172.33 51.06 2,776.39 148.00 73.00 2,701.00 182.32 54.02 2,937.34 296.00 37 2,405.00 222 2.91 646.02 436.00 35.00 403.00 1520.02 884.98 900.00 15.02 277.50 (292.52) 7.91
38 65.00 2,470.00 166.73 49.40 2,686.13 69.00 2,622.00 176.99 52.44 2,851.43 152.00 73.00 2,774.00 187.25 55.48 3,016.73 304.00 38 2,470.00 228 2.91 663.48 436.00 35.00 403.00 1537.48 932.52 900.00 (32.52) 285.00 (252.48) 6.64
39 65.00 2,535.00 171.11 50.70 2,756.81 69.00 2,691.00 181.64 53.82 2,926.46 156.00 73.00 2,847.00 192.17 56.94 3,096.11 312.00 39 2,535.00 234 2.91 680.94 436.00 35.00 403.00 1554.94 980.06 900.00 (80.06) 292.50 (212.44) 5.45
40 65.00 2,600.00 175.50 52.00 2,827.50 69.00 2,760.00 186.30 55.20 3,001.50 160.00 73.00 2,920.00 197.10 58.40 3,175.50 320.00 40 2,600.00 240 2.91 698.40 436.00 35.00 403.00 1572.40 1027.60 900.00 (127.60) 300.00 (172.40) 4.31
41 65.00 2,665.00 179.89 53.30 2,898.19 69.00 2,829.00 190.96 56.58 3,076.54 164.00 73.00 2,993.00 202.03 59.86 3,254.89 328.00 41 2,665.00 246 2.91 715.86 436.00 35.00 403.00 1589.86 1075.14 900.00 (175.14) 307.50 (132.36) 3.23
42 65.00 2,730.00 184.28 54.60 2,968.88 69.00 2,898.00 195.62 57.96 3,151.58 168.00 73.00 3,066.00 206.96 61.32 3,334.28 336.00 42 2,730.00 252 2.91 733.32 436.00 35.00 403.00 1607.32 1122.68 900.00 (222.68) 315.00 (92.32) 2.20
43 65.00 2,795.00 188.66 55.90 3,039.56 69.00 2,967.00 200.27 59.34 3,226.61 172.00 73.00 3,139.00 211.88 62.78 3,413.66 344.00 43 2,795.00 258 2.91 750.78 436.00 35.00 403.00 1624.78 1170.22 900.00 (270.22) 322.50 (52.28) 1.22
44 65.00 2,860.00 193.05 57.20 3,110.25 69.00 3,036.00 204.93 60.72 3,301.65 176.00 73.00 3,212.00 216.81 64.24 3,493.05 352.00 44 2,860.00 264 2.91 768.24 436.00 35.00 403.00 1642.24 1217.76 900.00 (317.76) 330.00 (12.24) 0.28
45 65.00 2,925.00 197.44 58.50 3,180.94 69.00 3,105.00 209.59 62.10 3,376.69 180.00 73.00 3,285.00 221.74 65.70 3,572.44 360.00 45 2,925.00 270 2.91 785.70 436.00 35.00 403.00 1659.70 1265.30 900.00 (365.30) 337.50 27.80 -0.62
46 65.00 2,990.00 201.83 59.80 3,251.63 69.00 3,174.00 214.25 63.48 3,451.73 184.00 73.00 3,358.00 226.67 67.16 3,651.83 368.00 46 2,990.00 276 2.91 803.16 436.00 35.00 403.00 1677.16 1312.84 900.00 (412.84) 345.00 67.84 -1.47
47 65.00 3,055.00 206.21 61.10 3,322.31 69.00 3,243.00 218.90 64.86 3,526.76 188.00 73.00 3,431.00 231.59 68.62 3,731.21 376.00 47 3,055.00 282 2.91 820.62 436.00 35.00 403.00 1694.62 1360.38 900.00 (460.38) 352.50 107.88 -2.30
48 65.00 3,120.00 210.60 62.40 3,393.00 69.00 3,312.00 223.56 66.24 3,601.80 192.00 73.00 3,504.00 236.52 70.08 3,810.60 384.00 48 3,120.00 288 2.91 838.08 436.00 35.00 403.00 1712.08 1407.92 900.00 (507.92) 360.00 147.92 -3.08
49 65.00 3,185.00 214.99 63.70 3,463.69 69.00 3,381.00 228.22 67.62 3,676.84 196.00 73.00 3,577.00 241.45 71.54 3,889.99 392.00 49 3,185.00 294 2.91 855.54 436.00 35.00 403.00 1729.54 1455.46 900.00 (555.46) 367.50 187.96 -3.84
50 65.00 3,250.00 219.38 65.00 3,534.38 69.00 3,450.00 232.88 69.00 3,751.88 200.00 73.00 3,650.00 246.38 73.00 3,969.38 400.00 50 3,250.00 300 2.91 873.00 436.00 35.00 403.00 1747.00 1503.00 900.00 (603.00) 375.00 228.00 -4.56
51 65.00 3,315.00 223.76 66.30 3,605.06 69.00 3,519.00 237.53 70.38 3,826.91 204.00 73.00 3,723.00 251.30 74.46 4,048.76 408.00 51 3,315.00 306 2.91 890.46 436.00 35.00 403.00 1764.46 1550.54 900.00 (650.54) 382.50 268.04 -5.26
52 65.00 3,380.00 228.15 67.60 3,675.75 69.00 3,588.00 242.19 71.76 3,901.95 208.00 73.00 3,796.00 256.23 75.92 4,128.15 416.00 52 3,380.00 312 2.91 907.92 436.00 35.00 403.00 1781.92 1598.08 900.00 (698.08) 390.00 308.08 -5.92
53 65.00 3,445.00 232.54 68.90 3,746.44 69.00 3,657.00 246.85 73.14 3,976.99 212.00 73.00 3,869.00 261.16 77.38 4,207.54 424.00 53 3,445.00 318 2.91 925.38 436.00 35.00 403.00 1799.38 1645.62 900.00 (745.62) 397.50 348.12 -6.57
54 65.00 3,510.00 236.93 70.20 3,817.13 69.00 3,726.00 251.51 74.52 4,052.03 216.00 73.00 3,942.00 266.09 78.84 4,286.93 432.00 54 3,510.00 324 2.91 942.84 436.00 35.00 403.00 1816.84 1693.16 900.00 (793.16) 405.00 388.16 -7.19
55 65.00 3,575.00 241.31 71.50 3,887.81 69.00 3,795.00 256.16 75.90 4,127.06 220.00 73.00 4,015.00 271.01 80.30 4,366.31 440.00 55 3,575.00 330 2.91 960.30 436.00 35.00 403.00 1834.30 1740.70 900.00 (840.70) 412.50 428.20 -7.79
56 65.00 3,640.00 245.70 72.80 3,958.50 69.00 3,864.00 260.82 77.28 4,202.10 224.00 73.00 4,088.00 275.94 81.76 4,445.70 448.00 56 3,640.00 336 2.91 977.76 436.00 35.00 403.00 1851.76 1788.24 900.00 (888.24) 420.00 468.24 -8.36
57 65.00 3,705.00 250.09 74.10 4,029.19 69.00 3,933.00 265.48 78.66 4,277.14 228.00 73.00 4,161.00 280.87 83.22 4,525.09 456.00 57 3,705.00 342 2.91 995.22 436.00 35.00 403.00 1869.22 1835.78 900.00 (935.78) 427.50 508.28 -8.92
58 65.00 3,770.00 254.48 75.40 4,099.88 69.00 4,002.00 270.14 80.04 4,352.18 232.00 73.00 4,234.00 285.80 84.68 4,604.48 464.00 58 3,770.00 348 2.91 1012.68 436.00 35.00 403.00 1886.68 1883.32 900.00 (983.32) 435.00 548.32 -9.45
59 65.00 3,835.00 258.86 76.70 4,170.56 69.00 4,071.00 274.79 81.42 4,427.21 236.00 73.00 4,307.00 290.72 86.14 4,683.86 472.00 59 3,835.00 354 2.91 1030.14 436.00 35.00 403.00 1904.14 1930.86 900.00 (1030.86) 442.50 588.36 -9.97
60 65.00 3,900.00 263.25 78.00 4,241.25 69.00 4,140.00 279.45 82.80 4,502.25 240.00 73.00 4,380.00 295.65 87.60 4,763.25 480.00 60 3,900.00 360 2.91 1047.60 436.00 35.00 403.00 1921.60 1978.40 900.00 (1078.40) 450.00 628.40 -10.47
61 65.00 3,965.00 267.64 79.30 4,311.94 69.00 4,209.00 284.11 84.18 4,577.29 244.00 73.00 4,453.00 300.58 89.06 4,842.64 488.00 61 3,965.00 366 2.91 1065.06 436.00 35.00 403.00 1939.06 2025.94 900.00 (1125.94) 457.50 668.44 -10.96
62 65.00 4,030.00 272.03 80.60 4,382.63 69.00 4,278.00 288.77 85.56 4,652.33 248.00 73.00 4,526.00 305.51 90.52 4,922.03 496.00 62 4,030.00 372 2.91 1082.52 436.00 35.00 403.00 1956.52 2073.48 900.00 (1173.48) 465.00 708.48 -11.43
63 65.00 4,095.00 276.41 81.90 4,453.31 69.00 4,347.00 293.42 86.94 4,727.36 252.00 73.00 4,599.00 310.43 91.98 5,001.41 504.00 63 4,095.00 378 2.91 1099.98 436.00 35.00 403.00 1973.98 2121.02 900.00 (1221.02) 472.50 748.52 -11.88
64 65.00 4,160.00 280.80 83.20 4,524.00 69.00 4,416.00 298.08 88.32 4,802.40 256.00 73.00 4,672.00 315.36 93.44 5,080.80 512.00 64 4,160.00 384 2.91 1117.44 436.00 35.00 403.00 1991.44 2168.56 900.00 (1268.56) 480.00 788.56 -12.32
65 65.00 4,225.00 285.19 84.50 4,594.69 69.00 4,485.00 302.74 89.70 4,877.44 260.00 73.00 4,745.00 320.29 94.90 5,160.19 520.00 65 4,225.00 390 2.91 1134.90 436.00 35.00 403.00 2008.90 2216.10 900.00 (1316.10) 487.50 828.60 -12.75
66 65.00 4,290.00 289.58 85.80 4,665.38 69.00 4,554.00 307.40 91.08 4,952.48 264.00 73.00 4,818.00 325.22 96.36 5,239.58 528.00 66 4,290.00 396 2.91 1152.36 436.00 35.00 403.00 2026.36 2263.64 900.00 (1363.64) 495.00 868.64 -13.16
67 65.00 4,355.00 293.96 87.10 4,736.06 69.00 4,623.00 312.05 92.46 5,027.51 268.00 73.00 4,891.00 330.14 97.82 5,318.96 536.00 67 4,355.00 402 2.91 1169.82 436.00 35.00 403.00 2043.82 2311.18 900.00 (1411.18) 502.50 908.68 -13.56
68 65.00 4,420.00 298.35 88.40 4,806.75 69.00 4,692.00 316.71 93.84 5,102.55 272.00 73.00 4,964.00 335.07 99.28 5,398.35 544.00 68 4,420.00 408 2.91 1187.28 436.00 35.00 403.00 2061.28 2358.72 900.00 (1458.72) 510.00 948.72 -13.95
69 65.00 4,485.00 302.74 89.70 4,877.44 69.00 4,761.00 321.37 95.22 5,177.59 276.00 73.00 5,037.00 340.00 100.74 5,477.74 552.00 69 4,485.00 414 2.91 1204.74 436.00 35.00 403.00 2078.74 2406.26 900.00 (1506.26) 517.50 988.76 -14.33
70 65.00 4,550.00 307.13 91.00 4,948.13 69.00 4,830.00 326.03 96.60 5,252.63 280.00 73.00 5,110.00 344.93 102.20 5,557.13 560.00 70 4,550.00 420 2.91 1222.20 436.00 35.00 403.00 2096.20 2453.80 900.00 (1553.80) 525.00 1028.80 -14.70
71 65.00 4,615.00 311.51 92.30 5,018.81 69.00 4,899.00 330.68 97.98 5,327.66 284.00 73.00 5,183.00 349.85 103.66 5,636.51 568.00 71 4,615.00 426 2.91 1239.66 436.00 35.00 403.00 2113.66 2501.34 900.00 (1601.34) 532.50 1068.84 -15.05
72 65.00 4,680.00 315.90 93.60 5,089.50 69.00 4,968.00 335.34 99.36 5,402.70 288.00 73.00 5,256.00 354.78 105.12 5,715.90 576.00 72 4,680.00 432 2.91 1257.12 436.00 35.00 403.00 2131.12 2548.88 900.00 (1648.88) 540.00 1108.88 -15.40
73 65.00 4,745.00 320.29 94.90 5,160.19 69.00 5,037.00 340.00 100.74 5,477.74 292.00 73.00 5,329.00 359.71 106.58 5,795.29 584.00 73 4,745.00 438 2.91 1274.58 436.00 35.00 403.00 2148.58 2596.42 900.00 (1696.42) 547.50 1148.92 -15.74
74 65.00 4,810.00 324.68 96.20 5,230.88 69.00 5,106.00 344.66 102.12 5,552.78 296.00 73.00 5,402.00 364.64 108.04 5,874.68 592.00 74 4,810.00 444 2.91 1292.04 436.00 35.00 403.00 2166.04 2643.96 900.00 (1743.96) 555.00 1188.96 -16.07
75 65.00 4,875.00 329.06 97.50 5,301.56 69.00 5,175.00 349.31 103.50 5,627.81 300.00 73.00 5,475.00 369.56 109.50 5,954.06 600.00 75 4,875.00 450 2.91 1309.50 436.00 35.00 403.00 2183.50 2691.50 900.00 (1791.50) 562.50 1229.00 -16.39

Actual capital costs to date (Thru Sep 2004, does not include routine maintenance).

Description Price Quantity Total
     
Purchase Price $19,100.00 1 $19,100.00
Signature Engines - O-200-A W.O. E1812 $11,800.00 1 $11,800.00
Core Fix $1,378.00 1 $1,378.00
Engine Install/100 Hour Insp/Tail Bracket/Wing Repair/Seat Belts $5,321.00 1 $5,321.00
Avionics KX-155/KI-209A/KMA-26 Audio Panel/Marker Antenna (Hardware) $4,630.39 1 $4,630.39
Mac Michael Avionics Installation (Labor) Audio Panel, Radio, CDI $2,857.50 1 $2,857.50
Spirit Avionics - IFR Certification $479.05 1 $479.05
Battery $99.98 1 $99.98
Push-to-Talk Grips $109.00 1 $109.00
Key-Start Switch $78.00 1 $78.00
Aircraft Spruce $67.41 1 $67.41
Clock $100.00 1 $0.00
2003 OH Registration $5.00 1 $5.00
2004 OH Registration $100.00 1 $100.00
Altitude Encoder $500.00 1 $500.00
Altitude Adjustment $95.00 1 $95.00
KX-155 Knob Replacement $30.00 1 $30.00
KLN-89B IFR Certified GPS Kit (GPS, Annuciator, Interface Cable, Antenna) $2,047.00 1 $2,047.00
Mac Michael Avionics Installation (Labor) For KLN-89B and Certification $3,333.05 1 $3,333.05
     
    $52,030.38

If you look at the plane from a 100 hour standpoint where the plane is averaging 33.3 hours per month this is what it may look like.

  3   $65.00     6   $2.91   $800   $403.00 $35.00 $7.50         $600.00
Hours             Gal/Hr   per Gal.   Maint. Per 100 hrs.   Insurance Cost Per Mo. Tie Down Engine/Prop Reserve         Mo. Payment
  33.3                                    
Hours Cum Hours Mo.per 100 Hours Mo. Cum. Owner Rate Income Income Cum Gals of Fuel Gals. Cum Fuel Expense Fuel Cum $ 100 Hour Maint. Cost 100 hour maint. cum Insurance cost per 100 hours. Tie Down Per 100 hours Reserve/100 hours Reserve/100 hr. cum 100 Hour Net Cash Flow 100 Hour Cash Flow Cum Monthly Net Cash Flow Net Profit/100 Hours
100 100 3 3 $65.00 $6,500 $6,500 600 600 $1,746.00 $1,746.00 $800 $800 $1,209.00 $105.00 $750.00 $750.00 $1,890.00 $1,890.00 $630.00 $30.00
100 200 3 6 $65.00 $6,500 $13,000 600 1,200 $1,746.00 $3,492.00 $800 $1,600 $1,209.00 $105.00 $750.00 $1,500.00 $1,890.00 $3,780.00 $630.00 $30.00
100 300 3 9 $65.00 $6,500 $19,500 600 1,800 $1,746.00 $5,238.00 $800 $2,400 $1,209.00 $105.00 $750.00 $2,250.00 $1,890.00 $5,670.00 $630.00 $30.00
100 400 3 12 $65.00 $6,500 $26,000 600 2,400 $1,746.00 $6,984.00 $800 $3,200 $1,209.00 $105.00 $750.00 $3,000.00 $1,890.00 $7,560.00 $630.00 $30.00
100 500 3 15 $65.00 $6,500 $32,500 600 3,000 $1,746.00 $8,730.00 $800 $4,000 $1,209.00 $105.00 $750.00 $3,750.00 $1,890.00 $9,450.00 $630.00 $30.00
100 600 3 18 $65.00 $6,500 $39,000 600 3,600 $1,746.00 $10,476.00 $800 $4,800 $1,209.00