Access over 20 million homework & study documents
search

FIN 445 Book Values Net Present Values 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

Gadget Division - UDA Proposal Machinery Costs ($) Modification Costs ($) Plant & Properties Opportunity Costs ($) Salvage Value - Plant ($) Salvage Value - Machinery ($) $ $ $ $ Cost of Capital (%) Tax Rate (%) Positive side effect Operating Cash Flow ($) 120,000,000 15,000,000 20,000,000 12,000,000 0 $ 15% 21% 21,000,000 $ $ YEAR 1 2,300,000 650.00 520.00 BASE SCENARIO (Most Common Approach for OCF) Initial Cash outflow ($) $ 150,800,000 Annual Sales Volume (units) Unit Price ($) Unit Production Costs ($) Incremental Revenues ($) Incremental Costs ($) Depreciation ($) EBIT ($) Taxes ($) $ 1,495,000,000 $ 1,196,000,000 $ $ $ 44,995,500 254,004,500 53,340,945 INCREMENTAL OPERATING CASH FLOWS, OCF ($) POSITIVE SIDE EFFECT OPERATING CASH FLOW ($) $ 245,659,055 $ 21,000,000 $ $ 83,720,000 83,720,000 (150,800,000) $ 182,939,055 Net Working Capital ($) CHANGE in NET WORKING CAPITAL ($) $ - TERMINAL CASH FLOW ($) INCREMENTAL CASH FLOW TO PROJECT ($) $ NET PRESENT VALUE, NPV ($) Internal Rate of Return, IRR $223,861,773.87 105.28% OPTIMISTIC SCENARIO (Most Common Approach for OCF) Initial Cash outflow ($) $ 150,800,000 YEAR 1 Annual Sales Volume (units) Unit Price ($) Unit Production Costs ($) $ $ Incremental Revenues ($) Incremental Costs ($) Depreciation ($) EBIT ($) Taxes ($) $ 1,495,000,000 $ 1,196,000,000 $ $ $ $ 44,995,500 254,004,500 53,340,945 $ 245,659,055 $ 21,000,000 $ $ 83,720,000 83,720,000 (150,800,000) $ 182,939,055 I ...
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
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4