The Postal Service Analysis-need asap

profilecoolstudent1
attachments_20131012-1.zip

1.jpg

2.jpg

3.jpg

4.jpg

5.jpg

6.jpg

7.jpg

Copy 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

Sheet2

Sheet3