“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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.

Solved by E. A. in 28 mins