Create in Visual Basic:

The Central Mountain Credit Union finances new and used vehicles for its members. A credit union branch manager asks you to create a Vehicle Loan Amortization form that looks similar to the form below:

The credit union currently charges 6.9% annual interest rate for new vehicle loans and 8.5% annual interest rate for used vehicle loans. The annual interest rate is automatically entered after user select new or used vehicle. The credit union does not finance a vehicle for less than 6 months or more than 48 months. The loan amortization table is displayed using a DataGridView with each periods data entered as a row of the DataGridView. You may use VBs financial functions PMT, IPMT and PPMT to compute the payment, interest payment and principal payment. These functions are identical as Excels functions. The Calculate button create the table; the Clear button clear all controls and the Exit button close the form. Test your program with these data:

Cost of Vehicle= $25,000, Downpayment = $5,000, Number of Months = 12, and is a new car.

1	$1,729.61	$115.00	$1,614.61	$18,385.39
2	$1,729.61	$105.72	$1,623.90	$16,761.49
3	$1,729.61	$96.38	$1,633.23	$15,128.26
4	$1,729.61	$86.99	$1,642.63	$13,485.63
5	$1,729.61	$77.54	$1,652.07	$11,833.56
6	$1,729.61	$68.04	$1,661.57	$10,171.99
7	$1,729.61	$58.49	$1,671.12	$8,500.86
8	$1,729.61	$48.88	$1,680.73	$6,820.13
9	$1,729.61	$39.22	$1,690.40	$5,129.73
10	$1,729.61	$29.50	$1,700.12	$3,429.62
11	$1,729.61	$19.72	$1,709.89	$1,719.72
12	$1,729.61	$9.89	$1,719.72	$0.00

Requirement: Alternating the color of the tables rows with any two colors of your choice