L.C.8.1

lab exercise

 

payments

 

 

Background:

 

 

Borrowing money for expensive items has become a way of life for most Americans.  To illustrate the high cost of borrowing and how such loans work, you will write a program to calculate the following monthly analysis of a loan.

 

Month

Principal

Interest

Payment

New Balance

 

 

 

 

 

1

10000.00

100.00

300.00

9800.00

2

9800.00

98.00

300.00

9598.00

3

9598.00

95.98

300.00

9393.98

4

9393.98

93.94

300.00

9187.92

 

             and many months later ...

 

39

809.46

8.09

300.00

517.55

40

517.55

5.18

300.00

222.73

 

 

 

 

 

 

 

2222.73

total interest

 

 

 

The loan analysis above started with the following information:

 

Principal (amount borrowed) =                    10000.00

Annual interest rate =                                        12.0 %

Monthly payment =                                         300.00

 

The monthly interest rate is found by dividing the annual rate among 12 months.  For the above example the monthly rate is 1.0 %.  The last three values of each line are calculated as follows:

 

Interest = Principal * Monthly interest rate

Payment = amount set at beginning of problem

New Balance = Principal + Interest - Payment

 

The new balance becomes the starting principal amount for the next month.  As you can see, progress toward decreasing the principal is slow at the beginning of the loan.


 

Assignment:

 

Write a program to analyze a loan as described above using the five column format.  Your program must accomplish the following:

 

1.    Data input:  The program should ask for the appropriate starting information. 

 

2.    Printing of analysis:  The program must print the month-by-month analysis until the remaining principal is less than the monthly payment.  You must use a do-while loop to solve this problem.  At the bottom of the analysis you must print the total interest paid to the lending institution. 

 

 

Instructions:

 

 

1.    After completing your program, test it using the data given in the example.  Your answers should agree within a few cents.

 

2.    You are to analyze the following loan data:

 

       principal = 12000

       annual interest rate = 8.80

       monthly payment = 500.00

 

3.    Turn in your source code and run output.

 

 

Extending the Lab:

 

 

1.    We now reverse the idea.  Suppose we wish to study the effect of time and compounding interest on investments.  Revise the program to ask the user for:

 

       starting principal to invest

       annual rate of return (5%, 10%, etc)

       monthly addition to the principal

       number of months to iterate

 

2.    The printout will be similar except the column called "payment" will be changed to investment.  You should still calculate and print out the total interest and final balance.

 

3.    This lab exercise should encourage you to start investing early in life.