NPV Excel Example - (Lecture6)

NPV Excel Example - (Lecture6) - $85,000 Tax...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Year 0 1 2 3 4 Revenue $40,000 $55,000 $70,000 $85,000 Depreciation -$45,000 -$45,000 -$45,000 -$45,000 Taxable -$5,000 $10,000 $25,000 $40,000 Tax $1,500 -$3,000 -$7,500 -$12,000 Outlay -$180,000 Revenue $40,000 $55,000 $70,000
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $85,000 Tax $1,500-$3,000-$7,500 -$12,000 Net CF $41,500 $52,000 $62,500 $73,000 PV-$180,000 $37,054 $41,454 $44,486 $46,393 NPV-$10,613 Tax rate 30% Reqd return 12%...
View Full Document

Ask a homework question - tutors are online