un-debt.net

This video is the 2nd in a 4-part series that presents the essentials of investment decision-making. Part 2 covers the NPV (net present value) and IRR (internal rate of return).

use the payment function (pmt) to calculate monthly car payments and mortgage payments

See how to do Linear Regression for determining what part of a mixed cost is a Fixed Cost and what part is a Variable Cost. Also See how to create a Scatter Diagram and add Trend Line. Excel Magic Trick # 265: Cost Accounting Linear Regression (Excel Magic Trick #265) This video is for a Highline Community College Cost Accounting Class. The SLOPE (m) function calculates the slope of the linear equation y = m*x + b The INTERCEPT (b) function calculates the intercept of the linear equation y = m*x + b The RSQ (r^2) function calculates the Coefficient Of Determination (how much influence x has on y) The symbol carrot ^ (Shift + 6) is used for exponents The ROUND function must be used when: 1) multiplying decimals; 2) you are required to round (money requires that you round because the smallest unit is a penny); 3) you will use your formula results in subsequent formulas To see how to use the Excel Add-in Data Analysis feature, see this video: Stats 08: Install Excel 2007 Data Analysis Add-in Ron Sabado Accounting Class

Download Excel workbook people.highline.edu Learn how to calculate Cash Flow From Assets, Cash Flow To Creditors and Cash Flow To Shareholders using accounting Financial Statements. Highline Community College Busn 233 Financial Management with Excel taught by Michael Girvin.

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 and EAR for a Pay Day Loan. See a problem with the EFFECT function. Learn how to use the function help to find a solution. Pay Day Loans will: Allow you to write a check that has a date 25 days in the future for $250 and will give you $200 today (they cash check in 25 days). What is the APR and EAR? Nominal Rate APR Rate Annual Percentage Rate Effective Annual Rate. 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

www.TeachMsOffice.com How to find the interest and principal payments on a fixed rate loan in excel. This tutorial will walk you through using the PPMT() and IPMT() functions in excel in order to find out how much of a monthly payment on a loan actually goes to pay off the loan amount and how much is just an interest payment. To follow along with this spreadsheet as well as to get more free excel stuff such as macros, tutorials, articles, etc. go to www.TeachMsOffice.com

See the Beauty of the PMT function and an Amortization Table. For consumers, you can see how much the bank takes from you each month as interest and how much is left over for the loan reduction. For accountants (financial and tax), you can see how much of each cash flow goes toward an Expense and how much reduces the liability by. For financers, you can see how much of the cash flow actually reduces the liability by and how much the deduction on a tax form would be.

This video is the 1st in a 4-part series that presents the essentials of investment decision-making. Part 1 covers the Time Value of Money, Cash Flows, and Incremental Analysis.

This video is the 2nd in a 4-part series that presents the essentials of investment decision-making. Part 2 covers the NPV (net present value) and IRR (internal rate of return).

This video is aimed at describing the analysis of transactions of business entity and how to embed those transactions to the entity’s Balance Sheet.