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/-+ 4th year 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 -~----------~----~----~----~------~----~------~--~---
