Ben Bates 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 Wilton University or Mount Perry 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 student to work while enrolled in its MBA program.

Ben currently works at the money management firm of Dewey and Louis. His annual salary at the firm is $70,000 per year, and his salary is expected to increase at 3 percent per year until retirement. He is currently 26 years old and expects to work for 39 more years. His current job includes a fully paid health insurance plan, and his current average tax rate is 26 percent. Ben has a savings account with enough money to cover the entire cost of his MBA program.

The Ritter College of Business at Wilton University is one of the top MBA programs in the country. The MBA degree requires two years of full-time enrollment at the university. The annual tuition is $65,000, payable at the beginning of each school year. Books and other supplies are estimated to cost $2,000 per year. Ben expected that after graduation from Wilton, he will receive a job offer for about $100,000 per year, with a $10,000 signing bonus. The salary at this job will increase at 4% per year. Because of the higher salary, his average income tax rate will increase to 30 percent.

The Bradley School of Business at Mount Perry College began its MBA 16 years ago. The Bradley School is smaller and less well known than the Ritter College. Bradley offers an accelerated, one year program, with a tuition cost of $75,000 to be paid upon matriculation. Books and other supplies for the program are expected to cost $3,000. Ben thinks that he will receive an offer of $85,000 per year upon graduation, with a $10,000 signing bonus. The salary at this job will increase at 3.5 percent. His average tax rate at this level of income will be 28 percent.

Both schools offer a health insurance plan that will cost $2,500 per year, payable at the beginning of the year. Ben also estimates that room and board expenses will cost $15,000 per year at either school. The appropriate discount rate is 5 percent.

a. Assuming all salaries are paid at the end of each year and costs with tuition and fees occur in the beginning of each year, represent in excel the annual CFs from 0 until retirement for each of the three options: 1. Ben keeps his current job; 2. Ben attends the MBA at Wilton University; 3. Ben attends the MBA at Mount Perry College.

It should be on excel spreadsheet. please show me the formulas