|
File size: 9KB
Description of data:
rating=overall rating by the IAP
rdt=total $ R&D cash outlays in current value
rdmonth = calendar months of R&D
rele_m = month when product released on market
rele_y = year when product released on market
q5month = month when product was taken off the market
q5month = year when product was taken off the market
first, second, .. = $ sales in first year, second year, etc.
margin = average gross profit margin over all years
r = internal rate of return [solved for]
CPI = Canadian consumer price index (average) between 1976
and 1993
R = NPV of profit stream, year 0
R in 1995 [row AF] is computed using the formula =AE3*(1+AD3)^(95-E3)
TOTAL d in 1995 [row AG] is computed using the formula =B3*(1+AD3)^(95-E3)
Download data now
Data_to_EJ.xls
(9KB)
|