Chapter 4 Spreadsheet on the problem (C04)Amortization table2. The chart shows the total payment, pay to the interests of capital and the payment of the loan for 20 years, is displayed when you click on the tab called CHART at the bottom of the spreadsheet. To return to the worksheet, click the tab called C04 at the bottom of the sheet graphic work.3. Start by organizing the worksheet by placing the line 21 at the top of the screen. This will allow you to simultaneously view the input data and amortization. Then place the cursor in a cell in the input data, enter new data and observe changes in the amortization table. Also, work the problem to a term of 20 years and interest rates of 3 and 25%, see chart and note the difference in the amount of payments and interest between the fertilizer and capital.4. F25..F44 cells contain the present value of each annual payment discounted at the appropriate interest rate. By changing the interest rate, you can see what happens to each discounted payment. The sum of this range is equal to the original loan amount.DATA ENTRY: KEY FINDINGS:Loan amount 20,000 I pay 2,037.04Interest rate 8.00%Number of years twentyData generated by the model:Amortization table:crediting crediting Balance PV ofYear I pay interests capital payments1 2,037.04 1,600.00 437.04 19562.96 1,886.152 2,037.04 1,565.04 472.01 19090.95 1,746.443 2,037.04 1,527.28 509.77 18581.18 1,617.074 2,037.04 1,486.49 550.55 18030.63 1,497.295 2,037.04 1,442.45 594.59 17436.04 1,386.386 2,037.04 1,394.88 642.16 16793.87 1,283.687 2,037.04 1,343.51 693.53 16100.34 1,188.608 2,037.04 1,288.03 749.02 15351.32 1,100.559 2,037.04 1,228.11 808.94 14542.39 1,019.0310 2,037.04 1,163.39 873.65 13668.73 943.55eleven 2,037.04 1,093.50 943.55 12725.19 873.6512 2,037.04 1,018.01 1,019.03 11706.16 808.9413 2,037.04 936.49 1,100.55 10605.61 749.0214 2,037.04 848.45 1,188.60 9,417.01 693.53fifteen 2,037.04 753.36 1,283.68 8,133.33 642.1616 2,037.04 650.67 1,386.38 6,746.95 594.5917 2,037.04 539.76 1,497.29 5,249.66 550.5518 2,037.04 419.97 1,617.07 3,632.59 509.7719 2,037.04 290.61 1,746.44 1,886.15 472.01twenty 2,037.04 150.89 1,886.15 0.00 437.0440740.88 20740.88 20,000.00 20,000.00We have previously entered data in this file to the base caseeach model, and these are designed for the analysis of preceding partsof the problem. You should only enter the details of each of the partiesthe remaining problem-we point out in each problem, the partiesto be performed using the spreadsheet. However, there are severalthings to consider before entering the model:1. The input data are entered in specific cells in the sectionDATA ENTRY. When an input is changed, the modelDATA ENTRY. When an input is changed, the modelDATA ENTRY. When an input is changed, the modelDATA ENTRY. When an input is changed, the model2. The key results are displayed on the right sectionDATA ENTRY or immediately below it. This distribution allows youmodify an input and immediately see how the change affects the resultsmodel. This is quite useful in a sensitivity analysis.3. The input data that can be modified differ from those who should notmodify. The data that can be changed are highlighted in color (blue) toUnlike other data are black.4. All percentages must be entered as decimal. Monetary unitsand other numbers should be entered without signs of pesos or dollars without commas.5. For each model instructions and comments are includedspecific. Graphic associated with each model are included inanother worksheet to which could be accessed by clicking on the tabGRAPHICS call and located at the bottom of the spreadsheet.FINC-Chapter 4Problem related to the worksheet: the value of money over timeUsing the computer model in C04.xlsx file spreadsheet to solve this problem.a. Establish a repayment plan for a loan of $ 30,000 to be paid in equal installments at the end of each of the next 20 years at an interest rate of 10 percent. What is the annual payment?b. Establish a plan for repayment of a loan of $ 60,000 to be paid in 20 equal annual installments at an interest rate of 10 percent. What is the annual payment?c. Establish a plan for repayment of a loan of $ 60,000 to be paid in 20 equal annual installments at an interest rate of 20 percent. What is the annual payment?