|
Player's card (fragment)
|
|
Important!
The player needs to download the Player's Card in Excel format and a sample of filling out the Player's Card in Excel format.
The data is entered only in the yellow fields (according to the sample).
As a result of new game situations, you will need to enter data from the cards only in the yellow fields.
All other calculations will be performed automatically in the "Player Card" template.
Calculation formulas are provided for verification.
For self-study and convenience, hyperlinks highlight the main financial terms (which are discussed in detail in the "The rules of the game" section).
|
|
The amount of the Player's initial savings
|
30 000
|
|
|
0
|
|
|
0
|
|
|
0
|
|
|
0
|
|
Field legend
|
Key financial indicators
|
Player actions and calculation formulas
|
Calculation sample
|
The first move
|
|
0
|
The number of the game's progress
|
1
|
|
The value of the cube/cubes
|
1
|
|
The player's sequential move on the Playing field by sectors of the field
|
1
|
|
A
|
Number and name of the playing field
|
The player records which sector of the field he stopped at
|
1 - Salary
|
1 - Salary
|
|
B
|
Player action (what did the player do?)
|
Records his action in the game
|
I got a salary
|
I got a salary
|
|
C
|
|
Data from the "Profession" card
|
30 000
|
0
|
|
D
|
|
Data from the "Profession" card
|
20 000
|
0
|
|
E
|
|
E = C - D
|
10 000
|
0
|
|
E1
|
|
E1 = O (previous)
|
40 000
|
30 000
|
|
F
|
|
|
0
|
0
|
|
G
|
|
|
0
|
0
|
|
H
|
|
Calculated using the formula automatically
|
0
|
0
|
|
I
|
|
I = H*0,1
|
0
|
0
|
|
J
|
Change of funds in the account AFTER receipt of salary
|
J= E +The amount of the Player's initial savings
|
40 000
|
30 000
|
|
J0
|
Change of funds in the account AFTER the sale of the business
|
|
0
|
0
|
|
K
|
Change in transaction income
|
K = G
|
0
|
0
|
|
K0
|
|
K=1, under standard conditions.
K=1.1 with a 10% increase in profitability.
K=0.9 with a 10% decrease in profitability.
K=4 at the conclusion of a strategic partnership
|
0,0
|
0,0
|
|
K1
|
Total change in monthly income
|
K1 = J + O
|
40 000
|
30 000
|
|
L
|
|
L = G - I
|
0
|
0
|
|
M
|
|
M = L (it is considered accumulative) taking into account the coefficient of return
|
0
|
0
|
|
N
|
Expenses:
|
|
0
|
0
|
|
O
|
The balance of funds on the account after all transactions (available for investment)
|
Calculated using the formula automatically
|
0
|
30 000
|
|
P
|
|
O<0
|
0
|
You are in the game
|
|
Q
|
|
H (accumulatively)
|
0
|
0
|
|
S
|
|
|
0
|
Uncredited
|
|
|
|
To make the first move in the game – click on the link "First move"
|
|
|
|
|
|
Additional materials:
|
