Financial Excel Templates - Value Analysis Calculator for Product

Value Analysis Calculator for Product/Service Q1 BENEFITS Increased revenue Reduced costs Avoided costs Quarterly total Cumulative value $0 0 13 $13 $13 $293 33 26 $353 $366 $587 67 39 $692 $1,058 $880 100 52 $1,032 $2,090 Q2 Q3 Q4 INVESTMENTS One time investment Ongoing investment Quarterly total Cumulative investment ($641) (97) ($738) ($738) ($271) (30) ($301) ($1,039) $0 (30) ($30) ($1,069) $0 (30) ($30) ($1,099) NET VALUE Quarterly total Cumulative total ($725) ($725) $52 ($673) $662 ($11) $1,002 $991 1st year net return Breakeven point ROI (1st year) $991,000 4th Quarter 90.17%