Joe starts a savings account with $ 500,000 in a bank that pays him an interest rate of 2% per month. Every end of the month he deposits $ 200,000, for 12 months. If at the end of month 6 he makes an extra deposit of $ 2,000,000, calculate the accumulated value at the end of the year

Mary wants to acquire an apartment that in 10 years will cost the sum of $ 120,000,000. For this reason today he cancels an initial installment of $ 5,000,000 and each month cancels equal monthly installments. The interest rate charged is 24% per annum, compounded monthly. What is the required monthly fee?

Solve with excel and show formulae