6/1/2023 0 Comments Variable tools 2There are so many scenarios for multiple months and respective re-pay the amount as EMI.Īs we can see in the data table for each Interest rate and loan amount as a result. The same amount if a person wants to pay for the next 30 months, then ₹ -38,665.60 Need to pay as EMI. If a user wants to take ₹ 2,000,000.00 loans, then he needs to pay ₹ -105,332.90 for the next 20 Months as EMI. Step 8: Result will be published per month loan re-payment amount as per the combination of each month and loan amount data set.Īs we can see in the data table for each month and Loan amount. of months for Payment in Column input cell > click OK button. Step 7: Data Table pop up will appear with two input cells for the row, and column >Select Loan amount in the Row input cell and no. Step 6: Go to Data tab > click on the What-if Analysis drop-down list toolbar > select Data Table. ![]() Step 5: Now select all dataset from F5 to F16 and F5 to M5 Step 4: Select cell F5 and the assigned value of the cell C5, click Enter. Step 3: Enter all desired loan amount in the 5 th row of a sheet. Step 2: Enter all user desired months in column F Step 1: Write down the desired months input in column E and Loan amount in row 4
0 Comments
Leave a Reply. |