Similar Content
Hide the Excel Interface and Show Only Data
Tutorial: I'm going to show you how to remove almost every interface from Excel and streamline the...
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...
PMT Function - Get the Payment Due for a Loan in Excel
Tutorial: How to calculate the payment amount for a loan or similar financial instrument that has a ...

# Excel Finance Trick #8: Complete Loan Analysis

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

Got a Question? Ask it Here in the Forum.