Question: So I've been asked to recreate this using JavaScript. I wrote some javaScript but I somehow deleted the whole file. Please HELP!!! Redo amortization table

So I've been asked to recreate this using JavaScript. I wrote some javaScript but I somehow deleted the whole file. Please HELP!!!

Redo amortization table using JavaScript. The amount to interest column is calculated by multiplying the previous months remaining balance (initially equals to the loan) by the monthly rate (annual rate/12). The amount to principal is calculated by subtracting the amount to interest from the monthly payment. The remaining balance is calculated by subtracting the amount to principal from the previous months remaining balance. Also, you dont need the Reset and Exit buttons.

Requirement: Alternating rows with two colors of your choice.

Part 2: Vehicle Loan Amortization

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.Do not need reset button or Exit button. 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!