Project is to create a 1 year financial projection for a company that sells internet subscription.

need to show a 1 year projection for a subscription business model. The project needs to show what the revenue would look like if we were selling monthly internet subscriptions. Monthly retail and modem fee combined will be $79.90. From a revenue stand point, how much would we be projecting?  Listed the monthly sales but 10% of it churns every month. We need to also factor in 85% of activation rate for the active users. You can ignore the 10% churn on the starting month, starting with 2500 sales, 85% activation rate so 2125, and go from there.

COR Price: $45Churn10%Retail Price:$64.95Activation rate85%Monthly modem fee:$14.95One time activation fee per sub$79.95MonthSalesChurnActive UsersRevJan-252500Feb-254000400Mar-256000600Apr-257000700May-258000800Jun-259000900Jul-25100001000Aug-25100001000Sep-25100001000Oct-25100001000Nov-25100001000Dec-25100001000

COR Price:
$45
Retail Price:
$64.95
Modem fee:
$14.95
One time activation fee per sub$79.95
Month
Sales
Churn Active Users
Jan-25
2500
Feb-25
4000
400
Mar-25
6000
600
Apr-25
7000
700
May-25
8000
800
Jun-25
9000
900
Jul-25
10000
1000
Aug-25
10000
1000
Sep-25
10000
1000
Oct-25
10000
1000
Nov-25
10000
1000
Dec-25
10000
1000
Rev
2125
4972.5
Churn
Activation rate
10%
85%