Here are some problems that our users have asked and received explanations on
Did I calculate the beginning balance correctly?
Here is the question I'm referring to.
In cell E2 calculate the present value of an auto loan that has a $450.00 payment. 5.25% interest rate, and a four year repayment period. could you explain how to do this? Also we use pmt function and absolute references instead of mixed.
Solved by A. H. in 19 mins
set up the necessary formula for calculating the interest rate surcharge for each applicant given below. The rules for calculating the surcharge as follows:
a) there is no (zero) surchage if the applicant's credit score is 720 or greater)
b) the surcharge is 0.125 if the credit score is less than 720 and the loan amount is less than or equal to 25% of the annual income
C) the surcharge is 0.150 if the credit score is less than 720 and the loan amount is greater than 25% of the annual income
Solved by B. J. in 18 mins
I am trying to forecast sales for a car dealership based off of historical data. I also have to take into account interest rates and predicted interest rates. I am not excel save and every time I use the forecast command I get null values back. I just don't know how to make them work and need some help.
Solved by T. B. in 11 mins
I have a problem regarding to Calculate interest rate for loan
Solved by Z. E. in 22 mins
enter a formula in cell c9 using the PMT function excel to calulate the monthly payment on a loan using the assumptions list in the status Quo scenario in the pmt formula use c6 as the monthly interest rate c8 as the num of payments and c4 as the loan amount enter the formula in cell c9
Solved by B. E. 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
22. Narlen wishes to compare the use of the money for this project to simply investing the money at the prevailing interest rates. They want to know what interest rate would be required that would provide a better return on the money by investing versus doing this project. Enter the values 1% through 15% in D23:R23 to represent possible interest rates. Calculate Net Present Value in D24:R24 using the NPV function for each of those rates for Years 1-15 plus Project End, adding the initial Startup profit value in C21 to the result of the NPV in each cell.
Solved by V. S. in 11 mins
22. Narlen wishes to compare the use of the money for this project to simply investing the money at the prevailing interest rates. They want to know what interest rate would be required that would provide a better return on the money by investing versus doing this project. Enter the values 1% through 15% in D23:R23 to represent possible interest rates. Calculate Net Present Value in D24:R24 using the NPV function for each of those rates for Years 1-15 plus Project End, adding the initial Startup profit value in C21 to the result of the NPV in each cell.
Solved by K. F. in 17 mins
I am trying to calculate the time needed to accumulate $500K in a 401K account using a fixed interest rate and a fixed investment per month. I can't get the NPER excel formula to work. I need some help. Please.
Solved by Z. J. in 28 mins
In cell B5, insert the PMT formula in excel using the data from the range B2:B4—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number