Formula which splits principal & interest pmts on P&I Loan

I am creating a spreadsheet setting out loan repayments on a daily basis. I
need the formula that seperates the interest from the daily payments to allow
the principal reduction to occur?

Copied fro Excel Help:

PPMT Returns the payment on the principal for a given period for an
investment based on periodic, constant payments and a constant interest rate

IPMT Returns the interest payment for a given period for an investment based
on periodic, constant payments and a constant interest rate. For a more
complete description of the arguments in IPMT and for more information about
annuity functions, see PV.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dealmakerjc" <Dealmakerjc@discussions.microsoft.com> wrote in message
news:6AA1AD66-4C69-487D-B033-90F4EEE6E7CD@microsoft.com...
>I am creating a spreadsheet setting out loan repayments on a daily basis. I
> need the formula that seperates the interest from the daily payments to
> allow
> the principal reduction to occur?