Thank you friend, i didn't create any excel file for that, this my concept , I new to VBA, i didnt know how to start,
sorry for the inconvenience caused On Fri, Oct 30, 2009 at 1:28 PM, sudhir kumar <bluecore...@gmail.com> wrote: > *Hi friends it is interesting, * > *can u sent me attachement > * > > On 10/29/09, grlinks-karthik <grli...@gmail.com> wrote: >> >> I need to calculate in interest excel sheet could any one help me with? >> >> >> >> Its like insurance calculation method, user will pay premium yearly >> basis, Period 20 years >> >> Conditions >> >> 1. Bonus will be calculated from 4th year onwards >> >> 2. 1 year -30%, 2nd year 10%, 3 year -10% will be deducted from >> user premium for administration charges >> >> 3. Bonus percentage Rs-10% for every year (from 4th year only >> bonus can be calculate) >> >> 4. Calculation method >> >> a. 1st three year ( after deducting admintration charges) *10% >> >> For example if user pays Rs-10000/- per year premium then >> >> 1. 10000*30%=3000/- so balance is Rs-7000/- will be accountable 1styear >> >> 2. 10000*10%=1000/- so balance is Rs-9000/- will be accountable 2styear >> >> 3. 10000*30%=1000/- so balance is Rs-9000/- will be accountable 3styear >> >> So net total will be in 4 th year (7000+9000+9000)= Rs-25000/-+ 4thyear >> premium +10% bonus >> >> >> >> From 4th year onwards user will get 10 % bonus upto 20 years premium >> >> >> >> So calculation will be >> >> >> >> Pervious year Premium+ bonus+current year premium+bonus >> >> 4th year : 25000+10% = 27500+10000 >> >> 5th year :- 37500+10%= 41250+10000 >> >> 6th year :- 51250+10%= 56375+10000 >> >> >> >> Like this I need to generate up to 20 years >> >> >> >> How to geneate Using VBA >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
