Visual Basic:

Summary: In this assignment you create a program to compute a loan payments:

1. Monthly payment

2. How much of is used for interest after each monthly payment

3. How much of is used for principal after each monthly payment

4. The balance of the loan after each monthly payment

5. Display the month number and all of the above items as a line in a list box for each month.

All computations are done on monthly basis.

Input data:

Loan: The amount of the loan;

Period: Number of years the loan to be paid back. It is entered in years, you need to multiply by 12 to get number of months;

Annual Interest Rate: Entered in percentage, you need to divide it by 12 for monthly interest, and then divide by 100 to use in computations. VB does not use percentage.

Instructions:

Create a new project and name it as yourlastname-firstname-Assignment3. Save this project in VB folder you created earlier.

Change forms title to: Your full name Loan Assignment 3.

Form contains four Labels, three TextBoxes, one ListBox, and three Button controls.

Use labels to identify loan components (three TextBoxes) and results (ListBox). ListBox displays the Month, Monthly Payment, Principal, Interest and Loan Balance for each month. Buttons are to Calculate, Clear Input and Exit program. See below Form Layout with Controls for more details. Note: The control Names are shown in callouts.

You will declare two set of variables:

- Input variables:

Loan Amount (Double)

Period (Integer)

Interest (Double)

- Output variables:

Count (Integer, to be used for For Loop to keep track of Loan period)

Months (Integer, to calculate Loan number of months

Payment (Double, for monthly payment)

ToInterest (Double, how much of the monthly payment to Interest)

ToPrincipal (Double, how much of the monthly payment to Principal)

Balance (Double, displays loan's balance on monthly basis)

Output (String, to display Month, Monthly payment, ToPrincipal, ToInterest and Balance in the ListBox.

To convert Interest Rate to monthly interest rate, do the following: 1. divide by 100; 2. divide by 12.

To calculate Number of Years into months, do the following: multiply by 12.

To calculate Monthly payment, use PMT function: PMT(interest rate, months, -loan amount). Pay attention to minus symbol in front of loan amount.

Create a For ... Next loop to calculate the values you need for ListBox

For loop starts with: For Counter = 1 to months

To calculate ToInterest, do the following: Balance * Interest

To calculate ToPrincipal, do the following: Payment - ToInterest

To calculate Balance, do the following: Balance - ToPrincipal

Build the string for displaying Output in ListBox. See my comments in Discussion.

Items to note:

Label control that displays: Month, Payment, ToInterest, ToPrincipal and Loan is one control. Use spaces to type in its Text property.

variables names must follow the conventions and rules explained earlier and must have proper data type for the values that will be stored in them.

Appearance of the form is very important; Make sure that your design is clean; Spelling is important.

Text property of controls must use the text shown in the image below.

Clear Input button, clears TextBoxes and ListBox.

Exit button, closes the Form.

You will write the code for the three buttons.

Avoid double-clicking on TextBox and Label Controls to create unnecessary code. If you do delete them.

Run the program, enter values for Loan, Period and Interest rate, then click Calculate button, to see the Monthly information display in the ListBox.

See example for the ListBox entry below.

Please include a For Next Loop and include the following variables in the instructions. If you follow the instructions, I will give you a good rating.

Yourname-Loan-Assignment 3 Amount of Loan txtLoan Labels Number of Years txtPeriod Annual Interest Rate txtlnterestRate Month Payment To Interest To Principal Balance ListBox IstOutput Calculate Clear input Exit Buttons: Name them according to their text property. i.e., btnClearlnput Yourname - Loan - Assignment 3 Amount of Loan Number of Years Annual Interest Rate 7.75 Month Payment Interest T0 Principal Balance 3 0001 S3,223.86 $2,906.25 $317.61 $449,682.39 0002 $3,223.86 $2,904.20 $319.66 $449,362.74 0003 S3,223.86 $2,902.13 $321.72 $449,041.02 0004 $3,223.86 $2,900.06 $323.80 $448,717.22 0005 S3,223.86 $2,897.97 $325.89 $448,391.33 0006 $3,223.86 $2,895.86 $327.99 S448,063.34 0007 $3,223.86 $2,893.74 $330.11 $447,733.22 0008 $3,223.86 $2,891.61 $332.24 $447,400.98 0009 S3,223.86 $2,889.46 $334.39 $447,066.59 0010 $3,223.86 $2,887.31 $336.55 S446,730.04 0011 $3,223.86 $2,885.13 $338.72 $446,391.31 V Calculate Clear input