You can use the NPV function when the cash flows are of different amounts but the time periods between cash flows is the same. When an asset DOES NOT have an annuity cash flow pattern, you can use the NPV function for Capital Investment Decision. Asset Valuation with Discounting Cash Flow Analysis. In ThisSeries learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!! The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks! Excel Formula
Tags: capital, cash, college, Community, Decision, Excel, Finance, flow, for, function, Gel, Girvin, Highline, investment, Mike, NPV
February 10th, 2010 at 1:59 pm
Dear DesiMC,
YouTube will not let us post a link here. To get the workbooks with all the Finance Tricks, click on the ExcelIsFun channel, click on the college web site link, then click on the link for the workbook, then click Save, then you can get the workbook.
I made a video about how to do this called:
Amazing Excel videos! Excel Is Fun Channel! Magic!
Keep trying to find and download the workbook because it is filled with even more cool Finance Tricks.
–ExcelIsFun
February 10th, 2010 at 1:59 pm
Thanks I tried to find this from your website.
The sheet.
But I couldn’t find it.
Could you please link me ?