On the right, you can see the result of the same formula in the General format. By default, it is highlighted in red and enclosed in parenthesis ( Currency format for negative numbers) as shown in the left part of the screenshot below. In accordance with the cash flow sign convention, the result is returned as a negative number because you pay out this money. Instead of supplying the numbers directly into a formula, you can input them in some predefined cells and refer to those cells like shown in the screenshot below. 1 - payments are made at the beginning of each period.įor example, if you received a loan of $20,000, which you must pay off in annual installments during the next 3 years with an annual interest rate of 6%, the interest portion of the 1 st year payment can be calculated with this formula:.0 or omitted - payments are made at the end of each period.Type (optional) - specifies when the payments are due:.If omitted, it is implied to be zero (0). the desired balance after the last payment is made. Fv (optional) - the future value, i.e.In other words, it is the loan principal, i.e. Pv (required) - the present value of the loan or investment.Nper (required) - the total number of payments during the lifetime of the loan.It must be an integer in the range from 1 to nper. Per (required) - the period for which you want to calculate the interest.Say, if you make quarterly payments on a loan with an annual interest rate of 6 percent, use 6%/4 for rate. If you make weekly, monthly, or quarterly payments, divide the annual rate by the number of payment periods per year, as shown in this example. You can supply it as a percentage or decimal number.įor example, if you make annual payments on a loan with an annual interest rate of 6 percent, use 6% or 0.06 for rate. Rate (required) - the constant interest rate per period.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |