Solved

# How to prorate a yearly subscription

Posted on 2010-11-16
499 Views
Last Modified: 2012-06-27
Hello Experts!

I'm creating a subscription-based calculator in Java and I'm trying to figure out how to correctly prorate the value if the subscription.
My yearly subscription fee is a flat \$120 per year (365 days).  If a user wants only a 6 month subscription then the cost is \$60.  But let's say the subscriber signs on Jan. 15, 2011 and ends his subscription on June 30.  That's only 5 months and 15 days.  I need a formula that can correctly calculate the amount I need to charge.  In this case it would be ~\$55.00.  It gets a little trickier if my user signs on Feb. 6th and ends their subscription Dec. 28.
Can anyone help?
0
Question by:Greengiants15
• 4
• 4
• 3
• +2
15 Comments

LVL 86

Expert Comment

ID: 34149226
Why not calculate per day?
0

LVL 20

Expert Comment

ID: 34149269
The formula you are looking for is -

120/365 * No of days

0

LVL 58

Expert Comment

ID: 34149274
As CEHJ has pointed out it is easier to calc the daily amount, then multiply by the number of days.
Obviously the amount per day is fuzzy due to leap years, so one month in July could cost just fractionally less on a leap year.

days in year = 1/1/next - 1/1/current
days subscribed = last - first + 1
amount to pay = days subscribed / days in year * \$120
0

LVL 86

Assisted Solution

CEHJ earned 100 total points
ID: 34149347
See below (though you would put 'PER_YEAR' as a class variable)

http://technojeeves.com/joomla/index.php/free/71-difference-between-two-dates-in-java
``````public static double getSub(Date d1, Date d2) {
final double PER_YEAR = 120;
long days = TimeDiff.getTimeDifference(d1, d2, TimeDiff.TimeField.DAY);
return (double)(days * PER_YEAR / 365);
}
``````
0

LVL 58

Expert Comment

ID: 34149374
I stress again that you need the +1 in

last - first + 1

Otherwise, you will never get the full year in 1/1 - 31/12, you will be short 1 day
Not only that, a subscription for 7/7-7/7 will result in 0 days, when common sense says 1?
0

LVL 92

Expert Comment

ID: 34149755
0

Author Comment

ID: 34149770
All - thank so so much for your solutions.  I do have one caveat.  What if a user starts their subscription on Feb.15, 2010 and ends their subscription March 15.  Really, I should charge the user \$10 since it's one month but with the formula given:
days * PER_YEAR / 365
That would be:
29 *120 / 365 = 9.53

I guess for situations like this I would have to write a separate condition to calculate something like this?
0

LVL 92

Expert Comment

ID: 34149834
then you want to count the # months instead of # days

0

Author Comment

ID: 34149854
objects - so are you saying that if I have a situation like this:
Start date: 2/15/2010
End date: 3/30/2010

I first have to calculate the number of months then calculate the number of days?
0

LVL 58

Assisted Solution

cyberkiwi earned 100 total points
ID: 34149864
(sidenote: Banks are happy to pay me less than 1/12 of the annual rate between 15/2 and 15/3!)

If you are not going by daily rate, then a stepped calculation may work better

Is full year? \$120
Is start = end?  \$120 / days in year (minimum of 1 day)
else:
d = start
months = 0
days = 0
while d < end {
add 1 month to d
months++
}
while d < end {
add 1 day to d
days++
}
calc = (months + days / 30.0) * \$120 / 12

Notes:
It is possible to have 3 months 30 days which is 1 day less than 4 months in some cases, but you will charge 4 months exactly.
It is also possible to charge 27 days in feb (27/28) at 27/30 of the monthly rate.
Give some take some.
0

LVL 92

Expert Comment

ID: 34149870
what you have to do depends on how you want to charge :)
0

Author Comment

ID: 34150120
I want to charge \$10 for a month, 120 for a year and prorate the days if it falls over a month.
0

Author Comment

ID: 34150448
Is there a way to calculate the number of months?
Ex:
1/15/2010
to
6/15/2011

=

5 months
0

LVL 86

Expert Comment

ID: 34150481
Using months is not going to help you. They have different numbers of days
0

LVL 92

Accepted Solution

objects earned 300 total points
ID: 34150597
yes you can use the Calendar class to get the month

and you can take your start and end date and increment the month of the start until they are  both in the same month

http://helpdesk.objects.com.au/java/how-do-i-add-a-specified-number-of-months-to-a-java-date

then calculate the #days as I posted above
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is about my first experience with programming Arduino.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, itâ€™s also â€¦
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files â€” any plâ€¦

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

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