louisville - 6533000 5137000 DOCF 1087500 7085459 6023796...

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

View Full Document Right Arrow Icon
Exogrid Pro Forma Statement Capital Spending Year 1 2 3 4 5 6 sale per unit(1st 3 years) 350 MACRS Table Volume 75000 125000 50000 90000 80000 65000 sale per unit(2nd 3 years) 300 1 14.29% Sales 26250000 43750000 17500000 27000000 24000000 19500000 Equipment cost 25000000 2 24.49% Loss of Sales 3400000 3400000 3400000 variable cost(per unit) 145 3 17.49% Loss of Revenue(warri 4350000 3600000 2100000 fixed cost(per year) 3000000 4 12.49% Net Revenue 18500000 36750000 12000000 27000000 24000000 19500000 Tax 40% 5 8.93% Variable 9685000 16935000 6060000 13050000 11600000 9425000 required return 12% 6 8.92% Fixed 3000000 3000000 3000000 3000000 3000000 3000000 NWC(fromsales) 20% Depriciation 3572500 6122500 4372500 3122500 2232500 2230000 marketing study 225000 EBT 2242500 10692500 -1432500 7827500 7167500 4845000 resale value 3500000 Taxes 897000 4277000 573000 3131000 2867000 1938000 Book value 3347500 Net Income 1345500 6415500 -859500 4696500 4300500 2907000 After tax SV 3439000 OCF 4918000 12538000 3513000 7819000
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6533000 5137000 DOCF 1087500 7085459 6023796 3062562 4047456 6776698 NPV IRR 15.53% NWC Change in NWC Year 0-25000000 year 1-3700000 -3700000 Year 1 1218000 year 2 7350000 -3650000 Year 2 8888000 1.75588 year 3 2400000 4950000 Year 3 8463000 year 4 5400000 -3000000 Year 4 4819000 year 5 4800000 600000 Year 5 7133000 year 6 3900000 900000 Year 6 13376000 Total 20150000 3900000 Final $2,753,098.82 Payback Period Payback Period Discount-ed PP Profitabil-ity Warrior With Exogrid Warrior without exogrid Current cost 200 Year 1 2 3 1 75000 Discount Rate 125 Volume 75000 58000 48000 28000 2 65000 Erosion 75 Sales 4350000 3600000 2100000 3 45000 Variable(per unit) 70 Fixed cost(per year) 2150000 Volume Decrementals Loss of units/year 17000 1 58000 loss of sales 3400000 2 48000 Variable costs 1190000 3 28000...
View Full Document

This note was uploaded on 01/20/2012 for the course FIN 310 taught by Professor Staff during the Fall '11 term at The University of Akron.

Page1 / 2

louisville - 6533000 5137000 DOCF 1087500 7085459 6023796...

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

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