CAPITAL BUDGETING TEMPLATE

CAPITAL BUDGETING TEMPLATE Copyright © 2007 ACBA - All Rights Reserved Assumptions Initial depreciable Investment 1st year relative value units Sales price per unit Variable cost per unit Depreciation (3,5,7,10,15, or 20) Tax Rate Working Capital % of Revenue Initial non-depreciable Investment Units growth rate Inflation Assumption 1st yr Fixed Costs 0.0% 0.0% 0.0% 0.0% Salvage value Weighted Aver Cost of Capital 0.0% 0 Initial Investment Total Units Sold Revenue Variable Costs Fixed Operating Costs Depreciation EBIT Taxes NOPAT Add Back Depreciation Operating Cash Flow Net Operating Working Capital: Working Capital based on Revenue Cashflow due to NOWC Salvage Cashflow: Net Salvage cashflow Book value of asset gain or loss on sale taxes on gain or loss on sale Net cashflow on salvage Net cashflow Internal Rate of Return Net Present Value #NUM! $ 0 0 1 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0