Fha Loan Calculator

See how to use the FV function. See the math formula for calculating Future Value and for calculating the effective interest rate. Also see long hand how compound interest is calculated.

See that Excel only sees 15 significant digits in Excel. Learn that Excel 2007 has 100 Undo, whereas Excel 2003 only had 16.

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 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

Duration : 0:10:36

(more…)

Technorati Tags: College, Community, compound, excel, finance, function, FV, Gel, Girvin, Highline, interest, Mike, Simple

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 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 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

Duration : 0:6:5

(more…)

Technorati Tags: APR, College, Community, day, EFFECT, excel, finance, for, function, Gel, Girvin, Highline, interest, loans, Mike, pay, rate

1-4) IF function To Put Label on Income Statement. See four different Logical Tests for the same result.
5) IF function using comparative Operator to put one of two formulas in a cell
6) 2 IF functions in one formula (Multiple IF functions)
7) IF function to see if two columns are in Balance
IF function to see if accounts are in Balance from different Sheets
9) IF function formula to show or hide a formula
10-11) IF function formulas to see if Invoice or Loan in Past Due
12) IF function for column in data set to determine which products are stored IN house and which ones are OUT oh House. See the NOT operator in a formula.
13) IF function to calculate Commission Bonus
14-15) Multiple IF functions in one formula, then switch to VLOOKUP or LOOKUP
16) IF array formula for MEDIAN calculation

Duration : 0:36:40

(more…)

Technorati Tags: Array, calculation, College, column, Commission, Community, excel, excelisfun, field, for, formula, function, Gel, Girvin, Highline, IF, Logical, Median, Mike, Nesting, or, statement, Test

Calculate the payment for a loan, calculate how much is owed during a loan, total payment over a loan, on a TI calculator

Duration : 0:3:48

(more…)

Technorati Tags: College, Community, finance, loan, math, ribas, roberto, scc, scottsdale

See the Excel functions RATE, EFFECT, NOMINAL, NPER solve these problems:
1.Calculate Adjusted Interest Rate For Loans With Points using the RATE function
2.See Math formula to calculate the Effective Interest Rate for a loan given the APR or Nominal Rate
3.See the EFFECT function to calculate the Effective Interest Rate for a loan given the APR or Nominal Rate
4.Solve this finance problem: Savings Plan that compounds interest 365 times a year, but you put money in 12 times a year. What is future Value?
5.How long to pay off your credit Card if you pay only the minimum PMT required? See the NPER function.
6.Use the NPER function to calculate how long it takes to pay off your credit card balance when you make only the minimum payment
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Duration : 0:20:0

(more…)

Technorati Tags: adjusted, College, Community, EFFECT, excel, excelisfun, function, Gel, Girvin, Highline, interest, Mike, NOMINAL, NPER, rate

See how to calculate the Maturity Date for a loan, how to calculate a running balance for an account using the IF function, and see how to calculate the number of days left on an outstanding loan. See how to build a table for debt records

Duration : 0:6:12

(more…)

Technorati Tags: College, Community, date, Days, excel, formulas, function, Gel, Girvin, Highline, IF, math, Maturity, Mike, remaining

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 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 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

Duration : 0:10:39

(more…)

Technorati Tags: Balloon, College, Community, delayed, excel, finance, function, Gel, Girvin, Highline, Mike, or, payment, pmt(), rate

See how to use VLOOKUP to create a Mortgage Calculator that can handle 4 different types of loans: Begin Annuity, End Annuity, Interest Only and Other loan.

Duration : 0:6:55

(more…)

Technorati Tags: Annuity, Begin, calculator, College, Community, End, excel, excelisfun, for, Gel, Girvin, Highline, interest, Mike, mortgage, only, VLOOKUP

Excel! Learn how to calculate the time between 2 dates like invoices past due. Learn how to calculate a loan due date or how many days you have been alive! Also, learn the lightening fast keyboard shortcuts for removing Number format.

Duration : 0:3:45

(more…)

Technorati Tags: between, College, Community, date, dates, due, excel, Gel, Girvin, Highline, loan, math, Mike, spreadsheets, time, two

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 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

Duration : 0:4:13

(more…)

Technorati Tags: adjusted, calculate, College, Community, excel, finance, function, Gel, Girvin, Highline, loan, Mike, Points, rate