Solved

"Rule of 78s" calculation

Posted on 2013-01-27
3
338 Views
Last Modified: 2013-01-31
Does anyone have an example of C# code that does an accurate "Rule of 78s" calculation? I've spent a few hours trying to get this figured out so I can build an amotization table...

I have the table logic built and working. I have spreadsheet values I'm trying to replicate; but I don't understand (and haven't been able to replicate) the fomulas.

Any help here would be greatly appreciated!

Thanks
Payment-Calculator.XLS
0
Comment
Question by:Miles Thornton
  • 2
3 Comments
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 38825182
The "rule of 72" says that if you divide the 72 by the percentage rate, it gives the approximate number of years for the investment to double.

Here is a table showing those values

%      72/%      actual value
1      72      2.047099312
2      36      2.039887344
3      24      2.032794106
4      18      2.025816515
5      14.4      2.018951594
6      12      2.012196472
7      10.3      2.005548375
8      9      1.999004627
9      8      1.992562642
10      7.2      1.98621992
20      3.6      1.927757874
30      2.4      1.876999019
50      1.44      1.792963353

So it's actually pretty close.
The formula for the last column (actual value after 72/P years) is V = (1+P/100)^(72/P)
where P is the percent.
0
 
LVL 37

Accepted Solution

by:
TommySzalapski earned 500 total points
ID: 38825189
And here's the actual number of years it would take to double compared to the guess
%      72/%      years
1      72      69.66071689
2      36      35.00278878
3      24      23.44977225
4      18      17.67298769
5      14.4      14.20669908
6      12      11.89566105
7      10.3      10.24476835
8      9      9.006468342
9      8      8.043231727
10      7.2      7.272540897
20      3.6      3.801784017
30      2.4      2.641926796
50      1.44      1.709511291

And here's the formula for the actual number of years to double
=log(2)/log(P/100+1)

Note, that if you replace the 2 with 3, it gives the number of years for the investment to triple. Also note that you can use ln or any other base for log since log(x)/log(y) is the same in any base.
0
 
LVL 1

Author Closing Comment

by:Miles Thornton
ID: 38840842
Thank you Tommy Szalapski!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
import issue in bit values 3 44
Need help with a query 6 54
Expando 4 33
Visual Studio 2013 debugging 2 16
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Article by: Nadia
Suppose you use Uber application as a rider and you request a ride to go from one place to another. Your driver just arrived at the parking lot of your place. The only thing you know about the ride is the license plate number. How do you find your U…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now