The Postal Service Analysis-need asap
coolstudent1copy_of_po_starter_1.xlsx
Sheet1
The Postal Service Analysis | ||||||
Constants | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
No Saturday delivery cost savings | NA | $ 3,000,000,000 | $ 3,000,000,000 | $ 3,000,000,000 | $ 3,000,000,000 | $ 3,000,000,000 |
Minimum cash needed to start year | NA | $ 2,000,000,000 | $ 2,000,000,000 | $ 2,000,000,000 | $ 2,000,000,000 | $ 2,000,000,000 |
Expected work force | NA | 620,000 | 600,000 | 580,000 | 560,000 | 540,000 |
Expected increase in average compensation | NA | 2% | 2% | 3% | 3% | 4% |
Expected decrease in first class units | NA | 5% | 6% | 7% | 8% | 9% |
Pension and health costs, no pre-funding | NA | $ 3,000,000,000 | $ 3,000,000,000 | $ 3,000,000,000 | $ 3,000,000,000 | $ 3,000,000,000 |
Pension and health pre-funding cost | NA | $ 5,000,000,000 | $ 5,000,000,000 | $ 5,000,000,000 | $ - 0 | $ - 0 |
Expected other than first class revenue | NA | $ 30,000,000,000 | $ 32,000,000,000 | $ 34,000,000,000 | $ 35,000,000,000 | $ 36,000,000,000 |
Interest rate on debt owed | NA | 3.5% | 3.5% | 3.5% | 3.5% | 3.5% |
Expected other operating expense | NA | $ 9,000,000,000 | $ 9,200,000,000 | $ 9,400,000,000 | $ 9,600,000,000 | $ 9,800,000,000 |
Other Business net income | NA | $ 1,000,000,000 | $ 2,000,000,000 | $ 4,000,000,000 | $ 6,000,000,000 | $ 8,000,000,000 |
Inputs | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
Allowed to Enter Other Business? (Y/N) | NA | NA | NA | NA | NA | |
Saturday Delivery Eliminated? (Y/N) | NA | NA | NA | NA | NA | |
Increase in Price of First Class Stamp ($.xx) | NA | |||||
Remove Benefits Pre-Funding? (Y/N) | NA | NA | NA | NA | NA | |
Expected % Change in Energy Prices | NA | |||||
Added attrition in year | NA | |||||
Summary of Key Results | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
Net Income (Loss) in Year | NA | |||||
End-of-year cash on hand | NA | |||||
End-of-year debt owed | NA | |||||
Calculations | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
Average yearly employee compensation | $ 75,000 | |||||
Number of employees | NA | |||||
Total compensation | NA | |||||
Other Business net income | NA | |||||
Cost of first class stamp | $ 0.45 | |||||
Number of first class pieces | 74,000,000,000 | |||||
First class mail revenue | NA | |||||
Pension and health cost | NA | |||||
Transportation cost | $ 6,000,000,000 | |||||
Other operating expense | NA | |||||
Income and Cash Flow Statements | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
Beginning-of-year cash on hand | NA | |||||
Revenue: | NA | |||||
First class mail | NA | |||||
Other mail services | NA | |||||
Other business | NA | |||||
Total revenue | NA | |||||
Costs: | ||||||
Employee compensation | NA | |||||
Pension and health cost | NA | |||||
Transportation cost | NA | |||||
Other operating expense | NA | |||||
Total costs | NA | |||||
Income before interest expense | NA | |||||
Interest expense | NA | |||||
Net Income (Loss) | NA | |||||
Expected capital outlays in year | NA | |||||
Net cash position (NCP) | NA | |||||
Borrowing from government | NA | |||||
Repayment to government | NA | |||||
End-of-year cash on hand | $ 2,000,000,000 | |||||
Debt Owed | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
Beginning-of-year debt owed | NA | |||||
Borrowing from government | NA | |||||
Repayment to government | NA | |||||
End-of-year debt owed | $ 12,000,000,000 |