Access over 20 million homework & study documents
search

Financial Values and Payback Periods Worksheet

Content type

User Generated

Subject

Accounting

Type

Worksheet

Rating

Showing Page:
1/8

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/8

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/8

Sign up to view the full document!

lock_open Sign Up

Unformatted Attachment Preview

Fran Assumptions Annual Output (metric tons) Output Gain/Original Output Price/ton (pounds sterling) Inflation Rate (prices and costs) Gross Margin (ex. Deprec.) Old Gross Margin Energy Savings/Sales Yr. 1-5 Yr. 6-10 Yr. 11-15 250.000 7,0% 675 0,0% 12,50% 11,5% 1,25% 0,75% 0,0% Now 1 2008 Year 1. Estimate of Incremental Gross Profit New Output (tons) Lost Output--Construction New Sales (Millions) New Gross Margin New Gross Profit Old Output Old Sales Old Gross Profit Incremental Gross Profit 2. Estimate of Incremental WIP inventory New WIP inventory Old WIP inventory Incremental WIP inventory 3. Estimate of Incremental Depreciation New Depreciation 4. Overhead Discount rate Tax Rate Investment Outlay (m Depreciable Life (yea Salvage Value WIP Inventory/Cost o Months Downtime, C Preliminary Engineeri Overhead/Investment 2 2009 3 2010 267.500 (33.438) 157,99 13,8% 21,72 267.500 250.000 168,75 19,41 2,32 250.000 168,75 19,41 5,42 250.000 168,75 19,41 5,42 4,09 4,48 -0,39 4,67 4,48 0,19 4,67 4,48 0,19 1,60 0,42 1,39 0,42 1,20 0,42 180,56 13,8% 24,83 267.500 180,56 13,8% 24,83 5. Prelim. Engineering Costs Pretax Incremental Profit 6. Cash Flow Adjustments Less Capital Expenditures Add back Depreciation Change of WIP inventory 7. Free Cash Flow -12,00 NPV = IRR = £10,57 24,3% Average annual addition to EPS= Payback Period= 0,022 92,8912 Outstanding shares (given in the ca 3,78 years -12,00 0,50 -0,20 3,61 3,80 1,60 0,39 1,85 1,39 -0,58 3,33 1,20 ...
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
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4