The Will worked example - Teachnet UK-home by nyut545e2

VIEWS: 10 PAGES: 10

• pg 1
```									             Year 1   Year 2   Year 3   Year 4   Year 5   Year 6   Year 7
Scenario 1
Scenario 2
Scenario 3
Year 8   Year 9   Year 10   Total
Year 1    Year 2    Year 3    Year 4    Year 5    Year 6    Year 7    Year 8
Scenario 1   £1,000.00 £1,000.00 £1,000.00 £1,000.00 £1,000.00 £1,000.00 £1,000.00 £1,000.00
Scenario 2    £100.00    £150.00  £225.00   £337.50   £506.25   £759.38 £1,139.06 £1,708.59
Scenario 3      £10.00    £20.00    £40.00    £80.00  £160.00   £320.00   £640.00 £1,280.00
Year 9   Year 10     Total
£1,000.00 £1,000.00 £10,000.00
£2,562.89 £3,844.34 £11,333.01
£2,560.00 £5,120.00 £10,240.00
Year 1    Year 2    Year 3    Year 4    Year 5    Year 6    Year 7    Year 8
Scenario 1   £1,000.00 £1,050.00 £1,102.50 £1,157.63 £1,215.51 £1,276.28 £1,340.10 £1,407.10
Scenario 2    £100.00    £155.00  £240.25   £372.39   £577.20   £894.66 £1,386.72 £2,149.42
Scenario 3      £10.00    £20.50    £42.03    £86.15  £176.61   £362.05   £742.20 £1,521.52
Year 9   Year 10     Total
£1,477.46 £1,551.33 £12,577.89
£3,331.61 £5,163.99 £14,371.24
£3,119.11 £6,394.18 £12,788.36
Year 1     Year 2      Year 3       Year 4        Year 5      Year 6
Scenario 1 1000   =B2          =C2          =D2          =E2          =F2
Scenario 2 100    =B3+(B3*0.5) =C3+(C3*0.5) =D3+(D3*0.5) =E3+(E3*0.5) =F3+(F3*0.5)
Scenario 3 10     =(B4*2)      =(C4*2)      =(D4*2)      =(E4*2)      =(F4*2)
Year 7       Year 8       Year 9       Year 10       Total
=G2          =H2          =I2          =J2          =SUM(B2:K2)
=G3+(G3*0.5) =H3+(H3*0.5) =I3+(I3*0.5) =J3+(J3*0.5) =SUM(B3:K3)
=(G4*2)      =(H4*2)      =(I4*2)      =(J4*2)      =(K4*2)
The Will

£12,000.00

£10,000.00

£8,000.00
Amounts paid

Scenario 1
£6,000.00                                                                                                        Scenario 2
Scenario 3

£4,000.00

£2,000.00

£0.00
Year 1   Year 2   Year 3   Year 4   Year 5    Year 6    Year 7   Year 8   Year 9   Year 10   Total
Years
The Will

£12,000.00

£10,000.00

£8,000.00
Amounts

Scenario 1
£6,000.00                                                                                                        Scenario 2
Scenario 3

£4,000.00

£2,000.00

£0.00
Year 1   Year 2   Year 3   Year 4   Year 5   Year 6     Year 7   Year 8   Year 9   Year 10   Total
Years

```
To top