Company Guide v 0.90b

Day 2,215, 17:40 Published in USA Greece by 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)