VIPSolutions

VIPSolutions logo ✨ VIPSolutions

Home Dashboard Ask AI Archive

Give step-by-step solution with explanation and final answer: CASE STUDY # 1 Source: You graduated college six years ago with an undergraduate degree in Finance. Although satisfied with your current job, your goal is to become an investment banker, and you wonder if an MBA degree would allow you to achieve that goal. After examining schools, you have narrowed your choice to either Wilton University or Mount Perry College. Although internships are encouraged by both schools, to get credit for the internship, no salary can be paid. Other than internships, neither school will allow students to work while enrolled on the MBA program. However, thanks to a bequest from your grandmother, your savings account has enough money to cover the entire cost of the MBA program You currently work a money management firm, earning $ 5 3 , 0 0 0 annually. Your salary is expected to increase 3 % per year until retirement. You expect to work for 3 8 more years. Your current job includes a fully paid health insurance plan. Your current average tax rate is 2 6 % . The Ritter College of Business at Wilton University is one of the top MBA programs in the country. The MBA degree requires 2 years of full - time enrollment at the university. Annual tuition is $ 5 8 , 0 0 0 , payable at the beginning of each school year. Books and other supplies are estimated to cost $ 2 , 0 0 0 per year. Upon graduation from Wilton you expect to receive a job offer for about $ 8 7 , 0 0 0 per year, with a $ 1 0 , 0 0 0 signing bonus. Because of the higher salary, your tax rate will increase to 3 1 % . Annual salary increases are expected to be at 4 % per year. The Bradley School of Business at Mount Perry College began its MBA program 1 6 years ago. The Bradley School is smaller and less well known than Ritter College. Bradley offers an accelerated oneyear program; cost of tuition for the program is $ 7 5 , 0 0 0 , to be paid upon matriculation. Books and other supplies are expected to cost $ 4 , 2 0 0 . You think that you will receive an offer of $ 7 8 , 0 0 0 per year upon graduation, with an $ 8 , 0 0 0 signing bonus, resulting in an average tax rate of 2 9 % . The salary at this job would increase 3 . 5 % per year. Both schools offer comparable health insurance that will cost $ 3 , 0 0 0 per year, payable at the beginning of the year. Both schools also offer graduate housing, that will result in a decrease to your current room and board expenses of $ 4 , 0 0 0 per year, whichever school you attend. Assume the appropriate discount rate is 5 . 5 % . 3 . Assuming all salaries are paid at the end of each year, what is your best option from a strictly financial standpoint?  4 . A friend suggests that the appropriate analysis is to calculate the future value of each option. How would you evaluate this statement? 5 . What initial salary would you need to receive to make you indifferent between attending Wilton University and staying in your current position?  6 . Suppose that instead of being able to cover the cost of the MBA from your savings, you must borrow money. ( ( The current borrowing rate is 5 . 4 % ) How does this affect your decision

Question:

