Answer To: amit tax plannign advice create tax efficiencies explain the advantages and disdavantages aged55...
Neha answered on Dec 02 2021
Sheet1
accumulation math
the first thing is to set up the spreadsheet and see what we get in terms of their incomes, because we need to calculate the discretionary and non discretionary spending
we also need this to determine their annual savings, and establish a rate of return NOTE we will use numbers drawn from a source of information
So what does that mean? Well, use something with a proof behind it- a justification
Out of there annal income, they are ale to contibute an amunt towards their spending and saving. By finding out the amont they contribute annually to the sving, we can establish the amount hey will require and the rate at which they are able to generate return of their income.
spouse 1 spouse 2 spouse 1 spouse 2 spouse 1 spouse 2 total annual savings total 5% return end of year
year age age income income contribution contribution contribution (prev year) savings on savings total savings
1 32 30 $ 60,000.00 $ 80,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 0 $ 61,000.00 $ 3,050.00 $ 64,050.00
2 33 31 $ 60,000.00 $ 80,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 64,050.00 $ 125,050.00 $ 6,252.50 $ 131,302.50
3 34 32 $ 60,000.00 $ 80,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 131,302.50 $ 192,302.50 $ 9,615.13 $ 201,917.63
4 35 33 $ 60,000.00 $ 80,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 201,917.63 $ 262,917.63 $ 13,145.88 $ 276,063.51
5 36 34 $ 60,000.00 $ 80,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 276,063.51 $ 337,063.51 $ 16,853.18 $ 353,916.68
6 37 35 $ 66,000.00 $ 88,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 353,916.68 $ 414,916.68 $ 20,745.83 $ 435,662.52
7 38 36 $ 66,000.00 $ 88,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 435,662.52 $ 496,662.52 $ 24,833.13 $ 521,495.64
8 39 37 $ 66,000.00 $ 88,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 521,495.64 $ 582,495.64 $ 29,124.78 $ 611,620.42
9 40 38 $ 66,000.00 $ 88,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 611,620.42 $ 672,620.42 $ 33,631.02 $ 706,251.44
10 41 39 $ 66,000.00 $ 88,000.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 706,251.44 $ 767,251.44 $ 38,362.57 $ 805,614.02
11 42 40 $ 72,600.00 $ 96,800.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 805,614.02 $ 866,614.02 $ 43,330.70 $ 909,944.72
12 43 41 $ 72,600.00 $ 96,800.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 909,944.72 $ 970,944.72 $ 48,547.24 $ 1,019,491.95
13 44 42 $ 72,600.00 $ 96,800.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 1,019,491.95 $ 1,080,491.95 $ 54,024.60 $ 1,134,516.55
14 45 43 $ 72,600.00 $ 96,800.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 1,134,516.55 $ 1,195,516.55 $ 59,775.83 $ 1,255,292.38
15 46 44 $ 72,600.00 $ 96,800.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 1,255,292.38 $ 1,316,292.38 $ 65,814.62 $ 1,382,107.00
16 47 45 $ 79,860.00 $ 101,640.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 1,382,107.00 $ 1,443,107.00 $ 72,155.35 $ 1,515,262.35
17 48 46 $ 79,860.00 $ 101,640.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 1,515,262.35 $ 1,576,262.35 $ 78,813.12 $ 1,655,075.47
18 49 47 $ 79,860.00 $ 101,640.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 1,655,075.47 $ 1,716,075.47 $ 85,803.77 $ 1,801,879.24
19 50 48 $ 79,860.00 $ 101,640.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 1,801,879.24 $ 1,862,879.24 $ 93,143.96 $ 1,956,023.20
20 51 49 $ 79,860.00 $ 101,640.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 1,956,023.20 $ 2,017,023.20 $ 100,851.16 $ 2,117,874.36
21 52 50 $ 87,846.00 $ 106,722.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 2,117,874.36 $ 2,178,874.36 $ 108,943.72 $ 2,287,818.08
22 53 51 $ 87,846.00 $ 106,722.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 2,287,818.08 $ 2,348,818.08 $ 117,440.90 $ 2,466,258.98
23 54 52 $ 87,846.00 $ 106,722.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 2,466,258.98 $ 2,527,258.98 $ 126,362.95 $ 2,653,621.93
24 55 53 $ 87,846.00 $ 106,722.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 2,653,621.93 $ 2,714,621.93 $ 135,731.10 $ 2,850,353.03
25 56 54 $ 87,846.00 $ 106,722.00 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 2,850,353.03 $ 2,911,353.03 $ 145,567.65 $ 3,056,920.68
26 57 55 $ 92,238.30 $ 112,058.10 $ 27,000.00 $ 34,000.00 $ 61,000.00 $ 3,056,920.68 $ 3,117,920.68 $ 155,896.03 $ 3,273,816.71
27 58 56 $ 92,238.30 $ ...