Here are some problems that our users have asked and received explanations on
How do I calculate the NPV and IRR of future MONTHLY cash flows using an annual rate? How do I convert to monthly rate?
Solved by M. J. in 22 mins
Input a formula to compute the monthly payment amount in cell B18. Use the =PMT function. Remember that the interest rate is an annual interest rate but the =PMT function will needs a monthly interest rate to compute a monthly payment. Also, be sure to calculate the total number of monthly payments in the =PMT function. The final number should be a positive number. You can achieve this by multiplying the =PMT function by -1
Solved by V. H. 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
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
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number.