Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/sql.php on line 16

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/html/sql.php on line 17
Coyotik's BMC/BTD5 farm calculator Legend at the bottom.
BTD5 mode: Under village: MK Farm: MK Village: MK Tycoon:
FarmCostIncomePays per roundProfit afterPaid afterUpgrade IncomeUpgrade per roundUpgrade profit afterUpgrade paid after
0/010001200.121.678.33
1/013001800.141.447.22600.215
2/027003900.141.386.922100.151.336.67
3/059007500.131.577.873600.111.788.89
4/01990030000.151.336.6322500.161.246.22
0/255001800.036.1130.56
1/258002700.054.321.48900.30.673.33
2/272005850.082.4612.313150.230.894.44
3/21040011250.111.859.245400.171.195.93
4/22440045000.181.085.4233750.240.834.15
0/3970010060.11.939.64
1/31000010710.111.879.34650.220.924.62
2/31140012680.111.88.991970.141.427.11
0/41520037110.240.824.1
1/41550037500.240.834.13390.131.547.69
2/41690039180.230.864.311680.121.678.33

Total bank balance

Rounds0/31/32/30/41/42/4
17438091040180018722124
2155916982183396041184672
3245726763440655268137730
434453752482396621004711400
5453249356344133941392815804
6572762377500178721858521088
7704275007500232462417427429
8750075007500296953000030000
9750075007500300003000030000

Per-round value if collected

Per round0/31/32/30/41/42/4
17438091040180018722124
27798491091198020592336
38198921146218422712576
48619381205241525112850
59069871268267827853160
695410391250297830973514
7100610711071332034533918
8937937937371137503750
9833833833333333333333

Base numbers after bonuses

ParameterValue
Base cost1000
Banana value30
Crate value300
Interest 0/31.1
Interest 0/41.2
4/0 upgrade14000
0/4 upgrade5500
Bananas from 0/04
Bananas from 1/06
Bananas from 2/013
Crates from 4/010

Legend

There are only two really important columns: Profit after and Paid after. Profit after means that if you sell the farm after this many rounds, you're breaking even. So, if you expect a MOAB on round 6 and your Profit after value is lower than 1, it's still worth buying that farm on round 5, even if you're gonna sell it at the very start of round 6. Paid after is the same, but without selling.
The upgrade section of the table shows values for the difference against the previous row. Say that you have a 1/0 farm and 1400 cash to spend. Should you upgrade it to 2/0 or get another 1/0 going? The answer should basically match the difference in the standard section, but I'm not 100% sure about this given how many factors are in play, so I included the upgrade calculations as well.
BTD5 checkbox turns off all MK boosts and uses BTD5 farm data as well.
Village checkbox applies village discount to all prices, which might again change the balance in some cases. Note that after you fill your MK values and click Go, you can bookmark the URL of the page to have them filled on each visit.
BMC: MOAB popping | Village tool | Farm calculator with MK support BTD5: Challenge list and guides (not updated anymore since Dec 2014)