kingdom_profit_calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRS
1
2
3
The Vaux Kingdom of France:
4
Each 1,000,000 of property sales taxation income allows for 4 more in population.
A minor code problem, the text equations are resetting to 0, its only a few fields, & they are not pertinent to the internal workings of the answers, merely helpful.
5
with options of profit shares for businesses & workers, while including supporting income from unique businesses.
6
Each person is not required to purchase property,
This Years Info:
Specifics for the pages:
7
Sales to population “Savings limits” are based on each year of property sales.
8
The population is paid at the start of each year, from the prior years property sales income.
Property Sales during:
2015
This years date:
2015
9
sales total:320,000,000
Date Kingdom Began:
2014
Property avr. Price:
400,000
10
Indexearnings:80,000,000
Number of Years
2
11
Budget
The main details of income & savings, including tax collections.
12
kingdoms_savings
The kingdoms savings page, used by the budget sheet.
Pre-paid wage:
20,000
Property Sales:
803
13
sales
Property sales totals by each day of the year.
Kingdoms Savings %:
30.00%This Years:3
14
properties
Each property, buyer & seller listing.
next yrs projected
2016
Property sale income %:
25.00%Prior Years:800
15
property_allowances
Property Allowances & mortgage amounts; with or without mortgages
Income:160,000,000
First yrs. Starting Savings:
2,000estimate:
16
reservesDepartment %'s
Pre-paid wage:
95,823,009Population:2,5514781
17
w_or_w_out_tax
Quick look calculator at Kingdoms earnings potential
Depts & pre-paid:
44,923,893
tax rate on unique business income:
25.00%This Years:1,4391280
18
income_stats
Income stats & then population stats regarding the kingdoms employees.
Kingdom's Savings:
19,253,097
tax rate on personal or business income:
0.00%Prior Years:1,2623520
19
profit_shares
Small profit share calculator for business
monthly income:
13,333,333
This years deaths:
15020
20
profit_shares_lg
large profit share calculator for business
following yrs proposed monthly income:
18,666,667
21
#of businesses:
10
Max. population per 1 million in sales:
4
22
Est & copy sheets:
persons per property avr.
1.6
23
budget_5yrs_est_active
Active 5 yr estimate
Updating the lt. green fields, edits the other sheets.
24
budget_5yrs_est_inactive
Inactive 5 yr estimate
25
budget_copy
Active copy of main budget sheet
Population to Sales values: Savings limits:
26
27
written by zayvra: qizalia.blogspot.com youtube.com/zayvra
The Kingdom: Le Royaume Vaux de la Fontaine Berry
To income value:
if editing population per million in property sales, across the sheets:
sales valueincome:years:
28
The Kingdom of flowing berry valleys3,12541,000,000250,00062,500avr property:
29
The Wine Monarchy
this years new population total & income:
1,439320,000,00080,000,00055,58821,658,876
30
31
Property Sales Income “Savings Increase Chart” : 20 yrs.
estimations:
32
In conclusion; with the Chart below.
to change the chart select the plum fields:
33
If increases cannot be fulfilled, with property sales earnings,
if it errors, scroll the window to to update the answers.
34
…then other earnings, including resales & taxations are sought to make-up the difference.
when earnings are too low, if the savings is built,
35
complete this field if using savings extra.:
Prior yrs savings if reduced population:
keep it on a % or optional, to include the savings from its 30% yes/no drop box.
36
If another savings amount to increase population:
30% savings to increase population:
1,278
Plum & fuschia fields only:
total savings:
37
optional for the pages
Population increase Choices:
96075 percent
select the fuschia boxes:
0yes
estimated earnings:
Est. current pop.
estimated earnings:
population increase 201718,119,421,568,028
38
optional
max. new population
75% of sales income as new population
50% of sales income as new population
25% of sales income as new population
Property sum total:
# of all properties:
3,183,009no1,000,000200%
reference of kept
0
39
247201512809606403207,746,11115975 percent
The years sales:
pre-paid wage.
departments
savings
The yrs sales income:
40
4,757,70718,770,88525,027,84718,770,88512,513,9236,256,96220151,119320,000,00018,770,885next line10,079,53080,000,000
41
Set the new pre-paid wages for the year:
Pre-paid wagePopulation
from proceeding yr.
divied out first of the yr: from previous yrs income:
last yrs population
all population:
current earnings:
68.68%21.93%9.40%
42
Pre-Paid wage amount for the years budget:
maximum25,027,8471,439
Income is dispersed at the start of the year. N42
320161,1192,23164,976,62744,623,00914,247,5326,106,08516,185,615
43
New Pre-paid wage accepted for all pages:
If selected, it Includes the 30% savings version also.
as maximum:
Next yrs. Current pop.
Next yrs. Current sales earnings:
59.89%28.08%12.03%sales est.
44
Use the maximum amount only: for all pages:
25,027,847
maximum on all pages
10720172,5604,791160,000,00095,823,00944,923,89319,253,097640,000,000
45
Update the optional population answer from the sales page.
251520185,1209,911320,000,000198,223,00985,243,89336,533,0971,280,000,000
46
It's better to choose which version, maximum, 25, 30, 75, or optional,
5530201910,24020,151640,000,000403,023,009165,883,89371,093,0972,560,000,000
47
earlier in the year, because the amounts vary by the month.
11459201920,48040,6311,280,000,000812,623,009327,163,893140,213,0975,120,000,000
48
232118202040,96081,5912,560,000,0001,631,823,009649,723,893278,453,09710,240,000,000
49
instructions:
List the final chosen population # with the population column of the budget sheet.
savings:551,651,57163.87%25.29%10.84%
50
468236202181,920163,5115,120,000,0003,270,223,0091,294,843,893554,933,09720,480,000,000
51
9414732022163,840327,35110,240,000,0006,547,023,0092,585,083,8931,107,893,09740,960,000,000
52
1,8879462023327,680655,03120,480,000,00013,100,623,0095,165,563,8932,213,813,09781,920,000,000
53
3,7781,8912024655,3601,310,39140,960,000,00026,207,823,00910,326,523,8934,425,653,097163,840,000,000
54
7,5603,78220251,310,7202,621,11181,920,000,00052,422,223,00920,648,443,8938,849,333,097327,680,000,000
55
savings:17,703,277,05764.00%25.20%10.80%
56
15,1257,56520262,621,4405,242,551163,840,000,000104,851,023,00941,292,283,89317,696,693,097655,360,000,000
57
30,25415,12920275,242,88010,485,431327,680,000,000209,708,623,00982,579,963,89335,391,413,0971,310,720,000,000
58
60,51230,258202810,485,76020,971,191655,360,000,000419,423,823,009165,155,323,89370,780,853,0972,621,440,000,000
59
121,02960,517202920,971,52041,942,7111,310,720,000,000838,854,223,009330,306,043,893141,559,733,0975,242,880,000,000
60
242,062121,033203041,943,04083,885,7512,621,440,000,0001,677,715,023,010660,607,483,893283,117,493,09710,485,760,000,000
61
savings:566,249,462,54364.00%25.20%10.80%
62
484,128242,066203183,886,080167,771,8315,242,880,000,0003,355,436,623,0101,321,210,363,893566,233,013,09720,971,520,000,000
63
968,260484,1322032167,772,160335,543,99110,485,760,000,0006,710,879,823,0102,642,416,123,8931,132,464,053,09741,943,040,000,000
64
1,936,525968,2642033335,544,320671,088,31120,971,520,000,00013,421,766,223,0105,284,827,643,8932,264,926,133,09783,886,080,000,000
65
3,873,0541,936,5292034671,088,6401,342,176,95141,943,040,000,00026,843,539,023,01010,569,650,683,8934,529,850,293,097167,772,160,000,000
66
7,746,1113,873,05820351,342,177,2802,684,354,23183,886,080,000,00053,687,084,623,01021,139,296,763,8939,059,698,613,097335,544,320,000,000
67
savings:18,119,421,568,028
68
69
70
71
The Kingdom's Banking Income estimate from sales:
72
20 yr taxation Income of the banks:
20 yr taxation Income of the banks:
20 yrs.
population per purchase:
sales value
income valuation per person
73
interest of mortgages of 6.25
interest of mortgages of 6.25
86,73741,000,00021,684
74
this years population:
320
75
Income from int. earnings 20 years:
Income from int. earnings 20 years:
27,755,8401,439320,000,00019,286
76
Income this year:
Income this year:19,2861,43916,000,00013
77
78
20 yr Income from banks:
all population:
income valuation per person
79
20 years:2,55110,880
80
over one year 8
81
82
83
84
85
86
87
88
89
90
91
Loading...