Putnam/Premier Spreadsheet | FerrariChat

Putnam/Premier Spreadsheet

Discussion in 'Ferrari Discussion (not model specific)' started by henryr, Dec 21, 2006.

This site may earn a commission from merchant affiliate links, including eBay, Amazon, Skimlinks, and others.

  1. henryr

    henryr Two Time F1 World Champ
    Silver Subscribed

    Nov 10, 2003
    21,712
    Atlanta
    Full Name:
    Juan Sánchez Villa-L
    did anyone keep a detailed spreadsheet from purchase to sale on a lease thru these guys that a could see just out of curiosity ???? thx
     
  2. GCalo

    GCalo F1 Veteran

    Sep 15, 2004
    7,645
    Northern California
    Full Name:
    Greg Calo
    Lease companies don't give purchase prices. They'll give you an end of lease residual value

    What specifically do you want to see?

    Throw them figures of interest to you and they'll generate a sheet for you.

    Remember that costs change and interest rates have risen. So, what they did for someone else would not be applicable to you.
     
  3. henryr

    henryr Two Time F1 World Champ
    Silver Subscribed

    Nov 10, 2003
    21,712
    Atlanta
    Full Name:
    Juan Sánchez Villa-L
    i justed wanted to take a peek out of curiosity and didn't want to have to duplicate if someone had on hand already.
     
  4. GCalo

    GCalo F1 Veteran

    Sep 15, 2004
    7,645
    Northern California
    Full Name:
    Greg Calo
    You can assume that a lease is now at about 9% interest rate plus the lease company's overhead expenses.

    The lease company does not hold the paper. They are like a mortgage broker. They get an upfront fee for placing the lease and then a monthly residual for the life of the lease.

    If you did the numbers and kept a lease to maturity it would probably equate to an overall 15%+ rate.

    So, work a figure at about these numbers and you'll get a very good idea of what it costs.

    I had a few numbers run for me about 1.5 years ago but chose not to go with that. I may still have the files, but I have to check.
     
  5. henryr

    henryr Two Time F1 World Champ
    Silver Subscribed

    Nov 10, 2003
    21,712
    Atlanta
    Full Name:
    Juan Sánchez Villa-L
    15%. damn.
     
  6. Hunters360

    Hunters360 Formula Junior

    Nov 18, 2004
    330
    Massachusetts
    Full Name:
    James Wardwell
    I am not coming up with types of numbers at all... For instance a 2002 360 spider for $159,000 10% down. $2200 per month for 36 months. purchase when done at (Residual) $80,000.00 (est. $16000 interest over a 36 month period on a $143,000 loan works out to under 7.00%) because the same scenario for a $143,000 loan 72 month simple interest loan at 7% the payment is $2400.

    Good luck , personally I would go with Simple interest loan because there are no start up fees ($500-$1000) and early termination fees. With an exotic like a 360 spider you have equity within a year or with 10% down you have equity instantly.
     
  7. GCalo

    GCalo F1 Veteran

    Sep 15, 2004
    7,645
    Northern California
    Full Name:
    Greg Calo
    Multiply the monthly payment X's the # of payments.

    Take this total and subtract from the original vehicle price.

    Take that figure and add it to the residual and then subtract the the original vehicle price.

    Tell me if that does not come up to nearly 15% per year!

    I don't know of any lease company that is sufficiently benevolent to give a 7% interest figure on a lease!
     
  8. henryr

    henryr Two Time F1 World Champ
    Silver Subscribed

    Nov 10, 2003
    21,712
    Atlanta
    Full Name:
    Juan Sánchez Villa-L
    according to my bloomberg with 6% sales tax:

    using a buy price of $159,000 (10% down). $100 in lease fees. $500 dec deposit. 50% residual and a 7% rate. payment = $2,573.19

    vs a loan option (at 5.99%, 60 month) payment = $2950

    add in a 5.375% inv return and 20% annual depreciation and it figures the net cost of buying at $111,137.91 vs $111,443.62 cost of leasing (over the same 3 year period)
     
  9. GCalo

    GCalo F1 Veteran

    Sep 15, 2004
    7,645
    Northern California
    Full Name:
    Greg Calo

    This sounds too good to be true, but I'll go over the #'s again as soon as I have a chance.
     
  10. henryr

    henryr Two Time F1 World Champ
    Silver Subscribed

    Nov 10, 2003
    21,712
    Atlanta
    Full Name:
    Juan Sánchez Villa-L
    dec deposit.

    typo -----> sec deposit
     

Share This Page