Question

. If you die when you are 90 years old, how much money will be left to bequeath?

Answer 1

This is a very open ended question. Considering the question preparer is aware of these dependencies, its safe to assume the data as per answerer's specific data. I will try to create a dynamic linked model in excel and share the image of linkages so that you may be able to change the parameters
Assumptions- Investments and savings grow @7% before and after retirement. Expenses will continue to grow @ inflation before and after retirement.

Current age	30
Retirement age	60
Life expectancy	90
Time to retirement	30
Time after retirement	30
Current savings	0
Current salary	50,000
Salary growth	5%
Inflation	4%
Fixed expenses	25,000
Return on investments	7%

Year	Age	Salary	Expenses	Surplus to savings	Growth in surplus	PV of surplus
1	30	50,000	25,000	25,000	25,000	23,364
2	31	52,500	26,000	26,500	53,250	46,511
3	32	55,125	27,040	28,085	85,063	69,436
4	33	57,881	28,122	29,760	120,777	92,140
5	34	60,775	29,246	31,529	160,760	114,619
6	35	63,814	30,416	33,398	205,411	136,874
7	36	67,005	31,633	35,372	255,161	158,902
8	37	70,355	32,898	37,457	310,479	180,702
9	38	73,873	34,214	39,659	371,871	202,273
10	39	77,566	35,583	41,984	439,886	223,616
11	40	81,445	37,006	44,439	515,117	244,728
12	41	85,517	38,486	47,031	598,205	265,610
13	42	89,793	40,026	49,767	689,847	286,262
14	43	94,282	41,627	52,656	790,792	306,683
15	44	98,997	43,292	55,705	901,852	326,873
16	45	103,946	45,024	58,923	1,023,904	346,832
17	46	109,144	46,825	62,319	1,157,897	366,560
18	47	114,601	48,698	65,903	1,304,853	386,059
19	48	120,331	50,645	69,686	1,465,878	405,327
20	49	126,348	52,671	73,676	1,642,166	424,367
21	50	132,665	54,778	77,887	1,835,004	443,178
22	51	139,298	56,969	82,329	2,045,783	461,760
23	52	146,263	59,248	87,015	2,276,003	480,116
24	53	153,576	61,618	91,958	2,527,282	498,245
25	54	161,255	64,083	97,172	2,801,364	516,149
26	55	169,318	66,646	102,672	3,100,131	533,829
27	56	177,784	69,312	108,472	3,425,612	551,285
28	57	186,673	72,084	114,589	3,779,994	568,519
29	58	196,006	74,968	121,039	4,165,632	585,533
30	59	205,807	77,966	127,840	4,585,067	602,327
31	60	216,097	81,085	135,012	5,041,034	618,903
32	61	-	84,328	(84,328)	5,309,578	609,227
33	62	-	87,701	(87,701)	5,593,547	599,822
34	63	-	91,210	(91,210)	5,893,886	590,681
35	64	-	94,858	(94,858)	6,211,600	581,797
36	65	-	98,652	(98,652)	6,547,760	573,161
37	66	-	102,598	(102,598)	6,903,504	564,768
38	67	-	106,702	(106,702)	7,280,047	556,610
39	68	-	110,970	(110,970)	7,678,680	548,680
40	69	-	115,409	(115,409)	8,100,779	540,973
41	70	-	120,026	(120,026)	8,547,808	533,482
42	71	-	124,827	(124,827)	9,021,328	526,201
43	72	-	129,820	(129,820)	9,523,001	519,124
44	73	-	135,012	(135,012)	10,054,599	512,246
45	74	-	140,413	(140,413)	10,618,008	505,560
46	75	-	146,029	(146,029)	11,215,239	499,062
47	76	-	151,871	(151,871)	11,848,436	492,746
48	77	-	157,945	(157,945)	12,519,881	486,608
49	78	-	164,263	(164,263)	13,232,009	480,641
50	79	-	170,834	(170,834)	13,987,416	474,841
51	80	-	177,667	(177,667)	14,788,868	469,205
52	81	-	184,774	(184,774)	15,639,315	463,726
53	82	-	192,165	(192,165)	16,541,902	458,401
54	83	-	199,851	(199,851)	17,499,984	453,225
55	84	-	207,845	(207,845)	18,517,138	448,194
56	85	-	216,159	(216,159)	19,597,178	443,304
57	86	-	224,806	(224,806)	20,744,175	438,552
58	87	-	233,798	(233,798)	21,962,470	433,932
59	88	-	243,150	(243,150)	23,256,693	429,443
60	89	-	252,876	(252,876)	24,631,786	425,079
61	90	-	262,991	(262,991)	26,093,020	420,837

Based on these assumptions, when I die at the age of 90, there will $26.1M left at nominal future value or $421k at today's value.