Give step-by-step solution with explanation and final answer: CASE STUDY # 1 Source: You graduated college six years ago with an undergraduate degree in Finance. Although satisfied with your current job, your goal is to become an investment banker, and you wonder if an MBA degree would allow you to achieve that goal. After examining schools, you have narrowed your choice to either Wilton University or Mount Perry College. Although internships are encouraged by both schools, to get credit for the internship, no salary can be paid. Other than internships, neither school will allow students to work while enrolled on the MBA program. However, thanks to a bequest from your grandmother, your savings account has enough money to cover the entire cost of the MBA program You currently work a money management firm, earning $ 5 3 , 0 0 0 annually. Your salary is expected to increase 3 % per year until retirement. You expect to work for 3 8 more years. Your current job includes a fully paid health insurance plan. Your current average tax rate is 2 6 % . The Ritter College of Business at Wilton University is one of the top MBA programs in the country. The MBA degree requires 2 years of full - time enrollment at the university. Annual tuition is $ 5 8 , 0 0 0 , payable at the beginning of each school year. Books and other supplies are estimated to cost $ 2 , 0 0 0 per year. Upon graduation from Wilton you expect to receive a job offer for about $ 8 7 , 0 0 0 per year, with a $ 1 0 , 0 0 0 signing bonus. Because of the higher salary, your tax rate will increase to 3 1 % . Annual salary increases are expected to be at 4 % per year. The Bradley School of Business at Mount Perry College began its MBA program 1 6 years ago. The Bradley School is smaller and less well known than Ritter College. Bradley offers an accelerated oneyear program; cost of tuition for the program is $ 7 5 , 0 0 0 , to be paid upon matriculation. Books and other supplies are expected to cost $ 4 , 2 0 0 . You think that you will receive an offer of $ 7 8 , 0 0 0 per year upon graduation, with an $ 8 , 0 0 0 signing bonus, resulting in an average tax rate of 2 9 % . The salary at this job would increase 3 . 5 % per year. Both schools offer comparable health insurance that will cost $ 3 , 0 0 0 per year, payable at the beginning of the year. Both schools also offer graduate housing, that will result in a decrease to your current room and board expenses of $ 4 , 0 0 0 per year, whichever school you attend. Assume the appropriate discount rate is 5 . 5 % . 3 . Assuming all salaries are paid at the end of each year, what is your best option from a strictly financial standpoint?  4 . A friend suggests that the appropriate analysis is to calculate the future value of each option. How would you evaluate this statement? 5 . What initial salary would you need to receive to make you indifferent between attending Wilton University and staying in your current position?  6 . Suppose that instead of being able to cover the cost of the MBA from your savings, you must borrow money. ( ( The current borrowing rate is 5 . 4 % ) How does this affect your decision

This is AI generated Response.
Asked by: Yelligadala Praneesh
Created at: 2025-06-06 05:31:15

Final Answer:

