Docstoc

The Will worked example - Teachnet UK-home

Document Sample
The Will worked example - Teachnet UK-home Powered By Docstoc
					             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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:3/19/2011
language:English
pages:10