Need Capital Equipment Justification Form 2

[lastshadow]

I nned a simple Capital Equipment Cost Justification form. I did a web search but found nothing useful. Anyone having one you wouldn't mid sharing please email to scottm@peakindustries.com

 

[Al]

Try this:<br>
It was prepared in Excel: <br>
2000 2001 2002 2003 2004 2005<br>
<br>
Revenues $100 $200 $300 $400 $500 $600 <br>
<br>
Expenses $300 $200 $100 $100 $100 $100 <br>
<br>
Net cash flow ($200) $0 $200 $300 $400 $500 <br>
<br>
<br>
Discount rate 7.0% <br>
<br>
DCF ($200) $0 $175 $245 $305 $356 <br>
Cumulative DCF ($200) ($200) ($25) $220 $525 $881 <br>
<br>
NPV $881 $881 <br>
<br>
IRR 62%<br>