Apy | search
Click here to view Apy news from 60+ newspapers.
Bookmark or Share- Use Goal Seek to find the result you want by adjusting an input valueYou can use Goal Seek to determine what interest rate you will need to secure in order to meet your loan goal. If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For example, suppose that you need to borrow some money.
- Using Excel formulas to figure out payments and savingsExcel formulas and budgeting templates can help you calculate the future value of your debts and investments, making it easier to figure out how long it will take for you to reach your goals. Use the following functions: PMT calculates the payment for a loan based on constant payments and a constant interest rate.
- PMT function - Microsoft SupportHow to use the PMT function in Excel to calculate monthly loan payments based on constant payments and a constant interest rate.
- Go with the cash flow: Calculate NPV and IRR in ExcelThere are two financial methods that you can use to help you answer all of these questions: net present value (NPV) and internal rate of return (IRR). Both NPV and IRR are referred to as discounted cash flow methods because they factor the time value of money into your capital investment project evaluation.
- RATE function - Microsoft SupportThis article describes the formula syntax and usage of the RATE function in Microsoft Excel. Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns the #NUM! error value.
More
