Reference no: EM132178411
This is for Visual Studio:
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 period's data entered as a row of the DataGridView.
You may use VB's financial functions PMT, IPMT and PPMT to compute the payment, interest payment and principal payment. These functions are identical as Excel's functions. Compute and display the total interest payment in a textbox at the bottom of the interest column.
The Calculate button create the table; the Reset button clear all controls and the Exit button close the form (this.Close()). 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
|
|
Total Interest
|
$755.36
|
|
|
Requirement: Alternating the color of the table's rows with any two colors of your choice.