Here are some problems that our users have asked and received explanations on
I don't know how to calculate loan interest, please help me with this question: 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
hi, I need help with how to calculate interest btw 2 periods with an annual interest rate and semi-annual compounding?
Solved by K. J. in 23 mins
Can you get me the formula to calculate the interest as 0.08219178082 rate for 1,000,000 ?
Solved by T. C. in 12 mins
I need a formula that will allow me to compute annual payments due on a loan with accrued interest with variables; interest rate, number of years, initial principle amounts.
Solved by X. D. in 27 mins
Wanted: Excel formula to calculate number of months my savings will last given the following:
2.25 apy interest rate, $230,000 beginning nest egg, $862 monthly withdrawal, 3.5% annual inflation of withdrawal.