Hi Everyone,
First post here, so I wanted to share something I've been working on (before I start asking the hard questions later :wink: ).
I'm new to Traveller, and I've been struck with the greatness of this game. I'm so sad I did start back int he 1980's, when this was available!
Sorrow aside, I've been looking at the cost of character starships, and boy... they sure are expensive! Like crazy untenable expensive. I was curious as to how much of a derelict a young trader might need to get in order to actually break even (and make a little coin on the side). Thus, I created a spreadsheet to compare the Free Trader and the Far Trader, as outlined in the Mongoose Traveller 2e Core Rulebook.
What I found was:
1) Tramp freighters are profitable if they are fully loaded (with cargo and passengers) and on the routes that maximize their Jump numbers (1 parsec/run for Free Traders and 2 parsecs per run for Far Traders).
2) Running on a less efficient route is costly. Far Traders that only do one-parsec jumps are loosing the bonus cash that makes up for the lower capacity, and Free Traders making a two-parsec run are not making enough round trips to be viable.
3) Reducing the number of passengers quickly takes away a large portion of the revenue, and running with just cargo is not really viable. Guess a captain needs to put up with those pesky passengers, even if they are introverted.
For instance, the below example has 2 Ship Shares and MCr1 for a turret baked into the post discount cost. In order to be viable, the Far Trader needs a 75% Old Ship discount and the Free Trader is mostly viable at a 50% discount.
Far Trader
Original ship Price: 52,240,500
Purchase Price: 12,060,125
Original Mortgage: 217,669
Purchased Mortgage: 50,251
Maintenance (annual): 52,241
Fuel (tons): 41
% Old Ship Discount: 75%
Total Ship Savings: 40,180,375
% Total Savings: 77%
1 Parsec Run (in Cr)
Valuation (with full load)
Operating Revenue: 220,689
Operating Expenses: 94,870
Profit \ (Deficit): 125,819
Valuation (with cargo & low berth only)
Operating Revenue: 79,329
Operating Expenses: 70,870
Profit \ (Deficit): 8,459
Valuation (with cargo only)
Operating Revenue: 71,349
Operating Expenses: 70,270
Profit \ (Deficit): 1,079
2 Parsec Run (in Cr)
Valuation (with full load)
Operating Revenue: 330,129
Operating Expenses: 94,870
Profit \ (Deficit): 235,259
Valuation (with cargo & low berth only)
Operating Revenue: 159,129
Operating Expenses: 70,870
Profit \ (Deficit): 88,259
Valuation (with cargo only)
Operating Revenue: 144,309
Operating Expenses: 70,270
Profit \ (Deficit): 74,039
Free Trader
Original ship Price: 45,342,000
Purchase Price: 21,671,000
Original Mortgage: 188,925
Purchased Mortgage: 90,296
Maintenance (annual): 45,342
Fuel (tons): 21
% Old Ship Discount: 50%
Total Ship Savings: 23,671,000
% Total Savings: 52%
1 Parsec Run (in Cr)
Valuation (with full load)
Operating Revenue: 237,264
Operating Expenses: 74,029
Profit \ (Deficit): 163,236
Valuation (with cargo & low berth only)
Operating Revenue: 95,904
Operating Expenses: 50,029
Profit \ (Deficit): 45,876
Valuation (with cargo only)
Operating Revenue: 69,304
Operating Expenses: 48,029
Profit \ (Deficit): 21,276
2 Parsec Run (in Cr)
Valuation (with full load)
Operating Revenue: 147,584
Operating Expenses: 74,029
Profit \ (Deficit) 73,556
Valuation (with cargo & low berth only)
Operating Revenue: 62,084
Operating Expenses: 50,029
Profit \ (Deficit): 12,056
Valuation (with cargo only)
Operating Revenue: 37,384
Operating Expenses: 48,029
Profit \ (Deficit): (10,644)
A link to the spreadsheet is here:
https://docs.google.com/spreadsheets/d/1rmArSSyamTEclsysiPT0xyVDzFTN9TsOnh20uae2kh4/edit?usp=sharing
Feel free to use it as desired. Please note that this is a public spreadsheet, so if you make changes, it will also change other people's view. I recommend downloading it or making a copy for yourself if you want any changes to last more than a few minutes.
As for me, I have the original with other figures in it, so feel free to play!
Anyway, I wanted to share, in case any new (or veteran) players could use something like this, and to bring something to the group before I start taking. :mrgreen:
Have fun!
- Chris
First post here, so I wanted to share something I've been working on (before I start asking the hard questions later :wink: ).
I'm new to Traveller, and I've been struck with the greatness of this game. I'm so sad I did start back int he 1980's, when this was available!
Sorrow aside, I've been looking at the cost of character starships, and boy... they sure are expensive! Like crazy untenable expensive. I was curious as to how much of a derelict a young trader might need to get in order to actually break even (and make a little coin on the side). Thus, I created a spreadsheet to compare the Free Trader and the Far Trader, as outlined in the Mongoose Traveller 2e Core Rulebook.
What I found was:
1) Tramp freighters are profitable if they are fully loaded (with cargo and passengers) and on the routes that maximize their Jump numbers (1 parsec/run for Free Traders and 2 parsecs per run for Far Traders).
2) Running on a less efficient route is costly. Far Traders that only do one-parsec jumps are loosing the bonus cash that makes up for the lower capacity, and Free Traders making a two-parsec run are not making enough round trips to be viable.
3) Reducing the number of passengers quickly takes away a large portion of the revenue, and running with just cargo is not really viable. Guess a captain needs to put up with those pesky passengers, even if they are introverted.
For instance, the below example has 2 Ship Shares and MCr1 for a turret baked into the post discount cost. In order to be viable, the Far Trader needs a 75% Old Ship discount and the Free Trader is mostly viable at a 50% discount.
Far Trader
Original ship Price: 52,240,500
Purchase Price: 12,060,125
Original Mortgage: 217,669
Purchased Mortgage: 50,251
Maintenance (annual): 52,241
Fuel (tons): 41
% Old Ship Discount: 75%
Total Ship Savings: 40,180,375
% Total Savings: 77%
1 Parsec Run (in Cr)
Valuation (with full load)
Operating Revenue: 220,689
Operating Expenses: 94,870
Profit \ (Deficit): 125,819
Valuation (with cargo & low berth only)
Operating Revenue: 79,329
Operating Expenses: 70,870
Profit \ (Deficit): 8,459
Valuation (with cargo only)
Operating Revenue: 71,349
Operating Expenses: 70,270
Profit \ (Deficit): 1,079
2 Parsec Run (in Cr)
Valuation (with full load)
Operating Revenue: 330,129
Operating Expenses: 94,870
Profit \ (Deficit): 235,259
Valuation (with cargo & low berth only)
Operating Revenue: 159,129
Operating Expenses: 70,870
Profit \ (Deficit): 88,259
Valuation (with cargo only)
Operating Revenue: 144,309
Operating Expenses: 70,270
Profit \ (Deficit): 74,039
Free Trader
Original ship Price: 45,342,000
Purchase Price: 21,671,000
Original Mortgage: 188,925
Purchased Mortgage: 90,296
Maintenance (annual): 45,342
Fuel (tons): 21
% Old Ship Discount: 50%
Total Ship Savings: 23,671,000
% Total Savings: 52%
1 Parsec Run (in Cr)
Valuation (with full load)
Operating Revenue: 237,264
Operating Expenses: 74,029
Profit \ (Deficit): 163,236
Valuation (with cargo & low berth only)
Operating Revenue: 95,904
Operating Expenses: 50,029
Profit \ (Deficit): 45,876
Valuation (with cargo only)
Operating Revenue: 69,304
Operating Expenses: 48,029
Profit \ (Deficit): 21,276
2 Parsec Run (in Cr)
Valuation (with full load)
Operating Revenue: 147,584
Operating Expenses: 74,029
Profit \ (Deficit) 73,556
Valuation (with cargo & low berth only)
Operating Revenue: 62,084
Operating Expenses: 50,029
Profit \ (Deficit): 12,056
Valuation (with cargo only)
Operating Revenue: 37,384
Operating Expenses: 48,029
Profit \ (Deficit): (10,644)
A link to the spreadsheet is here:
https://docs.google.com/spreadsheets/d/1rmArSSyamTEclsysiPT0xyVDzFTN9TsOnh20uae2kh4/edit?usp=sharing
Feel free to use it as desired. Please note that this is a public spreadsheet, so if you make changes, it will also change other people's view. I recommend downloading it or making a copy for yourself if you want any changes to last more than a few minutes.

Anyway, I wanted to share, in case any new (or veteran) players could use something like this, and to bring something to the group before I start taking. :mrgreen:
Have fun!
- Chris