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 Please help with the excel formulas for PV of normal salary and

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!