I need assistance in answering this question. I'd like to be able to calculate in Excel. David Jetter graduated from college six years ago with a...

I need assistance in answering this question. I'd like to be able to calculate in Excel. David Jetter graduated from college six years ago with a finance undergraduate degree. Although he is satisfied with his current job, his goal is to become an investment banker. He feels that an MBA degree would allow him to achieve his goal. After examining schools, he has narrowed his choice to either Prentice University or Mount Alliance College. Although internships are encouraged by both schools, to get class credit for the internship, no salary can be paid. Other than internships, neither school will allow its students to work while enrolled in its MBA program. David currently works at the money management firm of Dewey and Louis. His annual salary at the firm is $50,000 per year, and his salary expected to increase at 3 % per year until retirement. He is currently 28 years old and expects to work for 40 more years. His current job includes a fully paid health insurance plan, and his current average tax rate is 26 %. David has savings account with enough money to cover the entire cost of his MBA program. 3. Assuming all salaries are paid at the end of each year, what is the best option for David – from a strictly financial standpoint? Explain why in detail with calculations. 4. David believes that the appropriate analysis is to calculate the future value of each option. How would you evaluate this statement? So what is the future value of each option? 5. What initial salary would David need to receive to make him indifferent between attending Prentice University and staying in his current position? Explain in detail with calculations.

3. Assuming all salaries are paid at the end of each year, what is thebest option for David – from a strictly financial standpoint? Explainwhy in detail with calculations.Annual salary...