i am tryingn to figure iut which numbers i apply the scenario percentages too
challenge. Scenarios Use the scenario manager to create two additional scenarios that can be compared to the baseline that you've already created: 1. Increase post-retirement spending by 7.5%, increase retirement savings rate by 10%. 2. Decrease post-retirement spending by 10%, decrease earnings by 5%. E F G H Retirement @ 65 Yes!! Total Investments $ 1,006,942 Investment RRSP's Dividends Interest Savings $ 420,000.00 $ 33,000.00 $ 57,633.95 $ 357,286.51 $ 139,021.95 Net income - Expenses Expenses Net Income S 534,576.36 $ 673,598.31 Gross Income-Income Tax Income Tax Gross Income Bonus RRSP Salary S 164,075.64 Gross Income . 19% $ 837,673.95 Salary + Bonus - RRSP $79,152.18 10% Salary $ 33,000.00 $ 791,521.77 Original Salary + 3% COLA accumulated for 10 years PM 40 ENG OM M + Merge & Center Number 2 Alignment c D G E 3% 10% 3,000 19% 2% 20% Expenses Yearly Life Insurance $ 1,620.00 Until Age 70 Food & Household $ 6,600.00 Utilities $ 2,400.00 Telecom/Internet/TV $ 3,000.00 Entertainment $3,000.00 Travel/Vacations $ 4,800.00 Insurance Home/Auto $ 4,200.00 Maintenance & Repairs $4,200.00 Fuel (2 autos) $ 2,400.00 Miscellaneous $3,300.00 Total $ 35,520.00 / Available Funds $ 40,277.70 /yr 14,400 0.8339 5% 50,000 262,000 420,000 Questions Farnings Source Data Base Case Base Case (2) Scenario Finanses Scenario Jacob CEK B DA Assignment Case Gp 2013 Comments Page Layout Dets Foem Review View Shale Help Power Pivot net - 2.49 0 4 - cabi MAA - West BILE - AE Merge Centet Custom $ - % Ideas Conditional formats Cell Formatting able Styles Sort & Find a Fater - Seled Editing Foet Anment Number D F E K H Farnings Expenses Savings Re-invested Ro invested Salary Bonus Income Tax Net Income Expenses Mortgage Savings RRSP Investment Dividends Appreciation Base Years 51,500.00 6,180.00 $ 12,346.20 $ 52,633.80 S 35,520.00 S 14,400.00 $ 2,713.80 $ 2,000.00 S 420,000.00 $ 3,500.00 21,40069 63,654.00 S 6,365.40 $ 12.733.69 $ 54,285,71 $ 36,230.40 S 14,400.00 $ 3,655.31 $3,000.00 $ 450,676.495 3,755.625 23.054.27 25 65,563.62 S6,556.36 $ 13.132.50 $ 55,987.19 S 36,955.01$ 14,400.00 $ 4,032.18$ 3,000.00 $ 484,139.70 $ 4,034.50 $ 24.10.32 3$ 67,530,535 6.753.05 S 11,543.8 S 57.739.705 37.611 S 14,400.00 5 5,645.59 $3,000.00 $ 520,596.69 $ 4,238.31 $ 26,079.00 45 69.556.44 $ 6,955.64 S 13,967.80 59,544.79$ 38.447.99 $ 14400.00 S 6,696.80 $ 3,000.00 $ 560,259.62 $ 4,665.335 28,72125 5$ 71,613.14 S 7,164.31 $ 15,161.49 $ 60,645.56 $ 39,216.95 $ 14,400.00 $ 7,029.01 $3,000.00 $ 603,356.51 $ 5,027.97 $ 30,320,67 5$ 73,792.43S 7,379.24 S 15,634.44 $ 62,537.34 $ 40,001 29 $ 14,400.00 $ 8,136.00 $3,000.00 $ 649.12.173 5,411.125 33,294.07 75 76,006,20 $ 7.600.62 S 16, 121.37 $ 64,485.46 $40.801.31 $ 1,543.59 $ 22.140.56 $3,000.00 $ 699,175.40 $ 5,826.46 5 36,507.12 8$ 78,286.39.5 7.828.64 $ 16,623.01 $ 66.492.02 $ 41,617.34 $ 24.8.68 $3,000.00 $ 766,649.54 $ 5.155.75$ 40.005.05 95 30,634.98 S 8,063 505 17.135.70 S 68,558.78 5 42.469.69 $ 26.109.10 $3,000.00 $ 840,958.625 7,007.99 $ 43,853.7 10 S 83.051.03 5 8,305.40 5 17,621.89 $20.687.55 41,296,68 5 27,388.87 $3,000.00 S 920.929.49 $ 7,67441 47.949.64 s 21.254.03 $ 72,972.18 S 164,075,64 $673,598.31 S 139,021.95 $ 33,000.00 $ 57,633.95$ 357,286,51 $ 586,942.41 $ 1,006,942.41 Savings Annuities Expenses Questions Source Data Dase Case 21 Scena Stenand here to search O + L M & ENG 2:01 PM 1000-110 challenge. Scenarios Use the scenario manager to create two additional scenarios that can be compared to the baseline that you've already created: 1. Increase post-retirement spending by 7.5%, increase retirement savings rate by 10%. 2. Decrease post-retirement spending by 10%, decrease earnings by 5%. E F G H Retirement @ 65 Yes!! Total Investments $ 1,006,942 Investment RRSP's Dividends Interest Savings $ 420,000.00 $ 33,000.00 $ 57,633.95 $ 357,286.51 $ 139,021.95 Net income - Expenses Expenses Net Income S 534,576.36 $ 673,598.31 Gross Income-Income Tax Income Tax Gross Income Bonus RRSP Salary S 164,075.64 Gross Income . 19% $ 837,673.95 Salary + Bonus - RRSP $79,152.18 10% Salary $ 33,000.00 $ 791,521.77 Original Salary + 3% COLA accumulated for 10 years PM 40 ENG OM M + Merge & Center Number 2 Alignment c D G E 3% 10% 3,000 19% 2% 20% Expenses Yearly Life Insurance $ 1,620.00 Until Age 70 Food & Household $ 6,600.00 Utilities $ 2,400.00 Telecom/Internet/TV $ 3,000.00 Entertainment $3,000.00 Travel/Vacations $ 4,800.00 Insurance Home/Auto $ 4,200.00 Maintenance & Repairs $4,200.00 Fuel (2 autos) $ 2,400.00 Miscellaneous $3,300.00 Total $ 35,520.00 / Available Funds $ 40,277.70 /yr 14,400 0.8339 5% 50,000 262,000 420,000 Questions Farnings Source Data Base Case Base Case (2) Scenario Finanses Scenario Jacob CEK B DA Assignment Case Gp 2013 Comments Page Layout Dets Foem Review View Shale Help Power Pivot net - 2.49 0 4 - cabi MAA - West BILE - AE Merge Centet Custom $ - % Ideas Conditional formats Cell Formatting able Styles Sort & Find a Fater - Seled Editing Foet Anment Number D F E K H Farnings Expenses Savings Re-invested Ro invested Salary Bonus Income Tax Net Income Expenses Mortgage Savings RRSP Investment Dividends Appreciation Base Years 51,500.00 6,180.00 $ 12,346.20 $ 52,633.80 S 35,520.00 S 14,400.00 $ 2,713.80 $ 2,000.00 S 420,000.00 $ 3,500.00 21,40069 63,654.00 S 6,365.40 $ 12.733.69 $ 54,285,71 $ 36,230.40 S 14,400.00 $ 3,655.31 $3,000.00 $ 450,676.495 3,755.625 23.054.27 25 65,563.62 S6,556.36 $ 13.132.50 $ 55,987.19 S 36,955.01$ 14,400.00 $ 4,032.18$ 3,000.00 $ 484,139.70 $ 4,034.50 $ 24.10.32 3$ 67,530,535 6.753.05 S 11,543.8 S 57.739.705 37.611 S 14,400.00 5 5,645.59 $3,000.00 $ 520,596.69 $ 4,238.31 $ 26,079.00 45 69.556.44 $ 6,955.64 S 13,967.80 59,544.79$ 38.447.99 $ 14400.00 S 6,696.80 $ 3,000.00 $ 560,259.62 $ 4,665.335 28,72125 5$ 71,613.14 S 7,164.31 $ 15,161.49 $ 60,645.56 $ 39,216.95 $ 14,400.00 $ 7,029.01 $3,000.00 $ 603,356.51 $ 5,027.97 $ 30,320,67 5$ 73,792.43S 7,379.24 S 15,634.44 $ 62,537.34 $ 40,001 29 $ 14,400.00 $ 8,136.00 $3,000.00 $ 649.12.173 5,411.125 33,294.07 75 76,006,20 $ 7.600.62 S 16, 121.37 $ 64,485.46 $40.801.31 $ 1,543.59 $ 22.140.56 $3,000.00 $ 699,175.40 $ 5,826.46 5 36,507.12 8$ 78,286.39.5 7.828.64 $ 16,623.01 $ 66.492.02 $ 41,617.34 $ 24.8.68 $3,000.00 $ 766,649.54 $ 5.155.75$ 40.005.05 95 30,634.98 S 8,063 505 17.135.70 S 68,558.78 5 42.469.69 $ 26.109.10 $3,000.00 $ 840,958.625 7,007.99 $ 43,853.7 10 S 83.051.03 5 8,305.40 5 17,621.89 $20.687.55 41,296,68 5 27,388.87 $3,000.00 S 920.929.49 $ 7,67441 47.949.64 s 21.254.03 $ 72,972.18 S 164,075,64 $673,598.31 S 139,021.95 $ 33,000.00 $ 57,633.95$ 357,286,51 $ 586,942.41 $ 1,006,942.41 Savings Annuities Expenses Questions Source Data Dase Case 21 Scena Stenand here to search O + L M & ENG 2:01 PM 1000-110
