Please review I am confused about if the data is accurate on my charts.

Complete the Data Case Presented in Chapter 4. Your submission should be a one-page executive summary of what you found in your analysis with two external citations and a copy of the Microsoft Excel spreadsheet that you used to complete your analysis. Graphs and gures should be presented as appendices (i.e. not presented within the body of the executive summary). Assume today is March 16, 2016. Natasha Kingery is 30 years old and has a Bachelor of Science degree in computer science. She is currently employed as a Tier 2 eld service representative for a telephony corporation located in Seattle, Washington, and earns $38,000 a year that she anticipates will grow at 3% per year. Natasha hopes to retire at age 65 and has just begun to think about the future. Natasha has $75,000 that she recently inherited from her aunt. She invested this money in 30-year Treasury Bonds. She is considering whether she should further her education and would use her inheritance to pay for it. If Natasha lacked the cash to pay for her tuition upfront, she could borrow the money. More intriguingly1 she could sell a fraction of her future earnings, an idea that has received attention from researchers and entrepreneurs; see M. Palacios, Investing in Human Capital: A Capital Markets Approach to Student Funding, Cambridge University Press, 2004 She has investigated a couple of options and is asking for your help as a nancial planning intern to determine the nancial consequences associated with each option. Natasha has already been accepted to both of these programs, and could start either one soon. One alternative that Natasha is considering is attaining a certication in network design. This certication would automatically promote her to a Tier 3 eld service representative in her company. The base salary for a Tier 3 representative is $10,000 more than what she currently earns and she anticipates that this salary differential will grow at a rate of 3% a year as long as she keeps working. The certication program requires the completion of 20 Web based courses and a score of 80% or better on an exam at the end of the course work. She has learned that the average amount of time necessary to nish the program is one year. The total cost of the program is $5000, due when she enrolls in the program. Because she will do all the work for the certication on her own time, Natasha does not expect to lose any income during the certication. Another option is going back to school for an MBA degree. With an MBA degree, Natasha expects to be promoted to a managerial position in her current rm. The managerial position pays $20,000 a year more than her current position. She expects that this salary differential will also grow at a rate of 3% per year for as long as she keeps working. The evening program, which will take three years to complete, costs $25,000 per year, due at the beginning of each of her three years in school. Because she will attend classes in the evening, Natasha doesn't expect to lose any income while she is earning her MBA if she chooses to undertake the MBA. 1. Determine the interest rate she is currently earning on her inheritance by going to the U.S. Treasury Department Web site (treasury.gov) and selecting "Data" on the main menu. Then select "Daily Treasury Yield Curve Rates" under the Interest Rate heading and enter the appropriate year, 2016, and then search down the list for March 16 to obtain the closing yield or interest rate that she is earning. Use this interest rate as the discount rate for the remainder of this problem. As of March 16, 2016 Natasha, is currently earning 2.73% for a 30-year Interest Rate according to the U.S. Treasury Department Web site (treasury.gov). 2. Create a timeline in Excel for her current situation, as well as the certification program and MBA degree options, using the following assumptions: a. Salaries for the year are paid only once, at the end of the year. b. The salary increase becomes effective immediately upon graduating from the MBA program or being certified. That is, because the increases become effective immediately but salaries are paid at the end of the year, the first salary increase will be paid exactly one year after graduation or certification.Timeline for Current Situation, Cert Program and MBA Year Age _ Current Situation Salary |Certification Program Salary [ | MBA Salary Differ D 30 $ 30,000.00 0 31 $ 30,900.00 0 2 32 $ 31,827.00 $ 10,609.00 3 33 $ 32,781.81 $ 10,927.27 o 4 34 $ 33,765.26 $ 11,255.09 $ 22,510. 18 5 35 $ 34, 778.22 $ 11,592.74 $ 23, 185.48 6 36 $ 35, 821.57 $ 11,940.52 $ 23,881.05 37 $ 36,896.22 $ 12,298.74 $ 24,597.48 38 $ 38,003.10 $ 12,667.70 $ 25,335.40 8 60 00 39 $ 39, 143.20 $ 13,047.73 $ 26,095.46 40 $ 40,317.49 $ 13,439. 16 $ 26,878.33 11 41 $ 41,527.02 $ 13,842.34 $ 27,684.68 12 42 $ 42,772.83 $ 14,257.61 $ 28,515.22 13 43 $ 44,056.01 $ 14,685.34 $ 29,370.67 14 44 $ 45,377.69 $ 15, 125.90 $ 30,251.79 15 45 $ 46,739.02 $ 15,579.67 $ 31,159.35 16 46 $ 48, 141. 19 $ 16,047.06 $ 32,094.13 47 $ 49,585.43 $ 16,528.48 $ 33,056.95 48 $ 51,072.99 $ 17,024.33 $ 34,048.66 49 $ 52,605.18 $ 17,535.06 $ 35,070.12 50 $ 54, 183.34 $ 18,061.11 $ 36, 122.22 21 51 $ 55, 808 .84 $ 18,602.95 $ 37,205.89 52 $ 57,483.10 |$ 19, 161.03 $ 38,322.07 23 53 $ 59,207.60 $ 19,735.87 $ 39,471.73 24 54 $ 60,983.82 $ 20,327.94 $ 40,655.88 25 55 $ 62,813.34 $ 20,937.78 $ 41,875.56 26 56 $ 64,697.74 $ 21,565.91 $ 43, 131.83 27 57 $ 66,638.67 $ 22,212.89 $ 44,425.78 28 58 $ 68,637.83 $ 22,879.28 $ 45,758.55 29 59 $ 70,696.97 $ 23,565.66 $ 47, 131.31 30 60 $ 72,817.87 $ 24,272.62 $ 48,545.25 31 61 $ 75,002.41 $ 25,000.80 $ 50,001.61 32 62 $ 77,252.48 $ 25, 750.83 $ 51,501.66 33 63 $ 79,570.06 $ 26,523.35 $ 53,046.70 34 64 $ 81,957 . 16 $ 27,319.05 $ 54,638.11 35 65 $ 84,415.87 $ 28, 138.62 $ 56,277.25 3. Calculate the present value of the salary differential for completing the certification program. Subtract the cost of the program to get the NPV of undertaking the certification program.NPV for Undertaking the Certification Program Year Age Salary Differential PVF @ 2.73% Present Value 30 O 1.00000000 OO 31 0 0.97342548 32 10609.00 0.94755717 10052.63 33 10927.27 0.92237630 10079.05 34 1 1255.09 0.89786460 10105.55 35 1 1592.74 0.87400428 10132.11 36 1940.52 0.85077804 10158.73 37 2298.74 0.82816903 10185.43 38 2667.70 0.80616083 10212.20 NO UA W N - OO OO VO ULA W N - O 39 13047.73 0.78473750 10239.04 40 13439.16 0.76388348 0265.96 41 13842.34 0.74358365 10292.94 42 14257.61 0.72382327 10319.99 43 14685.34 0.70458802 0347 . 11 44 15125.90 0.68586393 10374.31 45 15579.67 0.66763743 10401.57 46 16047.06 0.64989529 10428.91 47 6528.48 0.63262464 10456.32 18 48 17024.33 0.61581294 10483.80 19 49 17535.06 0.59944801 10511.36 20 50 18061.11 0.58351797 0538.98 21 51 18602.95 0.56801127 10566.68 22 52 19161.03 0.55291664 0594.45 23 53 19735.87 0.53822315 10622.30 24 54 20327.94 0.52392013 10650.22 25 55 20937.78 0.50999721 10678.21 26 56 21565.91 0.49644428 10706.27 27 57 22212.89 0.48325151 10734.41 28 58 22879.28 0.47040934 10762.63 29 59 23565.66 0.45790844 10790.91 30 60 24272.62 0.44573974 10819.27 31 61 25000.80 0.43389442 10847.71 32 62 25750.83 0.42236389 0876.22 33 63 26523.35 0.41113977 10904.81 34 64 27319.05 0.40021393 0933.47 35 65 28138.62 0.38957844 10962.20 Total Present Value $ 357,035.77 Minus Cost of Cert Program 5,000.00 Net Present Value $ 352,035.77 Calculate the present value of the salary differential for completing the MBA degree. Calculate the present value of the cost of the MBA program. Based on your calculations, determine the NPV of undertaking the MBA.NPV for Undertaking the MBA Year Age Salary Differential PVF @ 2.732 Present Value 0 30 1.00000000 31 0.97342548 32 ooo 0.94755717 33 0.92237630 34 $ 22,510.18 0.89786460 $ 20,211.09 35 $ 23, 185.48 0.87400428 $ 20,264.21 36 $ 23,881.05 0.85077804 $ 20,317.47 37 $ 24,597.48 0.82816903 $ 20,370.87 W N J O O O VO ULA W N- 38 $ 25,335.40 0.80616083 $ 20,424.41 39 $ 26,095.46 0.78473750 $ 20,478.09 40 $ 26,878.33 0.76388348 $ 20,531.91 41 $ 27,684.68 0.74358365 $ 20,585.87 42 $ 28,515.22 0.72382327 $ 20,639.98 43 $ 29,370.67 0.70458802 $ 20,694.23 44 $ 30,251.79 0.68586393 $ 20,748.61 15 45 $ 31, 159.35 0.66763743 $ 20,803.15 16 46 $ 32,094.13 0.64989529 $ 20,857.82 17 47 $ 33,056.95 0.63262464 $ 20,912.64 18 48 $ 34, 048.66 0.61581294 $ 20,967.61 19 49 $ 35,070.12 0.59944801 $ 21,022.71 20 50 $ 36, 122.22 0.58351797 $ 21,077.97 21 51 $ 37,205.89 0.56801127 $ 21, 133.37 22 52 $ 38,322.07 0.55291664 $ 21, 188.91 23 53 $ 39,471.73 0.53822315 $ 21,244.60 24 54 $ 40,655.88 0.52392013 $ 21,300.44 25 55 $ 41,875.56 0.50999721 $ 21,356.42 26 56 $ 43, 131.83 0.49644428 $ 21,412.55 27 57 $ 44,425.78 0.48325151 $ 21,468.83 28 58 $ 45,758.55 0.47040934 $ 21,525.25 29 59 $ 47,131.31 0.45790844 $ 21,581.82 30 60 $ 48,545.25 0.44573974 $ 21,638.55 31 61 $ 50,001.61 0.43389442 $ 21,695.42 32 62 $ 51,501.66 0.42236389 $ 21,752.44 33 63 $ 53,046.70 0.41113977 $ 21,809.61 34 64 $ 54,638.11 0.40021393 $ 21,866.93 35 65 $ 56,277.25 0.38957844 $ 21,924.40 Total Present Value $ 673,808. 16 Minus Cost of Cert Program $ 73,024.57 Net Present Value $ 600, 783.605. Based on your answers to Questions 3 and 4, what advice would you give to Natasha? What if the two programs are mutually exclusive? That is, if Natasha undertakes one of the programs there is no further benet to undertaking the other program. Would your advice be different? My advice for Natasha based on the NPV results would be for Natasha to select the MBA program. The MBA program's NPV is $600,783.60 versus $352,035.77 from the certication program. If the two programs were mutually exclusive then my advice would be for her to choose the MBA program, this recommendation is based on her achieving a managerial position upon completion along with a raise of $20,000 and a 3% annual pay Increase