Excel function to find out daily and monthly growth rates

Hi: I am trying to find an excel formula to use compounding backwards and find monthly and daily growth rates while having an annual growth rate. Example: Year 1 sales = 100. Year 2 Sales = 200. What is the daily growth rate to get from 100 to 200? From there I can create a table with Day | daily rate | Value at day [x] and adjust each month's sales forecast by number of days in the month.

Thanks in advance

Please Login or Register  to view this content.

my question is similar. I have a year end target and need to find the excel function to help me work backwards to find the numbers to get to the target. I have 3 months sales data so need the next 9 months predicted. Ideas?