Get instant live expert help on How do I calculate interest rate in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Calculate, in cell D20, the interest amount for period 1 by multiplying the balance in period 0 (cell F19) by the loan interest rate (cell C13) divided by 12. Dividing the interest rate by 12 results in the monthly interest rate. This formula is reusable. The interest for a given period is always the monthly interest rate times the balance from the previous period. [3 points]
Solved by X. W. in 16 mins
Calculate the periodic interest rate in cell E3. I am only aloud to use absolute references.
Solved by D. H. in 24 mins
I have a problem regarding to Calculate interest rate for loan
Solved by Z. E. in 22 mins
I need to use the VLOOKUP function to calculate interest rate
Solved by T. E. in 25 mins
hi, I need help with a formula to calculate interest btw 2 periods with an annual interest rate and semi-annual compounding?
Solved by K. J. in 23 mins