Here are some problems that our users have asked and received explanations on
i want to caliculate through excel
monthly want to add some princiapl amt
there will be some interest rate.
some times deletions are there
want toal amt after certain no of months
Solved by Z. E. in 24 mins
I need a formula that will compute annual payments due of principle and interest accrued with variable numbers of years, interest rates and initial principle amounts.
Solved by G. H. in 11 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
I have the per day value to calculate automatically. if the interest rate is 60 percent per year how to get the same result ?
Solved by A. B. in 21 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.
Solved by D. D. in 26 mins
I have a worksheet that needs to calculate a daily interest rate by looking at another tab that has all of the interest rates by dates.
See example attached worksheet.
Solved by I. B. in 11 mins
I need a formula to calculate a value times a variable interest rate 5 years into the future. Can you help?
Solved by O. A. in 15 mins
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
how do i calculate the interest rate so that it is a positive number. Here is the question "Insert the PMT formula in J7 to calculate the first client's monthly payment; use appropriate relative and absolute references in your formula, do not use actual numbers. show the result as a positive number.
Solved by K. L. in 26 mins
Calculate the periodic interest rate in cell E3. I am only aloud to use absolute references.