Project 3 Assignment excel

Project 3 Assignment excel - Inputs 0 Machine Cost Annual...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Inputs 0 1 2 Machine Cost $2,000,000 Dep % 20.00% 32.00% Annual Units Sold 200,000 Sale Price Per Unit $40.00 Sales $8,000,000.00 $8,000,000.00 Variable Cost Per Unit $25.00 Variable Cost $5,000,000.00 $5,000,000 Annual Fixed Costs $1,000,000 Fixed Costs $1,300,000 $1,300,000 HR Costs $300,000 Dep Expense $400,000.00 $640,000.00 Tax Rate 35% EBIT $1,300,000.00 $1,060,000.00 Cost of Capital 10% Tax Expense $455,000.00 $371,000.00 Inventory build-up in Year 0 $3,000,000 Net Income $845,000.00 $689,000.00 OCF $1,245,000.00 $1,329,000.00 NPV = $2,047,267 Capital Investment IRR = 20.77% Machine ($2,000,000) Total Year 1 Cashflows = $1,245,000 Inventory ($3,000,000) Total CFs ($5,000,000) $1,245,000 $1,329,000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3 4 5 6 19.20% 11.52% 11.52% 5.76% $8,000,000.00 $8,000,000.00 $8,000,000.00 $8,000,000.00 $5,000,000.00 $5,000,000.00 $5,000,000.00 $5,000,000.00 $1,300,000 $1,300,000 $1,300,000 $1,300,000 $384,000.00 $230,400.00 $230,400.00 $115,200.00 $1,316,000.00 $1,469,600.00 $1,469,600.00 $1,584,800.00
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Project 3 Assignment excel - Inputs 0 Machine Cost Annual...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online