In excel if possible please

Develop an Excel solution to convert between interest rates of different periodicities. Use this tool to help find the accumulated value after 4 years of an initial investment of $10,000 if: a) i = 0.12 d) d = 0.08 b) i(4) = 0.12 e) 8 0.09 c) d(4) = 0.18 Question 2: 2 Marks a) John deposits $120,000 at time t = 0 into a savings account which earns an annual interest rate of 10% effective. He withdraws $18,000 at the end of each year. Calculate the account balance at the end of each year right after interest is paid and the withdrawal deducted until the money runs out. b) How much should John withdraw at the end of each year if he wants the money to last exactly 15 years. Develop an Excel solution to convert between interest rates of different periodicities. Use this tool to help find the accumulated value after 4 years of an initial investment of $10,000 if: a) i = 0.12 d) d = 0.08 b) i(4) = 0.12 e) 8 0.09 c) d(4) = 0.18 Question 2: 2 Marks a) John deposits $120,000 at time t = 0 into a savings account which earns an annual interest rate of 10% effective. He withdraws $18,000 at the end of each year. Calculate the account balance at the end of each year right after interest is paid and the withdrawal deducted until the money runs out. b) How much should John withdraw at the end of each year if he wants the money to last exactly 15 years