{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Datos del producto","Escenarios","Gráficas"],"not_rendered":{"charts":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Datos del producto","index":0,"n_rows":22,"n_cols":6,"rows_kept":22}
["[Nombre de la empresa]"]
["Venta de nuevos productos y modelo de previsión de beneficios: datos del producto "]
["[Fecha]"]
[]
[null,"[Empresa] CONFIDENCIAL"]
["Ventas"]
["Nombre de producto","Artículo"]
["Año 1º: estimación de ventas",100]
["Año 1º: precio por unidad",{"v":400,"d":"400.00 €"}]
["Crecimiento anual comparado del precio por unidad (años 2º a 5º)",{"v":0.05,"d":"5.00%"}]
["Año 1º: volumen de mercado (en dólares)",{"v":50000000,"d":"50,000,000.00 €"}]
["Crecimiento anual comparado del volumen de mercado (años 2º a 5º)",{"v":0.1,"d":"10.00%"}]
["Año 1º: coste variable por unidad",{"v":250,"d":"250.00 €"}]
["Crecimiento anual comparado del coste por unidad (años 2º a 5º)",{"v":0.05,"d":"5.00%"}]
["Año 1º: gastos fijos",{"v":250000,"d":"250,000.00 €"}]
["Tasa de crecimiento anual comparado (años 2º a 5º)",{"v":0.03,"d":"3.00%"}]
["Renta operativa de destino (año 5º)",{"v":100000,"d":"100,000.00 €"}]
["Cuota de mercado de destino (año 5º)",{"v":0.02,"d":"2.00%"}]
[]
["Factores de desnivel","Año 1","Año 2º","Año 3º","Año 4º","Año 5º"]
[]
["Años 2º a 4º (% ventas año 5º)","No disponible",{"v":0.1,"d":"10.0%"},{"v":0.5,"d":"50.0%"},{"v":0.75,"d":"75.0%"},1]

