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 Share with Facebook
  #2  
Old 04-04-2010
hellosailor's Avatar
Plausible Deniability
 
Join Date: Apr 2006
Posts: 10,418
Thanks: 1
Thanked 74 Times in 72 Posts
Rep Power: 10
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 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: 6
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 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 Share with Facebook
Reply


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 01:39 PM.

Add to My Yahoo!         
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, 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.