Access over 20 million homework & study documents
search

Victoria Chemicals Analysis of Rotterdam Project Worksheet

Content type

User Generated

Subject

Accounting

Type

Worksheet

Rating

Showing Page:
1/14

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/14

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/14

Sign up to view the full document!

lock_open Sign Up

Unformatted Attachment Preview

Assumptions Annual Output (metric tons) Output Gain Per Year/Prior Year Maximum Possible Output Price/ton (pounds sterling) Inflation (prices and costs) Gross Margin Growth Rate/Year Maximum Possible Gross Margin Gross Margin Tax Rate Investment Outlay (millions) 1. Estimate of Incremental Gross Profit 2. Estimate of Incremental Depreciation 3. Overhead 4. Pretax Incremental Profit 5. Tax Expense 6. After-tax Profit 7. Cash Flow Adjustments 8. Free Cash Flow DCF, Rotterdam = IRR, Rotterdam = 9. Adjustment for erosion in Merseyside volume: Lost Merseyside Output Lost Merseyside Revenue Lost Merseyside Gross Profits Lost Gross Profits after Taxes Change in Merseyside Inventory Total Effect on Free Cash Flow DCF, Erosion Merseyside Cash flows after erosion DCF, Rotterdam Adjusted for Full Erosion at Merseyside = Exhibit 1 VICTORIA CHEMICAL ANALYSIS OF ROTTERDAM (Financial values in millions of B Year New Output Lost Output--Construction New Sales (Millions) New Gross Margin New Gross Profit Old Output Old Sales Old Gross Profit Incremental Gross Profit Yr. 1 Outlays Yr. 2 Outlays Now 2008 2009 2010 250.000 2,0% 267.500 675 0,0% 0,5% 15,0% 11,5% 30,0% 3,5 5 1 1 0 Now 1 2008 2 2009 255.000 260.100 (106.250) (86.700) 100,41 117,05 11,5% 12,0% 11,55 14,05 250.000 250.000 168,75 168,75 19,41 19,41 (7,86) (5,36) 0,67 0,58 0,14 Yr. 3 Outlays Total, New Depreciation Add back Depreciation Less added WIP inventory Capital Spending Terminal Value, land (3,50) (3,50) 0, ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4