5.) Current job PV minus bonus after Wilton costs:

Value in 2 years:

Aftertax beginning salary:

Pretax beginning salary:

$ Current salary Years until retirement Salary increase Tax rate 57,000 40 3% 26% Wilton Tuition per year Books & Supplies Starting salary Signing bonus Salary increase Tax rate $ $ 63,000 2,500 105,000 18,000 4% 31% Mount Perry Tuition per year Books & Supplies Signing bonus Starting salary Salary increase Tax rate EA EA EA EA 75,000 3,500 15,000 88,000 3.5% 29% Both schools Health insurance Room & board increase $ 3,000 2,000 $ Discount rate 5.80% Output area: 3. Current job Aftertax income 57,000.00 42,180.00 $ Present value of salary 991,187.09 Wilton MBA PV of tuition & expenses $ 137,135.16 Aftertax bonus $ 12,420.00 PV of bonus $ 16,080.56 Aftertax salary $ 72,450.00 PV of salary in two years $ 1,928, 101.52 Value of salary today $ 1,722,497.34 PV of attending Wilton $ 1,601,442.74 Mount Perry MBA PV of tuition & expenses $ 79,388.47 PV of signing bonus $ 14,177.69 Aftertax salary $ 62,480.00 PV of salary in one year $ 1,563,743.46 PV of salary today $ 1,478,018.39 PV of attending Mt. Perry 1,412,807.61 5. Current job PV minus bonus after Wilton costs =D41-F4 Value in 2 years Aftertax beginning salary Pretax beginning salary $ Current salary Years until retirement Salary increase Tax rate 57,000 40 3% 26% Wilton Tuition per year Books & Supplies Starting salary Signing bonus Salary increase Tax rate $ $ 63,000 2,500 105,000 18,000 4% 31% Mount Perry Tuition per year Books & Supplies Signing bonus Starting salary Salary increase Tax rate EA EA EA EA 75,000 3,500 15,000 88,000 3.5% 29% Both schools Health insurance Room & board increase $ 3,000 2,000 $ Discount rate 5.80% Output area: 3. Current job Aftertax income 57,000.00 42,180.00 $ Present value of salary 991,187.09 Wilton MBA PV of tuition & expenses $ 137,135.16 Aftertax bonus $ 12,420.00 PV of bonus $ 16,080.56 Aftertax salary $ 72,450.00 PV of salary in two years $ 1,928, 101.52 Value of salary today $ 1,722,497.34 PV of attending Wilton $ 1,601,442.74 Mount Perry MBA PV of tuition & expenses $ 79,388.47 PV of signing bonus $ 14,177.69 Aftertax salary $ 62,480.00 PV of salary in one year $ 1,563,743.46 PV of salary today $ 1,478,018.39 PV of attending Mt. Perry 1,412,807.61 5. Current job PV minus bonus after Wilton costs =D41-F4 Value in 2 years Aftertax beginning salary Pretax beginning salary