Question: I need this for C# for Visual Studio. You can only do the PMT, IMPT, and PPMT by adding using Microsoft.VisualBasic; to the program. The

I need this for C# for Visual Studio. You can only do the PMT, IMPT, and PPMT by adding "using Microsoft.VisualBasic; to the program.

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. 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 tables rows with any two colors of your choice.

Vehicle Loan infomation Cost of vehicle 25000 Amount of down payment 5000 Number of months 12 Interest and principal payments Payment# Payment S1,729.61 $1.729,61 $1.729.61 4 $1.729,61 S1,729.61 S1,729.61 New or Used New Used Annual Interest rate Amount to Amount to Principal Interest $1.614.61 $115.00 $105.72 $1.623,90 $96.38 $1.633.23 $1.642.63 $86.99 $1.652.07 $77.54 $1.661.57 $68.04 a 21 R7112 Remaining $18,385.39 $16.76149 $15.128.26 $13,485.63 $11.833.56 $10.171.99 Vehicle Loan infomation Cost of vehicle 25000 Amount of down payment 5000 Number of months 12 Interest and principal payments Payment# Payment S1,729.61 $1.729,61 $1.729.61 4 $1.729,61 S1,729.61 S1,729.61 New or Used New Used Annual Interest rate Amount to Amount to Principal Interest $1.614.61 $115.00 $105.72 $1.623,90 $96.38 $1.633.23 $1.642.63 $86.99 $1.652.07 $77.54 $1.661.57 $68.04 a 21 R7112 Remaining $18,385.39 $16.76149 $15.128.26 $13,485.63 $11.833.56 $10.171.99

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!