{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Risk Assessment Scorecard","Sample 1—Competitive Risk","Sample 2—Operational Risk"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Risk Assessment Scorecard","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"merged":[[26,1,26,2]],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Risk Assessment and Financial Impact Model"]
[null,"[Date]"]
[]
[null,"Gray cells are calculated for you. You do not need to enter anything into them."]
[null,"Risk area","Potential risk","Number of annual incidents","Cost per incident","Total annual cost","Probability of occurrence","Weighted cost","Mitigating strategies & controls","Annual control cost","Cost/benefit","Decision summary","Owner"]
[null,"Competitive","Contoso, Ltd. might introduce a superior offering on June 30 to compete with our #1 product line.",{"v":1,"d":"1.00"},{"v":1850000,"d":"$1,850,000"},{"v":1850000,"d":"$1,850,000"},{"v":0.75,"d":"75.0%"},{"v":1387500,"d":"$1,387,500"},"Reduce price by 25% on May 31 to keep the volume stable.",{"v":1150000,"d":"$1,150,000"},{"v":237500,"d":"$237,500"},"Monitor competitor progress and implement new strategy if required.","Kirk DeGrasse"]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[null,"Economic/political",{"$nulls":3},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[null,"Regulatory/legal","Need to meet Sarbanes-Oxley 404 (SOX) compliance requirements by target date.",{"v":1,"d":"1.00"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":0.05,"d":"5.0%"},{"v":750000,"d":"$750,000"},"Establish SOX Compliance Office on January 15 to ensure compliance 30 days before required date.",{"v":1200000,"d":"$1,200,000"},{"v":-450000,"d":"($450,000)"},"Despite negative cost/benefit, proceed with SOX compliance because of the company's high visibility.  ","Kim Ralls"]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[null,"Technological","Potential exists for hackers to compromise internal network and obtain confidential customer or employee information.",{"v":5,"d":"5.00"},{"v":4000000,"d":"$4,000,000"},{"v":20000000,"d":"$20,000,000"},{"v":0.1,"d":"10.0%"},{"v":2000000,"d":"$2,000,000"},"Upgrade firewall to latest version; install proxy server in Q2.",{"v":750000,"d":"$750,000"},{"v":1250000,"d":"$1,250,000"},"Continue to monitor technology to ensure that our company's and our clients' information is protected.  Intrusion would have an enormous effect.","Carol Philips"]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[null,"Operational","If a key parts supplier in Eastern Asia suddenly goes out of business, it will risk 25% of production.",{"v":1,"d":"1.00"},{"v":1250000,"d":"$1,250,000"},{"v":1250000,"d":"$1,250,000"},{"v":0.75,"d":"75.0%"},{"v":937500,"d":"$937,500"},"Partner with alternate suppliers to reduce reliance on dominant supplier.",{"v":937500,"d":"$937,500"},{"v":0,"d":"$0"},"Begin negotiating terms with other key suppliers; take care not to lock into minimum volume agreements.","Michiko Osada"]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[null,"Financial",{"$nulls":3},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},{"v":0,"d":"$0"},null,{"v":0,"d":"$0"},null,null,{"v":0,"d":"$0"}]
[null,"TOTALS",null,null,{"v":22100000,"d":"$22,100,000"},{"v":38100000,"d":"$38,100,000"},null,{"v":5075000,"d":"$5,075,000"},null,{"v":4037500,"d":"$4,037,500"},{"v":1037500,"d":"$1,037,500"}]

{"sheet":"Sample 1—Competitive Risk","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"flags":["formulas_cached_only"]}
[null,"Sample—Competitive risk"]
[null,"Scenario:  Contoso, Ltd. introduces superior offering in June to compete with our #1 product line."]
[]
[{"$nulls":4},"Units","Dollars","Annual growth rate"]
[null,"Product X sales—year 1",null,null,9,{"v":5000000,"d":"$5,000,000"},"–"]
[null,"Product X sales—year 2",null,null,10,{"v":5500000,"d":"5,500,000 "},{"v":0.1,"d":"10%"}]
[null,"Product X sales—year 3",null,null,11,{"v":6000000,"d":"6,000,000 "},{"v":0.09090909090909091,"d":"9%"}]
[]
[null,"Projected  sales—year 4 ",null,null,12,{"v":6545454.545454545,"d":"$6,545,455"}]
[]
[null,"First half sales weighting",{"$nulls":3},{"v":0.3,"d":"30%"}]
[null,"Second half sales weighting",{"$nulls":3},{"v":0.7,"d":"70%"}]
[]
[null,"Second half sales at risk",{"$nulls":3},{"v":4581818.181818181,"d":"$4,581,818"}]
[null,"Number of units at risk",{"$nulls":3},8.399999999999999]
[null,"Cost per unit",{"$nulls":3},{"v":500000,"d":"$500,000"}]
[]
[null,"Impact with no mitigation"]
[null,"Sales reduction",{"$nulls":3},{"v":0.4,"d":"40%"},"Note: based on market surveys"]
[null,"Reduced number of units sold",{"$nulls":3},{"v":5.039999999999999,"d":"5.04"}]
[null,"Revised second half product sales",{"$nulls":3},{"v":2749090.9090909082,"d":"$2,749,091"}]
[null,"Revenue impact",{"$nulls":3},{"v":-1832727.2727272725,"d":"($1,832,727)"},"Note: round to $1,850,000 for scorecard"]
[]
[]
[null,"Mitigation through price reduction"]
[null,"Unit price reduction required to maintain volume",{"$nulls":3},{"v":0.25,"d":"25%"},"Note: based on market surveys"]
[null,"Number of units at risk",{"$nulls":3},{"v":8.399999999999999,"d":"8.40"}]
[null,"Revised second half product sales",{"$nulls":3},{"v":3436363.636363636,"d":"$3,436,364"}]
[null,"Revenue impact",{"$nulls":3},{"v":-1145454.545454545,"d":"($1,145,455)"},"Note: round to $1,150,000 on scorecard"]
[]
[null,"Mitigation of competitive impact with price reduction",{"$nulls":3},{"v":687272.7272727275,"d":"$687,273"}]

{"sheet":"Sample 2—Operational Risk","index":2,"n_rows":32,"n_cols":6,"rows_kept":32,"flags":["formulas_cached_only"]}
[null,"Sample—Operational risk"]
[null,"Scenario: Key materials supplier in East Asia goes out of business, risking 25% of production for Product X."]
[]
[null,"Expected Product X revenues—2004",{"$nulls":3},{"v":5000000,"d":"$5,000,000"}]
[null,"Cost of goods sold"]
[null,"Labor",{"$nulls":3},{"v":1000000,"d":"$1,000,000"}]
[null,"Materials",{"$nulls":3},{"v":2000000,"d":"2,000,000 "}]
[null,"Other direct costs",{"$nulls":3},{"v":500000,"d":"500,000 "}]
[null,"Total cost of goods sold",{"$nulls":3},{"v":3500000,"d":"$3,500,000"}]
[null,"Gross margin",{"$nulls":3},{"v":1500000,"d":"$1,500,000"}]
[null,"Margin contribution percentage",{"$nulls":3},{"v":0.3,"d":"30%"}]
[]
[null,"Impact with no mitigation"]
[null,"Reduction in materials availability",{"$nulls":3},{"v":0.25,"d":"25%"}]
[null,"Revised product sales",{"$nulls":3},{"v":3750000,"d":"$3,750,000"}]
[null,"Revenue impact",{"$nulls":3},{"v":-1250000,"d":"($1,250,000)"}]
[]
[]
[null,"Mitigation through new supplier"]
[null,"Reduction in materials availability",{"$nulls":3},{"v":0.1875,"d":"19%"}]
[null,"Revised product sales",{"$nulls":3},{"v":4062500,"d":"$4,062,500"}]
[null,"Revenue impact",{"$nulls":3},{"v":-937500,"d":"($937,500)"}]
[]
[null,"Mitigation of impact with other suppliers",{"$nulls":3},{"v":312500,"d":"$312,500"}]
[]
[null,"Materials breakdown"]
[{"$nulls":4},"% Contribution","Amount"]
[null,"At-risk supplier",null,null,{"v":0.25,"d":"25%"},{"v":500000,"d":"$500,000"}]
[null,"All other suppliers",null,null,{"v":0.75,"d":"75%"},{"v":1500000,"d":"1,500,000 "}]
[null,"Total materials costs",{"$nulls":3},{"v":2000000,"d":"$2,000,000"}]
[]
[null,"Ability to mitigate materials loss through other suppliers",{"$nulls":3},{"v":0.25,"d":"25%"}]