Get instant live expert help on How do I calculate apr in excel

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a problem with the month# desired entered in cell C1. Dates are in Cells C3-Z3 (i.e. Jan-2016 to Dec 2017). Product1 name is in cell B5. Product2 name is in cell B6. Data1 amounts are in C5 to Z5. Data2 amounts are in C6 to Z6. What formula would I need to add in cell AB5? Given the below specs: Col AB5 needs to calculate the rolling 12 months based on cell C1. So if C1=3 (i.e. Mar 2017), it should calculate amounts in F5 through Q5 (i.e. Apr 2016 through Mar 2017). If C1=4 (i.e. Apr 2017), it should dynamically calculate amounts in G5 through R5 (i.e. May 2016 through Apr 2017). Any help will be greatly appreciated. Thank you!
Solved by D. Y. in 21 mins
How do you enter this problem in excel? The answer is $250.00, I cannot get the answer PMT=P(APR/n)/1-(1+APR/n)-nY 25000*(0.12/12)/1-(1+0.12/12)-12*25
Solved by K. S. in 24 mins
calculate the loan amount, the number of payment periods, and the monthly interest rate: Info given: complex cost down payment # of pmts per year years apr 1st payment date
Solved by K. L. in 29 mins
Hey, I'm trying to calculate the loan amount and the monthly payment together of a set of data where I have the years, Purchase Price, Down Payment and the apr.
Solved by C. D. in 23 mins
Can you format cells to read Jan, Feb, Mar, Apr by just putting one date in?
Solved by I. J. in 24 mins