Can someone pls write the code for this program in VBA in excel for me

4) IAnumber of matchstickx(Note, The remainder when n is divided by 4 is (n Mod 4).1 After writing the program, play a few observe that the computer always wins games with the e omputer 6. Loan Calculator The most common types of loans are mortgage loans, which are f four com used to finance the purchase of a house, and car loans. A loan consists o nents-amount, interest rate, duration, and periodic payment. I programming project is to calculate the v values of the other three components he purpose of this alue of any one of the components given the he duration is in months, that interest (given as a percent) is y, and that payments are made monthly. Currently home mort We will assume thatt compo gages typically have an interest rate of about 4% and a duration of 30 years (360 months). Car loans typically have an interest rate of about 6% and duration of between 3 and 5 years (36 to 60 months). Four built-in Visual Basic financial functions that perform loan calculations are as follows: Pmt(interest rate / 1200, duration, -amount) gives the monthly payment 1200 * Rate(duration, monthly payment, -amount) gives the stated interest rate interest rate /1200, duration, -monthly payment) gives the amount o NPer(interest rate /1200, monthly payment, -amount) gives the duration of the loan in months Write a program in which the user specifies a value to calculate, enters the three calcula- radio other values, and clicks on the Calculate Value button. See Fig. 5.16. Before any tions are made, the program should use a Function procedure to validate that a button is selected and that the values entered into the three text boxes corresponding to unselected radio buttons are valid. Annuity Check Value to Calculate