For all the problems here you need to create a text file fro
For all the problems here, you need to create a text file from your script with the following format: State the problem number. Headers. Corresponding data. The output should be a table with each column of data under its own header. Also append ail the problems in one text file. An example of your final file is shown below: The monthly payment M of a loan amount P for .y years and with interest rate r can be calculated by the formula: Calculate the monthly payment and the total payment for a 100.000 loan for 10, 11, 12, 29, 30 years with an interest rate of 4.85%. Display the results in a three-column table where the first column is the number of years. the second is the monthly payment. and the third is the total payment.
Solution
Calculate the monthly payment and total payment for a 100,000 loan for 10,11,…,30 years with an interest rate 4.85%.display the result in athree column table where the first column is the number of years the second column is the monthly payment and third column is total payment
| principle amount | the no of years | rate of interest | mothly payment | Total payment |
| 100,000 | 10 | 0.0485 | 1053.338 | 1053.338 |
| 100,000 | 11 | 0.0485 | 979.0372 | 2032.376 |
| 100,000 | 12 | 0.0485 | 917.3837 | 2949.759 |
| 100,000 | 13 | 0.0485 | 865.4578 | 3815.217 |
| 100,000 | 14 | 0.0485 | 821.1737 | 4636.391 |
| 100,000 | 15 | 0.0485 | 783.0019 | 5419.393 |
| 100,000 | 16 | 0.0485 | 749.7949 | 6169.187 |
| 100,000 | 17 | 0.0485 | 720.6752 | 6889.863 |
| 100,000 | 18 | 0.0485 | 694.9605 | 7584.823 |
| 100,000 | 19 | 0.0485 | 672.1116 | 8256.935 |
| 100,000 | 20 | 0.0485 | 651.6976 | 8908.632 |
| 100,000 | 21 | 0.0485 | 633.3693 | 9542.002 |
| 100,000 | 22 | 0.0485 | 616.8409 | 10158.84 |
| 100,000 | 23 | 0.0485 | 601.8765 | 10760.72 |
| 100,000 | 24 | 0.0485 | 588.2793 | 11349 |
| 100,000 | 25 | 0.0485 | 575.8841 | 11924.88 |
| 100,000 | 26 | 0.0485 | 564.5508 | 12489.43 |
| 100,000 | 27 | 0.0485 | 554.1604 | 13043.59 |
| 100,000 | 28 | 0.0485 | 544.6105 | 13588.2 |
| 100,000 | 29 | 0.0485 | 535.8131 | 14124.02 |
| 100,000 | 30 | 0.0485 | 527.6918 | 14651.71 |
