Predicting future assets.xlsx

	A	B	C	D	E	F	G	H
1	Year	Assets at beginning of year	Divididends 5%	Wages	Costs	Assets end of year before gains	Assets value gain 5%	Assets at end of year after gains
2	2025	100000	5000	100000	90000	115000	5750	120750
3	2026	120750	6038	100000	90000	136788	6839	143627
4	2027	143627	7181	100000	90000	160808	8040	168849
5	2028	168849	8442	100000	90000	187291	9365	196656
6	xls formulas at row 5	+H4	=0.05*B5	WhatIf	WhatIf	=+B5+C5+D5-E5	=0.05*F5	=+F5+G5
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100