Can someone please help me out with the following questions below? I would like to be able to do them with ease on Excel, so if you could help with the formulas and a layout where I would just plug numbers in that would be much appreciated. Thank you so much in advance.

1. Please calculate the effective yield for 10% rate where compounding periods are 1, 2, 4, 12 times per year. 2. Please calculate the nominal rate of 9.5% EY where compounding periods are 1,2,4,12 times per year. 3. What rate would we need on a mortgage to be equivalent on an effective yield basis with a bond that has a 7.5% interest rate? Please calculate the monthly mortgage payment using CPM of the following mortgages in questions 4-6: 4. 100,000 loan amount, 7% rate 30 year amortization 5. 250,000 loan amount 6.25% rate 25 year amortization 6. 300,000 loan amount 5.10% rate 20 year amortization 1. Please calculate the effective yield for 10% rate where compounding periods are 1, 2, 4, 12 times per year. 2. Please calculate the nominal rate of 9.5% EY where compounding periods are 1,2,4,12 times per year. 3. What rate would we need on a mortgage to be equivalent on an effective yield basis with a bond that has a 7.5% interest rate? Please calculate the monthly mortgage payment using CPM of the following mortgages in questions 4-6: 4. 100,000 loan amount, 7% rate 30 year amortization 5. 250,000 loan amount 6.25% rate 25 year amortization 6. 300,000 loan amount 5.10% rate 20 year amortization