Eir | search
Click here to view Eir news from 60+ newspapers.
Bookmark or Share- EFFECT function - Microsoft SupportThis article describes the formula syntax and usage of the EFFECT function in Microsoft Excel. Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. EFFECT (nominal_rate, npery) The EFFECT function syntax has the following arguments: Nominal_rate Required.
- 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.
- 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.
- XNPV function - Microsoft SupportThis article describes the formula syntax and usage of the XNPV function in Microsoft Excel. Returns the net present value for a schedule of cash flows that is not necessarily periodic. To calculate the net present value for a series of cash flows that is periodic, use the NPV function. XNPV (rate, values, dates)
- XIRR function - Microsoft SupportTo calculate the internal rate of return for a series of periodic cash flows, use the IRR function. XIRR (values, dates, [guess]) The XIRR function syntax has the following arguments: Values Required. A series of cash flows that corresponds to a schedule of payments in dates.
More
