Can anyone offer guidance, preferred way to compute final outstanding balance
of a loan, with additional non-periodic (irregular) withdrawls and irregular
payments made against loan over time, and exposed to variable interest rate
over various date ranges. Time period spans several years. I'm thninking of
building a cash flow schedule but looking for suggestions on how to handle
the variable interest rate. Any specific Finanical functions to help with
this? Thanks

Just have the table contain a column for rate for each period. Instead of
having your financial functions look at one cell for a constant rate, have
them look at that row's interest rate.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Finance Novice" wrote:

Can anyone offer guidance, preferred way to compute final outstanding balance
of a loan, with additional non-periodic (irregular) withdrawls and irregular
payments made against loan over time, and exposed to variable interest rate
over various date ranges. Time period spans several years. I'm thninking of
building a cash flow schedule but looking for suggestions on how to handle
the variable interest rate. Any specific Finanical functions to help with
this? Thanks