Anyone has spreadsheet on "Rule of 78 Calculation" a.k.a. SU

xenium · May 22nd, 2002, 01:03 AM

hi,

does anyone has excel worksheet with "RULE OF 78" formula??? Thanks!

Juan Pablo González · May 22nd, 2002, 01:11 AM

huh ? what's that ? can you be more specific ?

Paul B · May 22nd, 2002, 01:14 AM

I did not know what the “rule of 78” was, but a search on google returned this information, hope it helps you some

http://groups.google.com/groups?hl=e...p05%26rnum%3D1

Dave Patton · May 22nd, 2002, 01:19 AM

[quote]
xenium wrote:

does anyone has excel worksheet with "RULE OF 78" formula??? Thanks!

Do you have a question?

To secure a relevant response, please provide a concise example and the result that you expect.

Yogi Anand · May 22nd, 2002, 02:42 AM

You may want to look at the following link --it has some examples as well
http://www.pine-grove.com/pi09003.htm

Regards!

_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 13:01 ]

xenium · May 22nd, 2002, 05:47 AM

if you've not heard of it...you probably won't know what is it... no matter how specific i can try to be....

anyway, it's a method of calculating loans settlement amount by lender (financial institutions).

so the question here is "Can anyone provide a spreadsheet that can generate the settlement table computed using the "Rule of 78" formula...

now, somebody learns something new today...

iancshaw · May 22nd, 2002, 06:08 AM

We have a spreadsheet that we use at work for calculating the interest component for a rule of 78.

I am not able to access it until tomorrow.

If you can provide your email address, I will forwarded when I have it.

Ian

May 22nd, 2002, 01:11 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,757	huh ? what's that ? can you be more specific ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 01:03 AM	#1
xenium Join Date: Apr 2002 Posts: 8	hi, does anyone has excel worksheet with "RULE OF 78" formula??? Thanks!

May 22nd, 2002, 01:14 AM	#3
Paul B Join Date: Feb 2002 Location: Nicholson, Georgia. USA Posts: 507	I did not know what the “rule of 78” was, but a search on google returned this information, hope it helps you some http://groups.google.com/groups?hl=e...p05%26rnum%3D1

May 22nd, 2002, 01:19 AM	#4
Dave Patton Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 1,760	[quote] xenium wrote: does anyone has excel worksheet with "RULE OF 78" formula??? Thanks! Do you have a question? To secure a relevant response, please provide a concise example and the result that you expect.

May 22nd, 2002, 02:42 AM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,448	You may want to look at the following link --it has some examples as well http://www.pine-grove.com/pi09003.htm Regards! _________________ Yogi Anand Edit: Deleted inactive website from hardcoded signature [ This Message was edited by: Yogi Anand on 2003-01-19 13:01 ]

May 22nd, 2002, 05:47 AM	#6
xenium Join Date: Apr 2002 Posts: 8	if you've not heard of it...you probably won't know what is it... no matter how specific i can try to be.... anyway, it's a method of calculating loans settlement amount by lender (financial institutions). so the question here is "Can anyone provide a spreadsheet that can generate the settlement table computed using the "Rule of 78" formula... now, somebody learns something new today...

May 22nd, 2002, 06:08 AM	#7
iancshaw Join Date: May 2002 Location: Brisbane, Australia Posts: 3	We have a spreadsheet that we use at work for calculating the interest component for a rule of 78. I am not able to access it until tomorrow. If you can provide your email address, I will forwarded when I have it. Ian