|Instead of using specific
values, Excel allows arguments for the PMT Function to be entered as
cells. This was the computed payment
can be based on information provided on a different worksheet. This shows that the terms of the loan are
displayed in specific cells. The
principle amount of the loan is always entered as a negative number because
it is seen as the outflow of cash for the bank.