Boat ImageUse our free Boat Loan Calculator to estimate the monthly payment for a fixed-rate loan and create an amortization schedule. The calculator is a simple, self-explanatory, Excel spreadsheet and doesn't contain any macros. It gives you complete flexibility in adding additional payments and calculates how much is saved by avoiding paying so much interest.


Boat Loan Calculator

for Excel
Boat Loan Calculator


⤓ Excel (.xlsx)
For: Excel 2007 or later & Excel for iPad/iPhone

Other Versions

License: Personal Use (not for distribution or resale)

"No installation, no macros - just a simple spreadsheet"


Calculate the monthly payment and create a payment schedule (i.e. amortization table) for a fixed-interest rate boat loan. The spreadsheet also allows you to input optional extra payments.

Additional Boat Expenses

Before jumping into buying a boat, make sure you consider all of the other expenses associated with owning and operating a boat - not just the monthly payment on your loan! Do a search on Google for "How to Buy a Boat" and read all the articles you can find. One recommendation I have seen for determining the maximum monthly boat loan payment is to make the payment less than 60% of your total monthly boat budget.

Below is a short list of some of the expenses and costs you might want to consider when figuring out what you can afford:

  • Maintenance and Repair
  • Insurance
  • Boat equipment (first aid, safety, etc.)
  • Sporting equipment (skiis, boards, nets, etc.)
  • Dockage costs
  • Registration and licensing fees
  • Transportation costs (to and from the water)
  • Fuel and Oil
  • Food and Beverages
  • Other Recreational Fees

More Loan Calculators

Boat Loan Resources

  • Buying a Boat at : Explains some of the costs of buying and owning a boat.
  • NASBLA : Information about boating laws.
  • AVDA : Links to vessel Documentation services in your state.
Disclaimer: The calculations in this spreadsheet are estimates, and although we believe the calculations to be correct, we do not guarantee the results. Please consult your financial advisor or lending institution before making any final financial decisions.