Use Excel Goal Seek To Find The Formula Result You Want
Feb 2017 »
| STEP 1: Enter your 3 input variables that you will need to use for your PMT formula i.e. Interest Rate of 3.50%, Term of 240 months & Principal of $250,000 loan calculator STEP 2: Enter the PMT function in cell C8 =PMT(Interest Rate/12, Term, Principal) which will give you a monthly payment amount of -$1,450. Read on to check out the rest of my step by step tutorial from #MyExcelOnline | Microsoft Excel Tips #MSExcel #ExcelFormulas #ExcelTips #MicrosoftExcel #ExcelforBeginners |
