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 1o Month and apply PMT formulas (=PMT (C3/12, C4, C2)) to calculate the EMI. 6%, Number of the month for EMI / Payment, i.e. Assume a Total loan amount, i.e.₹ 1,000,000.00, Interest Rate (Yearly), i.e. Pre-requisite: Write down a sample calculation. You can download this Two-Variable Data Table Excel Template here – Two-Variable Data Table Excel Template Two-Variable Data Table in Excel Example #1Ĭreate Two Variable data table for the different Loan Amount and months
0 kommentar(er)
