Question: Please help with the excel formulas for PV of normal salary and PV of MBA tuition and Salary. I only need those two formulas also
Please help with the excel formulas for PV of normal salary and PV of MBA tuition and Salary. I only need those two formulas also only need the first 4 years! TIA 
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 3% per year (without earning an MBA). MBAs typically earn $80,000 per year upon graduation, with salaries growing by 4% 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? Current salary MBA Starting Salary MBA Tuition 50,000 Growth Rate: 80,000 Growth Rate: 30,000 Discount rate: 3.00% 4.00% 8.00% PV of MBA tuition and salary PV of normal salary Normal Salary MBA Tuition MBA salary Age (at birthday) 30 31 Year 0 1 2 30,000.00 30,000.00 32 w N 33 34 35 4 5 51,500.00 53,045.00 54,636.35 56,275.44 57,963.70 59,702.61 61,493.69 63,338.50 65,238.66 67.195.82 50,000.00 101,500.00 154,545.00 209,181.35 265,456.79 323,420.49 383,123.11 444,616.80 507,955.31 573.193.97 0.00 0.00 80,000.00 83,200.00 86,528.00 89,989.12 93,588.68 97,332.23 101,225.52 105.274.54 36 6 37 7 38 8 39 9 40 10
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
