Simone is now 50 years old and plan to retire at age 67 (in 17 years). She currently has a share portfolio worth $750,000, a superannuation fund worth $1,200,000, and a money market (similar to cash) account worth $500,000. Her share portfolio is expected to provide annual returns of 12% p.a. (compounded annually), her superannuation will earn her 9% p.a. (compounded annually), and the money market account earns 1.2% p.a. (compounded monthly). Assume all these returns are aftertax. Assume Simones superannuation contribution is $25,000 (after-tax) per year for the next 17 years (starting 1 year from now).

d. Simone is looking to purchase a Mercedes Benz SL500, which has a total cost of $350,000. To maintain sufficient liquidity, Simone plans to withdraw $150,000 from her money market account and will pay the rest by taking on a 6.6% p.a. (compounded monthly) 5-year bank loan. If Simone decides to repay $6,000 per month, how long will she pay off the car loan?

Need complete formula and calculation process.