Buy vs Financing spreadsheet comparo - SailNet Community

   Search Sailnet:

 forums  store  


Quick Menu
Forums           
Articles          
Galleries        
Boat Reviews  
Classifieds     
Search SailNet 
Boat Search (new)

Shop the
SailNet Store
Anchor Locker
Boatbuilding & Repair
Charts
Clothing
Electrical
Electronics
Engine
Hatches and Portlights
Interior And Galley
Maintenance
Marine Electronics
Navigation
Other Items
Plumbing and Pumps
Rigging
Safety
Sailing Hardware
Trailer & Watersports
Clearance Items

Advertise Here






Go Back   SailNet Community > On Board > Boat Review and Purchase Forum
 Not a Member? 


Reply
 
LinkBack Thread Tools
  #1  
Old 04-04-2010
Junior Member
 
Join Date: Apr 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
IfIhadaboat is on a distinguished road
Buy vs Financing spreadsheet comparo

I was intrigued by a post I stumbled across in a search last night about financing a boat. The OP was going to finance his boat from rental income on his home. My plan is similar except I was going to buy the boat outright from my savings, and then contribute back to savings with my rental income. It seems to me that financing a depreciating asset is a losing proposition, but thought I'd at least take a look and see where it went.

I built a quick spreadsheet in Google Docs to look at the two options...I'm not especially finance/accountant oriented and I'm not sure my logic in building the sheet is sound (and I've made quite a few assumptions).

The idea was to be able to look at the the two different options and see the real and opportunity costs. Anyways...thought some of ya'll smarter than me could take a peek and see if I was framing the problem correctly or suggest an alternative way of looking at the data.

The sheet tabs represent the 2 options, and the 'Raw Data' tab is where variables should be changed/manipulated.

Any discussion appreciated.
The link to the spreadsheet is below:

https://spreadsheets.google.com/ccc?...JbVNZQkE&hl=en

Thanks,
Scott
Reply With Quote Quick reply to this message Share with Facebook
  #2  
Old 04-04-2010
hellosailor's Avatar
Senior Member
 
Join Date: Apr 2006
Posts: 11,300
Thanks: 4
Thanked 128 Times in 125 Posts
Rep Power: 11
hellosailor has a spectacular aura about hellosailor has a spectacular aura about
Scott, I'm not sure why you are looking at those factors since there are things like the residual value of the boat that frankly MAKE NO DIFFERENCE with regard to how you are going to PAY FOR IT.

And you are totally missing the fact that if you finance the boat and the lender gives you a proper mortgage on it, you may be able to take an income tax deduction for the interest on the HOME MORTGAGE on the boat. How much that is worth to you depends on your tax bracket and whether the IRS will allow you to deduct that home. (Boat or house doesn't matter.)

The only other things that matter are:
1-With a boat loan you will be REQUIRED to carry insurance and meet survey standards
2- What does it cost you every month? The principal will be the same either way, so it is strictly how much you pay in interest, versus how much you lose by not putting the cash to work elsewhere, at whatever rate of return you'd normally get. Some folks are getting 4% after taxes, others 20% or higher. If the loan is 7% and the IRS effectively reduces that to 5%...the only question is whether you can make more than that by not buying the boat outright, and investing in something else.

It really is that simple.
Reply With Quote Quick reply to this message Share with Facebook
  #3  
Old 04-04-2010
nickmerc's Avatar
Senior Member
 
Join Date: Nov 2008
Location: O'Fallon, MO
Posts: 563
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 7
nickmerc is on a distinguished road
This may be a simple way of looking at it, but unless your savings
ROR is higher than the interest on the loan, then it makes sense to purchase the boat outright rather than pay interest to a bank.
________
Kaylee_XXX cam

Last edited by nickmerc; 08-18-2011 at 06:21 AM.
Reply With Quote Quick reply to this message Share with Facebook
  #4  
Old 04-04-2010
Senior Member
 
Join Date: Jul 2001
Posts: 1,174
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 14
k1vsk will become famous soon enough
Like you said, it's never a good idea to finance a depreciating asset. You lose any way you spreadsheet it. It is that simple. The only issue is if you want a boat and can't afford a cash transaction, many people ignore the real cost.

Insurance is a moot point as it is a cost regardless.

Tax deduction is also a moot point as you only effectively regain a portion of the finance charge depending on your tax bracket - the transaction cost is still significant.

There is no logic to financing unless your desire exceeds your financial ability to buy it. Financing is a purely emotional purchase.


Reply With Quote Quick reply to this message Share with Facebook
Reply

Quick Reply
Message:
Options

By choosing to post the reply above you agree to the rules you agreed to when joining Sailnet.
Click Here to view those rules.

Register Now

In order to be able to post messages on the SailNet Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
Please note: After entering 3 characters a list of Usernames already in use will appear and the list will disappear once a valid Username is entered.
User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.
Password:
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:

Log-in

Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

 
Posting Rules
You may post new threads
You may post replies
You may post attachments
You may edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advice on when and what to buy. joelpat Boat Review and Purchase Forum 7 10-13-2010 05:03 PM
Finally, an LED Light with Some Warmth PracticalSailor Gear and Maintenance Articles 10 09-26-2007 11:39 PM
creative financing a boat bobf Boat Review and Purchase Forum 9 06-22-2002 04:02 PM
Creating a 12-Volt Spreadsheet Tom Wood Gear and Maintenance Articles 0 06-29-1999 08:00 PM


All times are GMT -4. The time now is 05:26 AM.

Add to My Yahoo!         
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2015, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.1
(c) Marine.com LLC 2000-2012

The SailNet.com store is owned and operated by a company independent of the SailNet.com forum. You are now leaving the SailNet forum. Click OK to continue or Cancel to return to the SailNet forum.