Excel Finance Trick #6: RATE function and Loan Points
by
ExcelIsFun
on
Youtube
Duration:
0.07 hours
See how to use the RATE function to calculate an adjusted rate when there are Loan Points. Period rate = RATE function. In This Series learn 17 amazing ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Trick #7: EFFECT function (EAR Rate)
by
ExcelIsFun
on
Youtube
Duration:
0.04 hours
See how to use the EFFECT function to calculate the Effective Annual Rate given an APR or Nominal Rate. Also see the math formula to calculate the Effective ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Trick #8: Complete Loan Analysis
by
ExcelIsFun
on
Youtube
Duration:
0.18 hours
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 ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Trick 9: Daily Interest But Monthly Deposits?!
by
ExcelIsFun
on
Youtube
Duration:
0.07 hours
When your savings plans pays interest 365 days in a year and you make monthly deposits, use the NOMINAL and EFFECT functions first before using the FV ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Trick #10: Interest Rate for Pay Day Loans
by
ExcelIsFun
on
Youtube
Duration:
0.1 hours
See how to calculate the Interest Rates for Pay Day Loans. See how to calculate the Period Rate, the Number of Compounding Periods in a year, and the APR ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Trick 13: PV function Capital Invest Decision
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
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 ...
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 ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Trick 14: NPV function Capital Invest Decision
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
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 ...
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 ...
