Company Guide v 0.90b
Jack Lantos
The Company Guide is a spreadsheet tool you can download, to assist your selection and management of companies. You can enter the current prices for your own situation and it will calculate which types of companies are profitable. This article will give a demonstration of what it can do for you.
Company Performance Test
The main function of this tool is to calculate the performance of each company type, in your own particular economic conditions.
Example: eUSA day 2215
The first screen will let you select your country and input the relevant tax rates. Since the last version, this section now includes:
- new option for discounted raw material companies
- Work Tax and Average Wage (as shown on economy page)
- Target earning margin % (explained later in this article)
You can then enter the current market values for every item.
Once everything on the first screen is complete, move on to the Output tab.
The orange section will show the startup costs associated with each company type, with discounts applied if they were selected.
The aqua section will show the worker allocation scheme - at this point you can see how much extra value you would get from assigning workers to the different company types. If this is a positive value, then you should increase the "Workers per day" to the maximum, by clicking on the cells in that column and using the dropdown lists.
Scrolling across to the right reveals the green section, with a breakdown of the production quantities.
Further along is the purple section, showing market prices. The unit sell price is the current market value, and next to it there are now two new columns:
- Break-even sell price: this shows the price that would give enough earnings to equal the costs involved.
- Target sell price: this is a calculated value aimed to give X% more earnings than the total costs, where X is the target earning margin chosen on the first screen. If the market price is higher than the target sell price, the market price will be used here. This purple-highlighted column is therefore the recommended sell price you should use when you list your items on the market.
The red section shows all the costs involved, including food consumption for the work click.
The blue section generates a neat cost-effectiveness report for all the company types.
Earnings and repayment
Immediately you will see some company types may not be profitable, even working alone as manager. These types of companies should obviously be avoided and the formatting will change to alert you if they are not profitable. Other company types will have varying amounts of daily earnings, and varying amounts of time to repay the initial start-up cost. It may not be the natural way to think about companies, but in this game the start-up cost gives you an initial negative balance that you slowly recover over more than a year, before you actually make any "profit" at all.
Investment score
For the purpose of choosing the best company types to invest in, the shortest repayment times are best, but the efficiency is also important; i.e. larger companies are more robust against work tax (shown in the grey section) and produce more earnings for the same amount of work button clicks, compared to running lots of smaller companies. To integrate all that information, an investment score shows overall how "good" each company type is at the moment.
In previous versions of this calculator the best company type automatically got a score of "10" and the other companies were scaled according to that, but the formula has been changed so that doesn't happen any more. This still allows comparison of companies in the present, and will also allow you to see over time if company value increases or decreases, the latter being of course more likely.
The grey section has been added a while ago mainly to try to correct public misinformation that the Work Tax "effects everyone equally and so it is a fair tax", although it also helps to test the impact of different VAT rates.
The last tab in the spreadsheet lets you plot the trajectory of your glorious business empire. Simply add in the number of companies of each type that you own, and you will see summary figures of total earnings, RM turnover, and total value.
At the lower-right corner you can also plan for new companies and factor in your training/fighting expenses (roughly) if you want.
You can read more about this tool and its features in the previous version release articles:
http://www.erepublik.com/en/article/company-guide-v-0-5-beta-release-1964883/1/20
http://www.erepublik.com/en/article/company-guide-v-0-6-beta-new-features-1971298/1/20
http://www.erepublik.com/en/article/company-guide-v-0-7b-update-for-q7-2095563/1/20
Download
You can download the latest version from > > here! < <
This tool has been downloaded 780 times, in over 60 countries!
As always, feedback and suggestions are very welcome.
Please share this article to help more people to benefit from this tool if they are interested in companies. For shouts:
Company Loss Calculator -
http://www.erepublik.com/en/article/2352033/1/20
Also, recommended reading: History of the Erep Economy by Eisenmutter2
erepublik.com/en/article/2351825/1/20
Minor update: Version 0.91b
- Corrected company value after discounts (Thanks GoopyPants)
- Added "Dissolve value" column
- Added time to repay the paid value minus dissolve value
Plan for next update:
- Will add option to set VAT to 0 (suggested by Jeff Cycles)
Comments
Voted very good work.
I will test the calculator.
Best regards
Thanks for this update, this tool has always been very helpful... 😉
You really should work for eRepublik Labs, so they can incorporate your ideas into the game.
Man, eRep Labs only works in important things like the "Do not press" button. Forget it.
v
Big vote! You're work is really appreciated here!
Does the boosters give a good reason to keep low quality weapons?
I guess convenience, or insurance in case the game changes? Apart from that there does seem to be much advantage from buying the ones on market with people undercutting each other even below the cost price
.hmm, micro economics! i like it, but most people can do that mathe themselves, can you tell me is he ireland deal worth it? 90k a month for a 20% bonus pluse three territories ? or is that too hard of a claculation?
or can you prove the rate of return for the usa economy is (gold in - gold out)/ total assets so that gold from medals and player average assets are really what determines if factories will be profitable. and the rate of return. well i guess also gold buying. and prove that we should export 10% of our goods if we want our factories to return 10%
Blah, blah bite me.
Only if you female
Although one can measure the production benefits of extra bonuses with this calculator, it's not so simple to put a price on extra bonuses - as the perceived benefits go beyond the production advantages. Player retention and country status also increase hugely with bonuses, and so does the motivation and tactical exposure for potential attack. There are also political motivations in the mix, so for the people making the decision they are asking a different question: is 90k a month (of someone else's cash) worth it for a better public image in the next elections? All these would factor into the bargaining process.
For exporting, it is generally required to be in a 100/100 bonus country to be competitive, and the 20g cost of licences are very prohibitive as well. So I wouldn't recommend doing any exporting.
Great Idea saves me time from doing all the long statistics!
V+S
Lots of good work.
You deserved more votes.
The bottom graphs and charts are not that clear (without the download which would require leaving eRepublik). For new players it is non applicable, and for the few who have enough companies to use it, it would seem more like a barometer than a tool.
The first charts really hit it right on the head; for a long time, I have been writing that one can make money from employees ONLY in Q7 weapons company, but this was intuitive; your charts clearly shows eAdin one place they have really wrecked the "employment economy". took the thee skills too!
We should all unite and attack eBukarest!
I think your company cost math is off.. doesn't a Q2 food factory cost 20.8 and not 16.2? And a Q7 (if building from scratch around 780)?
[removed]
My math is off for the Q7, should be 10+(.54)*1220=668.8. For your worksheet: 10 + (1-ProductionDiscount)*UpgradeCost, not (1-ProductionDiscount)*TotalCost
Also, companies have a residual value, since you can sell them. So the days to repay should include that, lowering the amount of time to profitability: the days until your initial investment can be refunded if you sell the company, not "days until you have all your gold back and also have the company"
Ah yes I see it. The company "upgrade" discount was applying to the initial 10g cost of the company, easily fixed.
As for dissolving companies, if you prefer to see it like that there is now an extra column for the days to repay the full paid cost minus "dissolve value"
Version 0.91b incorporating these changes is up.
\0/
http://prntscr.com/2bix21
With 100% bonus Q5 food factory consume 2000 FRM/employee where in this calculator it calculating 3000 FRM
Did you choose the number of workers in the factory, in the output tab?
On wiki, Q5 food factory with 100% bonus consume 1000 FRM per worker
http://wiki.erepublik.com/index.php/Productivity
so if your worker number is set to "3" it would explain why it says 3000 FRM on they last tab
ahh yah thanx for the tip 🙂
Good information, very well presented and organized. Thanks!
The House industry has been re-added to the game today, so this calculator will get an update again