Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer must use solver on excel Michelle is a business student who plans to attend medical school. The average state university medical school education expense

Answer must use solver on excel

Michelle is a business student who plans to attend medical school. The average state university medical school education expense can cost around $ 35,000 per year and is escalating rapidly. Michelle created a spreadsheet model to calculate the total expenses for each year of medical school, including both education and living expenses. Her estimates are Year 1: $ 57,067, Year 2: $ 56,572, Year 3: $ 67,846, and Year 4: $ 55,662. She is considering three loan options: the Stafford loan, a 6.8% loan with a cap of $ 47,167 that does not accrue interest during medical school; the Graduate Plus loan, a 7.9% loan with no cap that does accrue interest during medical school; and a private bank loan, a 5.9% loan with a cap of $ 30,000, also with accruing interest during medical school. Assume that each loan will be paid over 25 years after graduation. Michelle currently has $ 39,500 saved from investments, family gifts, and work, and will receive an additional $ 4,500 in gifts from her grandparents in years 2 through 4. Develop and solve an optimization model to determine how much money to fund from each type of loan to minimize the amount of interest that will have to be paid on the loans.+(Use the Excel function CUMIPMT to find the total interest that will be paid over the life of a loan. For example, if a 30 year loan for $ 100,000 has an interest rate of 9%, then the formula = CUMIPMT( 9%, 30, 100,000, 1, 30, 0) will yield $ 192,009 cumulative interest paid between years 1 and 30.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Remittances And International Development

Authors: Sabith Khan, Daisha Merritt

1st Edition

0367521881, 978-0367521882

More Books

Students also viewed these Finance questions

Question

d. Who are important leaders and heroes of the group?

Answered: 1 week ago