Question

Please show all work. Thank you I greatly appreciate your help!

4 Lexy Halliday graduated four years ago with degrees in accounting and finance. She has been employed in the finance 5 department at Thorvaldsen Conglomerated (TC) since graduation. She is satisfied with her current job, but is 5considering 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 paya ble 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.

Answer 1

		CURRENT JOB
		Present Salary (paid in year1)	$70,000
		Tax Rate	22%
		After tax salary in year1	$54,600	(70000*(1-0.22)
		After tax salary in year2	$56,511	(54600*1.035)
		After tax salary in year(N+1)=1.035*After tax Salary in Year(N)
		ARRINGTON UNIVERSITY OPTION
		Total annual expenses in Year0	$76,000	(60000+3000+6000+5000)+moving expense 2000
		Total annual expenses in Year1	$74,000	(60000+3000+6000+5000)
		Annaul Salary in 3	$100,000
		After tax salary in Year3	$70,000	(100000*(1-0.30)
		After tax salary in Year4	$73,150	(75900*1.045)
		After tax salary in year(N+1)=1.045*After tax Salary in Year(N)
		Signing Bonus in Year2	$20,000
		BOYDEN COLLEGE OPTION
		Total annual expenses in year 0	$67,000	(50000+4000+6000+5000)+moving expense 2000
		Annaul Salary in 2	$85,000
		After tax salary in Year2	$63,750	(85000*(1-0.25)
		After tax salary in Year3	$66,300	(63150*1.04)
		After tax salary in year(N+1)=1.04*After tax Salary in Year(N)
		Signing Bonus in Year1	$10,000
		Present Value of Cash Flow=(Cash Flow)/((1+i)^N)
		i=discount rate =7.1%=0.071
		N=Year of Cash Flow
	1	If her iage is lower, the net benefit will be higher
	2	Best Option: MBA from JENSEN COLLEGE(Boyden University)
		Total Value of Current Job	$972,895
		Total Value of Arrington MBA	$1,040,022
		Total Value of Boyden MBA	$1,043,239
		N	Continue Current Job		ARRINGTON OPTION		BOYDEN COLLEGE OPTION
			CF1	PV1=CF1/(1.071^N)	CF2	PV2=CF2/(1.071^N)	CF3	PV3=CF3/(1.071^N)
		Year	Cash Flow	Present Value	Cash Flow	Present Value	Cash Flow	Present Value
		0			($76,000)	($76,000)	($67,000)	($67,000)
		1	$54,600	$50,980	($74,000)	($69,094)	$10,000	$9,337
		2	$56,511	$49,267	$20,000	$17,436	$63,750	$55,578
		3	$58,489	$47,611	$70,000	$56,981	$66,300	$53,969
		4	$60,536	$46,010	$73,150	$55,598	$68,952	$52,407
		5	$62,655	$44,464	$76,442	$54,248	$71,710	$50,890
		6	$64,848	$42,969	$79,882	$52,931	$74,578	$49,417
		7	$67,117	$41,525	$83,476	$51,646	$77,562	$47,987
		8	$69,466	$40,129	$87,233	$50,392	$80,664	$46,598
		9	$71,898	$38,780	$91,158	$49,169	$83,891	$45,249
		10	$74,414	$37,477	$95,260	$47,975	$87,246	$43,939
		11	$77,019	$36,217	$99,547	$46,811	$90,736	$42,667
		12	$79,714	$35,000	$104,027	$45,674	$94,366	$41,432
		13	$82,504	$33,823	$108,708	$44,565	$98,140	$40,233
		14	$85,392	$32,686	$113,600	$43,484	$102,066	$39,069
		15	$88,381	$31,588	$118,712	$42,428	$106,148	$37,938
		16	$91,474	$30,526	$124,054	$41,398	$110,394	$36,840
		17	$94,676	$29,500	$129,636	$40,393	$114,810	$35,773
		18	$97,989	$28,508	$135,470	$39,412	$119,403	$34,738
		19	$101,419	$27,550	$141,566	$38,456	$124,179	$33,732
		20	$104,969	$26,624	$147,936	$37,522	$129,146	$32,756
									18 19 20 $97,989 $101,419 $104,969 $28,508 $27,550 $26,624 $135,470 $141,566 $147,936 $39,412 $38,456 $37,522 $119,403 $124,179 $129,146 $34,738 $33,732 $32,756 21 $108,642 22 $112,445 23 $116,381 24 $120,454 25 $124,670 26 $129,033 27 $133,549 28 $138,224 29 $143,061 30 $148,069 SUM $25,729 $154,594 $24,864 $161,550 $24,028 $168,820 $23,221 $176,417 $22,440 $184,356 $21,686 $192,652 $20,957 $ 201,321 $20,252 $210,380 $19,572 $219,848 $18,914 $229,741 $972,895 SUM $36,611 $35,722 $34,855 $34,009 $33,183 $32,378 $31,592 $30,825 $30,076 $29,346 $1,040,022 $134,312 $139,684 $145,271 $ 151,082 $157,126 $ 163,411 $169,947 $176,745 $183,815 $191,167 $31,808 $30,887 $29,993 $29,125 $28,282 $27,463 $26,668 $25,897 $25,147 $24,419 $1,043,239 Present Worth of Current Job $972,895 Present Worth of ARRINGTON ME $1,040,022 Present Worth of BOYDEN MBA $1,043,239 BOYDEN MBA should be selected