{"sheet":"Escenarios","index":1,"n_rows":22,"n_cols":6,"rows_kept":22}
["[Nombre de la empresa]"]
["Venta de nuevos productos y modelo de previsión de beneficios: escenarios"]
["[Fecha]"]
[]
["La plantilla calculará los importes en gris.",{"$nulls":4},"[Nombre de la empresa] CONFIDENCIAL"]
["Ventas","Año 1º","Año 2º","Año 3º","Año 4º","Año 5º"]
["Precios por unidad",{"$f":"'Datos del producto'!B9","v":{"v":400,"d":"400.00 €"}},{"$f":"B7*(1+'Datos del producto'!$B$10)","v":{"v":420,"d":"420.00 €"}},{"$f":"C7*(1+'Datos del producto'!$B$10)","v":{"v":441,"d":"441.00 €"}},{"$f":"D7*(1+'Datos del producto'!$B$10)","v":{"v":463.05,"d":"463.05 €"}},{"$f":"E7*(1+'Datos del producto'!$B$10)","v":{"v":486.20250000000004,"d":"486.20 €"}}]
["Costes por unidad",{"$f":"'Datos del producto'!B13","v":{"v":250,"d":"250.00 €"}},{"$f":"B8*(1+'Datos del producto'!$B$14)","v":{"v":262.5,"d":"262.50 €"}},{"$f":"C8*(1+'Datos del producto'!$B$14)","v":{"v":275.625,"d":"275.63 €"}},{"$f":"D8*(1+'Datos del producto'!$B$14)","v":{"v":289.40625,"d":"289.41 €"}},{"$f":"E8*(1+'Datos del producto'!$B$14)","v":{"v":303.87656250000003,"d":"303.88 €"}}]
["Gastos fijos",{"$f":"'Datos del producto'!B15","v":{"v":250000,"d":"250,000.00 €"}},{"$f":"B9*(1+'Datos del producto'!$B$16)","v":{"v":257500,"d":"257,500.00 €"}},{"$f":"C9*(1+'Datos del producto'!$B$16)","v":{"v":265225,"d":"265,225.00 €"}},{"$f":"D9*(1+'Datos del producto'!$B$16)","v":{"v":273181.75,"d":"273,181.75 €"}},{"$f":"E9*(1+'Datos del producto'!$B$16)","v":{"v":281377.2025,"d":"281,377.20 €"}}]
["Volumen de mercado",{"$f":"'Datos del producto'!B11","v":{"v":50000000,"d":"50,000,000.00 €"}},{"$f":"B10*(1+'Datos del producto'!$B$12)","v":{"v":55000000.00000001,"d":"55,000,000.00 €"}},{"$f":"C10*(1+'Datos del producto'!$B$12)","v":{"v":60500000.000000015,"d":"60,500,000.00 €"}},{"$f":"D10*(1+'Datos del producto'!$B$12)","v":{"v":66550000.00000002,"d":"66,550,000.00 €"}},{"$f":"E10*(1+'Datos del producto'!$B$12)","v":{"v":73205000.00000003,"d":"73,205,000.00 €"}}]
[]
["Escenario 1: Basado en la renta operativa de destino"]
["Ventas por unidades",{"$f":"'Datos del producto'!B8","v":{"v":100,"d":"100.00 €"}},{"$f":"'Datos del producto'!C22*$F$13","v":{"v":209.17331221730316,"d":"209.17 €"}},{"$f":"'Datos del producto'!D22*$F$13","v":{"v":1045.8665610865157,"d":"1,045.87 €"}},{"$f":"'Datos del producto'!E22*$F$13","v":{"v":1568.7998416297737,"d":"1,568.80 €"}},{"$f":"(F9+'Datos del producto'!B17)/(F7-F8)","v":{"v":2091.7331221730315,"d":"2,091.73 €"}}]
["Ventas en dólares",{"$f":"B13*B7","v":{"v":40000,"d":"40,000.00 €"}},{"$f":"C13*C7","v":{"v":87852.79113126732,"d":"87,852.79 €"}},{"$f":"D13*D7","v":{"v":461227.15343915345,"d":"461,227.15 €"}},{"$f":"E13*E7","v":{"v":726432.7666666667,"d":"726,432.77 €"}},{"$f":"F13*F7","v":{"v":1017005.8733333334,"d":"1,017,005.87 €"}}]
["Renta operativa",{"$f":"B14-(B13*B8)-B9","v":{"v":-235000,"d":"-235,000.00 €"}},{"$f":"C14-(C13*C8)-C9","v":{"v":-224555.20332577475,"d":"-224,555.20 €"}},{"$f":"D14-(D13*D8)-D9","v":{"v":-92264.81746031746,"d":"-92,264.82 €"}},{"$f":"E14-(E13*E8)-E9","v":{"v":-769.4624999999651,"d":"-769.46 €"}},{"$f":"F14-(F13*F8)-F9","v":{"v":100000,"d":"100,000.00 €"}}]
["Cuota de mercado",{"$f":"B14/B10","v":{"v":0.0008,"d":"0.08%"}},{"$f":"C14/C10","v":{"v":0.001597323475113951,"d":"0.16%"}},{"$f":"D14/D10","v":{"v":7.6235893130438565E-3,"d":"0.76%"}},{"$f":"E14/E10","v":{"v":0.010915593789130977,"d":"1.09%"}},{"$f":"F14/F10","v":{"v":0.013892573913439423,"d":"1.39%"}}]
[]
["Escenario 2: Basado en la cuota de mercado de destino"]
["Ventas por unidades",{"$f":"'Datos del producto'!B8","v":100},{"$f":"'Datos del producto'!C22*$F$19","v":{"v":301.1296733356987,"d":"301"}},{"$f":"'Datos del producto'!D22*$F$19","v":{"v":1505.6483666784936,"d":"1,506"}},{"$f":"'Datos del producto'!E22*$F$19","v":{"v":2258.4725500177406,"d":"2,258"}},{"$f":"F20/F7","v":{"v":3011.2967333569873,"d":"3,011"}}]
["Ventas en dólares",{"$f":"B7*B13","v":{"v":40000,"d":"40,000.00 €"}},{"$f":"C19*C7","v":{"v":126474.46280099347,"d":"126,474.46 €"}},{"$f":"D19*D7","v":{"v":663990.9297052157,"d":"663,990.93 €"}},{"$f":"E19*E7","v":{"v":1045785.7142857148,"d":"1,045,785.71 €"}},{"$f":"'Datos del producto'!B18*F10","v":{"v":1464100.0000000007,"d":"1,464,100.00 €"}}]
["Renta operativa",{"$f":"B20-(B19*B8)-B9","v":{"v":-235000,"d":"-235,000.00 €"}},{"$f":"C20-(C19*C8)-C9","v":{"v":-210072.07644962746,"d":"-210,072.08 €"}},{"$f":"D20-(D19*D8)-D9","v":{"v":-16228.401360544085,"d":"-16,228.40 €"}},{"$f":"E20-(E19*E8)-E9","v":{"v":118987.89285714307,"d":"118,987.89 €"}},{"$f":"F20-(F19*F8)-F9","v":{"v":267660.2975000002,"d":"267,660.30 €"}}]
["Cuota de mercado",{"$f":"B20/B10","v":{"v":0.0008,"d":"0.08%"}},{"$f":"C20/C10","v":{"v":0.00229953568729079,"d":"0.23%"}},{"$f":"D20/D10","v":{"v":0.010975056689342406,"d":"1.10%"}},{"$f":"E20/E10","v":{"v":0.015714285714285715,"d":"1.57%"}},{"$f":"F20/F10","v":{"v":0.02,"d":"2.00%"}}]

{"sheet":"Gráficas","index":2,"n_rows":46,"n_cols":2,"rows_kept":46}
{"$rows_empty":44}
["Graph 1 Title",{"$f":"CONCATENATE(\"Scenario 1: \",'Datos del producto'!B7,\" Sales and Profit Analysis\")","v":"Scenario 1: Artículo Sales and Profit Analysis"}]
["Graph 2 Title",{"$f":"CONCATENATE(\"Scenario 2: \",'Datos del producto'!B7,\" Sales and Profit Analysis\")","v":"Scenario 2: Artículo Sales and Profit Analysis"}]