Crop and Tree Profits Calculated
I’ve received some questions and comments that have made me feel as if I am not explaining the calculations I use to determine the profits of crops and trees in Farm Town properly. First off, as some of you may already be aware, I offer a spreadsheet for sale that calculates a lot of the information I talk about regarding Farm Town in my blog posts. If you are interested in learning more, a description is available here: http://male.themodernhippy.com/games/farm-town-spreadsheet-v20-excel/. This spreadsheet is not protected and does not have any of the formulas hidden. This means that you can clearly see the math behind my calculations, and edit them to your liking. You can even take it a step further and perform your own calculations by making additions to the spreadsheet. At any rate, I use this spreadsheet to determine the profits that are obtainable via each specific crop and tree on an hourly basis.

The Farm Town Spreadsheets Calculations
We’ll begin with Crops. The calculations are really quite simple. At the beginning, I determine the actual cost to plant the crop. The actual cost to plant a crop in Farm Town is the crop’s price, plus the cost to plow the field (20 coins). So, lets work with the Potato crop as an example. The crop itself is 40 coins, adding the cost to plow of 20 coins, leaves us with a total cost of 60 to plant 1 crop of Potatoes. Now we need to know the amount of money we’ll get from selling our harvest. In Farm Town, you get more money for allowing others to harvest your crops and trees. For this reason, I use what is referred to as the ‘hired harvest’ sale price for determining profits. The amount of money Tom, the Farm Town marketplace sales dude, will give you 119 coins for selling 1 crop of Potatoes that were harvested by another person. Now, take profit from selling the crop (119) and subtract the cost of (60) and you will come up with a result of 59 coins. This number represents your total profit from purchasing the crop. However, in order to compare this crop to all the others you need to divide the profit by the harvest time. Because grapes are 4 hour crops, you cannot use the days number to calculate this crop easily. And, one day in Farm Town is 20 hours, which means crops with a 1 day harvest time take 20 hours, 2 day harvest time take 40… and so on. So now we dividing the profit (59) by the harvest time in hours (20) and arrive at our Profit / Hour for Potatoes of 2.95. This represents the number of coins that you will earn per hour with planting 1 crop of Potatoes. Now you have a good number to work with to compare all of the crops to one another.

Trees
The method in calculating the profit per hour for trees in Farm Town is a little different, and even easier than that of crops. For trees that you do not purchase yourself (received as gifts from Farm Town friends) all you need to do is take the hired harvest sale price and divide it by the harvest time in hours. If we take the Coconut tree (best income) we have a hired harvest sale price of 101 coins and a harvest time of 5 days (100 hours). Performing the calculation shows us that 1.01 is the income per hour from owning a coconut tree. If you decide to purchase a tree (not the best idea) the calculation would be different yet again. Because you do not purchase a tree each time you harvest it as you do with crops, the price only has to be deducted once. What I do is divide the cost by the hired harvest payout to determine the number of harvest cycles that will have to take place before I recoup my initial investment. After that, the income is pure profit and can be calculated using the formula above. For example, Apple trees cost 400 coins and have a hired harvest sale price of 46 coins. Dividing the cost (400) by the income (46) shows us that it will take 8.70 (rounded) cycles to earn back our 400 coin investment. At which time, the trees income per hour will be 0.77 coins.

What does this mean and how can it help me?
This means I just outlined how to determine the best values for all of the crops and trees in Farm Town. All you need to do is perform these calculations for each crop and tree and you will be in the know. Don’t want to do that, that’s ok. I already have.. my spreadsheet contains all of the calculations already done. Not interested? Well, if I gave all of the information away, no one would want to buy the spreadsheet. However, I’m not going to leave you empty handed. As mentioned before…

BEST INVESTMENTS
Crops:
Grapes
Trees:
Coconut Tree
Although Grapes are tedious to plow, plant and then harvest every 4 hours, they are by far the best money earning crop available. And on that note, they are the best XP earning crop as well. However, I mentioned this fact already in an earlier post… and I can’t leave you without some updated information.
The next best crop for those of you not able / willing to be on every 4 hours for Grapes, is Onions.

But, Grapes only sell for 67 coins, and Pumpkins sell for 475.. you must be wrong.
Sorry Mr. Negative pants… make sure to keep in mind that just because 1 crop sells for more than another doesn’t take into account all of the necessary information. If a crop takes 5 days (100 hours) to harvest then that block of your farm will be busy for that length of time and unusable for another crop. So if you have a crop that takes 4 hours, such as Grapes, you could then plant 25 crops of Grapes in the same amount of time it takes for 1 instance of Pumpkins to be ready for harvest. Doing the math tells you that the number of Grapes that can be planted (25) multiplied by the income for harvesting each plot (67) leaves us with a total of 1,675 coins in the same amount of time you would have earned 475 coins had you planted Pumpkins. Using the profit rather than the sales price for both of these crops shows a better comparison. Pumpkins earn a profit of 255 coins after the costs to plant 1 crop are deducted. Grapes equal 675 coins profit after deducting their planting costs for 25 crops. This is still a dramatic difference!

I hope this information reaches you all well, and happy Farming!

