A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Instructions: Cells for your input are marked in white or light grey. Autocalculated cells are in dark grey. Instructions are in pink. | |||||||||||||
2 | If you see a little black triangle in the cell's top right corner, it means there's a note with instructions. Please hover over the cell to read the note. There are 6 tabs on this spreadsheet. Please make sure you check them all! You have a writing tracker and admin tracker for hours tracking! Here's a video tutorial on the pricing calculator: https://youtu.be/zz46HIJz5Vo | |||||||||||||
3 | STEP 1: Enter your desired Hourly Rate for WRITING: | $ 15.00 | ||||||||||||
4 | STEP 2: Enter your Desired Hourly Rate ADMIN: | $ 15.50 | ||||||||||||
5 | ||||||||||||||
6 | STEP 3: On this page (below) Enter your subscription tier information. Keep this updated with numbers of subscribers per tier. | |||||||||||||
7 | ||||||||||||||
8 | STEP 4: Fill out your EXPENSEES sheet, Writing Tracker, and Admin Tracker | |||||||||||||
9 | TIER PRICE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEPT | OCT | NOV | DEC | |
10 | Tier 1 | $ 5.00 | 2 | 3 | 6 | 8 | 10 | 15 | 20 | 25 | 30 | |||
11 | Tier 2 | $ 10.00 | 2 | |||||||||||
12 | Tier 3 | $ 20.00 | 4 | 5 | 7 | |||||||||
13 | Tier 4 | $ 25.00 | ||||||||||||
14 | Tier 5 | $ 30.00 | ||||||||||||
15 | Tier 6 | $ 35.00 | 1 | 2 | 3 | 5 | ||||||||
16 | Tier 7 | $ 40.00 | ||||||||||||
17 | Tier 8 | $ 45.00 | 2 | |||||||||||
18 | Tier 9 | $ 50.00 | ||||||||||||
19 | Tier 10 | $ 100.00 | ||||||||||||
20 | Tier 11 | $ 150.00 | ||||||||||||
21 | Tier 12 | $ 200.00 | ||||||||||||
22 | TOTAL SUBSCRIBERS | 7 | 3 | 12 | 13 | 10 | 18 | 27 | 25 | 35 | ||||
23 | GROSS INCOME | $ 125.00 | $ 15.00 | $ 210.00 | $ 140.00 | $ 50.00 | $ 180.00 | $ 240.00 | $ 125.00 | $ 325.00 | $ - | $ - | $ - | |
24 | EXPENSES/READER | $ (116.35) | $ (20.16) | $ (7.04) | $ (5.70) | |||||||||
25 | ACTUAL NET INCOME | $ 8.65 | $ (5.16) | $ 202.96 | $ 134.30 | $ 50.00 | $ 180.00 | $ 240.00 | $ 125.00 | $ 325.00 | $ - | $ - | $ - |