Finance questions with excel worksheet

Part 1
    Number of Visitors    1,000,000
    % Visitors which registers    27%
    Number of people which register    270000
    % People taking Premium subscription    5%
    Number of People taking subscription    13500
    Upfront Cost per Subscription    $ 4.95
    Revenue from Upfront Cost    $ 66,825.00
    Additional Charge after 8 days    $ 34.95
    % of People not cancelling the subscription    17%
    Number of People not cancelling subsciption    2295
    additional Revenue after 8 days    $ 80,210.25
    Additonal Charge every 30 days    1    2    3    4    5    6    7    8    9    10    11    12
    Number of People not cancelling subsciption    1262    1010    808    646    517    414    331    265    212    169    136    108
    Revenue    $ 44,116    $ 35,293    $ 28,234    $ 22,587    $ 18,070    $ 14,456    $ 11,565    $ 9,252    $ 7,401    $ 5,921    $ 4,737    $ 3,790
    Total Revenue Earned    $ 352,455.42
    Add: 2% ecommerce fee    $ 7,049.11
    (a). Total Revenue for cohort of clicks    $ 359,504.53
    (b). Life time value of 1 subscriber    $ 459.30
    (c) Value of one click    $ 0.36
    (d). Value of 1 registrant    $ 26.63
Part 2
    Number of Visitors    1,000,000
    % Visitors which registers    0.3
    Number of people which register    300000
    % People taking Premium subscription    0.05
    Number of People taking subscription    15000
    Upfront Cost per Subscription    $ ...