Amortization Tables

The speaker talks about how to create an amortization table in Microsoft Excel using the CUMIPMT & CUMPRINC functions to calculate net interest paid and net principal paid figures without having to create an amortization table.

Facebook
Twitter
LinkedIn
Email

Tim Ord

Ord Oracle

Tim Ord is a technical analyst and expert in the theories of chart analysis using price, volume, and a host of proprietary indicators as a guide...

View Author

Tradingsim.com

Day Trading Simulator

Tradingsim.com provides the ability to simulate day trading 24 hours a day from anywhere in the world. TradingSim provides tick by tick data for...

View Author

Amortization Tables

Send this article to a friend.

Day Trading

Bonds

Technical Analysis

Fundamental Analysis

Options

Stocks

Personal Finance

Futures

Forex

Investment Articles

Premium Services

Free Offers

Videos

My Stock Market Power

Day Trading
-Day Trading Psychology
-Day Trading Indicators
-Day Trading Strategies
-Day Trading Basics
Bonds
-Bond Basics
-Bond Glossary
-Bond Types
-Credit Crisis
Technical Analysis
-Candlestick Charts
-Chart Patterns
-Fibonacci
-Technical Indicators
-Basics of Technical Analysis
Fundamental Analysis
-Earnings
-Financial Ratios
Options
-Options Basics
-Options Glossary
-Options Strategies
Stocks
-Investing Basics
-Investing Strategies
-Online Trading
-Penny Stocks
-Stock Market Indices
Personal Finance
-Retirement Plans
-401k
-Annuities
-Roth IRA
Forex
-Forex Basics
-Forex Glossary
-Forex Trading Hours
Futures
-Futures Basics
-Futures Contract Types
Investment Articles
blog
Image Ad
Banking
Blog
blog
Bond
Bond ETFs
Bonds
-Bond Basics
--Arbitrage Capital Asset Pricing Model
--Bond Math
--Bond Price Volatility
--Convexity
--CUSIP
--Duration
--Yield Curve
-Bond Glossary
--Accrued Interest
--Basis Points
--CPI
--Discount Rate
--Eurodollar
--Fed Funds
--Federal Reserve Bank
--GDP
--Inflation
--Interest Rate Swap
--LIBOR
--Maturity Date
--Recession
--TED Spread
-Bond Types
--Asset Backed Securities
--Callable Bonds
--CDOs
--CDs
--Commercial Paper
--Convertible Bonds
--Corporate Bond
--Credit Default Swaps
--Fixed Income ETFs
--High Yield Bonds
--I Bonds
--MBS
--Money Market
--Municipal Bonds
--Repo
--Series EE
--Structured Investment Vehicle
--Syndicated Bank Loan
--Treasury Bills
--Treasury Bond
--Treasury Inflation Protected Securities
--Treasury STRIPS
-Credit Crisis
--Credit Crisis Conclusion
--Deleverage
--Mortgage Crisis
Brazil ETF
Chart Patterns
Clean Energy ETF
Commodity ETFs
Consumer Confidence
Corporate Debt
Day Trading
-Automated Trading
-Day Trading Hardware and Software
-Day Trading Indicators
-Day Trading Journal
-Day Trading Money Management
-Day Trading Psychology
-Day Trading Risk
-Day Trading Strategies
--Day Trading Breakouts
--Momentum Trading
-Level II
-Scalp Trading
-Trading Plan
-Trading Risk
-Visual Exercise
Day Trading Basics
derivatives
Dogs of the Dow
Dogs of the Dow Videos
Dow ETF
Elliott Wave Videos
Emerging Markets ETF
Energy ETFs
ETF List
Financial ETFs
Forex
-Currency Carry Trade
-Forex Basics
-Forex Glossary
--Base Currency
--Cross Rate
--Currency Swap
--Forex PIP
-Forex Trading Hours
Fundamental Analysis
-Altman Z Score
-Asset Allocation
-Balance Sheet
--Accounts Receivables
-Book Value
-Capital Structure
-Cash Conversion Cycle
-Cash Flow Statement
-Cost of Capital
-Cost of Goods Sold
-Current Liabilities
-Days Payable Outstanding
-Debt to Income Ratio
-Deferred Tax Assets
-Depreciation
-Discounted Cash Flow
-Earnings
-EPS
-Financial Ratios
--EBITDA
--Leverage Ratios
--Liquidity Ratios
--PE Ratio
--PEG Ratio
--Price To Sales Ratio
-Income Statement
-Inventory Valuation
-IRR
-Mark to Market
-Market Capitalization
-Net Present Value
-Profit Margins
-Retained Earnings
-Return on Assets
-Return on Equity
-Treasury Stock
-WACC
-Working Capital
Futures
-Commodity Futures
-Emini Futures
-Forward Contract
-Futures Basics
-Futures Contract
-Futures Contract Types
-Futures Margin Requirements
-Futures Trading Pits
-Index Futures
-Interest Rate Futures
-Introduction to Futures
-Limit Down Futures
-Open Outcry
-Spot Price
Gold ETF
Healthcare ETF
history of technical analysis
Income ETF
Initial Public Offering
insurance
Investment Articles
IRA
liquidity
Mutual Funds
Non-Farm Payrolls
Options
-Option Greeks
-Options Basics
--Implied Volatility
-Options Expiration
-Options Glossary
--Call Option
--Options Moneyness
--Put Options
--Strike Price
-Options Strategies
--Bull Call Spread
--Bull Put Spread
--Butterfly Spread
--Call Ratio Backspread
--Call Ratio Spread
--Condor
--Covered Calls
--Married Puts
--Naked Puts
--Short Straddle
--Short Strangle
--Straddle
--Strangle
Penny Stocks. Investing Basics
Personal Finance
-Adjusted Gross Income
-APR
-Beneficiary
-Bridge Loan
-Credit Cards
-Education Savings Accounts
-FICO Score
-HELOC
-Joint Tenancy
-Life Expectancy
-Loan to Value
-Mortgage Basics
--Adjustable Rate Mortgage
--Alt-A
--Amortization Table
--Balloon Mortgage
-Negative Amortization
-PMI
-Qualified Plans
-Required Minimum Distribution
-Retirement Plan Loans
-Retirement Plans
--401k
--403b
--Annuities
--Defined Benefit Plan
--Defined Benefit Program
--Early Withdrawal Penalty Exclusions
--Roth 401k
--Roth IRA
---Roth IRA Contribution
---Roth IRA Conversion
---Roth IRA Withdrawal
--SEP IRA
--Simple IRA
--Traditional IRA
--Variable Annuities
-Secured Credit Card
-Truth in Lending
-Unemployment Rate
Pink Sheets
Recharacterization
Resources
restricted
Roth IRA Ordering Rules
sharpe ratio
Silver ETFs
Stock Market Indicies
Stock Terms
Stocks
-ADRs
-After Hours Trading
-Bear Market
-Bear Raid
-Berkshire Hathaway Holdings
-Blue Chip Stocks
-Boiler Room
-Bottom Up Investing
-Bull Market
-Buy and Hold
-Buy Back
-Buy Limit Order
-Buyout
-Capital Gains
-Cash Trading
-Closing Bell
-Common Stock
-Direct Access Broker
-Dividends
-Dollar Cost Average
-ECNs
-ETFs
-Green Investing
-Insider Trading
-Investing Basics
-Investing for Dummies
-Investing Strategies
-Jesse Livermore
-Leveraged Buyout
-Leveraged ETFs
-Limit Order
-Margin Trading
--Buying Power
-Market Maker
-Online Trading
-Opening Bell
-Penny Stocks
-Preferred Stock
-Pullback
-REITS
-Rogue Trader
-Secondary Market
-Shareholders Equity
-Short Selling
-Short Squeeze
-Stock Market Indices
-Stock Splits
-Stock Tips
-Trailing Stops
-Wall of Worry
Tax
Taxes
Technical Analysis
-Candlestick
--Dark Cloud Cover
-Chart Patterns
--Ascending Triangle
--Bar Chart
--Bear Trap
--Breakdown
--Cup and Handle
--Dead Cat Bounce
--Descending Triangle
--Double Bottom
--Flag
--Gap
---Breakaway Gap
--Pennant
--Symmetrical Triangle
--Wedge
-Cycles
--Cyclical Stocks
-Fibonacci
-Point and Figure Charts
-Renko Charts
-Technical Indicators
--Absolute Breadth Index
--Advance Decline Line
--ADX
--Andrews Pitchfork
--Bollinger Bands
--Bull Bear Ratio
--CCI
--Exponential Moving Average
--MACD
--Money Flow Index
--Moving Average
--On Balance Volume
--Parabolic SAR
--RSI
--Sentiment Indicators
--Simple Moving Average
--Slow Stochastic
--Volume Analysis
--Zig Zag
TIPS ETFs
Total Asset Turnover
Trading Courses
Trading Strategies
trends
Triple Leveraged ETF
Video
Video
-Bond Videos
--Bond Basics Videos
---Arbitrage Capital Asset Pricing Model Videos
---Bond Math Videos
---Bond Price Volatility Videos
---Convexity Videos
---CUSIP Videos
---Duration Videos
---Yield Curve Videos
--Bond Definition Videos
--Bond Glossary Videos
---Basis Point Videos
---CPI Videos
---Discount Rate Videos
---Eurodollar Videos
---Fed Funds Videos
---Federal Reserve Bank Videos
---GDP Videos
---Inflation Videos
---Interest Rate Swap Videos
---LIBOR Videos
---Maturity Date Videos
---Recession Videos
---TED Spread Videos
--Bond Types Videos
---Asset Backed Securities Videos
---Callable Bond Videos
---CD Videos
---CDO Videos
---Commercial Paper Videos
---Convertible Bond Videos
---Corporate Bond Videos
---Credit Default Swap Videos
---Fixed Income ETF Videos
---High Yield Bond Videos
---I Bond Videos
---MBS Videos
---Money Market Videos
---Municipal Bond Videos
---Repo Videos
---Series EE Bond Videos
---Structured Investment Vehicles Videos
---Syndicated Bank Loan Videos
---Treasury Bills Videos
---Treasury Bond Videos
---Treasury Inflation Protected Securities Videos
---Treasury STRIPS Videos
--Credit Crisis Videos
---Credit Crisis Conclusion Videos
---Deleveraging Videos
-Day Trading Videos
--Automated Trading Videos
--Day Trading Hardware Videos
--Day Trading Journal Videos
--Day Trading Money Management Videos
--Day Trading Risk Videos
--Day Trading Strategies Videos
---Day Trading Breakouts Videos
---Momentum Trading Videos
--Level II Videos
--Scalp Trading Videos
--Trading Plan Videos
-Forex Videos
--Cross Rate Videos
--Currency Swap Videos
--Forex Basics Videos
---Base Currency Videos
--Forex Trading Hours Videos
-Forex Videos
--Currency Carry Trade Videos
-Fundamental Analysis Videos
--Altman Z Score Videos
--Asset Allocation Videos
--Balance Sheet Videos
---Accounts Receivables Videos
--Book Value Videos
--Capital Structure Videos
--Cash Flow Statement Videos
--Cost of Capital Videos
--Cost of Goods Sold Videos
--Current Liabilities Videos
--Days Payable Outstanding Videos
--Debt to Income Ratio Videos
--Deferred Tax Assets Videos
--Depreciation Videos
--Discounted Cash Flow Videos
--EPS Videos
--Financial Ratios
--Financial Ratios Videos
---EBITDA Videos
---Leverage Ratio Videos
---Liquidity Ratio Videos
---PE Ratio Videos
---PEG Ratio Videos
---Price to Sales Videos
--Income Statement Videos
--Inventory Valuation Videos
--IRR Videos
--Mark to Market Videos
--Market Capitalization Videos
--Net Present Value Videos
--Profit Margin Videos
--Retained Earnings Videos
--Return on Assets Videos
--Return on Equity Videos
--WACC Videos
--Working Capital Videos
-Futures Videos
--Commodity Futures Videos
--Emini Futures Videos
--Forward Contract Videos
--Futures Contract Videos
--Futures Margin Requirement Videos
--Index Futures Videos
--Introduction to Futures Videos
--Limit Down Futures Videos
--Open Outcry Videos
--Spot Price Videos
-Mutual Funds Videos
-Options Videos
--Option Greeks Videos
--Options Basics Videos
---Implied Volatility Videos
--Options Expiration Videos
--Options Glossary Videos
---Call Option Videos
---Options Moneyness Videos
---Put Option Videos
---Strike Price Videos
--Options Strategies Videos
---Bull Call Spread Video
---Bull Put Spread Videos
---Butterfly Spread Videos
---Call Ratio Backspread Videos
---Call Ratio Spread Videos
---Condor Videos
---Covered Call Videos
---Married Puts Videos
---Naked Puts Videos
---Short Straddle Videos
---Short Strangle Videos
---Straddle Videos
---Strangle Videos
-Personal Finance Videos
--Adjusted Gross Income Videos
--APR Videos
--Beneficiary Videos
--Bridge Loan Videos
--Education Savings Account Videos
--FICO Score Videos
--Life Expectancy Videos
--Loan to Value Videos
--Mortgage Videos
---Adjustable Rate Mortgage Videos
---Alt-A Videos
---Amortization Table Videos
---Balloon Mortgage Videos
---HELOC Videos
---Mortgage Crisis Videos
---Negative Amortization Videos
--PMI Videos
--Qualified Plan Videos
--Required Minimum Distribution Videos
--Retirement Plan Loan Videos
--Retirement Plan Type Videos
---401K Videos
---Annuity Videos
---Defined Benefit Plan Videos
---Early Withdrawal Penalty Exclusion Videos
---Roth 401k Videos
---Roth IRA Videos
---SEP IRA Videos
---Simple IRA Videos
---Traditional IRA Videos
---Variable Annuity Videos
--Secured Credit Card Videos
--Truth In Lending Videos
--Unemployment Rate Videos
-Stocks Videos
--ADR Videos
--After Hours Trading Videos
--Bear Market Videos
--Bear Raid Videos
--Berkshire Hathaway Holdings Videos
--Blue Chip Stocks Videos
--Boiler Room Videos
--Bottom Up Investing Videos
--Bull Market Videos
--Buy and Hold Videos
--Buy Back Videos
--Buy Limit Order Videos
--Buyout Videos
--Capital Gains Videos
--Cash Trading Videos
--Closing Bell Videos
--Common Stock Videos
--Direct Access Broker Videos
--Dividend Videos
--Dollar Cost Average Videos
--ETF Videos
--Green Investing Videos
--Insider Trading Videos
--Investing For Dummies Videos
--Jesse Livermore Videos
--Leveraged Buyout Videos
--Leveraged ETFs Videos
--Limit Order Videos
--Margin Trading Videos
---Buying Power Videos
--Market Maker Videos
--Opening Bell Videos
--Penny Stocks Videos
--Preferred Stock Videos
--Pullback Videos
--REIT Videos
--Rogue Trader Videos
--Secondary Market Videos
--Short Selling Videos
--Short Squeeze Videos
--Stock Splits Videos
--Stock Tips Videos
--Trailing Stops Videos
--Wall of Worry Videos
-Technical Analysis Videos
--Candlesticks Videos
---Dark Cloud Cover Videos
--Chart Patterns Videos
---Ascending Triangle Videos
---Bar Chart Videos
---Breakdown Videos
---Cup and Handle Videos
---Dead Cat Bounce Videos
---Descending Triangle Videos
---Double Bottom Videos
---Flag Videos
---Gap Videos
---Pennant Videos
---Point and Figure Charts Videos
---Symmetrical Triangle Videos
---Wedge Videos
--Cycles Videos
---Cyclical Stocks Videos
--Fibonacci Videos
--Renko Charts Videos
--Technical Indicators Videos
---ADX Videos
---Andrews Pitchfork Video
---Bollinger Bands Videos
---Bull Bear Ratio Videos
---CCI Videos
---Exponential Moving Average Videos
---MACD Videos
---Money Flow Index Videos
---Moving Average Videos
---On Balance Volume Videos
---Parabolic SAR Videos
---RSI Videos
---Simple Moving Average Videos
---Slow Stochastic Videos
---Volume Analysis Videos
---Zig Zag Videos
-World Markets Videos
--Bombay Stock Exchange Videos
--BSE Sensex Videos
--Money Supply Videos
World Markets
-Bombay Stock Exchange
-BSE Sensex
-Money Supply

Amortization Tables

Related Videos

Related Articles

Send this article to a friend.

My Stock Market Power