Please show work for functions and macros thanks

NOTE: For BOTH problems 1 and 2 you may use the PMT function inside VBA, you will need to refer to it as Excel.WorksheetFunction.Pmt(... 1 Create a function that computes the Payment. This function will only work for loan A and B. The function call should look like this: NOTE: The function can ONLY reference values in the yellow input box =MyPmt(Rate1,Years,HouseValue,PctDown,PctPoints) a. Bank A offers you 5.00% (APR w/ Monthly Payments) plus 2.00% points with 20% down for 30 years. b. Bank B offers you 5.38\% (APR w/ Monthly Payments) plus 0.50% points with 25% down for 25 years. 2 Create at least 2 Macros that compute the Payment. The macro will only work for ordinary bank loans like A and B. a. Make the first Macro refer directly to the cells in green below. b. Make the second Macro have input boxes for each input. c. Make a third Macro that is fancy. It has nice captions, and allows input of percent as well as decimals. (Optional, but recommended) Make a third Macro that is fancy. It has nice captions, and allows input of percent as well as decimals. (Optional, but recommended) NOTE: For BOTH problems 1 and 2 you may use the PMT function inside VBA, you will need to refer to it as Excel.WorksheetFunction.Pmt(... 1 Create a function that computes the Payment. This function will only work for loan A and B. The function call should look like this: NOTE: The function can ONLY reference values in the yellow input box =MyPmt(Rate1,Years,HouseValue,PctDown,PctPoints) a. Bank A offers you 5.00% (APR w/ Monthly Payments) plus 2.00% points with 20% down for 30 years. b. Bank B offers you 5.38\% (APR w/ Monthly Payments) plus 0.50% points with 25% down for 25 years. 2 Create at least 2 Macros that compute the Payment. The macro will only work for ordinary bank loans like A and B. a. Make the first Macro refer directly to the cells in green below. b. Make the second Macro have input boxes for each input. c. Make a third Macro that is fancy. It has nice captions, and allows input of percent as well as decimals. (Optional, but recommended) Make a third Macro that is fancy. It has nice captions, and allows input of percent as well as decimals. (Optional, but recommended)