F
Frank B Denman
Hi Folks,
I'm trying to help a customer who has been making reimbursable expenditures for
a family estate at irregular intervals over the last 18 years. During this
period, the estate has occasionaly sent partial reimbursements. A time of
reckoning now approaches. The understanding is that the estate will pay simple
interest on the expenses. No interest on the interest.
I can visualize a spreadsheet with a row for every month across the 18 years,
and with all expenditures and payments treated as if they happened on the first
of the month.
But this seems like kind of a kludge.
Is there an elegant way to do this?
Thanks.
Frank
Frank Denman
Denman Systems
(e-mail address removed)
Please delete the "x" from my email address.
I'm trying to help a customer who has been making reimbursable expenditures for
a family estate at irregular intervals over the last 18 years. During this
period, the estate has occasionaly sent partial reimbursements. A time of
reckoning now approaches. The understanding is that the estate will pay simple
interest on the expenses. No interest on the interest.
I can visualize a spreadsheet with a row for every month across the 18 years,
and with all expenditures and payments treated as if they happened on the first
of the month.
But this seems like kind of a kludge.
Is there an elegant way to do this?
Thanks.
Frank
Frank Denman
Denman Systems
(e-mail address removed)
Please delete the "x" from my email address.