Financial functions in Excel allow for a variety of discounting operations. PMT function, for given present value, interest rate and number of periods calculates the total repayment value (annuity). How much, in this case, goes for the principal and how much for interest? To get answers to these questions you need to use the PPMT and IPMT functions.