This model generates a number of schedules to help you understand and manage your US Treasury activity. All input and output data is stored in your spreadsheet. Schedule data generated by Numbrz is presented using pivot tables for easy manipulation.

Monthly schedules included:

1. Interest income earned
2. Interest Receivable
3. Treasury Holdings @ purchase price
4. Treasury Holdings @ par value
5. Accounting journal entries for every transaction and accrual.

This model uses outside data for the following:

1. Actual auction pricing results per the Treasury Direct website.
2. Expected future TBill rates per my expectations.

This model is free to use. If you want to support my efforts to develop these calculations, you can send me requests for additional calculations or contribute financially.

Next up, I'll add the option for users to include their own TBill rate forecasts. I also expect to support Treasury Notes soon.

Finally, We're considering creating a community version that will add optional participation in peer interest rate expectations. Let me know if you have thoughts on this.

Enjoy!