FBR - Google Sheets

	A	B	C	D	E	H	I	N
1	Raw data					1. No warranty. 2. You can play with the numbers in the boxes marked in yellow. 3. All amounts in USD except share price which is in ASD 4. The red boxes change according to the assumptions you filled in the yellow boxes		assumptions
2
3								Number of shares today
4		houses per year	Machinery required	Capital consumed	annual profit			5,000,000,000
5	Australia:	161,000	805	$2,012,500,000	$2,415,000,000
6	Europe:	693,000	3,465	$8,662,500,000	$10,395,000,000			Gross profit for a house
7	U.S:	1,260,000	6,300	$15,750,000,000	$18,900,000,000			$15,000
8	Middle East:	259,000	1,295	$3,237,500,000	$3,885,000,000		Part 1 - WAAS Partnership Contract
9		2,373,000	11,865	$29,662,500,000	$35,595,000,000			Amount of profit for partners for a house ($)
10			including other buildings				Contract size - how many machines	$7,500
11		3,559,500	17,798	$44,493,750,000	$53,392,500,000		20
12								Annual costs of the FBR company's operation
13							Houses are built a year	$15,000,000
14							4,000
15								Cost of purchasing each machine
16			Annual number of houses per machine to cover machine cost				Annual quantity - percentage of global potential	$2,500,000
17			11				0.11%
18								machine - amount of houses built per year
19							Partner costs	200
20							$54,000,000
21			Number of houses in US built per year. The top ten.					Other buildings except houses, multiplied by how many
22			Number of houses in US built per year. The top ten.				Expected annual profit for partner	1.5
23							$30,000,000
24								cost for the partner, setting the WAAS branch
25							Expected annual profit for FBR	$4,000,000
26							$30,000,000
27								Life expectancy of the machine (years)
28							net Annual profit for FBR after company expenses	15
29							$15,000,000
30
31							Company value - according to the expected profit multiplier ratio of
32							60
33
34							FBR company value (in USD)
35							$900,000,000
36
37							Value per share (in ASD)
38							$0.27
39
40
41
42
43							Part 2 - Dilution
44
45							The dilution percentage
46							15%
47
48							Discount rate on the dilution
49							10%
50
51							Cash that will enter the company's coffers
52							$121,500,000
53
54							Cash that they will keep for continuing developments and expenses
55							$54,000,000
56
57							Cash left over to buy new machines
58							$67,500,000
59
60							machines will be purchased (from the dilution funds)
61							27
62
63							Houses are built a year (from the dilution funds)
64							5,400
65
66							Expected annual profit for FBR (from the dilution funds)
67							$81,000,000
68
69							Total annual net profits (dilution and partnership)
70							$96,000,000
71
72							Houses are built a year (dilution and partnership)
73							9,400
74
75							Annual quantity - percentage of global potential
76							0.26%
77
78							Company value - according to the expected profit multiplier ratio of
79							60
80
81							FBR company value (in USD)
82							$5,760,000,000
83
84							Value per share (in ASD)
85							$1.50
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100