Select any two data assets identified in the image BELOW and apply the IVI, CVI, and EVI valuation models to them in a worksheet. Then
Select any two data assets identified in the image BELOW and apply the IVI, CVI, and EVI valuation models to them in a worksheet. Then using the CVI and EVI, calculate the net asset value (NAV) of each data asset. For the CVI, use only current or previous year variable costs and or amortized fixed costs (excluding indirect costs) that can be allocated to generating or acquiring, managing, and storing the data asset. Be sure to consider (estimate) how these costs are allocated to each particular data asset. Document any estimates or assumptions about the terms in the model. For completeness and best practice, be sure to document the formulas used and/or use named ranges in the worksheet.Make a worksheet or set of worksheets (in a single workbook) that document the inputs and assumptions and performs the calculations. They should enable a side-by-side comparison of valuations for the two data assets you selected.
Degree of Information assets Type of information Business meaning Volume utilization Velocity Variety Too big to fit in an Excel spreadsheet, stored in a 1 Quantity of products competitors supplied to customers External data Estimate market share 12 data portal Quarterly Several third party logistic companies Shipment reports from many different suppliers which include order number, 2 Quantity of each product supplied Data from business partners Operation managment 1 Over 100,000 units Daily tracking number, and quantity supplied. Invoices from many different suppliers Accounting and auditing which include prices and gross prices 3 Price of product Data from business partners purposes 1 Over 100,000 units Daily minus fees Inventory reports on various types of Internal critical operational products received and if there were any 4 Product status data Operation managment 1 Over 100,000 units Daily issues Strategy and pricing Price data from many different public 5 Competitors' prices Public information decisions 2 Over 50 rows As needed sources Receipts from paying rent, utilities, and 6 Maintenance expenses Data from business partners Manage expenses Over 50 rows Monthly service providers Receipts from purchasing flights, hotels, 7 Corporate travel expenses Data from business partners Manage expenses Over 50 rows Monthly and rental cars Internal critical operational 8 Sales data Track revenue Over 20 Rows Monthly Sales reports from each hospital Feedback data from many different 9 Customer satisfaction Data from business partners |Quality management 2 Over 50 rows Monthly hospitals Reports from third party advertising 10 Marketing metrics Data from business partners Marketing strategy 13 Over 20 Rows Monthly companies Source: Interview with John, Senior Manager of Finance for a start- up company selling surgery drugs to hospitals