Charter Onwership Models
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Use Case A. Goal = Reduce Charter Costs
Prepared by Nestor @ Blue Buddha Adventures
2
Instagram/Facebook = @bluebuddhaadventures
See related article at: http://bluebuddhaadventures.com/2017/11/28/does-boat-charter-ownership-work-how-to-create-a-financial-model/
3
To edit, create copy for yourself and edit the assumptions in blue
4
5
Options
6
InvestGuaranteed Performance
7
Boat Purchase
8
Sail away priceNA$550,000$550,000
9
InterestNA4.50%4.50%
10
Term (months)NA180180
11
Down Payment %NA25.00%25.00%
12
Down Payment $NA$137,500$137,500
13
Amount to FinanceNA$412,500$412,500
14
15
INCOME
16
Investment IncomeInvestGuaranteedPerformance
17
Amount invested$137,500NANA
18
Annual Return % 0.08NANA
19
Period (months)60NANA
20
Withdraws per Year$19,200NANA
21
Total 5Y Return $32,871NANASee Investment Income Sheet
22
23
Revenues GuaranteedInvestGuaranteedPerformance
24
Monthly Guaranteed %NA9.00%NA
25
Monthly Guaranteed $NA$4,125NA
26
Total AnnualNA$49,500NA
27
28
Revenues PerformanceInvestGuaranteedPerformance
29
High weeks #NANA12
30
High weeks $/weekNANA$8,800
31
High week $ annualNANA$105,600
32
Low weeks #NANA8
33
Low weeks $/weekNANA$6,400
34
Low week $ annualNANA$51,200
35
Total Annual without commissionNANA$156,800
36
37
Tax refund due to section 179InvestGuaranteedPerformance
38
Use Section 179 (Yes/No)NANAno
39
Your annual salaryNANA$250,000
40
Tax @ 33%NANA$82,500
41
Sec 179 depreciation 50% Y1-2NANA$275,000
42
Tax return year 1NANA$82,500
43
Tax retun year 2NANA$82,500
44
Total Tax ReturnNANA0
45
46
TOTAL 5 Year Revenue$32,871$247,500$784,000
47
48
EXPENSES
49
Mortgage ExpensesInvestGuaranteedPerformance
50
Monthly Payments0$3,156$3,156
51
Additional Monthly Payments0$969$969
52
Total Annual Payments0$49,500$49,500
53
Total 5 Y Mortgage Expenses0$247,500$247,500
54
55
Chartering CostsInvestGuaranteedPerformance
56
Charters per High Season111
57
Charters per Low Season222
58
Insurance and Turn Around$700$700$700
59
Total annual - Ins. & Turn Around$2,100$2,100$2,100
60
Charter fee High/week$8,800$0$0
61
Charter fee Low/week$6,400$0$0
62
Contributions from Guests (income)
$1,500$1,000$1,000
63
Total annual - Charter fee total$17,100-$3,000-$3,000
64
TOTAL Annual$19,200-$900-$900
65
Total 5 Year Chartering Costs$96,000-$4,500-$4,500Negative numbers reflect revenue
66
67
Performance Program CostsInvestGuaranteedPerformance
68
Turn Around FeeNANA$485
69
Number of charter weeksNANA20
70
Total AnnualNANA$9,700
71
Boat watching/ weekNANA$57
72
Number of weeks not chartedNANA32
73
Total AnnualNANA$1,824
74
Dockage weekNANA$200
75
Number of weeks not chartedNANA32
76
Total AnnualNANA$6,400
77
Insurance Y1NANA$11,000
78
Insurance Y2NANA$11,000
79
Insurance Y3NANA$9,350
80
Insurance Y4NANA$8,250
81
Insurance Y5NANA$7,150
82
Annual Maintenance %NANA12.00%<-- Has significant impact on outcome
83
Annual Maintenance $NANA$66,000
84
Total 5 Year Performance Costs
00$466,370
85
86
TOTAL 5 Year Costs$96,000$243,000$709,370
87
88
Cash Balance at Exit
89
90
Cost Calculation of InvestmentInvestGuaranteedPerformance
91
Initial Investment$137,500NANA
92
Return$32,871NANA
93
Charting Costs$96,000NANA
94
End cash balance$74,371NANA
95
Total Cost$63,129NANA
96
97
Calculation for Ownership Option
InvestGuaranteedPerformance
98
Boat Pricipal Loan Left at ExitNA$239,350$239,350
99
Boat value at end of program (65%)
NA$357,500$357,500
100
Sale costs (10%)NA$35,750$35,750
Loading...
Main menu