Human Capital Spreadsheet

This spreadsheet is designed to calculate a personal extended balance sheet. It accounts for mortality and inflation and shows the breakdown between liabilities and equity across time. This a template, meaning you can copy it down and save it to your own Google Drive. You can also see the math that I used to arrive at the conclusions that I did. All cells in blue are editable and all cells in red should remain unchanged. I will also be updating this over time, and I will email along new versions as they become available. If there are any issues, you can always reach out to me at alexwarfel@gmail.com.

NOTE: You do need to have a Google account to access this.