Pleasee show work. Thank you!

4 Lexy Halliday graduated four years ago with degrees in accounting and finance. She has been employed in the finance department at Thorvaldsen Conglomerated (TC) since graduation. She is satisfied with her current job, but is considering an MBA degree to increase her skills and her advancement prospects. She has examined a number of MBA schools. She has narrowed her choices to 1) staying in her current job, 2) getting an MBA at Arrington University (AU) or 3) getting an MBA at Boyden College (BC). Lexy's annual salary at TC is $70,000 per year and she expects it to increase at 3.5 percent per year until retirement. She is currently 26 years old and plans to retire in 30 years. Her current job includes a fully paid health insurance plan and her current average tax rate is 22 percent. Lexy has a savings account with enough money to cover the entire cost of her MBA program. The Mason College of Business at Arrington University is a top MBA program. An AU MBA degree requires two years of full-time enrollment. Annual tuition is $60,000, payable at the beginning of each school year. Books and other supplies are estimated to cost $3,000 per year. Lexy expects that after graduation from AU, she will receive a job offer for about $100,000 per year, with a $20,000 signing bonus. She expects the salary at this job to increase at about 4.5 percent per year. Because of the higher salary, her average income tax rate will increase to 30 percent. The Jensen School of Business at Boyden College (BC) began its MBA program 16 years ago. The Jensen School is smaller and less well known than the school at AU. BC offers an accelerated, one-year program, with a tuition cost of $50,000 to be paid upon matriculation. Books and other supplies for the program are expected to cost $4,000. Lexy expects to receive an offer of $85,000 per year with a $10,000 signing bonus after graduation from BC. The salary at this job is expected to increase at 4% per year and her average income tax rate at this level of income is expected to be 25 percent. Assume that once Lexy makes her decision she will immediately begin school. She will need to move and her health insurance and living expenses will change. Both schools offer a health insurance plan that will cost $6,000 per year payable at the beginning of the year. Moving expenses are $2,000 and Lexy estimates that room and board expenses for either school will cost $5,000 more per year than her current living expenses, payable at the beginning of the year. Lexy estimates that the appropriate discount rate for her analysis is 7.1 percent. Assume that all salaries are paid at the end of each year. 2. Assuming all salaries are paid at the end of each year, what is the best option for Lexyfrom a strictly financial standpoint? She has three choices remain at her current job, pursue an Arrington + MBA, or pursue a Boyden MBA In order to determine the best option, you will need to calculate the after a present value of each option perform analysis below) $ Remain at Current lob 7 After-tax salary 8 Discount rate: 9 Growth rate: 10 # of periods 11 Pof remaining at current job 54,600.00 7.1% 3.5 Boyd MA Direct Costs Present Value of Direct Costs 67.000 62,558 Plus " from getting an MBA Altertax bonus PV ofertax bonus Artaxay PV of new salary 7,500 7.00) 13 Arrington MBA 14 Direct Costs 15 Present Value of Direct Costs $ 74,000 76,000 145,094 $ Note here the assumptions used for PV of new Salary * Ist calculate the PV of new salary to be received 2 7.1% 17 Plus "gain" from getting an MBA 18 Aftertax bonus 19 PV of after-tax bonus 20 After tax salary 21 PV of new salary 14.000 $12205 70.000 114,704 Discount rate Growth rate Number of periods Finly of getting salary in 2 yrs $ 35,000 Total Value of a Boyden MBA 51,123,510.10 23 Note here the assumptions used for PV of new Salary: 25 1st calculate the PV of new salary to be received 3 years from now (which is FV of PV of new salary today 26 Discount rate 27 Growth rate 28 Number of periods $ 100.000 29 PV in 2 yrs of getting salary in 3 yos which option should she choose? 19 Total Value of a Arrington MBA 1. How does Lexy's age affect her decision to get an MBA? 3. In choosing between the two schools, Lexy believes that the appropriate analysis is to calculate the future value of each option. How would you evaluate this statement? - 5. What initial salary would Lexy need to receive after graduating from Boyden College to make her indifferent between attending Boyden College and staying in her current position? Assume her tax rate after graduating from Boyden College will be 25 percent regardless of her income level. 972.895 62.558 PV of Current Job 5 PV of Costs to attend Boyden SPV of bonus = Equal to PV of salary required Calculate the PV of the salary required 1 yr from now when she graduates 1.NO Calculate the first salary payment (hint: use formula shown above) After tax salary Pretax salary Salary Timeline Cash Flow | Pre Arrington MBA Timeline Present Value Boyden MBA Timeline Cash Flow Present Value VOULAWNHO UEUR S CEN 4 Lexy Halliday graduated four years ago with degrees in accounting and finance. She has been employed in the finance department at Thorvaldsen Conglomerated (TC) since graduation. She is satisfied with her current job, but is considering an MBA degree to increase her skills and her advancement prospects. She has examined a number of MBA schools. She has narrowed her choices to 1) staying in her current job, 2) getting an MBA at Arrington University (AU) or 3) getting an MBA at Boyden College (BC). Lexy's annual salary at TC is $70,000 per year and she expects it to increase at 3.5 percent per year until retirement. She is currently 26 years old and plans to retire in 30 years. Her current job includes a fully paid health insurance plan and her current average tax rate is 22 percent. Lexy has a savings account with enough money to cover the entire cost of her MBA program. The Mason College of Business at Arrington University is a top MBA program. An AU MBA degree requires two years of full-time enrollment. Annual tuition is $60,000, payable at the beginning of each school year. Books and other supplies are estimated to cost $3,000 per year. Lexy expects that after graduation from AU, she will receive a job offer for about $100,000 per year, with a $20,000 signing bonus. She expects the salary at this job to increase at about 4.5 percent per year. Because of the higher salary, her average income tax rate will increase to 30 percent. The Jensen School of Business at Boyden College (BC) began its MBA program 16 years ago. The Jensen School is smaller and less well known than the school at AU. BC offers an accelerated, one-year program, with a tuition cost of $50,000 to be paid upon matriculation. Books and other supplies for the program are expected to cost $4,000. Lexy expects to receive an offer of $85,000 per year with a $10,000 signing bonus after graduation from BC. The salary at this job is expected to increase at 4% per year and her average income tax rate at this level of income is expected to be 25 percent. Assume that once Lexy makes her decision she will immediately begin school. She will need to move and her health insurance and living expenses will change. Both schools offer a health insurance plan that will cost $6,000 per year payable at the beginning of the year. Moving expenses are $2,000 and Lexy estimates that room and board expenses for either school will cost $5,000 more per year than her current living expenses, payable at the beginning of the year. Lexy estimates that the appropriate discount rate for her analysis is 7.1 percent. Assume that all salaries are paid at the end of each year. 2. Assuming all salaries are paid at the end of each year, what is the best option for Lexyfrom a strictly financial standpoint? She has three choices remain at her current job, pursue an Arrington + MBA, or pursue a Boyden MBA In order to determine the best option, you will need to calculate the after a present value of each option perform analysis below) $ Remain at Current lob 7 After-tax salary 8 Discount rate: 9 Growth rate: 10 # of periods 11 Pof remaining at current job 54,600.00 7.1% 3.5 Boyd MA Direct Costs Present Value of Direct Costs 67.000 62,558 Plus " from getting an MBA Altertax bonus PV ofertax bonus Artaxay PV of new salary 7,500 7.00) 13 Arrington MBA 14 Direct Costs 15 Present Value of Direct Costs $ 74,000 76,000 145,094 $ Note here the assumptions used for PV of new Salary * Ist calculate the PV of new salary to be received 2 7.1% 17 Plus "gain" from getting an MBA 18 Aftertax bonus 19 PV of after-tax bonus 20 After tax salary 21 PV of new salary 14.000 $12205 70.000 114,704 Discount rate Growth rate Number of periods Finly of getting salary in 2 yrs $ 35,000 Total Value of a Boyden MBA 51,123,510.10 23 Note here the assumptions used for PV of new Salary: 25 1st calculate the PV of new salary to be received 3 years from now (which is FV of PV of new salary today 26 Discount rate 27 Growth rate 28 Number of periods $ 100.000 29 PV in 2 yrs of getting salary in 3 yos which option should she choose? 19 Total Value of a Arrington MBA 1. How does Lexy's age affect her decision to get an MBA? 3. In choosing between the two schools, Lexy believes that the appropriate analysis is to calculate the future value of each option. How would you evaluate this statement? - 5. What initial salary would Lexy need to receive after graduating from Boyden College to make her indifferent between attending Boyden College and staying in her current position? Assume her tax rate after graduating from Boyden College will be 25 percent regardless of her income level. 972.895 62.558 PV of Current Job 5 PV of Costs to attend Boyden SPV of bonus = Equal to PV of salary required Calculate the PV of the salary required 1 yr from now when she graduates 1.NO Calculate the first salary payment (hint: use formula shown above) After tax salary Pretax salary Salary Timeline Cash Flow | Pre Arrington MBA Timeline Present Value Boyden MBA Timeline Cash Flow Present Value VOULAWNHO UEUR S CEN