Short List Total Cost of Boat Ownership Model | |||||||||||
Cells for User Inputted Data | |||||||||||
Locked / Calculated Cells | |||||||||||
New 2006 Caliber 47LRC | New 2005 Tayana 48 | Used 2000 Hylas 49 | Used 2000 Amel 53 | Used 1997 HR 53 | Used 2003 IP 485 | ||||||
Asset Acquisition Costs | |||||||||||
Boat Cost | $ 382,950 | $ 410,000 | $ 450,000 | $ 485,000 | $ 655,000 | $ 590,000 | |||||
Options Cost | $ 83,000 | $ 45,000 | $ - | $ - | $ - | $ - | |||||
Additional Equipment Cost | $ 25,000 | $ 25,000 | $ 30,000 | $ 48,500 | $ 65,500 | $ 59,000 | |||||
Customization | $ - | $ - | $ 5,000 | $ - | $ 15,000 | $ - | |||||
Subtotal Boat, Options, EQ & Customization | $ 490,950 | $ 480,000 | $ 485,000 | $ 533,500 | $ 735,500 | $ 649,000 | |||||
Research Costs | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | |||||
(boat shows, inspections, factory visits, etc.) | |||||||||||
Consulting Fees | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | |||||
(vendor & design analysis, etc.) | |||||||||||
Haul Out / Storage | $ - | $ - | $ 1,000 | $ - | $ - | $ 1,000 | |||||
Commissioning | $ 7,000 | $ - | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | |||||
Documentation | $ 300 | $ 300 | $ 300 | $ 300 | $ 300 | $ 300 | |||||
Licensing | $ - | $ - | $ - | $ - | $ - | $ - | |||||
Delivery/shipping | $ - | $ - | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | |||||
Service Fees | $ - | $ - | $ - | $ - | $ - | $ - | |||||
Launch Fees | $ - | $ - | $ - | $ - | $ - | $ - | |||||
Sales Commission Amount | $ - | $ - | $ - | $ - | $ - | $ - | |||||
Miscelaneous Asset Acquisition Costs | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | |||||
Surveys, inspections, etc. | $ - | $ - | $ 2,500 | $ 2,500 | $ 2,500 | $ 2,500 | |||||
$ - | $ - | $ - | $ - | $ - | $ - | ||||||
$ - | $ - | $ - | $ - | $ - | $ - | ||||||
Subtotal Non-Boat Acquisition Costs | $ 13,300 | $ 6,300 | $ 13,300 | $ 12,300 | $ 12,300 | $ 13,300 | |||||
Subtotal Boat and Non-Boat Acquisition Costs | $ 504,250 | $ 486,300 | $ 498,300 | $ 545,800 | $ 747,800 | $ 662,300 | |||||
Sales Tax Rate | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | |||||
Sales Tax Amount | $ 42,861 | $ 41,336 | $ 42,356 | $ 46,393 | $ 63,563 | $ 56,296 | |||||
Total Asset Acquisition Cost | $ 547,111 | $ 527,636 | $ 540,656 | $ 592,193 | $ 811,363 | $ 718,596 | |||||
Financing | |||||||||||
Annual Interest Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||||
% Down (100% if buying the boat with cash) | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |||||
Loan Points (%) | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||||
Loan Period in Years (1 to 30) | - | - | - | - | - | - | |||||
Loan Fees | $ - | $ - | $ - | $ - | $ - | $ - | |||||
Total Asset Acquisition Cost | $ 547,111 | $ 527,636 | $ 540,656 | $ 592,193 | $ 811,363 | $ 718,596 | |||||
Loan Fees Cost | $ - | $ - | $ - | $ - | $ - | $ - | |||||
Loan Points Cost | $ - | $ - | $ - | $ - | $ - | $ - | |||||
Miscellaneous Closing Costs | $ - | $ - | $ - | $ - | $ - | $ - | |||||
Subtotal Acquisition and Financing Costs | $ 547,111 | $ 527,636 | $ 540,656 | $ 592,193 | $ 811,363 | $ 718,596 | |||||
Less Down Payment | $ (547,111) | $ (527,636) | $ (540,656) | $ (592,193) | $ (811,363) | $ (718,596) | |||||
Total Amount Financed | $ - | $ - | $ - | $ - | $ - | $ - | |||||
Cash Due at Closing | |||||||||||
Loan Fees Cost | $ - | $ - | $ - | $ - | $ - &nbs |