click the quick analysis button and choose charts.

Use to determine… FV (future value) How much an investment will be worth after a series of monthly payments at some future time PMT (payment) How much you have to spend each month to repay a loan or mortgage within a set period of time IPMT (interest payment) How much of your monthly loan payment is used to pay the interest PPMT (principal payment) How much of your monthly loan payment is used for repaying the principal PV (present value) Largest loan or mortgage you can afford given a set monthly payment NPER (number of periods) How long it will take to pay off a loan with constant monthly payments New Perspectives on Microsoft Excel 2010 New Perspectives on Microsoft Excel 2013ħ Financial Functions for Loans and InvestmentsĬost of a loan to the borrower is largely based on three factors: Principal: amount of money being loaned Interest: amount added to the principal by the lender Calculated as simple interest or as compound interest Time required to pay back the loan New Perspectives on Microsoft Excel 2010

Other loan functions include future value, present value, calculating the interest part of a payment, calculating the principle part of a payment, and the loan interest rate. One of these is the PMT function, which can be used to calculate the installment payment and payment schedule required to completely repay a loan. 1 Excel Tutorial 4: Analyzing and Charting Financial DataĢ Objectives Use the PMT function to calculate a loan paymentĬreate an embedded pie chart Apply styles to a chart Add data labels to a pie chart Format a chart legend Create a clustered column chart Create a stacked column chart New Perspectives on Microsoft Excel 2013ģ Objectives Create a line chart Create a combination chartįormat chart elements Modify the chart’s data source Add sparklines to a worksheet Format cells with data bars Insert a watermark New Perspectives on Microsoft Excel 2013ĥ Chart Elements New Perspectives on Microsoft Excel 2013Įxcel provides a wide range of financial functions related to loans and investments.

Click the quick analysis button and choose charts.