Financial Excel Templates - Value Analysis Calculator for Product

Document Sample
Financial Excel Templates -  Value Analysis Calculator for Product
Shared by: bipin kamath
Categories
Tags
Stats
views:
1005
posted:
2/23/2008
language:
English
pages:
1
Value Analysis Calculator for Product/Service



Q1 Q2 Q3 Q4



BENEFITS

Increased revenue $0 $293 $587 $880

Reduced costs 0 33 67 100

Avoided costs 13 26 39 52

Quarterly total $13 $353 $692 $1,032

Cumulative value $13 $366 $1,058 $2,090





INVESTMENTS

One time investment ($641) ($271) $0 $0

Ongoing investment (97) (30) (30) (30)

Quarterly total ($738) ($301) ($30) ($30)

Cumulative investment ($738) ($1,039) ($1,069) ($1,099)





NET VALUE

Quarterly total ($725) $52 $662 $1,002

Cumulative total ($725) ($673) ($11) $991



1st year net return $991,000

Breakeven point 4th Quarter

ROI (1st year) 90.17%


Share This Document


Related docs
Other docs by bipin kamath
Layaway Record[6]
Views: 85  |  Downloads: 18
RESOLUTIO[2]
Views: 15  |  Downloads: 0
Free Power Point Templates - hip blue
Views: 187  |  Downloads: 23
Application for use[2]
Views: 37  |  Downloads: 0
ASSIGNMENT OF DEED OF TRUST[5]
Views: 59  |  Downloads: 1
assignment_copyright[1]
Views: 62  |  Downloads: 2
Powerpoint Templates- Y2K
Views: 145  |  Downloads: 8
OATH OR AFFIRMATION
Views: 82  |  Downloads: 0
Application for Medicare Savings Programs
Views: 92  |  Downloads: 0
by registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!