Excel & Sheets practice: Financial & Loan Math
Chapter 31 · 6 questions · included in full access
Question 1 · medium
Monthly EMI
Solve it in your browserCalculate the monthly EMI for the loan in B2 at the annual rate in B3 over the years in B4. Make it a positive number. Answer in G2.
Question 2 · medium
Total interest paid
Solve it in your browserHow much interest is paid over the whole loan? (All EMIs minus the amount borrowed.) Answer in G2.
Question 3 · hard
NPV of the machine
Solve it in your browserCalculate the net present value of the cash flows in E2:E7 (E2 is the year-0 purchase) at the discount rate in B5. Answer in G2.
Question 4 · easy
IRR of the machine
Solve it in your browserCalculate the internal rate of return of the cash flows in E2:E7. Answer in G2.
Question 5 · easy
Hitting a target
Solve it in your browserYou want the loan amount that makes the EMI exactly ₹45,000. Which tool finds it fastest?
Question 6 · medium
Two inputs at once
Solve it in your browserYou want a grid of EMIs for interest rates 7–10% (rows) and tenures 3–7 years (columns). Which Excel feature is built for this?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing