SCOUG-SundialSIG Mailing List Archives

<< Previous Message << >> Next Message >>

Date:	Thu, 3 May 2001 23:42:36 PDT
From:	Peter Skye <pskye@peterskye.com >
Reply-To:	scoug-sundialsig@scoug.com
To:	scoug-sundialsig@scoug.com
Subject:	SCOUG-SundialSIG: I looked around.

Content Type: text/plain

John Hlavac wrote:
>
> It seems as though everyone does percentages differently
> just to confuse the client. Some use APYE, some use
> interest compounded quarterly, some monthly, some daily.
> Interest paid in monthly increments can't be easily
> compared to interest paid quarterly, or biannually.

It should be possible to convert the different reporting periods to
something "standard", such as annual.

If the period is monthly, for example, then take the percentage (say 1%)
and raise it to the 12th power (12 months in a year), thus 1% is 1.01^12
= 1.1268 -> 12.68% per year.

Or, if you have 12 months of percentages and each one is different,
multiply all the increases together to get the past 12 months'
percentage.

> How do you recommend dealing with this?

Can you add one additional column called "T" which would be the type of
the reported percentage? Then the formula can look at the type and
decide how to do the calculation. The value in the "T" column could be
D for daily, M for monthly, etc.

> It seems to me that it makes a little more sense to start
> with the easy stuff and work up to the more sophisticated
> stuff. I realize it'll be very boring for you and Steven.

Makes sense to me too. And it's not boring -- I *like* to play with
numbers.

- Peter

=====================================================

To unsubscribe from this list, send an email message
to "steward@scoug.com". In the body of the message,
put the command "unsubscribe scoug-sundialsig".

For problems, contact the list owner at
"rollin@scoug.com".

=====================================================

Return to [ 03 | May | 2001 ]

SCOUG, Warp Expo West, and Warpfest are trademarks of the Southern California OS/2 User Group. OS/2, Workplace Shell, and IBM are registered trademarks of International Business Machines Corporation. All other trademarks remain the property of their respective owners.