Complete each part on excel with step by step solutions please .

34 1-Mr Kenneth borrowed 1 0,000 dollars at the beginning of last month. The monthly rate is 1%, and is charged at end of each month. Mr. Kenneth wishes to pay off his debt by paying $400dollars each month, starting the beginning of this month How long will it take in order to pay off the entire debt? 3 4.2 . "Ms. Melody decided to invest 800 dollars per month in her pension fund at the beginning of each month (6% annual rate), for thirty years, before her retirement. Ms. Melody also decided that, at time of retirement, she will not take out all of the accumulated money at once. Instead, she will take her money out in 240 equal monthly installments, beginning one month after the date of retirement (refer to Figure 3.4. 7 for the timing of payments.) How much will Ms. Melodybe receive each month after 0 3.4.3- In Section 3.4 (Figure 3.4.2) our goal has been to accumulate 1 ,000,000 dollars by changing your annual investment amount. An alternative way to accumulate l ,000,000 dollars is to change the number of years of investment. At a 10% fixed annual rate, and at an annual investment of 3,000 dollars, how many years will be needed to reach the goal? 3.4.4 "Suppose that you wish to receive 5,000 dollars, once a month, for 20 years after retirement You also plan to invest onoe a month into your pension fund for 35 years before retirement. Your investment will start 35 years before the date of retirement and will end one month before the date of retirement. The date of first payment to you will be one month after the date of retirement Assuming that a fixed annual rate of 6% before and after retirement is guaranteed by the yourpension company, what amount do you need to deposit each month? (Refer to Figure 3.4.7 for the timing of payments