Here is a practice assingment that is giving me issues. Please use EXCEL to calculate the problem and show me the work. Later this week is the real assignment with different questions. But I would like to know how to do it myself. Thank you for everything! PLEASE ANSWER IN EXCEL and just screenshot it. So I can reference back to it later. Thanks again!

Using Figure 1 and Figure 2 as the initial data, and the Worksheet Answer as the place you enter your solutions of the following question a, b, and c. Use Excel functions for your work, such as PMT, WahtlE(), and Goal). Work on the Excel file to answer the followinq questions: a. Figure 1 shows a loan amount $150,000 with interest 8% and 30 years term, the monthly payment is 1,100.65, which is calculated by PMTO function. How much more you have to pay if the interest rate changes from 8% to 10%? Show your work for both interest rate 8 and 10 at the worksheet Figure 1. Specify the change of Monthly payment at your answer worksheet for this question. h(1) For the original 8% model in Figure 1, what interest rate is required to decrease the monthly payments by 20 percent? b. (2) What change in the loan amount would have the same effect? C. (1) In the Worksheet Figure 2, what is the effect of a prepayment of $200 per month for the loan (here is not asking you how much the monthly payment)? C. (2) What prepayment would be necessary to pay off the loan in 25 years instead of 30 years? Using Figure 1 and Figure 2 as the initial data, and the Worksheet Answer as the place you enter your solutions of the following question a, b, and c. Use Excel functions for your work, such as PMT, WahtlE(), and Goal). Work on the Excel file to answer the followinq questions: a. Figure 1 shows a loan amount $150,000 with interest 8% and 30 years term, the monthly payment is 1,100.65, which is calculated by PMTO function. How much more you have to pay if the interest rate changes from 8% to 10%? Show your work for both interest rate 8 and 10 at the worksheet Figure 1. Specify the change of Monthly payment at your answer worksheet for this question. h(1) For the original 8% model in Figure 1, what interest rate is required to decrease the monthly payments by 20 percent? b. (2) What change in the loan amount would have the same effect? C. (1) In the Worksheet Figure 2, what is the effect of a prepayment of $200 per month for the loan (here is not asking you how much the monthly payment)? C. (2) What prepayment would be necessary to pay off the loan in 25 years instead of 30 years