Rendered Raw Text
Did you like this answer?
Let's walk step-by-step through each part of your case study. Note: I’ll focus on the most critical calculations and logic for each question. If you need a more detailed spreadsheet, let me know! --- ### **Given Data (Summarized)** #### **Current Job** - Salary: **$53,000** (increases at 3%/year for 38 years) - Tax Rate: **26%** - Health insurance: Paid by employer (no out-of-pocket cost) - Room & board: Current amount, but will decrease by $4,000/year if you attend MBA #### **Wilton University (2 years)** - Tuition: **$58,000/year** (paid at beginning of each year for 2 years) - Books/Supplies: **$2,000/year** - Health insurance: **$3,000/year** - Room/Board: Decreases by $4,000/year - Length: **2 years** - Salary after graduation: **$87,000** + $10,000 signing bonus (tax rate 31%), salary grows 4%/year - Years after MBA: **36 years** (since 2 years for MBA, 38 - 2 = 36) #### **Mount Perry College (1 year)** - Tuition: **$75,000** (paid at beginning of year) - Books/Supplies: **$4,200** - Health insurance: **$3,000** - Room/Board: Decreases by $4,000/year - Length: **1 year** - Salary after graduation: **$78,000** + $8,000 signing bonus (tax rate 29%), salary grows at 3.5%/year - Years after MBA: **37 years** (since 1 year for MBA, 38 - 1 = 37) #### **Discount Rate:** **5.5%** --- ### **Q3: Best Option from a Financial Standpoint (NPV Calculation)** We'll compare the **Net Present Value (NPV)** of the three options: 1. **Continue working** 2. **Wilton University MBA** 3. **Mount Perry College MBA** #### **Step 1: Calculate NPV of Staying in Current Job** - **Salary at year 1 (current):** $53,000 - **Salary growth:** 3% per year - **Years:** 38 - **Tax rate:** 26% - **Health insurance:** $0 - **Room/board:** No change **After-tax salary per year:** \[ \text{After-tax Salary}_t = \text{Salary}_t \times (1 - 0.26) \] \[ \text{Salary}_t = 53,000 \times 1.03^{(t-1)} \] **NPV:** \[ NPV = \sum_{t=1}^{38} \frac{\text{After-tax Salary}_t}{(1+0.055)^t} \] --- #### **Step 2: NPV of Wilton MBA** **Years 1-2 (while in school):** - **Tuition:** $58,000/year - **Books:** $2,000/year - **Health insurance:** $3,000/year - **Room/board:** Save $4,000/year - **No salary** **Years 3-38 (after graduation):** - **Salary (year 3):** $87,000 + $10,000 signing bonus = $97,000 (first year after graduation) - **Salary growth:** 4%/year - **Tax rate:** 31% - **Health insurance:** $0 (covered by employer) - **Room/board:** back to normal expense **After-tax salary (year 3):** \[ \text{After-tax Salary}_3 = 97,000 \times (1 - 0.31) = 66,930 \] Then, from year 4 onwards: \[ \text{Salary}_{t} = 87,000 \times 1.04^{(t-4)} \] \[ \text{After-tax Salary}_t = \text{Salary}_t \times (1-0.31) \] **NPV Calculation:** - **Years 1-2:** Negative cash flow for costs (add back $4,000 room/board savings) - **Years 3-38:** Positive after-tax salary, discounted from year 3 onward \[ NPV = -\sum_{t=1}^{2} \frac{(\text{Tuition} + \text{Books} + \text{Health Insurance} - \text{Room/board savings})}{(1+0.055)^t} + \sum_{t=3}^{38} \frac{\text{After-tax Salary}_t}{(1+0.055)^t} \] --- #### **Step 3: NPV of Mount Perry MBA** **Year 1 (while in school):** - **Tuition:** $75,000 - **Books:** $4,200 - **Health insurance:** $3,000 - **Room/board:** Save $4,000 - **No salary** **Years 2-38:** - **Salary (year 2):** $78,000 + $8,000 signing bonus = $86,000 - **Salary growth:** 3.5%/year - **Tax rate:** 29% - **Health insurance:** $0 (covered by employer) - **Room/board:** returns to normal **After-tax salary (year 2):** \[ \text{After-tax Salary}_2 = 86,000 \times (1-0.29) = 61,060 \] From year 3: \[ \text{Salary}_t = 78,000 \times 1.035^{(t-3)} \] \[ \text{After-tax Salary}_t = \text{Salary}_t \times (1-0.29) \] **NPV Calculation:** - **Year 1:** Negative cash flow for costs (add back $4,000 room/board savings) - **Years 2-38:** Positive after-tax salary, discounted from year 2 onward \[ NPV = -\frac{(75,000 + 4,200 + 3,000 - 4,000)}{(1.055)^1} + \sum_{t=2}^{38} \frac{\text{After-tax Salary}_t}{(1.055)^t} \] --- #### **Step 4: Calculate Each NPV** Let's do the calculations step by step. --- ##### **Current Job NPV Calculation** \[ \text{After-tax Salary}_t = 53,000 \times 1.03^{(t-1)} \times 0.74 \] Let’s find the present value of a growing annuity: Formula for present value of a growing annuity: \[ PV = \frac{P}{r-g} \left[1 - \left(\frac{1+g}{1+r}\right)^n\right] \] Where: - \(P = \) first payment (after tax): \(53,000 \times 0.74 = 39,220\) - \(r = \) discount rate: 5.5% = 0.055 - \(g = \) growth rate: 3% = 0.03 - \(n = \) 38 years Plug in: \[ PV = \frac{39,220}{0.055-0.03} \left[1 - \left(\frac{1.03}{1.055}\right)^{38}\right] \] Calculate \((1.03/1.055)^{38}\): First, \(1.03/1.055 = 0.9763\) \(0.9763^{38}\) ≈ \(e^{38 \times \ln(0.9763)}\) \(\ln(0.9763) = -0.024\) \(38 \times -0.024 = -0.912\) \(e^{-0.912} ≈ 0.401\) So, \[ PV = \frac{39,220}{0.025} \left[1 - 0.401\right] = 1,568,800 \times 0.599 = \$940,701 \] --- ##### **Wilton University NPV Calculation** **Years 1-2 (costs):** - Tuition: $58,000 - Books: $2,000 - Health insurance: $3,000 - Room/board savings: -$4,000 Net cost per year: $58,000 + $2,000 + $3,000 - $4,000 = $59,000 per year - Year 1: \(-59,000 / 1.055 = -55,924\) - Year 2: \(-59,000 / (1.055)^2 = -53,049\) - Total cost NPV: \(-108,973\) **Years 3-38 (after-tax salary)** Year 3 salary: $97,000 (with signing bonus), after-tax: $97,000 × 0.69 = $66,930 Year 4 salary: $87,000 × 1.04 = $90,480, after-tax: $90,480 × 0.69 = $62,431 Continue with 4% growth for years 4-38 **Present Value Calculation:** - Year 3: $66,930 / (1.055)^3 = $57,161 - Years 4-38: This is a growing annuity starting at $62,431 in year 4, growing at 4% for 35 years Present Value (from year 4): \[ PV_{4-38} = \frac{62,431}{0.055-0.04} \left[1 - \left(\frac{1.04}{1.055}\right)^{35}\right] \] \[ 1.04/1.055 = 0.9853 \] \[ 0.9853^{35} = e^{35 \times \ln(0.9853)} = e^{-0.523} = 0.592 \] \[ PV_{4-38} = \frac{62,431}{0.015} \times (1 - 0.592) = 4,162,067 \times 0.408 = 1,698,323 \] But this is at year 3; discount to present: \[ PV_{0} = PV_{4-38} / (1.055)^3 = 1,698,323 / 1.174 = 1,447,669 \] **Total NPV:** \[ \text{Total NPV} = (-108,973) + 57,161 + 1,447,669 = \$1,395,857 \] --- ##### **Mount Perry NPV Calculation** **Year 1 (costs):** - Tuition: $75,000 - Books: $4,200 - Health insurance: $3,000 - Room/board savings: -$4,000 Net cost: $75,000 + $4,200 + $3,000 - $4,000 = $78,200 Year 1: \(-78,200 / 1.055 = -74,170\) **Years 2-38 (after-tax salary)** Year 2 salary: $86,000, after-tax: $86,000 × 0.71 = $61,060 Year 3 salary: $78,000 × 1.035 = $80,730, after-tax: $80,730 × 0.71 = $57,319 Continue with 3.5% growth for years 3-38 **Present Value Calculation:** - Year 2: $61,060 / (1.055)^2 = $54,872 - Years 3-38: Growing annuity with $57,319 in year 3, 3.5% growth, 36 years \[ PV_{3-38} = \frac{57,319}{0.055-0.035} \left[1 - \left(\frac{1.035}{1.055}\right)^{36}\right] \] \[ 1.035/1.055 = 0.9810 \] \[ 0.9810^{36} = e^{36 \times \ln(0.9810)} = e^{-0.686} = 0.503 \] \[ PV_{3-38} = 2,865,950 \times (1-0.503) = 2,865,950 \times 0.497 = 1,425,462 \] Discount to present (from year 2): \[ PV_0 = 1,425,462 / (1.055)^2 = 1,425,462 / 1.113 = 1,281,381 \] **Total NPV:** \[ \text{Total NPV} = -74,170 + 54,872 + 1,281,381 = \$1,262,083 \] --- ### **Summary Table** | Option | NPV | |------------------------|------------| | Stay in Current Job | $940,701 | | Wilton MBA | $1,395,857 | | Mount Perry MBA | $1,262,083 | --- ### **Final Answer to Q3: Best Financial Option** **Wilton University MBA** provides the highest financial NPV, followed by Mount Perry MBA, then staying at your current job. --- ### **Q4: Should You Use Future Value

📢 Instructions:

  • Ask anything relatd to above question only.
  • For new Question goto :
    Ask AI

Related Answers

Study Help, Fast Answers

VIPSolutions focuses on clear, step‑by‑step explanations so you can learn quickly. Whether you need an AI‑generated walkthrough or a short hint to get unstuck, each solution is organized for fast reading and easy review later.

Search similar questions, compare approaches, and bookmark the best answers for revision. Our goal is simple: quick, reliable study help that feels natural—not noisy.