Time-Value Spreadsheet | JamesClear.com
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGH
1
DIRECTIONS: To copy this sheet for yourself, go to 'File' and choose 'Make a Copy' or 'Download as'.
2
There are 3 examples in this spreadsheet: an hourly worker who makes $35k/year, a salaried worker who makes $65k/year and has a side hustle that makes $8k/year, and an entrepreneur who owns a business that makes $270k/year. All of these numbers are before taxes and expenses, which are also calculated on the spreadsheet. Click on the tabs at the bottom of the sheet to view them.
3
4
STEP 1: TimeMonthly AverageAnnual
5
Total Working Hours208.32500
6
7
STEP 2: MoneyRevenue
8
Annual Income$35,000.00
9
Taxes (25% estimated)$8,750.00
10
Take-Home Pay$26,250.00
11
12
13
Step 3: Realized Income Methods
14
AveragesHourly Rate5-Minute Rate15-Minute RateDaily Rate (10 hours)Weekly Rate (5 days)
15
$9.16$0.76$2.29$91.60$458.00
16
Take-Home Pay MethodRate
17
$26,250.00$10.50$0.88$2.63$105.00$525.00
18
19
Market Rate MethodMarket Rate
20
Alternate Job 1$24,000
21
Alternate Job 2$38,000
22
Average Rate$31,000
23
Taxes (25% estimated)$7,750
24
Take-Home Pay (estimated)$23,250$9.30$0.78$2.33$93.00$465.00
25
26
Cost-Based MethodEstimated RateTime Split
27
Potential Employee for Task 1$20,00040%
28
Potential Employee for Task 2$28,00020%
29
Potential Employee for Task 3$30,00040%
30
Weighted Average Rate$25,600100%
31
Taxes (25% estimated)$6,400
32
Take-Home Pay (estimated)$19,200$7.68$0.64$1.92$76.80$384.00
33
34
STEP 4: Expected Value Methods
35
*See the Entrepreneur Example tab at the bottom of this spreadsheet.
36
Loading...
 
 
 
Hourly Worker Example ($35k)
Salaried Worker Example ($65k + $8k)
Entrepreneur Example ($270k)