Part 34: Economic Breakdown 1
Empire size and food growth - What are my returns?Welcome back to this bonus economic update for my Rise of the Samurai LP. In this update, I will be discussing some hard numbers behind a very common question that has been the cause of some debate amongst Shogun 2 players (and even in this thread!). While the numbers are only tedious to calculate, the many variables involved and the playstyles of certain players means that there is no magic bullet where one thing is always the right thing to do, despite what others might tell you.
This question is the ever popular - "Is it worth upgrading my farms if I don't need the food?"
Obviously, this is a question of an economic nature and so will need to be compared to the cost effectiveness of other economic improvement options, but those other options are outside the scope of this post. Instead, this post will present the results of multiple scenarios in which you would be considering upgrading your farms and present the results in a manner that will allow an informed comparison with your other options.
First, let us look at the farm chain of buildings:
code:
Fields Free +200 wealth +1 town growth + 1 food
Dry Field Agriculture 950 +340 wealth +1 town growth + 2 food
Rice Paddies 1755 +420 wealth +1 town growth + 3 food
Improved Irrigation 4200 +700 wealth +1 town growth + 4 food
Since we are looking at an upgrade comparison, we are interested in the difference between each building, so let's have a look at what each upgrade gives us in real terms:
code:
Dry Field Agriculture 950 +140 wealth +1 food
Rice Paddies 1755 +80 wealth +1 food
Improved Irrigation 4200 +280 wealth +1 food
The amount of income added to your empire on a given turn from the upgrade is calculated as:
(Building Wealth bonus+(Building growth bonus x Turns since built)+(Food Bonus x Empire Size x Turns Since Built)) x Tax Rate
For the mathematically inclined, it would look like this:
(a+(b+(f*e))x)t
Where a is building wealth, b is building growth, f is the food bonus, e is empire size, t is the tax rate and x is the number of turns since construction.
Since each building adds only a single food and no additional town growth, we simplify it to:
(a+ex)t
Which can also be represented as:
at+etx
This is not the whole story however, as the tax rate can vary from province to province. Instead, we elect to have 2 tax rates, one for the local province and one for the empire. While all the local bonuses are affected by the (usually higher) local tax rate, your empire wide tax rate (which is what generates wealth from your empire growth) is likely to be significantly lower and is inversely impacted as your empire increases in size. Indeed, as your empire grows, your administrative cost will increase, reducing your empire tax rate from it's base of 30%.
We will call the empire tax rate m and now our formula looks like this:
at+emx
However, we are interested not in the income added on a single turn, but instead the total income that upgrade has given us up until our selected point. To find that, we must integrate our above formulae with respect to the turn.
This gives us the following result:
atx+(emx^2)/2 + c
Where c is a constant. As we will only be taking the integral between two values of x (0 and turns since upgrade), the value of c will cancel out. In addition, at x=0, the result is 0 and so we will just calculate for x is turns since upgrade to get our result.
We are interested in three separate "milestones" for our economy.
The first is when a building has paid for itself and so has become cash neutral. This is a useful metric to compare the break-even points of buildings, but is primarily of interest as a "tie-breaker" of sorts and is the minimum we expect of our buildings (as money now is worth more than money later, so at this point we have still made a loss in real terms).
The second is when a building has earned it's initial investment back, that is, it has earned enough to enable a second building to be constructed. This is a useful mid term indicator as it demonstrates the income growth pattern of a building. The closer this is to middle of our first and third indicators, the worse the overall growth potential (ie. close to a static return).
The third and final metric we use is when a building has earned three times it's initial cost. When combined with the other two data points allows us to see the trend for the building and this represents the long term returns of the building. It allows for more intelligent investment choices when you can weigh more money sooner against less money later or vice versa based on your situation (Small investments with good long term growth can be quite intelligent choices, while larger investments that only pay off in the long term are inherently more risky).
When we discuss risk in the context of Shogun 2 economic buildings, we are talking about things going wrong that prevent your investment from being the best return. These include invasion and loss of territory, enemy armies burning down farms on the campaign map and so incurring an associated (quite hefty) repair cost and also taking new territory that has better economic investment options. Buildings with fast break even points are inherently less risky than those with longer break-evens or high costs (and so tend to have worse long term returns to balance them, but not always!).
We will consider 5 different empire scenarios:
2 provinces - Your starting empire
5 provinces - Early game with a bit of steam
10 provinces - Solid expansion in late early game
15 provinces - Mid game and approaching Realm Divide
20 provinces - End Game (or midgame approaching Realm Divide for Long games, around the latest that food investment will yield reasonable dividends in time for it to matter.)
Additional scenarios are left as an exercise to the reader if they wish to calculate further options with the above methodology.
Now that we have all the theory out of the way, let's look at some numbers:
Time to Break Even - 2 provinces : Empire tax Rate : 30%
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (950) 27 23 20 18 16 15 13 12 11
Dry Field Agriculture M (950) 23 19 16 14 13 12 11 10 9
Dry Field Agriculture A (950) 20 17 15 13 11 10 9 9 8
Dry Field Agriculture F (950) 16 13 11 10 9 8 7 7 6
Dry Field Agriculture VF (950) 11 9 8 7 6 5 5 5 4
Rice Paddies B (1755) 55 51 47 43 40 38 35 33 31
Rice Paddies M (1755) 50 45 41 37 34 32 29 27 26
Rice Paddies A (1755) 47 42 38 34 31 29 26 24 23
Rice Paddies F (1755) 40 35 31 28 25 23 21 19 18
Rice Paddies VF (1755) 31 26 23 20 18 16 15 13 12
Improved Irrigation B (4200) 58 50 44 39 35 31 29 26 24
Improved Irrigation M (4200) 49 41 36 31 28 25 23 21 19
Improved Irrigation A (4200) 44 37 32 28 24 22 20 18 17
Improved Irrigation F (4200) 35 29 24 21 19 17 15 14 13
Improved Irrigation VF (4200) 24 20 17 15 13 12 10 10 9
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (1900) 46 41 36 33 30 27 25 23 22
Dry Field Agriculture M (1900) 40 35 30 27 24 22 20 19 17
Dry Field Agriculture A (1900) 36 31 27 24 22 19 18 16 15
Dry Field Agriculture F (1900) 30 25 22 19 17 15 14 13 12
Dry Field Agriculture VF (1900) 22 18 15 13 12 10 9 9 8
Rice Paddies B (3510) 85 80 76 72 68 64 61 58 55
Rice Paddies M (3510) 79 74 69 64 60 56 52 49 47
Rice Paddies A (3510) 76 70 64 59 55 51 48 45 42
Rice Paddies F (3510) 68 61 55 50 46 42 39 36 34
Rice Paddies VF (3510) 55 48 42 37 34 30 28 26 24
Improved Irrigation B (8400) 99 88 79 71 65 59 54 50 47
Improved Irrigation M (8400) 86 75 66 59 53 48 44 40 37
Improved Irrigation A (8400) 79 68 59 52 47 42 38 35 33
Improved Irrigation F (8400) 65 54 47 41 36 33 30 27 25
Improved Irrigation VF (8400) 47 38 33 28 25 22 20 18 17
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (2850) 62 56 50 46 42 39 36 33 31
Dry Field Agriculture M (2850) 55 48 43 38 35 32 29 27 25
Dry Field Agriculture A (2850) 50 44 39 35 31 28 26 24 22
Dry Field Agriculture F (2850) 42 36 31 27 24 22 20 18 17
Dry Field Agriculture VF (2850) 31 26 22 19 17 15 14 13 12
Rice Paddies B (5265) 109 104 99 94 90 86 82 79 75
Rice Paddies M (5265) 103 97 91 86 81 76 72 68 65
Rice Paddies A (5265) 99 92 86 80 75 71 66 63 59
Rice Paddies F (5265) 90 82 75 69 64 59 55 51 48
Rice Paddies VF (5265) 75 66 59 53 48 44 40 37 35
Improved Irrigation B (12600) 132 120 109 99 91 84 78 72 67
Improved Irrigation M (12600) 117 104 93 83 75 69 63 58 54
Improved Irrigation A (12600) 109 95 84 75 67 61 56 52 48
Improved Irrigation F (12600) 91 78 67 59 53 48 44 40 36
Improved Irrigation VF (12600) 67 56 48 42 37 33 30 27 25
Time to Break Even - 5 provinces : Empire tax Rate : 27%
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (950) 23 20 18 16 15 14 13 12 11
Dry Field Agriculture M (950) 20 17 15 14 12 11 10 9 9
Dry Field Agriculture A (950) 18 16 14 12 11 10 9 8 8
Dry Field Agriculture F (950) 15 13 11 10 9 8 7 7 6
Dry Field Agriculture VF (950) 11 9 8 7 6 5 5 5 4
Rice Paddies B (1755) 41 39 37 35 33 31 30 28 27
Rice Paddies M (1755) 38 36 33 31 29 27 26 24 23
Rice Paddies A (1755) 37 34 31 29 27 25 24 22 21
Rice Paddies F (1755) 33 30 27 25 23 21 19 18 17
Rice Paddies VF (1755) 27 24 21 19 17 15 14 13 12
Improved Irrigation B (4200) 48 43 39 35 32 29 27 25 23
Improved Irrigation M (4200) 42 37 33 29 26 24 22 20 19
Improved Irrigation A (4200) 39 33 29 26 23 21 19 18 16
Improved Irrigation F (4200) 32 27 23 21 18 16 15 14 13
Improved Irrigation VF (4200) 23 19 16 14 13 11 10 9 9
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (1900) 37 34 31 28 26 24 23 21 20
Dry Field Agriculture M (1900) 33 30 27 24 22 20 19 18 16
Dry Field Agriculture A (1900) 31 27 24 22 20 18 17 16 15
Dry Field Agriculture F (1900) 26 23 20 18 16 15 13 12 11
Dry Field Agriculture VF (1900) 20 17 15 13 11 10 9 9 8
Rice Paddies B (3510) 62 59 57 55 53 51 49 47 45
Rice Paddies M (3510) 59 56 53 51 48 46 44 42 40
Rice Paddies A (3510) 57 54 51 48 45 43 41 39 37
Rice Paddies F (3510) 53 49 45 42 39 37 35 33 31
Rice Paddies VF (3510) 45 41 37 34 31 28 26 24 23
Improved Irrigation B (8400) 78 72 66 61 57 53 49 46 43
Improved Irrigation M (8400) 70 63 57 52 48 44 41 38 35
Improved Irrigation A (8400) 66 59 53 47 43 40 36 34 31
Improved Irrigation F (8400) 57 49 43 38 35 31 29 26 24
Improved Irrigation VF (8400) 43 36 31 27 24 22 20 18 17
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (2850) 48 45 41 39 36 34 32 30 28
Dry Field Agriculture M (2850) 44 40 37 34 31 29 27 25 23
Dry Field Agriculture A (2850) 41 37 34 31 28 26 24 22 21
Dry Field Agriculture F (2850) 36 32 28 25 23 21 19 18 16
Dry Field Agriculture VF (2850) 28 24 21 18 16 15 14 12 11
Rice Paddies B (5265) 78 75 73 70 68 66 64 62 60
Rice Paddies M (5265) 75 72 69 66 63 61 58 56 54
Rice Paddies A (5265) 73 69 66 63 60 57 55 53 50
Rice Paddies F (5265) 68 64 60 57 53 50 48 45 43
Rice Paddies VF (5265) 60 55 50 46 43 40 37 34 32
Improved Irrigation B (12600) 102 95 88 83 77 73 68 64 61
Improved Irrigation M (12600) 93 85 78 72 67 62 58 54 50
Improved Irrigation A (12600) 88 80 73 66 61 56 52 48 45
Improved Irrigation F (12600) 77 68 61 55 50 45 41 38 36
Improved Irrigation VF (12600) 61 52 45 40 36 32 29 27 25
Time to Break Even - 10 provinces : Empire tax Rate : 24%
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (950) 19 18 16 15 14 13 12 11 10
Dry Field Agriculture M (950) 17 15 14 13 12 11 10 9 8
Dry Field Agriculture A (950) 16 14 13 11 10 10 9 8 8
Dry Field Agriculture F (950) 14 12 10 9 8 8 7 6 6
Dry Field Agriculture VF (950) 10 9 8 7 6 5 5 5 4
Rice Paddies B (1755) 33 31 30 29 28 27 26 25 24
Rice Paddies M (1755) 31 29 28 26 25 24 23 22 21
Rice Paddies A (1755) 30 28 27 25 24 22 21 20 19
Rice Paddies F (1755) 28 26 24 22 20 19 18 17 16
Rice Paddies VF (1755) 24 21 19 17 16 15 13 12 12
Improved Irrigation B (4200) 41 37 34 32 29 27 25 24 22
Improved Irrigation M (4200) 37 33 30 27 25 23 21 19 18
Improved Irrigation A (4200) 34 30 27 24 22 20 19 17 16
Improved Irrigation F (4200) 29 25 22 20 18 16 15 13 12
Improved Irrigation VF (4200) 22 19 16 14 12 11 10 9 9
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (1900) 30 28 26 25 23 22 21 20 18
Dry Field Agriculture M (1900) 28 26 24 22 20 19 18 16 15
Dry Field Agriculture A (1900) 26 24 22 20 18 17 16 15 14
Dry Field Agriculture F (1900) 23 21 18 17 15 14 13 12 11
Dry Field Agriculture VF (1900) 18 16 14 12 11 10 9 8 8
Rice Paddies B (3510) 48 47 45 44 43 42 40 39 38
Rice Paddies M (3510) 47 45 43 42 40 38 37 36 35
Rice Paddies A (3510) 45 44 42 40 38 37 35 34 32
Rice Paddies F (3510) 43 40 38 36 34 32 31 29 28
Rice Paddies VF (3510) 38 35 32 30 28 26 24 23 21
Improved Irrigation B (8400) 64 60 56 53 50 47 44 42 40
Improved Irrigation M (8400) 59 54 50 47 43 40 38 35 33
Improved Irrigation A (8400) 56 51 47 43 40 37 34 32 30
Improved Irrigation F (8400) 50 44 40 36 33 30 27 25 24
Improved Irrigation VF (8400) 40 34 30 26 24 21 19 18 17
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (2850) 39 37 35 33 31 30 28 27 25
Dry Field Agriculture M (2850) 36 34 32 29 28 26 24 23 22
Dry Field Agriculture A (2850) 35 32 30 27 25 24 22 21 20
Dry Field Agriculture F (2850) 31 28 25 23 21 20 18 17 16
Dry Field Agriculture VF (2850) 25 22 20 18 16 14 13 12 11
Rice Paddies B (5265) 60 59 57 56 55 53 52 51 50
Rice Paddies M (5265) 59 57 55 53 52 50 49 47 46
Rice Paddies A (5265) 57 55 53 52 50 48 46 45 43
Rice Paddies F (5265) 55 52 50 47 45 43 41 40 38
Rice Paddies VF (5265) 50 46 43 40 38 36 33 32 30
Improved Irrigation B (12600) 82 78 74 70 66 63 60 57 55
Improved Irrigation M (12600) 77 72 67 63 59 55 52 49 47
Improved Irrigation A (12600) 74 68 63 59 55 51 48 45 42
Improved Irrigation F (12600) 66 60 55 50 46 42 39 36 34
Improved Irrigation VF (12600) 55 48 42 38 34 31 28 26 24
Time to Break Even - 15 provinces : Empire tax Rate : 21%
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (950) 18 16 15 14 13 12 11 11 10
Dry Field Agriculture M (950) 16 15 13 12 11 10 10 9 8
Dry Field Agriculture A (950) 15 14 12 11 10 9 9 8 7
Dry Field Agriculture F (950) 13 11 10 9 8 7 7 6 6
Dry Field Agriculture VF (950) 10 9 7 7 6 5 5 5 4
Rice Paddies B (1755) 29 28 27 26 25 24 24 23 22
Rice Paddies M (1755) 28 27 25 24 23 22 21 20 20
Rice Paddies A (1755) 27 26 24 23 22 21 20 19 18
Rice Paddies F (1755) 25 24 22 21 19 18 17 16 15
Rice Paddies VF (1755) 22 20 18 17 15 14 13 12 11
Improved Irrigation B (4200) 37 34 32 30 28 26 24 23 21
Improved Irrigation M (4200) 34 31 28 26 24 22 20 19 18
Improved Irrigation A (4200) 32 29 26 23 21 20 18 17 16
Improved Irrigation F (4200) 28 24 21 19 17 16 14 13 12
Improved Irrigation VF (4200) 21 18 16 14 12 11 10 9 9
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (1900) 27 26 24 23 22 21 20 19 18
Dry Field Agriculture M (1900) 26 24 22 20 19 18 17 16 15
Dry Field Agriculture A (1900) 24 22 21 19 18 16 15 14 13
Dry Field Agriculture F (1900) 22 20 18 16 15 13 12 12 11
Dry Field Agriculture VF (1900) 18 15 13 12 11 10 9 8 8
Rice Paddies B (3510) 43 42 41 40 39 38 37 36 35
Rice Paddies M (3510) 42 40 39 38 36 35 34 33 32
Rice Paddies A (3510) 41 39 38 36 35 34 32 31 30
Rice Paddies F (3510) 39 37 35 33 32 30 29 27 26
Rice Paddies VF (3510) 35 32 30 28 26 25 23 22 20
Improved Irrigation B (8400) 58 55 52 49 46 44 42 39 38
Improved Irrigation M (8400) 54 50 47 44 41 38 36 34 32
Improved Irrigation A (8400) 52 47 44 40 38 35 33 31 29
Improved Irrigation F (8400) 46 42 38 34 31 29 27 25 23
Improved Irrigation VF (8400) 38 33 29 26 23 21 19 18 16
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (2850) 35 33 32 30 29 28 26 25 24
Dry Field Agriculture M (2850) 33 31 29 27 26 24 23 22 21
Dry Field Agriculture A (2850) 32 30 28 26 24 23 21 20 19
Dry Field Agriculture F (2850) 29 26 24 22 20 19 18 16 15
Dry Field Agriculture VF (2850) 24 21 19 17 15 14 13 12 11
Rice Paddies B (5265) 53 52 51 50 49 48 47 46 45
Rice Paddies M (5265) 52 51 49 48 47 45 44 43 42
Rice Paddies A (5265) 51 50 48 47 45 44 42 41 40
Rice Paddies F (5265) 49 47 45 43 41 40 38 37 35
Rice Paddies VF (5265) 45 42 40 38 35 33 32 30 28
Improved Irrigation B (12600) 74 70 67 64 61 58 56 54 51
Improved Irrigation M (12600) 70 66 62 58 55 52 49 47 44
Improved Irrigation A (12600) 67 63 58 55 51 48 45 43 40
Improved Irrigation F (12600) 61 56 51 47 44 40 38 35 33
Improved Irrigation VF (12600) 51 45 40 36 33 30 28 26 24
Time to Break Even - 20 provinces : Empire tax Rate : 19%
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (950) 17 15 14 13 13 12 11 10 10
Dry Field Agriculture M (950) 15 14 13 12 11 10 9 9 8
Dry Field Agriculture A (950) 14 13 12 11 10 9 8 8 7
Dry Field Agriculture F (950) 13 11 10 9 8 7 7 6 6
Dry Field Agriculture VF (950) 10 8 7 6 6 5 5 4 4
Rice Paddies B (1755) 27 26 25 24 24 23 22 21 21
Rice Paddies M (1755) 26 25 24 23 22 21 20 19 19
Rice Paddies A (1755) 25 24 23 22 21 20 19 18 17
Rice Paddies F (1755) 24 22 21 20 18 17 16 16 15
Rice Paddies VF (1755) 21 19 17 16 15 14 13 12 11
Improved Irrigation B (4200) 35 33 30 28 27 25 23 22 21
Improved Irrigation M (4200) 32 29 27 25 23 21 20 18 17
Improved Irrigation A (4200) 30 27 25 23 21 19 18 17 15
Improved Irrigation F (4200) 27 23 21 19 17 15 14 13 12
Improved Irrigation VF (4200) 21 18 15 14 12 11 10 9 9
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (1900) 26 24 23 22 21 20 19 18 17
Dry Field Agriculture M (1900) 24 22 21 20 18 17 16 15 14
Dry Field Agriculture A (1900) 23 21 20 18 17 16 15 14 13
Dry Field Agriculture F (1900) 21 19 17 16 14 13 12 11 11
Dry Field Agriculture VF (1900) 17 15 13 12 11 10 9 8 8
Rice Paddies B (3510) 39 39 38 37 36 35 34 33 33
Rice Paddies M (3510) 38 37 36 35 34 33 32 31 30
Rice Paddies A (3510) 38 36 35 34 33 32 30 29 29
Rice Paddies F (3510) 36 34 33 31 30 29 27 26 25
Rice Paddies VF (3510) 33 30 29 27 25 24 22 21 20
Improved Irrigation B (8400) 54 51 48 46 44 42 40 38 36
Improved Irrigation M (8400) 51 47 44 41 39 37 35 33 31
Improved Irrigation A (8400) 48 45 42 39 36 34 32 30 28
Improved Irrigation F (8400) 44 40 36 33 30 28 26 24 23
Improved Irrigation VF (8400) 36 32 28 25 23 21 19 17 16
code:
Province Tax Rate: 20% 25% 30% 35% 40% 45% 50% 55% 60%
Dry Field Agriculture B (2850) 33 31 30 28 27 26 25 24 23
Dry Field Agriculture M (2850) 31 29 27 26 25 23 22 21 20
Dry Field Agriculture A (2850) 30 28 26 24 23 22 20 19 18
Dry Field Agriculture F (2850) 27 25 23 21 20 18 17 16 15
Dry Field Agriculture VF (2850) 23 20 18 17 15 14 13 12 11
Rice Paddies B (5265) 49 48 47 46 45 45 44 43 42
Rice Paddies M (5265) 48 47 46 44 43 42 41 40 39
Rice Paddies A (5265) 47 46 45 43 42 41 40 39 37
Rice Paddies F (5265) 45 44 42 40 39 37 36 35 34
Rice Paddies VF (5265) 42 40 37 35 34 32 30 29 27
Improved Irrigation B (12600) 69 66 63 60 58 55 53 51 49
Improved Irrigation M (12600) 65 61 58 55 52 50 47 45 43
Improved Irrigation A (12600) 63 59 55 52 49 46 44 41 39
Improved Irrigation F (12600) 58 53 49 45 42 39 37 34 32
Improved Irrigation VF (12600) 49 44 39 35 32 30 27 25 24
Conclusion: Farm development is a viable cornerstone of a growth strategy, but caution has to be undertaken as it is a long term plan which, if over-invested in, can paradoxically leave you worse off in the long term compared to other, more traditional economic buildings. Careful consideration of your immediate and near future options should be undertaken before investing in Rice Paddies or Improved Irrigation. It is, however, almost always worth upgrading to Dry Field Agriculture regardless of soil fertility, as the low cost for the growth boost makes it one of the best economic investments under all situations and a very close second in those where it is not optimal.
I hope you enjoyed the breakdown on the economic returns to farm upgrades. The sister piece to this post, Economic Buildings and long term returns will be up next, to give you the other half of the economic investment equation and let you make intelligent, informed decisions about where to invest your hard earned (or possibly looted!) koku.