Need help writing correct formulas in excel. Should be getting answers provided in image below (question 3a, 3b, 3c).

Time for a new problem. You want to borrow $200,000 at 4% interest compounded monthly. If you can afford to make monthly payments of only $1200 /month, how many months (cell M14 on the sample output) will it take you to pay off the loan completely? How many years (cell N14 on the sample output)? Assume the same data as provided in question \#4. How much would you have to pay each month to pay off the loan in 10 years? Assume the same data as provided in question \#5 (borrow $200,000, interest is 4% compounded monthly, loan period is 10 years, payments are $2024.90/ month). a) How much interest in total will you pay for this loan over the full 10 years? b) How much of your very first monthly payment will go towards interest? c) How much interest will you pay in the first year of this loan? d) How much will you pay towards principal the first year of the loan? Numeric Answers to Exercises (you have to write the formulas to calculate the numbers) Time for a new problem. You want to borrow $200,000 at 4% interest compounded monthly. If you can afford to make monthly payments of only $1200 /month, how many months (cell M14 on the sample output) will it take you to pay off the loan completely? How many years (cell N14 on the sample output)? Assume the same data as provided in question \#4. How much would you have to pay each month to pay off the loan in 10 years? Assume the same data as provided in question \#5 (borrow $200,000, interest is 4% compounded monthly, loan period is 10 years, payments are $2024.90/ month). a) How much interest in total will you pay for this loan over the full 10 years? b) How much of your very first monthly payment will go towards interest? c) How much interest will you pay in the first year of this loan? d) How much will you pay towards principal the first year of the loan? Numeric Answers to Exercises (you have to write the formulas to calculate the numbers)