Question

A Aceto, Frank BUS 622 Week 3 Case Study Template F19- Excel AutoSave Off Share Review File Home Insert Page Layout Formulas Data View Help Tell me what you want to do AutoSum As 12A A Wrap Text Calibri General Fill Paste в I U Conditional Format as Insert Delete Format Sort & Find & - A 0 00 00 0 | Merge & Center Clear Formatting Table Styles Filter Select Number Editing Clipboard Font Alignment Styles Cells fox J19 А В C. E G Н K L M N O P 1 THE MBA DECISION 2 3 Lexy Halliday graduated four years ago with degrees in accounting and finance. She has been employed in 4 the finance department at Thorvaldsen Conglomerated (TC) since graduation. She is satisfied with her current 5 job, but is considering an MBA degree to increase her skills and her advancement prospects. She has 6 examined a number of MBA schools. She has narrowed her choices to 1) staying in her current job, 2) getting 7 an MBA at Arrington University (AU) or 3) getting an MBA at Boyden College (BC). 9 Lexy's annual salary at TC is $70,000 per year and she expects it to increase at 3.5 percent per year until 10 retirement. She is currently 26 years old and plans to retire in 30 years. Her current job includes a fully paid 11 health insurance plan and her current average tax rate is 22 percent. Lexy has a savings account with enough 12 money to cover the entire cost of her MBA program. 13 14 The Mason College of Business at Arrington University is a top MBA program. An AU MBA degree requires 15 two years of full-time enrollment. Annual tuition is $60,000, payable at the beginning of each school year. 16 Books and other supplies are estimated to cost $3,000 per year. Lexy expects that after graduation from AU, 17 she will receive a job offer for about $100,000 per year, with a $20,000 signing bonus. She expects the salary 18 at this job to increase at about 4.5 percent per year. Because of the higher salary, her average income tax 19 rate will increase to 30 percent 20 21 The Jensen School of Business at Boyden College (BC) began its MBA program 16 years ago. The Jensen 22 School is smaller and less well known than the school at AU. BC offers an accelerated, one-year program 23 with a tuition cost of $50,000 to be paid upon matriculation. Books and other supplies for the program are 24 expected to cost $4,000. Lexy expects to receive an offer of $85,000 per year with a $10,000 signing bonus 25 after graduation from BC. The salary at this job is expected to increase at 4% per year and her average 26 income tax rate at this level of income is expected to be 25 percent. 27 28 Assume that once Lexy makes her decision she will immediately begin school. She will need to move and her 29 health insurance and living expenses will change. Both schools offer a health insurance plan that will cost 30 $6,000 per year payable at the beginning of the year. Moving expenses are $2,000 and Lexy estimates that 31 room and board expenses for either school will cost $5,000 more per year than her current living expenses, 32 payable at the beginning of the year. Lexy estimates that the appropriate discount rate for her analysis is 33 7.1 percent. Assume that all salaries are paid at the end of each year. 34 Timeline for Growing Annuity Case Information #1 # 2 #3 #4 Ready 100% 9:42 AM е O Type here to search х‑ 10/29/2019

1. How does Lexy’s age affect her decision to get an MBA?              

Answer 1

	Given data
S.#	Particulars
	Lexy present age	26 years
	Retirement age	56 years
	Balance	30 years
	3 options
	staying in current job
	getting MBA from an Arrington university
	getting an MBA from boyden college
	PV of Option 1
	Salary	$70,000
	Tax amount @ 22%	$15,400
	After tax salary	$54,600
	Growth rate	3.50%
	No of periods	30 years
	Present value of remaining at current job	$1,006,946
	Arrington MBA
		Year 0	Year 1
	Tuition Fee	-$60,000.00	-$60,000.00
	Moving expenses	-$2,000.00
	Books and other supplies	-$3,000.00	-$3,000.00
	Health Insurance	-$6,000.00	-$6,000.00
	Extra Room and Board expenses	-$5,000.00	-$5,000.00
	Total Direct costs(cash outflow)	-$76,000.00	-$74,000.00
	Present value factor @ 7.1%	$1.00	$0.93
	Present value of direct costs	-$76,000.00	-$69,094.30
		Year 3
	Signing Bonus	$20,000
	Tax amount @ 30%	$6,000
		$14,000
	Present value factor @7.1%	0.81
	Present value of signing Bonus	$11,396
		Year 3- Year 30
	Salary	$100,000
	Tax amount @ 30%	$30,000
	After tax salary	$70,000
	Growth rate	4.50%
	No of periods	28 years
	Present value of remaining at current job	$1,167,680
	Value of Arrington MBA	$1,033,982
	Conclusion:-
	Present value of cash inflows by choosing Arrington MBA is more than remaining at current job.
	So if Lexy age has been much more than 26 years or retirement period
	was lesser than 30 years, then being at current job is better than choosing MBA
	If Lexy should have joined MBA much before than 26 years then going for MBA is better.
	Note:-
	Year 0- Starting of the year
	Year 1- ending of the 1st year