For Year 2 ..>>>If this trend continues but only with 5% new customer growth Month on month from 13 to 24th month , what would be revenue for year 2 assuming refills and customers from year one stay...
Let's calculate the revenue for Year 2 (Month 13-24).
New Customers (5% growth month-on-month)
- Month 13: 7086 * 1.05 = 7440 * $420 = $3,124,800
- Month 14: 7440 * 1.05 = 7812 * $420 = $3,281,040
- Month 15: 7812 * 1.05 = 8202 * $420 = $3,444,840
- Month 16: 8202 * 1.05 = 8612 * $420 = $3,617,040
- Month 17: 8612 * 1.05 = 9042 * $420 = $3,797,640
- Month 18: 9042 * 1.05 = 9494 * $420 = $3,987,480
- Month 19: 9494 * 1.05 = 9968 * $420 = $4,186,560
- Month 20: 9968 * 1.05 = 10466 * $420 = $4,395,720
- Month 21: 10466 * 1.05 = 10989 * $420 = $4,615,380
- Month 22: 10989 * 1.05 = 11538 * $420 = $4,846,160
- Month 23: 11538 * 1.05 = 12115 * $420 = $5,088,300
- Month 24: 12115 * 1.05 = 12721 * $420 = $5,342,820
Total revenue from new customers (Year 2): $3,124,800 + $3,281,040 + $3,444,840 + $3,617,040 + $3,797,640 + $3,987,480 + $4,186,560 + $4,395,720 + $4,615,380 + $4,846,160 + $5,088,300 + $5,342,820 = $48,727,780
Refills (assuming all customers from Year 1 stay)
- Month 13: 52948 * $420 = $22,238,160 (as calculated earlier, but for simplicity, let's assume the customer base grows to 52948 + 7086 = 60034 by the end of year 1 and stays consistent for refill calculations)
- Let's assume the average customer base for Year 2 refills is around 60034 + 10000 (avg new customers) = 70034
- Average monthly refill revenue: 70034 * $420 = $29,414,280
Total refill revenue (Year 2): $29,414,280 * 12 = $352,971,360
Total Year 2 Revenue
$48,727,780 (new customers) + $352,971,360 (refills) = $401,699,140
In AUD (using the exchange rate 1 USD = 1.5 AUD): $401,699,140 * 1.5 = AUD 602,548,710.
(20min delay)