Question: please include excel formulas and table. thank you. D53 fx A B D E F G H 2 3 4 5 You are 30 years

please include excel formulas and table. thank you.
D53 fx A B D E F G H 2 3 4 5 You are 30 years old today and are considering studying for an MBA. You have just received your annual salary of $50,000 and expect it to grow by 4% per year (without earning an MBA). MBAs typically earn $80,000 per year upon graduation, with salaries growing by 5% per year. The MBA program you're considering is a full-time, 2-year program that costs $30,000 per year, payable at the end of each study year. You want to retire on your 65th birthday, 35 years from today The relevant discount rate is 8%. Is it worthwhile for you to quit your job for two years in order to pursue an MBA? ON 6 7 8 9 10 11 12 Current salary MBA Starting Salary MBA Tuition 50,000 Growth Rate: 80,000 Growth Rate: 30,000 Discount rate: 4.00% 5.00% 8.00% 13 14 15 16 Normal (no-MBA) Salary 50,000 Year PV of MBA tuition and salary PV of normal salary MBA Tuition MBA salary 17 0 18 1 19 N 20 3 21 4 22 5 23 6 24 7 25 Age (at birthday) 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 8 26 9 10 27 28 11 29 12 13 30 31 32 33 14 15 16 17 18 34 35 48 36 49 19
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
