Get instant live Excel expert help to learn how to apply financial function in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. Format the Amount of Loan as Currency with 0 decimals. Format the Interest as Percentage with 2 decimals.
Amount of Loan $425,000
Period (months) 120
Interest rate (per year) 5.25%
Solved by M. C. in 13 mins
In the range B9:B16, enter varying interest rates in decrements of .5% beginning with 7.0% and ending with 3.5%. If necessary format all the interest rates with two decimal places, and then bold and center the range.
Solved by A. W. in 30 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
Create a Data Table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate.
Solved by D. Q. in 27 mins
In cell B5, insert the PMT function 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.
Solved by X. J. in 11 mins
On the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. Format the Amount of Loan as Currency with 0 decimals. Format the Interest as Percentage with 2 decimals.
Amount of Loan $425,000
Period (months) 120
Interest rate (per year) 5.25%
Solved by D. L. in 23 mins
In row 4, for a $750,000 loan at a 5.2 percent interest rate that is completely repaid with quarterly payments of $10,000, in E4 find the number of payments that will be necessary to pay off the loan. Once E6 is complete, the value in C6 will display.
Solved by X. W. in 18 mins
In cell D19, apply conditional formatting to highlight the cell to display red text if the value is less than 0 and Green Fill with Dark Green Text if the value is greater than 0. On the LoanConditions worksheet begin to create a one-variable data table by typing various interest rates ranging from 4% through 10% in increments of 1% in cells D3:D9.
Solved by T. B. in 17 mins
On loancondition sheet in cell E2, reference the cell that calculates the monthly payment amount for the loan. Apply a custom format to cell E2 so that the cell appears to be Monthly Payment. Finish the one-variable data table to see the monthly payment amount for each interest rate. Apply conditional formatting to the range E3:E9 using the gradient fill, green data bar option.
Solved by B. U. in 16 mins
how to calculate apr in excel on my loan if I have the following information:
1) date loan started
2) principal amount of loan advanced
3) accrued interest
4) compounded value of loan (principal plus interest)
5) The number of days outstanding?
6) how do I determine the APR being charged
Solved by X. J. in 27 mins