See how to use the RATE function to calculate an adjusted rate when there are Loan Points. Period rate = RATE function. 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! Formula
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
Brief description of the 00 Tax Credit
See how to use the XNPV function for non-periodic Cash Flows. This function will do all the math for Discounting Cash Flow that are not all equal and are separated by differing time periods! Asset Valuation with Discounting Cash Flow Analysis. For complicated cash flow analysis, the XNPV function is amazing! 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
See how to use the PMT function & a Balloon payment. When you have to make Period payments on a loan contract and a lump sum payment at the end of the contract, you can use this trick to calculate your PMT amount! 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 …
See how to use the SLN & DDB Depreciation functions. The non-cash depreciation expenses are important for finance cash flow analysis. This video shows you the SLN & DDB functions. 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 …
See how to use the PMT & FV function together to calculate a delayed PMT payment amount. See how to use the PMT function to calculate a payment amount when there are delayed payments. When you have to make Period payments on a loan contract and you are not required to make payments until sometime later use this trick to calculate the PMT amount. See how to use the PMT & FV function together to calculate a delayed PMT payment amount. In ThisSeries learn 17 amazing Finance Tricks. Learn about …
See how to use the PMT and RATE functions for a complete Debt/Loan Analysis. Debt Analysis with input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Payment, Actual Cash Received, Adjusted APR, and PMT w Balloon Payment. 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 …
Mike Gasior explains what happened with AIG and the advent of credit default swaps. There is also discussion about how the US Congress was complicit in this whole mess by passing legislation that exempted credit default swaps from any sort of regulatory oversight during the final day of the lame-duck Congress back in the year 2000..
When an asset has an annuity cash flow pattern, you can use the PV function for Capital Investment Decision. An annuity has equal payments at equal time intervals. Asset Valuation with Discounting Cash Flow Analysis. In This Series 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 …