Click in cell E2, enter the following formula: =pmt(c2/12,d2*12,-b2) and press enter. Select the currency ($) option from the number formatting menu, located on the formatting toolbar. The amount of the monthly payment will now appear in cell E2 and will be represented as a dollar amount.
Enter the loan calculation formula.
{"src": "wikihow-all_validation", "title": "How to Calculate Amount Financed in Excel2"}