In my next Farm Town post I hope to cover the specifics of maximizing your income with limited funds, or if you have a limited space to work with (small farm). I also hope to identify some other areas that I may have missed talking about in order to help keep all of my readers informed.

Please leave a comment and let me know what you think of this post. Also, feel free to ask any questions, or tell me what you would like me to talk about on my next post!

View my other Farm Town posts.

Farm Town Spreadsheet UPDATE
Along with all of the below information still being valid, I have updated the spreadsheet to include the newly released crops including: Raspberry, Cotton, Carrot, Pepper, Blueberry, and Pineapple. I will be emailing this spreadsheet update out to everyone who has already made a purchase shortly.

Farm Town Spreadsheet Revamp
If you’ve been following my blog at all (especially regarding farm town) then you know that I have recently been working to update my spreadsheet to include more features. With the release of grapes as a 4 hour crop, it was necessary for me to have my spreadsheet calculate hourly figures rather than daily ones. As you can see by the image below (if you can read it), the spreadsheet calculates many things including the profit / hour as well as the XP / hour for each individual crop. It also runs a calculation on the amount of money you have (after you enter it) in regard to how much of each crop you can purchase. It tells you how many of each crop you can buy if you were to invest all of your current money into that crop, the amount of XP you will ear from planting that many of that crop, and the total cost to purchase the maximum amount of each crop.

Spreadsheet requires Microsoft Excel to run.

Order the Farm Town Spreadsheet
While I was creating this spreadsheet, I was thinking about how I could best disperse it to other players of Farm Town. Again, if you’ve been following my blog then you know, I’m a struggling college student so I didn’t want to just give it away. However, I don’t want to appear greedy at the same time. I decided it would be best to combine the selling of my spreadsheet with my love for animals and donate some of the money received to a local animal shelter. One slight problem with this is the fact that the easiest way for me to receive payment for the Farm Town spreadsheet is via PayPal. While PayPal is a great option, and they offer excellent service, they take a cut of all monies transferred. This lead me to make the following offers:

• The Spreadsheet requires a minimum $1.50 donation.
• I will donate 25% of purchases $5.00 and under to a local (local to me) animal shelter.
• Donations over $5.00 will have half of their total donated to a local animal shelter.

$1.50 minimum donation to receive the spreadsheet.

Regardless of what you do, or do not donate, I thank you for visiting and reading my blog and wish you the best of luck in your Facebook Farm Town escapades.

View my other Farm Town posts.

Best income / XP for your money
I logged in the other day to find a few new seeds for sale in the store. Grapes, Watermelon, Cabbage, Peas, Onions, and Pumpkin. The problem here was the new addition of Grapes. My spreadsheet is laid out to accommodate daily harvest times, not hourly. This took a little finesse to rework my spreadsheet, but it is complete. The numbers are now calculated by their hourly harvest time (20 hours for 1 day crops, 40 hours for 2 day crops). This allowed me to plug in the values for Grapes with some expected and unexpected results. As mentioned in my Farm Town: Tips and Tricks part 1 (Facebook), 1 day crops are naturally better XP earners as they allow you to replant each day. This made strawberries and potatoes the early front runners. Not any more, grapes allow you to replant every 4 hours. This means, if you were able to plant every 4 hours as opposed to every 20 hours, as is the case with a 1 day crop, you can earn 5 TIMES THE XP! This was clear from the start, I didn’t need the spreadsheet to tell me that their was a definite XP advantage to planting grapes. However, the spreadsheet did highlight something that was quite unexpected… planting grapes also brings in the best profit over the other crops. As before, I had mentioned that the Sunflower crop was the highest earner over it’s 60 hour (3 day) harvest time. That has now been eclipsed… I’ll outline for clarity.

If you plant one of each crop, Sunflower and Grapes, you will:

• be able to replant Grapes 15 times during the harvest time of the Sunflower
• earn 45 XP from the Grapes, while only earning 3 XP from the Sunflower
• earn a profit of 405 from Grapes, while earning 197 from Sunflower

Profits are based on hired harvest rates of 67 for grapes and 332 for sunflowers.

That’s right, Grapes more than double the profit of the Sunflower crop over the Sunflowers harvest time. There, of course, is a distinct trade off. Harvesting, plowing, and replanting every 4 hours is noticeably more difficult than every 3 days (60 hours).

View Farm Town: Tips and Tricks part 5 (Facebook) – Crop / Tree Profits Calculated for updated information. NOTE: my information is incomplete. I do not have non-self harvest income numbers for both Onions and Pumpkins. While it is clear with the way Farm Town currently awards XP neither of these crops will be better than Grapes, they may offer a better profit margin. Keep this in mind and check back for updates. Also, if you know the income from non-self harvesting these crops (having a buddy harvest and then you selling them at market) let me know by leaving a comment on this post. I will rerun my numbers and present any further findings.

The XP Trick
If you aren’t aware, I’ve discovered and outlined a technique for earning XP directly in exchange for money. As it stands, the technique is still valid and working and can be found here Farm Town: Tips and Tricks part 2 (Facebook).

Like what I write? Consider supporting this site. There are many ways in which you can, be creative.

Questions? Leave a comment.

This post is in regard to the Facebook application game Farm Town. I, nor this site, has any affiliation with Facebook or the Farm Town application game. I’m merely an overly analytical fan.