can you please answer this question accordingly like question 1, 2 and so on

which question need the excel and which question need only the answer i didnt get it.

thankyou

BSION BEX e 2021 TAS Term TPING X TFIN603 Corporate Fina X THIN603 Worleshop 3F X TFIN603 W loads/TFIN603%20Corporate%20Finance Individual%20Assignment_T1.%202021%2003).pdf M Gmail Saba Settings - Site Setti. Saba Assignments Saba Saba Saba Sabo Assignment_T1, 2021 (3).pdf 2/5 100% + Assignment Sundar Pichai 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 this goal. After examining schools, he has narrowed his choice to cither 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 students to work while enrolled in its MBA program Sundar currently works at the money management firm of Dewey and Louis. His annual salary at the firm is $53,000 per year, and his salary is expected to increase at 3 percent per year until retirement. He is currently 28 years old and expects to work for 38 more years. His current job includes a fully paid health insurance plan, and his current average tax rate is 26 percent. Sundar 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 $58,000, payable at the beginning of each school year. Books and other supplies are estimated to cost $2,000 per year Sundar expects that after graduation from Wilton, he will receive a job offer for about $87,000 per year, with a $10,000 signing bonus. The salary at this job will increase at 4 percent per year. Because of the higher salary, his average income tax rate will increase to 31 percent The Bradley School of Business at Mount Perry College began its MBA program 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 $4,200 Sundar think that he will receive an offer of $78,000 per year upon graduation, with an $8,000 signing bonus. The salary at this job will increasca 3.5 percent per year. His average tax rate at this level of income will be 29 percent O hp nce_Individual Assignment_T1.2021 (3).pdf 2 / 5 100% + year. Because of the higher salary, his average income tax rate will increase to 31 percent. The Bradley School of Business at Mount Perry College began its MBA program 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 $4,200. Sundar thinks that he will receive an offer of $78,000 per year upon graduation, with an $8,000 signing bonus. The salary at this job will increase at 3.5 percent per year. His average tax rate at this level of income will be 29 percent Both schools offer a health insurance plan that will cost $3,000 per year, payable at the beginning of the year. Sundar has also found that both schools offer graduate housing. His room and board expenses will decrease by $4,000 per year at either school he attends. The appropriate discount rate is 5.5 percent Questions (Rubrics are in brackets): 1. What other, perlaps nongwantifiable, factors affect Sundar's decision to get an MBA? [20 marks) 2. Assuming all salaries are paid at the end of each year, what is the best option for Sundar from a strictly financial standpoint [30 marks] 3. Sundar believes that the appropriate analysis is to calculate the future rule of each option. How wowild you ervaluate this statement [10 marks) 4. What initial salary would Standar need to receive to make him indifferent between attending Willow University and staying in his current position [20 marks) 5. Suppose, instead of being alive to pay car for Wis MBA, Sundar mast hormow the money. The current borrowing nale is 5.4 penent. How would this affect his decision [20 marks] [Total Marks 100 marks BSION BEX e 2021 TAS Term TPING X TFIN603 Corporate Fina X THIN603 Worleshop 3F X TFIN603 W loads/TFIN603%20Corporate%20Finance Individual%20Assignment_T1.%202021%2003).pdf M Gmail Saba Settings - Site Setti. Saba Assignments Saba Saba Saba Sabo Assignment_T1, 2021 (3).pdf 2/5 100% + Assignment Sundar Pichai 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 this goal. After examining schools, he has narrowed his choice to cither 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 students to work while enrolled in its MBA program Sundar currently works at the money management firm of Dewey and Louis. His annual salary at the firm is $53,000 per year, and his salary is expected to increase at 3 percent per year until retirement. He is currently 28 years old and expects to work for 38 more years. His current job includes a fully paid health insurance plan, and his current average tax rate is 26 percent. Sundar 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 $58,000, payable at the beginning of each school year. Books and other supplies are estimated to cost $2,000 per year Sundar expects that after graduation from Wilton, he will receive a job offer for about $87,000 per year, with a $10,000 signing bonus. The salary at this job will increase at 4 percent per year. Because of the higher salary, his average income tax rate will increase to 31 percent The Bradley School of Business at Mount Perry College began its MBA program 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 $4,200 Sundar think that he will receive an offer of $78,000 per year upon graduation, with an $8,000 signing bonus. The salary at this job will increasca 3.5 percent per year. His average tax rate at this level of income will be 29 percent O hp nce_Individual Assignment_T1.2021 (3).pdf 2 / 5 100% + year. Because of the higher salary, his average income tax rate will increase to 31 percent. The Bradley School of Business at Mount Perry College began its MBA program 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 $4,200. Sundar thinks that he will receive an offer of $78,000 per year upon graduation, with an $8,000 signing bonus. The salary at this job will increase at 3.5 percent per year. His average tax rate at this level of income will be 29 percent Both schools offer a health insurance plan that will cost $3,000 per year, payable at the beginning of the year. Sundar has also found that both schools offer graduate housing. His room and board expenses will decrease by $4,000 per year at either school he attends. The appropriate discount rate is 5.5 percent Questions (Rubrics are in brackets): 1. What other, perlaps nongwantifiable, factors affect Sundar's decision to get an MBA? [20 marks) 2. Assuming all salaries are paid at the end of each year, what is the best option for Sundar from a strictly financial standpoint [30 marks] 3. Sundar believes that the appropriate analysis is to calculate the future rule of each option. How wowild you ervaluate this statement [10 marks) 4. What initial salary would Standar need to receive to make him indifferent between attending Willow University and staying in his current position [20 marks) 5. Suppose, instead of being alive to pay car for Wis MBA, Sundar mast hormow the money. The current borrowing nale is 5.4 penent. How would this affect his decision [20 marks] [Total Marks 100 marks