spreadsheet

[Steve Gordon]

Thanks Mike for the great spreadsheet.  I have two minor comments:

 

1.       Tire replacement is directly related to number of landings, which
in turn is related (loosely) to number of hours flown.  We should probably
include that as an operating cost unless you think it's covered by
"Engine/Airframe Maintenance" cost.

2.       If we purchase a plane, there will almost definitely be a required
one-time cost.  The one-time cost can constitute either a minimum
down-payment, payment in full, or anything in between.  It looks like the
spreadsheet double-counts the cost of the airplane.  The price is listed
both as a one-time cost per member to buy the plane and also is included as
a regular annual cost of the note.  It would probably be a good idea to
separate those costs.  You could add a "% Down Payment" value which would
drive the one-time cost (perhaps defaulted to 20%), and then the remainder
of the purchase price would be amortized over the length of the loan and
would be reflected in the note cost.

 

Thanks,

 

-Steve

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.workingcode.com/pipermail/eefc-core/attachments/20090407/2e361399/attachment.html