Tuesday, July 23, 2019

Calculate the Interest Rate on a Car Loan

Use the Excel RATE Function to calculate the annual interest rate.  This will give you an idea how much interest you are paying if you change the monthly amount or number of payment periods.

Monday, July 22, 2019

Create a Stock Chart

Are you tracking a stock investment and wanted to see how it's trending over a period of time?  But not just happy looking at numbers in a table?  Well create a chart....more specifically create a stock chart! This type of chart will let you look at the trend of high/low/open/close price of a stock over a period of time and let you visually see how it's been faring.  Did you also know this type of chart is as old as dirt?  The concept of the stock charts takes from candlestick charts which were supposedly created in 18th century in Japan by a rice trader.  So when creating your stock chart, you'll be in good company knowing that it's origin had the same purpose as it does today - to track investments.  See the video on how to create the stock chart.

Wednesday, July 17, 2019

Use the PMT, IPMT & PPMT Functions

If you do finance or just personal finance you are probably working on interest payments.  Excel has a bunch of finance functions that help you figure out financial payments.  In this video, I'll cover the different PMT functions and check out the video to learn how to use the different payment functions (PMT, IPMT & PPMT) in Excel.

Feel free to provide a comment or share it with a friend!