// Quarterly financial statements dataset: P&L and balance sheet (quarterly-financial-statements-dataset-p-l-and-balance-sheet) v1 — Prisma seed
// Synthetic sample data, CC0-1.0. Generated deterministically; re-running the
// generator with the same spec and seed reproduces this file exactly.
//
// Delegates are named after the tables (prisma.companies), which assumes models
// mapped to those table names. Rename the delegates if your models differ.
import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

async function main() {
    await prisma.companies.createMany({
        data: [
            { id: 1, company_name: "Bins-Dach Group", sector: "industrial", base_revenue: "193.97", cogs_ratio: "0.44" },
            { id: 2, company_name: "Steuber LLC", sector: "industrial", base_revenue: "154.07", cogs_ratio: "0.49" },
            { id: 3, company_name: "Roberts, Kiehn and McLaughlin", sector: "consumer", base_revenue: "77.57", cogs_ratio: "0.54" },
            { id: 4, company_name: "Koelpin, Prohaska and Green", sector: "consumer", base_revenue: "59.71", cogs_ratio: "0.59" },
            { id: 5, company_name: "Gerlach - Pollich", sector: "consumer", base_revenue: "98.65", cogs_ratio: "0.64" },
            { id: 6, company_name: "Jaskolski - Lowe", sector: "industrial", base_revenue: "63.28", cogs_ratio: "0.69" },
            { id: 7, company_name: "Waelchi Inc", sector: "healthcare", base_revenue: "154.94", cogs_ratio: "0.74" },
            { id: 8, company_name: "Shanahan LLC", sector: "technology", base_revenue: "97.58", cogs_ratio: "0.79" },
        ],
    });
    await prisma.periods.createMany({
        data: [
            { id: 1, ledger_set: "quarters", period_label: "2022 Q1", period_end: "2022-03-31", seasonal_index: "0.94", growth_index: "1.000" },
            { id: 2, ledger_set: "quarters", period_label: "2022 Q2", period_end: "2022-06-30", seasonal_index: "1.00", growth_index: "1.015" },
            { id: 3, ledger_set: "quarters", period_label: "2022 Q3", period_end: "2022-09-30", seasonal_index: "0.97", growth_index: "1.030" },
            { id: 4, ledger_set: "quarters", period_label: "2022 Q4", period_end: "2022-12-31", seasonal_index: "1.12", growth_index: "1.045" },
            { id: 5, ledger_set: "quarters", period_label: "2023 Q1", period_end: "2023-03-31", seasonal_index: "0.94", growth_index: "1.060" },
            { id: 6, ledger_set: "quarters", period_label: "2023 Q2", period_end: "2023-06-30", seasonal_index: "1.00", growth_index: "1.075" },
            { id: 7, ledger_set: "quarters", period_label: "2023 Q3", period_end: "2023-09-30", seasonal_index: "0.97", growth_index: "1.090" },
            { id: 8, ledger_set: "quarters", period_label: "2023 Q4", period_end: "2023-12-31", seasonal_index: "1.12", growth_index: "1.105" },
            { id: 9, ledger_set: "quarters", period_label: "2024 Q1", period_end: "2024-03-31", seasonal_index: "0.94", growth_index: "1.120" },
            { id: 10, ledger_set: "quarters", period_label: "2024 Q2", period_end: "2024-06-30", seasonal_index: "1.00", growth_index: "1.135" },
            { id: 11, ledger_set: "quarters", period_label: "2024 Q3", period_end: "2024-09-30", seasonal_index: "0.97", growth_index: "1.150" },
            { id: 12, ledger_set: "quarters", period_label: "2024 Q4", period_end: "2024-12-31", seasonal_index: "1.12", growth_index: "1.165" },
        ],
    });
    await prisma.income_statements.createMany({
        data: [
            { company_id: 1, period_id: 3, statement_no: 1, underlying_revenue: "199.79", seasonal_revenue: "193.80", demand_noise: "1.015", revenue: "196.71", cogs_noise: "0.981", cogs_ratio_applied: "0.432", cost_of_sales: "84.98", gross_profit: "111.73", selling_share: "0.102", development_share: "0.057", admin_share: "0.075", selling_expense: "20.06", development_expense: "11.21", admin_expense: "14.75", selling_and_development: "31.27", total_opex: "46.02", operating_income: "65.71", interest_share: "0.0089", interest_expense: "1.75", pretax_income: "63.96", tax_rate: "0.260", income_tax: "16.63", net_income: "47.33" },
            { company_id: 4, period_id: 12, statement_no: 2, underlying_revenue: "69.56", seasonal_revenue: "77.91", demand_noise: "1.010", revenue: "78.69", cogs_noise: "1.001", cogs_ratio_applied: "0.591", cost_of_sales: "46.51", gross_profit: "32.18", selling_share: "0.085", development_share: "0.086", admin_share: "0.073", selling_expense: "6.69", development_expense: "6.77", admin_expense: "5.74", selling_and_development: "13.46", total_opex: "19.20", operating_income: "12.98", interest_share: "0.0047", interest_expense: "0.37", pretax_income: "12.61", tax_rate: "0.251", income_tax: "3.17", net_income: "9.44" },
            { company_id: 7, period_id: 9, statement_no: 3, underlying_revenue: "173.53", seasonal_revenue: "163.12", demand_noise: "0.976", revenue: "159.21", cogs_noise: "1.003", cogs_ratio_applied: "0.742", cost_of_sales: "118.13", gross_profit: "41.08", selling_share: "0.102", development_share: "0.071", admin_share: "0.052", selling_expense: "16.24", development_expense: "11.30", admin_expense: "8.28", selling_and_development: "27.54", total_opex: "35.82", operating_income: "5.26", interest_share: "0.0077", interest_expense: "1.23", pretax_income: "4.03", tax_rate: "0.242", income_tax: "0.98", net_income: "3.05" },
            { company_id: 8, period_id: 8, statement_no: 4, underlying_revenue: "107.83", seasonal_revenue: "120.77", demand_noise: "0.991", revenue: "119.68", cogs_noise: "0.993", cogs_ratio_applied: "0.784", cost_of_sales: "93.83", gross_profit: "25.85", selling_share: "0.105", development_share: "0.091", admin_share: "0.062", selling_expense: "12.57", development_expense: "10.89", admin_expense: "7.42", selling_and_development: "23.46", total_opex: "30.88", operating_income: "-5.03", interest_share: "0.0159", interest_expense: "1.90", pretax_income: "-6.93", tax_rate: "0.267", income_tax: "-1.85", net_income: "-5.08" },
            { company_id: 2, period_id: 6, statement_no: 5, underlying_revenue: "165.63", seasonal_revenue: "165.63", demand_noise: "0.975", revenue: "161.49", cogs_noise: "1.013", cogs_ratio_applied: "0.496", cost_of_sales: "80.10", gross_profit: "81.39", selling_share: "0.109", development_share: "0.057", admin_share: "0.050", selling_expense: "17.60", development_expense: "9.20", admin_expense: "8.07", selling_and_development: "26.80", total_opex: "34.87", operating_income: "46.52", interest_share: "0.0127", interest_expense: "2.05", pretax_income: "44.47", tax_rate: "0.239", income_tax: "10.63", net_income: "33.84" },
            { company_id: 1, period_id: 2, statement_no: 6, underlying_revenue: "196.88", seasonal_revenue: "196.88", demand_noise: "0.988", revenue: "194.52", cogs_noise: "1.026", cogs_ratio_applied: "0.451", cost_of_sales: "87.73", gross_profit: "106.79", selling_share: "0.116", development_share: "0.093", admin_share: "0.052", selling_expense: "22.56", development_expense: "18.09", admin_expense: "10.12", selling_and_development: "40.65", total_opex: "50.77", operating_income: "56.02", interest_share: "0.0061", interest_expense: "1.19", pretax_income: "54.83", tax_rate: "0.239", income_tax: "13.10", net_income: "41.73" },
            { company_id: 6, period_id: 4, statement_no: 7, underlying_revenue: "66.13", seasonal_revenue: "74.07", demand_noise: "1.008", revenue: "74.66", cogs_noise: "0.995", cogs_ratio_applied: "0.687", cost_of_sales: "51.29", gross_profit: "23.37", selling_share: "0.082", development_share: "0.046", admin_share: "0.061", selling_expense: "6.12", development_expense: "3.43", admin_expense: "4.55", selling_and_development: "9.55", total_opex: "14.10", operating_income: "9.27", interest_share: "0.0075", interest_expense: "0.56", pretax_income: "8.71", tax_rate: "0.239", income_tax: "2.08", net_income: "6.63" },
            { company_id: 1, period_id: 8, statement_no: 8, underlying_revenue: "214.34", seasonal_revenue: "240.06", demand_noise: "0.992", revenue: "238.14", cogs_noise: "1.012", cogs_ratio_applied: "0.445", cost_of_sales: "105.97", gross_profit: "132.17", selling_share: "0.088", development_share: "0.072", admin_share: "0.052", selling_expense: "20.96", development_expense: "17.15", admin_expense: "12.38", selling_and_development: "38.11", total_opex: "50.49", operating_income: "81.68", interest_share: "0.0127", interest_expense: "3.02", pretax_income: "78.66", tax_rate: "0.185", income_tax: "14.55", net_income: "64.11" },
            { company_id: 7, period_id: 1, statement_no: 9, underlying_revenue: "154.94", seasonal_revenue: "145.64", demand_noise: "1.001", revenue: "145.79", cogs_noise: "0.995", cogs_ratio_applied: "0.736", cost_of_sales: "107.30", gross_profit: "38.49", selling_share: "0.085", development_share: "0.077", admin_share: "0.083", selling_expense: "12.39", development_expense: "11.23", admin_expense: "12.10", selling_and_development: "23.62", total_opex: "35.72", operating_income: "2.77", interest_share: "0.0128", interest_expense: "1.87", pretax_income: "0.90", tax_rate: "0.253", income_tax: "0.23", net_income: "0.67" },
            { company_id: 6, period_id: 7, statement_no: 10, underlying_revenue: "68.98", seasonal_revenue: "66.91", demand_noise: "1.017", revenue: "68.05", cogs_noise: "1.004", cogs_ratio_applied: "0.693", cost_of_sales: "47.16", gross_profit: "20.89", selling_share: "0.102", development_share: "0.093", admin_share: "0.078", selling_expense: "6.94", development_expense: "6.33", admin_expense: "5.31", selling_and_development: "13.27", total_opex: "18.58", operating_income: "2.31", interest_share: "0.0197", interest_expense: "1.34", pretax_income: "0.97", tax_rate: "0.224", income_tax: "0.22", net_income: "0.75" },
            { company_id: 5, period_id: 12, statement_no: 11, underlying_revenue: "114.93", seasonal_revenue: "128.72", demand_noise: "0.993", revenue: "127.82", cogs_noise: "0.976", cogs_ratio_applied: "0.625", cost_of_sales: "79.89", gross_profit: "47.93", selling_share: "0.085", development_share: "0.051", admin_share: "0.076", selling_expense: "10.86", development_expense: "6.52", admin_expense: "9.71", selling_and_development: "17.38", total_opex: "27.09", operating_income: "20.84", interest_share: "0.0171", interest_expense: "2.19", pretax_income: "18.65", tax_rate: "0.262", income_tax: "4.89", net_income: "13.76" },
            { company_id: 3, period_id: 5, statement_no: 12, underlying_revenue: "82.22", seasonal_revenue: "77.29", demand_noise: "0.966", revenue: "74.66", cogs_noise: "1.008", cogs_ratio_applied: "0.544", cost_of_sales: "40.62", gross_profit: "34.04", selling_share: "0.089", development_share: "0.092", admin_share: "0.070", selling_expense: "6.64", development_expense: "6.87", admin_expense: "5.23", selling_and_development: "13.51", total_opex: "18.74", operating_income: "15.30", interest_share: "0.0126", interest_expense: "0.94", pretax_income: "14.36", tax_rate: "0.247", income_tax: "3.55", net_income: "10.81" },
            { company_id: 5, period_id: 9, statement_no: 13, underlying_revenue: "110.49", seasonal_revenue: "103.86", demand_noise: "0.980", revenue: "101.78", cogs_noise: "0.994", cogs_ratio_applied: "0.636", cost_of_sales: "64.73", gross_profit: "37.05", selling_share: "0.113", development_share: "0.077", admin_share: "0.052", selling_expense: "11.50", development_expense: "7.84", admin_expense: "5.29", selling_and_development: "19.34", total_opex: "24.63", operating_income: "12.42", interest_share: "0.0073", interest_expense: "0.74", pretax_income: "11.68", tax_rate: "0.224", income_tax: "2.62", net_income: "9.06" },
            { company_id: 1, period_id: 6, statement_no: 14, underlying_revenue: "208.52", seasonal_revenue: "208.52", demand_noise: "1.005", revenue: "209.56", cogs_noise: "0.988", cogs_ratio_applied: "0.435", cost_of_sales: "91.16", gross_profit: "118.40", selling_share: "0.088", development_share: "0.089", admin_share: "0.051", selling_expense: "18.44", development_expense: "18.65", admin_expense: "10.69", selling_and_development: "37.09", total_opex: "47.78", operating_income: "70.62", interest_share: "0.0085", interest_expense: "1.78", pretax_income: "68.84", tax_rate: "0.251", income_tax: "17.28", net_income: "51.56" },
            { company_id: 7, period_id: 2, statement_no: 15, underlying_revenue: "157.26", seasonal_revenue: "157.26", demand_noise: "1.020", revenue: "160.41", cogs_noise: "0.987", cogs_ratio_applied: "0.730", cost_of_sales: "117.10", gross_profit: "43.31", selling_share: "0.074", development_share: "0.051", admin_share: "0.053", selling_expense: "11.87", development_expense: "8.18", admin_expense: "8.50", selling_and_development: "20.05", total_opex: "28.55", operating_income: "14.76", interest_share: "0.0147", interest_expense: "2.36", pretax_income: "12.40", tax_rate: "0.244", income_tax: "3.03", net_income: "9.37" },
            { company_id: 8, period_id: 7, statement_no: 16, underlying_revenue: "106.36", seasonal_revenue: "103.17", demand_noise: "0.975", revenue: "100.59", cogs_noise: "0.995", cogs_ratio_applied: "0.786", cost_of_sales: "79.06", gross_profit: "21.53", selling_share: "0.084", development_share: "0.096", admin_share: "0.087", selling_expense: "8.45", development_expense: "9.66", admin_expense: "8.75", selling_and_development: "18.11", total_opex: "26.86", operating_income: "-5.33", interest_share: "0.0180", interest_expense: "1.81", pretax_income: "-7.14", tax_rate: "0.247", income_tax: "-1.76", net_income: "-5.38" },
            { company_id: 6, period_id: 1, statement_no: 17, underlying_revenue: "63.28", seasonal_revenue: "59.48", demand_noise: "0.979", revenue: "58.23", cogs_noise: "1.004", cogs_ratio_applied: "0.693", cost_of_sales: "40.35", gross_profit: "17.88", selling_share: "0.074", development_share: "0.055", admin_share: "0.067", selling_expense: "4.31", development_expense: "3.20", admin_expense: "3.90", selling_and_development: "7.51", total_opex: "11.41", operating_income: "6.47", interest_share: "0.0170", interest_expense: "0.99", pretax_income: "5.48", tax_rate: "0.258", income_tax: "1.41", net_income: "4.07" },
            { company_id: 6, period_id: 10, statement_no: 18, underlying_revenue: "71.82", seasonal_revenue: "71.82", demand_noise: "1.014", revenue: "72.83", cogs_noise: "0.983", cogs_ratio_applied: "0.678", cost_of_sales: "49.38", gross_profit: "23.45", selling_share: "0.086", development_share: "0.046", admin_share: "0.062", selling_expense: "6.26", development_expense: "3.35", admin_expense: "4.52", selling_and_development: "9.61", total_opex: "14.13", operating_income: "9.32", interest_share: "0.0152", interest_expense: "1.11", pretax_income: "8.21", tax_rate: "0.270", income_tax: "2.22", net_income: "5.99" },
            { company_id: 6, period_id: 12, statement_no: 19, underlying_revenue: "73.72", seasonal_revenue: "82.57", demand_noise: "1.006", revenue: "83.07", cogs_noise: "0.986", cogs_ratio_applied: "0.680", cost_of_sales: "56.49", gross_profit: "26.58", selling_share: "0.103", development_share: "0.093", admin_share: "0.074", selling_expense: "8.56", development_expense: "7.73", admin_expense: "6.15", selling_and_development: "16.29", total_opex: "22.44", operating_income: "4.14", interest_share: "0.0076", interest_expense: "0.63", pretax_income: "3.51", tax_rate: "0.236", income_tax: "0.83", net_income: "2.68" },
            { company_id: 6, period_id: 2, statement_no: 20, underlying_revenue: "64.23", seasonal_revenue: "64.23", demand_noise: "1.006", revenue: "64.62", cogs_noise: "0.991", cogs_ratio_applied: "0.684", cost_of_sales: "44.20", gross_profit: "20.42", selling_share: "0.077", development_share: "0.049", admin_share: "0.063", selling_expense: "4.98", development_expense: "3.17", admin_expense: "4.07", selling_and_development: "8.15", total_opex: "12.22", operating_income: "8.20", interest_share: "0.0150", interest_expense: "0.97", pretax_income: "7.23", tax_rate: "0.195", income_tax: "1.41", net_income: "5.82" },
            { company_id: 8, period_id: 9, statement_no: 21, underlying_revenue: "109.29", seasonal_revenue: "102.73", demand_noise: "0.992", revenue: "101.91", cogs_noise: "1.012", cogs_ratio_applied: "0.799", cost_of_sales: "81.43", gross_profit: "20.48", selling_share: "0.080", development_share: "0.050", admin_share: "0.068", selling_expense: "8.15", development_expense: "5.10", admin_expense: "6.93", selling_and_development: "13.25", total_opex: "20.18", operating_income: "0.30", interest_share: "0.0188", interest_expense: "1.92", pretax_income: "-1.62", tax_rate: "0.213", income_tax: "-0.35", net_income: "-1.27" },
            { company_id: 5, period_id: 7, statement_no: 22, underlying_revenue: "107.53", seasonal_revenue: "104.30", demand_noise: "1.018", revenue: "106.18", cogs_noise: "0.983", cogs_ratio_applied: "0.629", cost_of_sales: "66.79", gross_profit: "39.39", selling_share: "0.086", development_share: "0.096", admin_share: "0.075", selling_expense: "9.13", development_expense: "10.19", admin_expense: "7.96", selling_and_development: "19.32", total_opex: "27.28", operating_income: "12.11", interest_share: "0.0152", interest_expense: "1.61", pretax_income: "10.50", tax_rate: "0.202", income_tax: "2.12", net_income: "8.38" },
            { company_id: 1, period_id: 10, statement_no: 23, underlying_revenue: "220.16", seasonal_revenue: "220.16", demand_noise: "0.999", revenue: "219.94", cogs_noise: "0.993", cogs_ratio_applied: "0.437", cost_of_sales: "96.11", gross_profit: "123.83", selling_share: "0.109", development_share: "0.064", admin_share: "0.075", selling_expense: "23.97", development_expense: "14.08", admin_expense: "16.50", selling_and_development: "38.05", total_opex: "54.55", operating_income: "69.28", interest_share: "0.0161", interest_expense: "3.54", pretax_income: "65.74", tax_rate: "0.216", income_tax: "14.20", net_income: "51.54" },
            { company_id: 6, period_id: 9, statement_no: 24, underlying_revenue: "70.87", seasonal_revenue: "66.62", demand_noise: "0.991", revenue: "66.02", cogs_noise: "0.998", cogs_ratio_applied: "0.689", cost_of_sales: "45.49", gross_profit: "20.53", selling_share: "0.085", development_share: "0.064", admin_share: "0.087", selling_expense: "5.61", development_expense: "4.23", admin_expense: "5.74", selling_and_development: "9.84", total_opex: "15.58", operating_income: "4.95", interest_share: "0.0128", interest_expense: "0.85", pretax_income: "4.10", tax_rate: "0.251", income_tax: "1.03", net_income: "3.07" },
            { company_id: 4, period_id: 4, statement_no: 25, underlying_revenue: "62.40", seasonal_revenue: "69.89", demand_noise: "1.005", revenue: "70.24", cogs_noise: "0.996", cogs_ratio_applied: "0.588", cost_of_sales: "41.30", gross_profit: "28.94", selling_share: "0.103", development_share: "0.073", admin_share: "0.061", selling_expense: "7.23", development_expense: "5.13", admin_expense: "4.28", selling_and_development: "12.36", total_opex: "16.64", operating_income: "12.30", interest_share: "0.0179", interest_expense: "1.26", pretax_income: "11.04", tax_rate: "0.196", income_tax: "2.16", net_income: "8.88" },
            { company_id: 2, period_id: 5, statement_no: 26, underlying_revenue: "163.31", seasonal_revenue: "153.51", demand_noise: "1.011", revenue: "155.20", cogs_noise: "0.998", cogs_ratio_applied: "0.489", cost_of_sales: "75.89", gross_profit: "79.31", selling_share: "0.096", development_share: "0.081", admin_share: "0.080", selling_expense: "14.90", development_expense: "12.57", admin_expense: "12.42", selling_and_development: "27.47", total_opex: "39.89", operating_income: "39.42", interest_share: "0.0086", interest_expense: "1.33", pretax_income: "38.09", tax_rate: "0.192", income_tax: "7.31", net_income: "30.78" },
            { company_id: 6, period_id: 5, statement_no: 27, underlying_revenue: "67.08", seasonal_revenue: "63.06", demand_noise: "1.011", revenue: "63.75", cogs_noise: "0.999", cogs_ratio_applied: "0.689", cost_of_sales: "43.92", gross_profit: "19.83", selling_share: "0.096", development_share: "0.061", admin_share: "0.063", selling_expense: "6.12", development_expense: "3.89", admin_expense: "4.02", selling_and_development: "10.01", total_opex: "14.03", operating_income: "5.80", interest_share: "0.0087", interest_expense: "0.55", pretax_income: "5.25", tax_rate: "0.205", income_tax: "1.08", net_income: "4.17" },
            { company_id: 4, period_id: 1, statement_no: 28, underlying_revenue: "59.71", seasonal_revenue: "56.13", demand_noise: "0.991", revenue: "55.62", cogs_noise: "0.993", cogs_ratio_applied: "0.586", cost_of_sales: "32.59", gross_profit: "23.03", selling_share: "0.070", development_share: "0.084", admin_share: "0.082", selling_expense: "3.89", development_expense: "4.67", admin_expense: "4.56", selling_and_development: "8.56", total_opex: "13.12", operating_income: "9.91", interest_share: "0.0146", interest_expense: "0.81", pretax_income: "9.10", tax_rate: "0.231", income_tax: "2.10", net_income: "7.00" },
            { company_id: 8, period_id: 2, statement_no: 29, underlying_revenue: "99.04", seasonal_revenue: "99.04", demand_noise: "0.989", revenue: "97.95", cogs_noise: "0.996", cogs_ratio_applied: "0.787", cost_of_sales: "77.09", gross_profit: "20.86", selling_share: "0.078", development_share: "0.042", admin_share: "0.065", selling_expense: "7.64", development_expense: "4.11", admin_expense: "6.37", selling_and_development: "11.75", total_opex: "18.12", operating_income: "2.74", interest_share: "0.0189", interest_expense: "1.85", pretax_income: "0.89", tax_rate: "0.266", income_tax: "0.24", net_income: "0.65" },
            { company_id: 2, period_id: 4, statement_no: 30, underlying_revenue: "161.00", seasonal_revenue: "180.32", demand_noise: "1.008", revenue: "181.76", cogs_noise: "1.005", cogs_ratio_applied: "0.492", cost_of_sales: "89.43", gross_profit: "92.33", selling_share: "0.077", development_share: "0.092", admin_share: "0.052", selling_expense: "14.00", development_expense: "16.72", admin_expense: "9.45", selling_and_development: "30.72", total_opex: "40.17", operating_income: "52.16", interest_share: "0.0119", interest_expense: "2.16", pretax_income: "50.00", tax_rate: "0.229", income_tax: "11.45", net_income: "38.55" },
            { company_id: 6, period_id: 6, statement_no: 31, underlying_revenue: "68.03", seasonal_revenue: "68.03", demand_noise: "0.996", revenue: "67.76", cogs_noise: "1.002", cogs_ratio_applied: "0.691", cost_of_sales: "46.82", gross_profit: "20.94", selling_share: "0.096", development_share: "0.046", admin_share: "0.065", selling_expense: "6.50", development_expense: "3.12", admin_expense: "4.40", selling_and_development: "9.62", total_opex: "14.02", operating_income: "6.92", interest_share: "0.0173", interest_expense: "1.17", pretax_income: "5.75", tax_rate: "0.181", income_tax: "1.04", net_income: "4.71" },
            { company_id: 1, period_id: 1, statement_no: 32, underlying_revenue: "193.97", seasonal_revenue: "182.33", demand_noise: "1.026", revenue: "187.07", cogs_noise: "1.009", cogs_ratio_applied: "0.444", cost_of_sales: "83.06", gross_profit: "104.01", selling_share: "0.110", development_share: "0.087", admin_share: "0.069", selling_expense: "20.58", development_expense: "16.28", admin_expense: "12.91", selling_and_development: "36.86", total_opex: "49.77", operating_income: "54.24", interest_share: "0.0109", interest_expense: "2.04", pretax_income: "52.20", tax_rate: "0.215", income_tax: "11.22", net_income: "40.98" },
            { company_id: 4, period_id: 9, statement_no: 33, underlying_revenue: "66.88", seasonal_revenue: "62.87", demand_noise: "0.985", revenue: "61.93", cogs_noise: "0.989", cogs_ratio_applied: "0.584", cost_of_sales: "36.17", gross_profit: "25.76", selling_share: "0.104", development_share: "0.074", admin_share: "0.071", selling_expense: "6.44", development_expense: "4.58", admin_expense: "4.40", selling_and_development: "11.02", total_opex: "15.42", operating_income: "10.34", interest_share: "0.0153", interest_expense: "0.95", pretax_income: "9.39", tax_rate: "0.189", income_tax: "1.77", net_income: "7.62" },
            { company_id: 1, period_id: 9, statement_no: 34, underlying_revenue: "217.25", seasonal_revenue: "204.21", demand_noise: "1.025", revenue: "209.32", cogs_noise: "1.012", cogs_ratio_applied: "0.445", cost_of_sales: "93.15", gross_profit: "116.17", selling_share: "0.119", development_share: "0.094", admin_share: "0.077", selling_expense: "24.91", development_expense: "19.68", admin_expense: "16.12", selling_and_development: "44.59", total_opex: "60.71", operating_income: "55.46", interest_share: "0.0076", interest_expense: "1.59", pretax_income: "53.87", tax_rate: "0.240", income_tax: "12.93", net_income: "40.94" },
            { company_id: 5, period_id: 10, statement_no: 35, underlying_revenue: "111.97", seasonal_revenue: "111.97", demand_noise: "1.018", revenue: "113.99", cogs_noise: "0.997", cogs_ratio_applied: "0.638", cost_of_sales: "72.73", gross_profit: "41.26", selling_share: "0.091", development_share: "0.065", admin_share: "0.079", selling_expense: "10.37", development_expense: "7.41", admin_expense: "9.01", selling_and_development: "17.78", total_opex: "26.79", operating_income: "14.47", interest_share: "0.0149", interest_expense: "1.70", pretax_income: "12.77", tax_rate: "0.263", income_tax: "3.36", net_income: "9.41" },
            { company_id: 7, period_id: 11, statement_no: 36, underlying_revenue: "178.18", seasonal_revenue: "172.83", demand_noise: "1.003", revenue: "173.35", cogs_noise: "0.986", cogs_ratio_applied: "0.730", cost_of_sales: "126.55", gross_profit: "46.80", selling_share: "0.096", development_share: "0.098", admin_share: "0.064", selling_expense: "16.64", development_expense: "16.99", admin_expense: "11.09", selling_and_development: "33.63", total_opex: "44.72", operating_income: "2.08", interest_share: "0.0076", interest_expense: "1.32", pretax_income: "0.76", tax_rate: "0.266", income_tax: "0.20", net_income: "0.56" },
            { company_id: 5, period_id: 8, statement_no: 37, underlying_revenue: "109.01", seasonal_revenue: "122.09", demand_noise: "1.043", revenue: "127.34", cogs_noise: "1.004", cogs_ratio_applied: "0.643", cost_of_sales: "81.88", gross_profit: "45.46", selling_share: "0.107", development_share: "0.082", admin_share: "0.061", selling_expense: "13.63", development_expense: "10.44", admin_expense: "7.77", selling_and_development: "24.07", total_opex: "31.84", operating_income: "13.62", interest_share: "0.0171", interest_expense: "2.18", pretax_income: "11.44", tax_rate: "0.213", income_tax: "2.44", net_income: "9.00" },
            { company_id: 8, period_id: 3, statement_no: 38, underlying_revenue: "100.51", seasonal_revenue: "97.49", demand_noise: "1.001", revenue: "97.59", cogs_noise: "0.996", cogs_ratio_applied: "0.787", cost_of_sales: "76.80", gross_profit: "20.79", selling_share: "0.113", development_share: "0.055", admin_share: "0.064", selling_expense: "11.03", development_expense: "5.37", admin_expense: "6.25", selling_and_development: "16.40", total_opex: "22.65", operating_income: "-1.86", interest_share: "0.0060", interest_expense: "0.59", pretax_income: "-2.45", tax_rate: "0.192", income_tax: "-0.47", net_income: "-1.98" },
            { company_id: 8, period_id: 1, statement_no: 39, underlying_revenue: "97.58", seasonal_revenue: "91.73", demand_noise: "0.998", revenue: "91.55", cogs_noise: "0.990", cogs_ratio_applied: "0.782", cost_of_sales: "71.59", gross_profit: "19.96", selling_share: "0.113", development_share: "0.082", admin_share: "0.065", selling_expense: "10.35", development_expense: "7.51", admin_expense: "5.95", selling_and_development: "17.86", total_opex: "23.81", operating_income: "-3.85", interest_share: "0.0149", interest_expense: "1.36", pretax_income: "-5.21", tax_rate: "0.206", income_tax: "-1.07", net_income: "-4.14" },
            { company_id: 3, period_id: 3, statement_no: 40, underlying_revenue: "79.90", seasonal_revenue: "77.50", demand_noise: "0.981", revenue: "76.03", cogs_noise: "0.986", cogs_ratio_applied: "0.532", cost_of_sales: "40.45", gross_profit: "35.58", selling_share: "0.106", development_share: "0.069", admin_share: "0.085", selling_expense: "8.06", development_expense: "5.25", admin_expense: "6.46", selling_and_development: "13.31", total_opex: "19.77", operating_income: "15.81", interest_share: "0.0188", interest_expense: "1.43", pretax_income: "14.38", tax_rate: "0.254", income_tax: "3.65", net_income: "10.73" },
            { company_id: 3, period_id: 12, statement_no: 41, underlying_revenue: "90.37", seasonal_revenue: "101.21", demand_noise: "1.013", revenue: "102.53", cogs_noise: "1.004", cogs_ratio_applied: "0.542", cost_of_sales: "55.57", gross_profit: "46.96", selling_share: "0.091", development_share: "0.076", admin_share: "0.081", selling_expense: "9.33", development_expense: "7.79", admin_expense: "8.30", selling_and_development: "17.12", total_opex: "25.42", operating_income: "21.54", interest_share: "0.0178", interest_expense: "1.83", pretax_income: "19.71", tax_rate: "0.260", income_tax: "5.12", net_income: "14.59" },
            { company_id: 7, period_id: 8, statement_no: 42, underlying_revenue: "171.21", seasonal_revenue: "191.76", demand_noise: "0.997", revenue: "191.18", cogs_noise: "1.011", cogs_ratio_applied: "0.748", cost_of_sales: "143.00", gross_profit: "48.18", selling_share: "0.094", development_share: "0.053", admin_share: "0.077", selling_expense: "17.97", development_expense: "10.13", admin_expense: "14.72", selling_and_development: "28.10", total_opex: "42.82", operating_income: "5.36", interest_share: "0.0084", interest_expense: "1.61", pretax_income: "3.75", tax_rate: "0.198", income_tax: "0.74", net_income: "3.01" },
            { company_id: 8, period_id: 12, statement_no: 43, underlying_revenue: "113.68", seasonal_revenue: "127.32", demand_noise: "0.990", revenue: "126.05", cogs_noise: "0.995", cogs_ratio_applied: "0.786", cost_of_sales: "99.08", gross_profit: "26.97", selling_share: "0.073", development_share: "0.053", admin_share: "0.086", selling_expense: "9.20", development_expense: "6.68", admin_expense: "10.84", selling_and_development: "15.88", total_opex: "26.72", operating_income: "0.25", interest_share: "0.0107", interest_expense: "1.35", pretax_income: "-1.10", tax_rate: "0.185", income_tax: "-0.20", net_income: "-0.90" },
            { company_id: 3, period_id: 9, statement_no: 44, underlying_revenue: "86.88", seasonal_revenue: "81.67", demand_noise: "0.963", revenue: "78.65", cogs_noise: "1.000", cogs_ratio_applied: "0.540", cost_of_sales: "42.47", gross_profit: "36.18", selling_share: "0.085", development_share: "0.074", admin_share: "0.071", selling_expense: "6.69", development_expense: "5.82", admin_expense: "5.58", selling_and_development: "12.51", total_opex: "18.09", operating_income: "18.09", interest_share: "0.0194", interest_expense: "1.53", pretax_income: "16.56", tax_rate: "0.264", income_tax: "4.37", net_income: "12.19" },
            { company_id: 4, period_id: 8, statement_no: 45, underlying_revenue: "65.98", seasonal_revenue: "73.90", demand_noise: "0.973", revenue: "71.90", cogs_noise: "0.994", cogs_ratio_applied: "0.586", cost_of_sales: "42.13", gross_profit: "29.77", selling_share: "0.097", development_share: "0.057", admin_share: "0.061", selling_expense: "6.97", development_expense: "4.10", admin_expense: "4.39", selling_and_development: "11.07", total_opex: "15.46", operating_income: "14.31", interest_share: "0.0081", interest_expense: "0.58", pretax_income: "13.73", tax_rate: "0.181", income_tax: "2.49", net_income: "11.24" },
            { company_id: 4, period_id: 5, statement_no: 46, underlying_revenue: "63.29", seasonal_revenue: "59.49", demand_noise: "0.981", revenue: "58.36", cogs_noise: "0.987", cogs_ratio_applied: "0.582", cost_of_sales: "33.97", gross_profit: "24.39", selling_share: "0.075", development_share: "0.091", admin_share: "0.083", selling_expense: "4.38", development_expense: "5.31", admin_expense: "4.84", selling_and_development: "9.69", total_opex: "14.53", operating_income: "9.86", interest_share: "0.0163", interest_expense: "0.95", pretax_income: "8.91", tax_rate: "0.268", income_tax: "2.39", net_income: "6.52" },
            { company_id: 2, period_id: 3, statement_no: 47, underlying_revenue: "158.69", seasonal_revenue: "153.93", demand_noise: "1.009", revenue: "155.32", cogs_noise: "0.984", cogs_ratio_applied: "0.482", cost_of_sales: "74.86", gross_profit: "80.46", selling_share: "0.084", development_share: "0.057", admin_share: "0.075", selling_expense: "13.05", development_expense: "8.85", admin_expense: "11.65", selling_and_development: "21.90", total_opex: "33.55", operating_income: "46.91", interest_share: "0.0099", interest_expense: "1.54", pretax_income: "45.37", tax_rate: "0.223", income_tax: "10.12", net_income: "35.25" },
            { company_id: 1, period_id: 11, statement_no: 48, underlying_revenue: "223.07", seasonal_revenue: "216.38", demand_noise: "0.984", revenue: "212.92", cogs_noise: "0.999", cogs_ratio_applied: "0.440", cost_of_sales: "93.68", gross_profit: "119.24", selling_share: "0.118", development_share: "0.094", admin_share: "0.056", selling_expense: "25.12", development_expense: "20.01", admin_expense: "11.92", selling_and_development: "45.13", total_opex: "57.05", operating_income: "62.19", interest_share: "0.0167", interest_expense: "3.56", pretax_income: "58.63", tax_rate: "0.257", income_tax: "15.07", net_income: "43.56" },
            { company_id: 5, period_id: 6, statement_no: 49, underlying_revenue: "106.05", seasonal_revenue: "106.05", demand_noise: "1.012", revenue: "107.32", cogs_noise: "1.009", cogs_ratio_applied: "0.646", cost_of_sales: "69.33", gross_profit: "37.99", selling_share: "0.070", development_share: "0.072", admin_share: "0.083", selling_expense: "7.51", development_expense: "7.73", admin_expense: "8.91", selling_and_development: "15.24", total_opex: "24.15", operating_income: "13.84", interest_share: "0.0200", interest_expense: "2.15", pretax_income: "11.69", tax_rate: "0.261", income_tax: "3.05", net_income: "8.64" },
            { company_id: 1, period_id: 12, statement_no: 50, underlying_revenue: "225.98", seasonal_revenue: "253.10", demand_noise: "1.025", revenue: "259.43", cogs_noise: "1.009", cogs_ratio_applied: "0.444", cost_of_sales: "115.19", gross_profit: "144.24", selling_share: "0.077", development_share: "0.079", admin_share: "0.084", selling_expense: "19.98", development_expense: "20.49", admin_expense: "21.79", selling_and_development: "40.47", total_opex: "62.26", operating_income: "81.98", interest_share: "0.0114", interest_expense: "2.96", pretax_income: "79.02", tax_rate: "0.253", income_tax: "19.99", net_income: "59.03" },
            { company_id: 7, period_id: 10, statement_no: 51, underlying_revenue: "175.86", seasonal_revenue: "175.86", demand_noise: "0.996", revenue: "175.16", cogs_noise: "1.024", cogs_ratio_applied: "0.758", cost_of_sales: "132.77", gross_profit: "42.39", selling_share: "0.098", development_share: "0.060", admin_share: "0.055", selling_expense: "17.17", development_expense: "10.51", admin_expense: "9.63", selling_and_development: "27.68", total_opex: "37.31", operating_income: "5.08", interest_share: "0.0071", interest_expense: "1.24", pretax_income: "3.84", tax_rate: "0.245", income_tax: "0.94", net_income: "2.90" },
            { company_id: 3, period_id: 4, statement_no: 52, underlying_revenue: "81.06", seasonal_revenue: "90.79", demand_noise: "0.978", revenue: "88.79", cogs_noise: "1.000", cogs_ratio_applied: "0.540", cost_of_sales: "47.95", gross_profit: "40.84", selling_share: "0.089", development_share: "0.059", admin_share: "0.089", selling_expense: "7.90", development_expense: "5.24", admin_expense: "7.90", selling_and_development: "13.14", total_opex: "21.04", operating_income: "19.80", interest_share: "0.0073", interest_expense: "0.65", pretax_income: "19.15", tax_rate: "0.232", income_tax: "4.44", net_income: "14.71" },
            { company_id: 7, period_id: 12, statement_no: 53, underlying_revenue: "180.51", seasonal_revenue: "202.17", demand_noise: "0.993", revenue: "200.75", cogs_noise: "0.998", cogs_ratio_applied: "0.739", cost_of_sales: "148.35", gross_profit: "52.40", selling_share: "0.089", development_share: "0.091", admin_share: "0.052", selling_expense: "17.87", development_expense: "18.27", admin_expense: "10.44", selling_and_development: "36.14", total_opex: "46.58", operating_income: "5.82", interest_share: "0.0107", interest_expense: "2.15", pretax_income: "3.67", tax_rate: "0.202", income_tax: "0.74", net_income: "2.93" },
            { company_id: 7, period_id: 4, statement_no: 54, underlying_revenue: "161.91", seasonal_revenue: "181.34", demand_noise: "1.002", revenue: "181.70", cogs_noise: "1.002", cogs_ratio_applied: "0.741", cost_of_sales: "134.64", gross_profit: "47.06", selling_share: "0.106", development_share: "0.066", admin_share: "0.067", selling_expense: "19.26", development_expense: "11.99", admin_expense: "12.17", selling_and_development: "31.25", total_opex: "43.42", operating_income: "3.64", interest_share: "0.0162", interest_expense: "2.94", pretax_income: "0.70", tax_rate: "0.235", income_tax: "0.16", net_income: "0.54" },
            { company_id: 8, period_id: 10, statement_no: 55, underlying_revenue: "110.75", seasonal_revenue: "110.75", demand_noise: "0.984", revenue: "108.98", cogs_noise: "1.014", cogs_ratio_applied: "0.801", cost_of_sales: "87.29", gross_profit: "21.69", selling_share: "0.093", development_share: "0.093", admin_share: "0.078", selling_expense: "10.14", development_expense: "10.14", admin_expense: "8.50", selling_and_development: "20.28", total_opex: "28.78", operating_income: "-7.09", interest_share: "0.0189", interest_expense: "2.06", pretax_income: "-9.15", tax_rate: "0.203", income_tax: "-1.86", net_income: "-7.29" },
            { company_id: 6, period_id: 3, statement_no: 56, underlying_revenue: "65.18", seasonal_revenue: "63.22", demand_noise: "1.012", revenue: "63.98", cogs_noise: "0.992", cogs_ratio_applied: "0.684", cost_of_sales: "43.76", gross_profit: "20.22", selling_share: "0.081", development_share: "0.070", admin_share: "0.069", selling_expense: "5.18", development_expense: "4.48", admin_expense: "4.41", selling_and_development: "9.66", total_opex: "14.07", operating_income: "6.15", interest_share: "0.0141", interest_expense: "0.90", pretax_income: "5.25", tax_rate: "0.228", income_tax: "1.20", net_income: "4.05" },
            { company_id: 8, period_id: 11, statement_no: 57, underlying_revenue: "112.22", seasonal_revenue: "108.85", demand_noise: "1.017", revenue: "110.70", cogs_noise: "0.999", cogs_ratio_applied: "0.789", cost_of_sales: "87.34", gross_profit: "23.36", selling_share: "0.095", development_share: "0.095", admin_share: "0.071", selling_expense: "10.52", development_expense: "10.52", admin_expense: "7.86", selling_and_development: "21.04", total_opex: "28.90", operating_income: "-5.54", interest_share: "0.0198", interest_expense: "2.19", pretax_income: "-7.73", tax_rate: "0.256", income_tax: "-1.98", net_income: "-5.75" },
            { company_id: 3, period_id: 11, statement_no: 58, underlying_revenue: "89.21", seasonal_revenue: "86.53", demand_noise: "0.978", revenue: "84.63", cogs_noise: "1.005", cogs_ratio_applied: "0.543", cost_of_sales: "45.95", gross_profit: "38.68", selling_share: "0.092", development_share: "0.089", admin_share: "0.052", selling_expense: "7.79", development_expense: "7.53", admin_expense: "4.40", selling_and_development: "15.32", total_opex: "19.72", operating_income: "18.96", interest_share: "0.0102", interest_expense: "0.86", pretax_income: "18.10", tax_rate: "0.261", income_tax: "4.72", net_income: "13.38" },
            { company_id: 4, period_id: 10, statement_no: 59, underlying_revenue: "67.77", seasonal_revenue: "67.77", demand_noise: "1.012", revenue: "68.58", cogs_noise: "1.001", cogs_ratio_applied: "0.591", cost_of_sales: "40.53", gross_profit: "28.05", selling_share: "0.113", development_share: "0.094", admin_share: "0.083", selling_expense: "7.75", development_expense: "6.45", admin_expense: "5.69", selling_and_development: "14.20", total_opex: "19.89", operating_income: "8.16", interest_share: "0.0072", interest_expense: "0.49", pretax_income: "7.67", tax_rate: "0.245", income_tax: "1.88", net_income: "5.79" },
            { company_id: 6, period_id: 11, statement_no: 60, underlying_revenue: "72.77", seasonal_revenue: "70.59", demand_noise: "1.017", revenue: "71.79", cogs_noise: "0.987", cogs_ratio_applied: "0.681", cost_of_sales: "48.89", gross_profit: "22.90", selling_share: "0.108", development_share: "0.099", admin_share: "0.059", selling_expense: "7.75", development_expense: "7.11", admin_expense: "4.24", selling_and_development: "14.86", total_opex: "19.10", operating_income: "3.80", interest_share: "0.0044", interest_expense: "0.32", pretax_income: "3.48", tax_rate: "0.201", income_tax: "0.70", net_income: "2.78" },
            { company_id: 4, period_id: 2, statement_no: 61, underlying_revenue: "60.61", seasonal_revenue: "60.61", demand_noise: "0.996", revenue: "60.37", cogs_noise: "1.002", cogs_ratio_applied: "0.591", cost_of_sales: "35.68", gross_profit: "24.69", selling_share: "0.071", development_share: "0.064", admin_share: "0.086", selling_expense: "4.29", development_expense: "3.86", admin_expense: "5.19", selling_and_development: "8.15", total_opex: "13.34", operating_income: "11.35", interest_share: "0.0130", interest_expense: "0.78", pretax_income: "10.57", tax_rate: "0.267", income_tax: "2.82", net_income: "7.75" },
            { company_id: 4, period_id: 3, statement_no: 62, underlying_revenue: "61.50", seasonal_revenue: "59.66", demand_noise: "1.008", revenue: "60.14", cogs_noise: "1.013", cogs_ratio_applied: "0.598", cost_of_sales: "35.96", gross_profit: "24.18", selling_share: "0.112", development_share: "0.077", admin_share: "0.058", selling_expense: "6.74", development_expense: "4.63", admin_expense: "3.49", selling_and_development: "11.37", total_opex: "14.86", operating_income: "9.32", interest_share: "0.0125", interest_expense: "0.75", pretax_income: "8.57", tax_rate: "0.260", income_tax: "2.23", net_income: "6.34" },
            { company_id: 7, period_id: 5, statement_no: 63, underlying_revenue: "164.24", seasonal_revenue: "154.39", demand_noise: "1.014", revenue: "156.55", cogs_noise: "1.014", cogs_ratio_applied: "0.750", cost_of_sales: "117.41", gross_profit: "39.14", selling_share: "0.105", development_share: "0.054", admin_share: "0.052", selling_expense: "16.44", development_expense: "8.45", admin_expense: "8.14", selling_and_development: "24.89", total_opex: "33.03", operating_income: "6.11", interest_share: "0.0041", interest_expense: "0.64", pretax_income: "5.47", tax_rate: "0.220", income_tax: "1.20", net_income: "4.27" },
            { company_id: 5, period_id: 3, statement_no: 64, underlying_revenue: "101.61", seasonal_revenue: "98.56", demand_noise: "1.012", revenue: "99.74", cogs_noise: "1.010", cogs_ratio_applied: "0.646", cost_of_sales: "64.43", gross_profit: "35.31", selling_share: "0.075", development_share: "0.053", admin_share: "0.075", selling_expense: "7.48", development_expense: "5.29", admin_expense: "7.48", selling_and_development: "12.77", total_opex: "20.25", operating_income: "15.06", interest_share: "0.0140", interest_expense: "1.40", pretax_income: "13.66", tax_rate: "0.228", income_tax: "3.11", net_income: "10.55" },
            { company_id: 1, period_id: 5, statement_no: 65, underlying_revenue: "205.61", seasonal_revenue: "193.27", demand_noise: "0.993", revenue: "191.92", cogs_noise: "0.982", cogs_ratio_applied: "0.432", cost_of_sales: "82.91", gross_profit: "109.01", selling_share: "0.093", development_share: "0.051", admin_share: "0.054", selling_expense: "17.85", development_expense: "9.79", admin_expense: "10.36", selling_and_development: "27.64", total_opex: "38.00", operating_income: "71.01", interest_share: "0.0082", interest_expense: "1.57", pretax_income: "69.44", tax_rate: "0.244", income_tax: "16.94", net_income: "52.50" },
            { company_id: 3, period_id: 10, statement_no: 66, underlying_revenue: "88.04", seasonal_revenue: "88.04", demand_noise: "0.984", revenue: "86.63", cogs_noise: "0.989", cogs_ratio_applied: "0.534", cost_of_sales: "46.26", gross_profit: "40.37", selling_share: "0.094", development_share: "0.092", admin_share: "0.062", selling_expense: "8.14", development_expense: "7.97", admin_expense: "5.37", selling_and_development: "16.11", total_opex: "21.48", operating_income: "18.89", interest_share: "0.0185", interest_expense: "1.60", pretax_income: "17.29", tax_rate: "0.242", income_tax: "4.18", net_income: "13.11" },
            { company_id: 7, period_id: 6, statement_no: 67, underlying_revenue: "166.56", seasonal_revenue: "166.56", demand_noise: "1.029", revenue: "171.39", cogs_noise: "0.999", cogs_ratio_applied: "0.739", cost_of_sales: "126.66", gross_profit: "44.73", selling_share: "0.095", development_share: "0.073", admin_share: "0.074", selling_expense: "16.28", development_expense: "12.51", admin_expense: "12.68", selling_and_development: "28.79", total_opex: "41.47", operating_income: "3.26", interest_share: "0.0149", interest_expense: "2.55", pretax_income: "0.71", tax_rate: "0.186", income_tax: "0.13", net_income: "0.58" },
            { company_id: 2, period_id: 11, statement_no: 68, underlying_revenue: "177.18", seasonal_revenue: "171.86", demand_noise: "1.000", revenue: "171.86", cogs_noise: "1.015", cogs_ratio_applied: "0.497", cost_of_sales: "85.41", gross_profit: "86.45", selling_share: "0.091", development_share: "0.045", admin_share: "0.052", selling_expense: "15.64", development_expense: "7.73", admin_expense: "8.94", selling_and_development: "23.37", total_opex: "32.31", operating_income: "54.14", interest_share: "0.0101", interest_expense: "1.74", pretax_income: "52.40", tax_rate: "0.200", income_tax: "10.48", net_income: "41.92" },
            { company_id: 4, period_id: 7, statement_no: 69, underlying_revenue: "65.08", seasonal_revenue: "63.13", demand_noise: "0.998", revenue: "63.00", cogs_noise: "1.013", cogs_ratio_applied: "0.598", cost_of_sales: "37.67", gross_profit: "25.33", selling_share: "0.100", development_share: "0.085", admin_share: "0.064", selling_expense: "6.30", development_expense: "5.36", admin_expense: "4.03", selling_and_development: "11.66", total_opex: "15.69", operating_income: "9.64", interest_share: "0.0073", interest_expense: "0.46", pretax_income: "9.18", tax_rate: "0.182", income_tax: "1.67", net_income: "7.51" },
            { company_id: 8, period_id: 4, statement_no: 70, underlying_revenue: "101.97", seasonal_revenue: "114.21", demand_noise: "0.998", revenue: "113.98", cogs_noise: "0.986", cogs_ratio_applied: "0.779", cost_of_sales: "88.79", gross_profit: "25.19", selling_share: "0.100", development_share: "0.060", admin_share: "0.083", selling_expense: "11.40", development_expense: "6.84", admin_expense: "9.46", selling_and_development: "18.24", total_opex: "27.70", operating_income: "-2.51", interest_share: "0.0086", interest_expense: "0.98", pretax_income: "-3.49", tax_rate: "0.200", income_tax: "-0.70", net_income: "-2.79" },
            { company_id: 4, period_id: 6, statement_no: 71, underlying_revenue: "64.19", seasonal_revenue: "64.19", demand_noise: "0.988", revenue: "63.42", cogs_noise: "1.005", cogs_ratio_applied: "0.593", cost_of_sales: "37.61", gross_profit: "25.81", selling_share: "0.113", development_share: "0.053", admin_share: "0.055", selling_expense: "7.17", development_expense: "3.36", admin_expense: "3.49", selling_and_development: "10.53", total_opex: "14.02", operating_income: "11.79", interest_share: "0.0055", interest_expense: "0.35", pretax_income: "11.44", tax_rate: "0.232", income_tax: "2.65", net_income: "8.79" },
            { company_id: 5, period_id: 5, statement_no: 72, underlying_revenue: "104.57", seasonal_revenue: "98.30", demand_noise: "0.977", revenue: "96.04", cogs_noise: "1.006", cogs_ratio_applied: "0.644", cost_of_sales: "61.85", gross_profit: "34.19", selling_share: "0.103", development_share: "0.099", admin_share: "0.070", selling_expense: "9.89", development_expense: "9.51", admin_expense: "6.72", selling_and_development: "19.40", total_opex: "26.12", operating_income: "8.07", interest_share: "0.0109", interest_expense: "1.05", pretax_income: "7.02", tax_rate: "0.199", income_tax: "1.40", net_income: "5.62" },
            { company_id: 2, period_id: 7, statement_no: 73, underlying_revenue: "167.94", seasonal_revenue: "162.90", demand_noise: "1.000", revenue: "162.90", cogs_noise: "0.999", cogs_ratio_applied: "0.490", cost_of_sales: "79.82", gross_profit: "83.08", selling_share: "0.083", development_share: "0.096", admin_share: "0.088", selling_expense: "13.52", development_expense: "15.64", admin_expense: "14.34", selling_and_development: "29.16", total_opex: "43.50", operating_income: "39.58", interest_share: "0.0192", interest_expense: "3.13", pretax_income: "36.45", tax_rate: "0.248", income_tax: "9.04", net_income: "27.41" },
            { company_id: 3, period_id: 7, statement_no: 74, underlying_revenue: "84.55", seasonal_revenue: "82.01", demand_noise: "0.989", revenue: "81.11", cogs_noise: "0.998", cogs_ratio_applied: "0.539", cost_of_sales: "43.72", gross_profit: "37.39", selling_share: "0.109", development_share: "0.053", admin_share: "0.052", selling_expense: "8.84", development_expense: "4.30", admin_expense: "4.22", selling_and_development: "13.14", total_opex: "17.36", operating_income: "20.03", interest_share: "0.0086", interest_expense: "0.70", pretax_income: "19.33", tax_rate: "0.210", income_tax: "4.06", net_income: "15.27" },
            { company_id: 5, period_id: 11, statement_no: 75, underlying_revenue: "113.45", seasonal_revenue: "110.05", demand_noise: "1.036", revenue: "114.01", cogs_noise: "1.015", cogs_ratio_applied: "0.650", cost_of_sales: "74.11", gross_profit: "39.90", selling_share: "0.102", development_share: "0.040", admin_share: "0.083", selling_expense: "11.63", development_expense: "4.56", admin_expense: "9.46", selling_and_development: "16.19", total_opex: "25.65", operating_income: "14.25", interest_share: "0.0114", interest_expense: "1.30", pretax_income: "12.95", tax_rate: "0.235", income_tax: "3.04", net_income: "9.91" },
            { company_id: 2, period_id: 8, statement_no: 76, underlying_revenue: "170.25", seasonal_revenue: "190.68", demand_noise: "1.004", revenue: "191.44", cogs_noise: "1.005", cogs_ratio_applied: "0.492", cost_of_sales: "94.19", gross_profit: "97.25", selling_share: "0.090", development_share: "0.083", admin_share: "0.087", selling_expense: "17.23", development_expense: "15.89", admin_expense: "16.66", selling_and_development: "33.12", total_opex: "49.78", operating_income: "47.47", interest_share: "0.0075", interest_expense: "1.44", pretax_income: "46.03", tax_rate: "0.258", income_tax: "11.88", net_income: "34.15" },
            { company_id: 5, period_id: 4, statement_no: 77, underlying_revenue: "103.09", seasonal_revenue: "115.46", demand_noise: "0.980", revenue: "113.15", cogs_noise: "0.982", cogs_ratio_applied: "0.628", cost_of_sales: "71.06", gross_profit: "42.09", selling_share: "0.093", development_share: "0.100", admin_share: "0.078", selling_expense: "10.52", development_expense: "11.32", admin_expense: "8.83", selling_and_development: "21.84", total_opex: "30.67", operating_income: "11.42", interest_share: "0.0172", interest_expense: "1.95", pretax_income: "9.47", tax_rate: "0.220", income_tax: "2.08", net_income: "7.39" },
            { company_id: 8, period_id: 5, statement_no: 78, underlying_revenue: "103.43", seasonal_revenue: "97.22", demand_noise: "0.981", revenue: "95.37", cogs_noise: "0.996", cogs_ratio_applied: "0.787", cost_of_sales: "75.06", gross_profit: "20.31", selling_share: "0.116", development_share: "0.043", admin_share: "0.075", selling_expense: "11.06", development_expense: "4.10", admin_expense: "7.15", selling_and_development: "15.16", total_opex: "22.31", operating_income: "-2.00", interest_share: "0.0143", interest_expense: "1.36", pretax_income: "-3.36", tax_rate: "0.247", income_tax: "-0.83", net_income: "-2.53" },
            { company_id: 7, period_id: 7, statement_no: 79, underlying_revenue: "168.88", seasonal_revenue: "163.81", demand_noise: "1.031", revenue: "168.89", cogs_noise: "0.996", cogs_ratio_applied: "0.737", cost_of_sales: "124.47", gross_profit: "44.42", selling_share: "0.099", development_share: "0.043", admin_share: "0.086", selling_expense: "16.72", development_expense: "7.26", admin_expense: "14.52", selling_and_development: "23.98", total_opex: "38.50", operating_income: "5.92", interest_share: "0.0065", interest_expense: "1.10", pretax_income: "4.82", tax_rate: "0.266", income_tax: "1.28", net_income: "3.54" },
            { company_id: 3, period_id: 8, statement_no: 80, underlying_revenue: "85.71", seasonal_revenue: "96.00", demand_noise: "0.992", revenue: "95.23", cogs_noise: "1.003", cogs_ratio_applied: "0.542", cost_of_sales: "51.61", gross_profit: "43.62", selling_share: "0.076", development_share: "0.063", admin_share: "0.075", selling_expense: "7.24", development_expense: "6.00", admin_expense: "7.14", selling_and_development: "13.24", total_opex: "20.38", operating_income: "23.24", interest_share: "0.0043", interest_expense: "0.41", pretax_income: "22.83", tax_rate: "0.211", income_tax: "4.82", net_income: "18.01" },
            { company_id: 2, period_id: 10, statement_no: 81, underlying_revenue: "174.87", seasonal_revenue: "174.87", demand_noise: "0.993", revenue: "173.65", cogs_noise: "0.983", cogs_ratio_applied: "0.482", cost_of_sales: "83.70", gross_profit: "89.95", selling_share: "0.087", development_share: "0.047", admin_share: "0.068", selling_expense: "15.11", development_expense: "8.16", admin_expense: "11.81", selling_and_development: "23.27", total_opex: "35.08", operating_income: "54.87", interest_share: "0.0128", interest_expense: "2.22", pretax_income: "52.65", tax_rate: "0.233", income_tax: "12.27", net_income: "40.38" },
            { company_id: 7, period_id: 3, statement_no: 82, underlying_revenue: "159.59", seasonal_revenue: "154.80", demand_noise: "0.977", revenue: "151.24", cogs_noise: "0.990", cogs_ratio_applied: "0.733", cost_of_sales: "110.86", gross_profit: "40.38", selling_share: "0.092", development_share: "0.065", admin_share: "0.076", selling_expense: "13.91", development_expense: "9.83", admin_expense: "11.49", selling_and_development: "23.74", total_opex: "35.23", operating_income: "5.15", interest_share: "0.0118", interest_expense: "1.78", pretax_income: "3.37", tax_rate: "0.266", income_tax: "0.90", net_income: "2.47" },
            { company_id: 2, period_id: 2, statement_no: 83, underlying_revenue: "156.38", seasonal_revenue: "156.38", demand_noise: "1.004", revenue: "157.01", cogs_noise: "1.015", cogs_ratio_applied: "0.497", cost_of_sales: "78.03", gross_profit: "78.98", selling_share: "0.110", development_share: "0.098", admin_share: "0.053", selling_expense: "17.27", development_expense: "15.39", admin_expense: "8.32", selling_and_development: "32.66", total_opex: "40.98", operating_income: "38.00", interest_share: "0.0061", interest_expense: "0.96", pretax_income: "37.04", tax_rate: "0.221", income_tax: "8.19", net_income: "28.85" },
            { company_id: 5, period_id: 2, statement_no: 84, underlying_revenue: "100.13", seasonal_revenue: "100.13", demand_noise: "1.006", revenue: "100.73", cogs_noise: "1.002", cogs_ratio_applied: "0.641", cost_of_sales: "64.57", gross_profit: "36.16", selling_share: "0.076", development_share: "0.061", admin_share: "0.068", selling_expense: "7.66", development_expense: "6.14", admin_expense: "6.85", selling_and_development: "13.80", total_opex: "20.65", operating_income: "15.51", interest_share: "0.0069", interest_expense: "0.70", pretax_income: "14.81", tax_rate: "0.247", income_tax: "3.66", net_income: "11.15" },
            { company_id: 3, period_id: 2, statement_no: 85, underlying_revenue: "78.73", seasonal_revenue: "78.73", demand_noise: "0.964", revenue: "75.90", cogs_noise: "1.005", cogs_ratio_applied: "0.543", cost_of_sales: "41.21", gross_profit: "34.69", selling_share: "0.093", development_share: "0.086", admin_share: "0.068", selling_expense: "7.06", development_expense: "6.53", admin_expense: "5.16", selling_and_development: "13.59", total_opex: "18.75", operating_income: "15.94", interest_share: "0.0148", interest_expense: "1.12", pretax_income: "14.82", tax_rate: "0.244", income_tax: "3.62", net_income: "11.20" },
            { company_id: 3, period_id: 1, statement_no: 86, underlying_revenue: "77.57", seasonal_revenue: "72.92", demand_noise: "1.009", revenue: "73.58", cogs_noise: "1.008", cogs_ratio_applied: "0.544", cost_of_sales: "40.03", gross_profit: "33.55", selling_share: "0.074", development_share: "0.079", admin_share: "0.080", selling_expense: "5.44", development_expense: "5.81", admin_expense: "5.89", selling_and_development: "11.25", total_opex: "17.14", operating_income: "16.41", interest_share: "0.0120", interest_expense: "0.88", pretax_income: "15.53", tax_rate: "0.222", income_tax: "3.45", net_income: "12.08" },
            { company_id: 2, period_id: 1, statement_no: 87, underlying_revenue: "154.07", seasonal_revenue: "144.83", demand_noise: "1.001", revenue: "144.97", cogs_noise: "0.993", cogs_ratio_applied: "0.487", cost_of_sales: "70.60", gross_profit: "74.37", selling_share: "0.080", development_share: "0.050", admin_share: "0.066", selling_expense: "11.60", development_expense: "7.25", admin_expense: "9.57", selling_and_development: "18.85", total_opex: "28.42", operating_income: "45.95", interest_share: "0.0181", interest_expense: "2.62", pretax_income: "43.33", tax_rate: "0.229", income_tax: "9.92", net_income: "33.41" },
            { company_id: 1, period_id: 7, statement_no: 88, underlying_revenue: "211.43", seasonal_revenue: "205.09", demand_noise: "1.014", revenue: "207.96", cogs_noise: "0.998", cogs_ratio_applied: "0.439", cost_of_sales: "91.29", gross_profit: "116.67", selling_share: "0.114", development_share: "0.097", admin_share: "0.086", selling_expense: "23.71", development_expense: "20.17", admin_expense: "17.88", selling_and_development: "43.88", total_opex: "61.76", operating_income: "54.91", interest_share: "0.0061", interest_expense: "1.27", pretax_income: "53.64", tax_rate: "0.211", income_tax: "11.32", net_income: "42.32" },
            { company_id: 8, period_id: 6, statement_no: 89, underlying_revenue: "104.90", seasonal_revenue: "104.90", demand_noise: "0.991", revenue: "103.96", cogs_noise: "1.001", cogs_ratio_applied: "0.791", cost_of_sales: "82.23", gross_profit: "21.73", selling_share: "0.105", development_share: "0.068", admin_share: "0.074", selling_expense: "10.92", development_expense: "7.07", admin_expense: "7.69", selling_and_development: "17.99", total_opex: "25.68", operating_income: "-3.95", interest_share: "0.0114", interest_expense: "1.19", pretax_income: "-5.14", tax_rate: "0.234", income_tax: "-1.20", net_income: "-3.94" },
            { company_id: 6, period_id: 8, statement_no: 90, underlying_revenue: "69.92", seasonal_revenue: "78.31", demand_noise: "1.012", revenue: "79.25", cogs_noise: "1.003", cogs_ratio_applied: "0.692", cost_of_sales: "54.84", gross_profit: "24.41", selling_share: "0.116", development_share: "0.046", admin_share: "0.088", selling_expense: "9.19", development_expense: "3.65", admin_expense: "6.97", selling_and_development: "12.84", total_opex: "19.81", operating_income: "4.60", interest_share: "0.0166", interest_expense: "1.32", pretax_income: "3.28", tax_rate: "0.263", income_tax: "0.86", net_income: "2.42" },
            { company_id: 1, period_id: 4, statement_no: 91, underlying_revenue: "202.70", seasonal_revenue: "227.02", demand_noise: "1.007", revenue: "228.61", cogs_noise: "0.982", cogs_ratio_applied: "0.432", cost_of_sales: "98.76", gross_profit: "129.85", selling_share: "0.099", development_share: "0.098", admin_share: "0.079", selling_expense: "22.63", development_expense: "22.40", admin_expense: "18.06", selling_and_development: "45.03", total_opex: "63.09", operating_income: "66.76", interest_share: "0.0068", interest_expense: "1.55", pretax_income: "65.21", tax_rate: "0.181", income_tax: "11.80", net_income: "53.41" },
            { company_id: 2, period_id: 9, statement_no: 92, underlying_revenue: "172.56", seasonal_revenue: "162.21", demand_noise: "1.004", revenue: "162.86", cogs_noise: "1.003", cogs_ratio_applied: "0.491", cost_of_sales: "79.96", gross_profit: "82.90", selling_share: "0.104", development_share: "0.068", admin_share: "0.074", selling_expense: "16.94", development_expense: "11.07", admin_expense: "12.05", selling_and_development: "28.01", total_opex: "40.06", operating_income: "42.84", interest_share: "0.0158", interest_expense: "2.57", pretax_income: "40.27", tax_rate: "0.228", income_tax: "9.18", net_income: "31.09" },
            { company_id: 3, period_id: 6, statement_no: 93, underlying_revenue: "83.39", seasonal_revenue: "83.39", demand_noise: "1.022", revenue: "85.22", cogs_noise: "1.020", cogs_ratio_applied: "0.551", cost_of_sales: "46.96", gross_profit: "38.26", selling_share: "0.092", development_share: "0.059", admin_share: "0.086", selling_expense: "7.84", development_expense: "5.03", admin_expense: "7.33", selling_and_development: "12.87", total_opex: "20.20", operating_income: "18.06", interest_share: "0.0050", interest_expense: "0.43", pretax_income: "17.63", tax_rate: "0.268", income_tax: "4.72", net_income: "12.91" },
            { company_id: 2, period_id: 12, statement_no: 94, underlying_revenue: "179.49", seasonal_revenue: "201.03", demand_noise: "1.030", revenue: "207.06", cogs_noise: "1.004", cogs_ratio_applied: "0.492", cost_of_sales: "101.87", gross_profit: "105.19", selling_share: "0.080", development_share: "0.066", admin_share: "0.085", selling_expense: "16.56", development_expense: "13.67", admin_expense: "17.60", selling_and_development: "30.23", total_opex: "47.83", operating_income: "57.36", interest_share: "0.0105", interest_expense: "2.17", pretax_income: "55.19", tax_rate: "0.182", income_tax: "10.04", net_income: "45.15" },
            { company_id: 5, period_id: 1, statement_no: 95, underlying_revenue: "98.65", seasonal_revenue: "92.73", demand_noise: "1.024", revenue: "94.96", cogs_noise: "0.990", cogs_ratio_applied: "0.634", cost_of_sales: "60.20", gross_profit: "34.76", selling_share: "0.113", development_share: "0.087", admin_share: "0.070", selling_expense: "10.73", development_expense: "8.26", admin_expense: "6.65", selling_and_development: "18.99", total_opex: "25.64", operating_income: "9.12", interest_share: "0.0145", interest_expense: "1.38", pretax_income: "7.74", tax_rate: "0.198", income_tax: "1.53", net_income: "6.21" },
            { company_id: 4, period_id: 11, statement_no: 96, underlying_revenue: "68.67", seasonal_revenue: "66.61", demand_noise: "1.004", revenue: "66.88", cogs_noise: "1.017", cogs_ratio_applied: "0.600", cost_of_sales: "40.13", gross_profit: "26.75", selling_share: "0.097", development_share: "0.087", admin_share: "0.051", selling_expense: "6.49", development_expense: "5.82", admin_expense: "3.41", selling_and_development: "12.31", total_opex: "15.72", operating_income: "11.03", interest_share: "0.0180", interest_expense: "1.20", pretax_income: "9.83", tax_rate: "0.192", income_tax: "1.89", net_income: "7.94" },
        ],
    });
    await prisma.balance_sheets.createMany({
        data: [
            { id: 1, statement_id: 17, company_id: 6, period_id: 1, cash_share: "0.632", receivables_share: "0.375", inventory_share: "0.258", ppe_share: "1.246", payables_share: "0.151", short_debt_share: "0.064", long_debt_share: "0.523", cash: "36.80", receivables: "21.84", inventory: "10.41", cash_and_receivables: "58.64", total_current_assets: "69.05", property_equipment: "72.55", total_assets: "141.60", payables: "6.09", short_term_debt: "3.73", total_current_liabilities: "9.82", long_term_debt: "30.45", total_liabilities: "40.27", total_equity: "101.33" },
            { id: 2, statement_id: 71, company_id: 4, period_id: 6, cash_share: "0.590", receivables_share: "0.442", inventory_share: "0.366", ppe_share: "1.480", payables_share: "0.193", short_debt_share: "0.144", long_debt_share: "0.789", cash: "37.42", receivables: "28.03", inventory: "13.77", cash_and_receivables: "65.45", total_current_assets: "79.22", property_equipment: "93.86", total_assets: "173.08", payables: "7.26", short_term_debt: "9.13", total_current_liabilities: "16.39", long_term_debt: "50.04", total_liabilities: "66.43", total_equity: "106.65" },
            { id: 3, statement_id: 53, company_id: 7, period_id: 12, cash_share: "0.789", receivables_share: "0.405", inventory_share: "0.250", ppe_share: "1.170", payables_share: "0.215", short_debt_share: "0.153", long_debt_share: "0.763", cash: "158.39", receivables: "81.30", inventory: "37.09", cash_and_receivables: "239.69", total_current_assets: "276.78", property_equipment: "234.88", total_assets: "511.66", payables: "31.90", short_term_debt: "30.71", total_current_liabilities: "62.61", long_term_debt: "153.17", total_liabilities: "215.78", total_equity: "295.88" },
            { id: 4, statement_id: 66, company_id: 3, period_id: 10, cash_share: "0.889", receivables_share: "0.252", inventory_share: "0.377", ppe_share: "1.543", payables_share: "0.221", short_debt_share: "0.186", long_debt_share: "0.747", cash: "77.01", receivables: "21.83", inventory: "17.44", cash_and_receivables: "98.84", total_current_assets: "116.28", property_equipment: "133.67", total_assets: "249.95", payables: "10.22", short_term_debt: "16.11", total_current_liabilities: "26.33", long_term_debt: "64.71", total_liabilities: "91.04", total_equity: "158.91" },
            { id: 5, statement_id: 12, company_id: 3, period_id: 5, cash_share: "0.811", receivables_share: "0.407", inventory_share: "0.257", ppe_share: "1.075", payables_share: "0.299", short_debt_share: "0.158", long_debt_share: "0.630", cash: "60.55", receivables: "30.39", inventory: "10.44", cash_and_receivables: "90.94", total_current_assets: "101.38", property_equipment: "80.26", total_assets: "181.64", payables: "12.15", short_term_debt: "11.80", total_current_liabilities: "23.95", long_term_debt: "47.04", total_liabilities: "70.99", total_equity: "110.65" },
            { id: 6, statement_id: 2, company_id: 4, period_id: 12, cash_share: "0.283", receivables_share: "0.333", inventory_share: "0.449", ppe_share: "1.415", payables_share: "0.247", short_debt_share: "0.086", long_debt_share: "0.393", cash: "22.27", receivables: "26.20", inventory: "20.88", cash_and_receivables: "48.47", total_current_assets: "69.35", property_equipment: "111.35", total_assets: "180.70", payables: "11.49", short_term_debt: "6.77", total_current_liabilities: "18.26", long_term_debt: "30.93", total_liabilities: "49.19", total_equity: "131.51" },
            { id: 7, statement_id: 3, company_id: 7, period_id: 9, cash_share: "0.738", receivables_share: "0.438", inventory_share: "0.443", ppe_share: "1.178", payables_share: "0.184", short_debt_share: "0.179", long_debt_share: "0.654", cash: "117.50", receivables: "69.73", inventory: "52.33", cash_and_receivables: "187.23", total_current_assets: "239.56", property_equipment: "187.55", total_assets: "427.11", payables: "21.74", short_term_debt: "28.50", total_current_liabilities: "50.24", long_term_debt: "104.12", total_liabilities: "154.36", total_equity: "272.75" },
            { id: 8, statement_id: 49, company_id: 5, period_id: 6, cash_share: "0.629", receivables_share: "0.345", inventory_share: "0.467", ppe_share: "1.937", payables_share: "0.216", short_debt_share: "0.159", long_debt_share: "0.836", cash: "67.50", receivables: "37.03", inventory: "32.38", cash_and_receivables: "104.53", total_current_assets: "136.91", property_equipment: "207.88", total_assets: "344.79", payables: "14.98", short_term_debt: "17.06", total_current_liabilities: "32.04", long_term_debt: "89.72", total_liabilities: "121.76", total_equity: "223.03" },
            { id: 9, statement_id: 67, company_id: 7, period_id: 6, cash_share: "0.676", receivables_share: "0.315", inventory_share: "0.321", ppe_share: "1.189", payables_share: "0.199", short_debt_share: "0.191", long_debt_share: "0.535", cash: "115.86", receivables: "53.99", inventory: "40.66", cash_and_receivables: "169.85", total_current_assets: "210.51", property_equipment: "203.78", total_assets: "414.29", payables: "25.21", short_term_debt: "32.74", total_current_liabilities: "57.95", long_term_debt: "91.69", total_liabilities: "149.64", total_equity: "264.65" },
            { id: 10, statement_id: 42, company_id: 7, period_id: 8, cash_share: "0.255", receivables_share: "0.314", inventory_share: "0.393", ppe_share: "1.508", payables_share: "0.223", short_debt_share: "0.121", long_debt_share: "0.609", cash: "48.75", receivables: "60.03", inventory: "56.20", cash_and_receivables: "108.78", total_current_assets: "164.98", property_equipment: "288.30", total_assets: "453.28", payables: "31.89", short_term_debt: "23.13", total_current_liabilities: "55.02", long_term_debt: "116.43", total_liabilities: "171.45", total_equity: "281.83" },
            { id: 11, statement_id: 9, company_id: 7, period_id: 1, cash_share: "0.493", receivables_share: "0.266", inventory_share: "0.395", ppe_share: "1.942", payables_share: "0.290", short_debt_share: "0.168", long_debt_share: "0.741", cash: "71.87", receivables: "38.78", inventory: "42.38", cash_and_receivables: "110.65", total_current_assets: "153.03", property_equipment: "283.12", total_assets: "436.15", payables: "31.12", short_term_debt: "24.49", total_current_liabilities: "55.61", long_term_debt: "108.03", total_liabilities: "163.64", total_equity: "272.51" },
            { id: 12, statement_id: 39, company_id: 8, period_id: 1, cash_share: "0.380", receivables_share: "0.405", inventory_share: "0.429", ppe_share: "1.532", payables_share: "0.232", short_debt_share: "0.141", long_debt_share: "0.873", cash: "34.79", receivables: "37.08", inventory: "30.71", cash_and_receivables: "71.87", total_current_assets: "102.58", property_equipment: "140.25", total_assets: "242.83", payables: "16.61", short_term_debt: "12.91", total_current_liabilities: "29.52", long_term_debt: "79.92", total_liabilities: "109.44", total_equity: "133.39" },
            { id: 13, statement_id: 74, company_id: 3, period_id: 7, cash_share: "0.862", receivables_share: "0.378", inventory_share: "0.201", ppe_share: "1.329", payables_share: "0.240", short_debt_share: "0.099", long_debt_share: "0.929", cash: "69.92", receivables: "30.66", inventory: "8.79", cash_and_receivables: "100.58", total_current_assets: "109.37", property_equipment: "107.80", total_assets: "217.17", payables: "10.49", short_term_debt: "8.03", total_current_liabilities: "18.52", long_term_debt: "75.35", total_liabilities: "93.87", total_equity: "123.30" },
            { id: 14, statement_id: 14, company_id: 1, period_id: 6, cash_share: "0.765", receivables_share: "0.421", inventory_share: "0.353", ppe_share: "1.580", payables_share: "0.294", short_debt_share: "0.067", long_debt_share: "0.930", cash: "160.31", receivables: "88.22", inventory: "32.18", cash_and_receivables: "248.53", total_current_assets: "280.71", property_equipment: "331.10", total_assets: "611.81", payables: "26.80", short_term_debt: "14.04", total_current_liabilities: "40.84", long_term_debt: "194.89", total_liabilities: "235.73", total_equity: "376.08" },
            { id: 15, statement_id: 24, company_id: 6, period_id: 9, cash_share: "0.804", receivables_share: "0.286", inventory_share: "0.248", ppe_share: "1.955", payables_share: "0.244", short_debt_share: "0.060", long_debt_share: "0.966", cash: "53.08", receivables: "18.88", inventory: "11.28", cash_and_receivables: "71.96", total_current_assets: "83.24", property_equipment: "129.07", total_assets: "212.31", payables: "11.10", short_term_debt: "3.96", total_current_liabilities: "15.06", long_term_debt: "63.78", total_liabilities: "78.84", total_equity: "133.47" },
            { id: 16, statement_id: 33, company_id: 4, period_id: 9, cash_share: "0.780", receivables_share: "0.329", inventory_share: "0.462", ppe_share: "1.726", payables_share: "0.282", short_debt_share: "0.144", long_debt_share: "0.447", cash: "48.31", receivables: "20.37", inventory: "16.71", cash_and_receivables: "68.68", total_current_assets: "85.39", property_equipment: "106.89", total_assets: "192.28", payables: "10.20", short_term_debt: "8.92", total_current_liabilities: "19.12", long_term_debt: "27.68", total_liabilities: "46.80", total_equity: "145.48" },
            { id: 17, statement_id: 58, company_id: 3, period_id: 11, cash_share: "0.354", receivables_share: "0.349", inventory_share: "0.325", ppe_share: "1.547", payables_share: "0.197", short_debt_share: "0.179", long_debt_share: "0.403", cash: "29.96", receivables: "29.54", inventory: "14.93", cash_and_receivables: "59.50", total_current_assets: "74.43", property_equipment: "130.92", total_assets: "205.35", payables: "9.05", short_term_debt: "15.15", total_current_liabilities: "24.20", long_term_debt: "34.11", total_liabilities: "58.31", total_equity: "147.04" },
            { id: 18, statement_id: 73, company_id: 2, period_id: 7, cash_share: "0.859", receivables_share: "0.270", inventory_share: "0.234", ppe_share: "1.580", payables_share: "0.276", short_debt_share: "0.114", long_debt_share: "0.324", cash: "139.93", receivables: "43.98", inventory: "18.68", cash_and_receivables: "183.91", total_current_assets: "202.59", property_equipment: "257.38", total_assets: "459.97", payables: "22.03", short_term_debt: "18.57", total_current_liabilities: "40.60", long_term_debt: "52.78", total_liabilities: "93.38", total_equity: "366.59" },
            { id: 19, statement_id: 34, company_id: 1, period_id: 9, cash_share: "0.320", receivables_share: "0.436", inventory_share: "0.470", ppe_share: "1.118", payables_share: "0.295", short_debt_share: "0.179", long_debt_share: "0.635", cash: "66.98", receivables: "91.26", inventory: "43.78", cash_and_receivables: "158.24", total_current_assets: "202.02", property_equipment: "234.02", total_assets: "436.04", payables: "27.48", short_term_debt: "37.47", total_current_liabilities: "64.95", long_term_debt: "132.92", total_liabilities: "197.87", total_equity: "238.17" },
            { id: 20, statement_id: 15, company_id: 7, period_id: 2, cash_share: "0.302", receivables_share: "0.352", inventory_share: "0.381", ppe_share: "1.672", payables_share: "0.300", short_debt_share: "0.076", long_debt_share: "0.450", cash: "48.44", receivables: "56.46", inventory: "44.62", cash_and_receivables: "104.90", total_current_assets: "149.52", property_equipment: "268.21", total_assets: "417.73", payables: "35.13", short_term_debt: "12.19", total_current_liabilities: "47.32", long_term_debt: "72.18", total_liabilities: "119.50", total_equity: "298.23" },
            { id: 21, statement_id: 5, company_id: 2, period_id: 6, cash_share: "0.327", receivables_share: "0.292", inventory_share: "0.467", ppe_share: "1.481", payables_share: "0.249", short_debt_share: "0.139", long_debt_share: "0.837", cash: "52.81", receivables: "47.16", inventory: "37.41", cash_and_receivables: "99.97", total_current_assets: "137.38", property_equipment: "239.17", total_assets: "376.55", payables: "19.94", short_term_debt: "22.45", total_current_liabilities: "42.39", long_term_debt: "135.17", total_liabilities: "177.56", total_equity: "198.99" },
            { id: 22, statement_id: 56, company_id: 6, period_id: 3, cash_share: "0.753", receivables_share: "0.258", inventory_share: "0.209", ppe_share: "1.350", payables_share: "0.276", short_debt_share: "0.054", long_debt_share: "0.683", cash: "48.18", receivables: "16.51", inventory: "9.15", cash_and_receivables: "64.69", total_current_assets: "73.84", property_equipment: "86.37", total_assets: "160.21", payables: "12.08", short_term_debt: "3.45", total_current_liabilities: "15.53", long_term_debt: "43.70", total_liabilities: "59.23", total_equity: "100.98" },
            { id: 23, statement_id: 65, company_id: 1, period_id: 5, cash_share: "0.638", receivables_share: "0.357", inventory_share: "0.402", ppe_share: "1.954", payables_share: "0.187", short_debt_share: "0.102", long_debt_share: "0.666", cash: "122.44", receivables: "68.52", inventory: "33.33", cash_and_receivables: "190.96", total_current_assets: "224.29", property_equipment: "375.01", total_assets: "599.30", payables: "15.50", short_term_debt: "19.58", total_current_liabilities: "35.08", long_term_debt: "127.82", total_liabilities: "162.90", total_equity: "436.40" },
            { id: 24, statement_id: 6, company_id: 1, period_id: 2, cash_share: "0.544", receivables_share: "0.304", inventory_share: "0.488", ppe_share: "1.901", payables_share: "0.220", short_debt_share: "0.057", long_debt_share: "0.422", cash: "105.82", receivables: "59.13", inventory: "42.81", cash_and_receivables: "164.95", total_current_assets: "207.76", property_equipment: "369.78", total_assets: "577.54", payables: "19.30", short_term_debt: "11.09", total_current_liabilities: "30.39", long_term_debt: "82.09", total_liabilities: "112.48", total_equity: "465.06" },
            { id: 25, statement_id: 85, company_id: 3, period_id: 2, cash_share: "0.450", receivables_share: "0.341", inventory_share: "0.298", ppe_share: "1.962", payables_share: "0.161", short_debt_share: "0.099", long_debt_share: "0.795", cash: "34.16", receivables: "25.88", inventory: "12.28", cash_and_receivables: "60.04", total_current_assets: "72.32", property_equipment: "148.92", total_assets: "221.24", payables: "6.63", short_term_debt: "7.51", total_current_liabilities: "14.14", long_term_debt: "60.34", total_liabilities: "74.48", total_equity: "146.76" },
            { id: 26, statement_id: 68, company_id: 2, period_id: 11, cash_share: "0.451", receivables_share: "0.392", inventory_share: "0.362", ppe_share: "1.979", payables_share: "0.291", short_debt_share: "0.150", long_debt_share: "0.926", cash: "77.51", receivables: "67.37", inventory: "30.92", cash_and_receivables: "144.88", total_current_assets: "175.80", property_equipment: "340.11", total_assets: "515.91", payables: "24.85", short_term_debt: "25.78", total_current_liabilities: "50.63", long_term_debt: "159.14", total_liabilities: "209.77", total_equity: "306.14" },
            { id: 27, statement_id: 50, company_id: 1, period_id: 12, cash_share: "0.573", receivables_share: "0.407", inventory_share: "0.239", ppe_share: "1.537", payables_share: "0.166", short_debt_share: "0.122", long_debt_share: "0.613", cash: "148.65", receivables: "105.59", inventory: "27.53", cash_and_receivables: "254.24", total_current_assets: "281.77", property_equipment: "398.74", total_assets: "680.51", payables: "19.12", short_term_debt: "31.65", total_current_liabilities: "50.77", long_term_debt: "159.03", total_liabilities: "209.80", total_equity: "470.71" },
            { id: 28, statement_id: 23, company_id: 1, period_id: 10, cash_share: "0.402", receivables_share: "0.444", inventory_share: "0.494", ppe_share: "1.481", payables_share: "0.210", short_debt_share: "0.056", long_debt_share: "0.913", cash: "88.42", receivables: "97.65", inventory: "47.48", cash_and_receivables: "186.07", total_current_assets: "233.55", property_equipment: "325.73", total_assets: "559.28", payables: "20.18", short_term_debt: "12.32", total_current_liabilities: "32.50", long_term_debt: "200.81", total_liabilities: "233.31", total_equity: "325.97" },
            { id: 29, statement_id: 4, company_id: 8, period_id: 8, cash_share: "0.324", receivables_share: "0.296", inventory_share: "0.280", ppe_share: "1.149", payables_share: "0.261", short_debt_share: "0.151", long_debt_share: "0.379", cash: "38.78", receivables: "35.43", inventory: "26.27", cash_and_receivables: "74.21", total_current_assets: "100.48", property_equipment: "137.51", total_assets: "237.99", payables: "24.49", short_term_debt: "18.07", total_current_liabilities: "42.56", long_term_debt: "45.36", total_liabilities: "87.92", total_equity: "150.07" },
            { id: 30, statement_id: 80, company_id: 3, period_id: 8, cash_share: "0.857", receivables_share: "0.305", inventory_share: "0.389", ppe_share: "1.099", payables_share: "0.160", short_debt_share: "0.104", long_debt_share: "0.695", cash: "81.61", receivables: "29.05", inventory: "20.08", cash_and_receivables: "110.66", total_current_assets: "130.74", property_equipment: "104.66", total_assets: "235.40", payables: "8.26", short_term_debt: "9.90", total_current_liabilities: "18.16", long_term_debt: "66.18", total_liabilities: "84.34", total_equity: "151.06" },
            { id: 31, statement_id: 63, company_id: 7, period_id: 5, cash_share: "0.837", receivables_share: "0.406", inventory_share: "0.227", ppe_share: "1.583", payables_share: "0.166", short_debt_share: "0.181", long_debt_share: "0.438", cash: "131.03", receivables: "63.56", inventory: "26.65", cash_and_receivables: "194.59", total_current_assets: "221.24", property_equipment: "247.82", total_assets: "469.06", payables: "19.49", short_term_debt: "28.34", total_current_liabilities: "47.83", long_term_debt: "68.57", total_liabilities: "116.40", total_equity: "352.66" },
            { id: 32, statement_id: 78, company_id: 8, period_id: 5, cash_share: "0.510", receivables_share: "0.283", inventory_share: "0.363", ppe_share: "1.597", payables_share: "0.248", short_debt_share: "0.110", long_debt_share: "0.572", cash: "48.64", receivables: "26.99", inventory: "27.25", cash_and_receivables: "75.63", total_current_assets: "102.88", property_equipment: "152.31", total_assets: "255.19", payables: "18.61", short_term_debt: "10.49", total_current_liabilities: "29.10", long_term_debt: "54.55", total_liabilities: "83.65", total_equity: "171.54" },
            { id: 33, statement_id: 45, company_id: 4, period_id: 8, cash_share: "0.610", receivables_share: "0.400", inventory_share: "0.343", ppe_share: "1.973", payables_share: "0.250", short_debt_share: "0.176", long_debt_share: "0.367", cash: "43.86", receivables: "28.76", inventory: "14.45", cash_and_receivables: "72.62", total_current_assets: "87.07", property_equipment: "141.86", total_assets: "228.93", payables: "10.53", short_term_debt: "12.65", total_current_liabilities: "23.18", long_term_debt: "26.39", total_liabilities: "49.57", total_equity: "179.36" },
            { id: 34, statement_id: 31, company_id: 6, period_id: 6, cash_share: "0.763", receivables_share: "0.270", inventory_share: "0.481", ppe_share: "1.960", payables_share: "0.259", short_debt_share: "0.141", long_debt_share: "0.454", cash: "51.70", receivables: "18.30", inventory: "22.52", cash_and_receivables: "70.00", total_current_assets: "92.52", property_equipment: "132.81", total_assets: "225.33", payables: "12.13", short_term_debt: "9.55", total_current_liabilities: "21.68", long_term_debt: "30.76", total_liabilities: "52.44", total_equity: "172.89" },
            { id: 35, statement_id: 16, company_id: 8, period_id: 7, cash_share: "0.728", receivables_share: "0.269", inventory_share: "0.278", ppe_share: "1.103", payables_share: "0.175", short_debt_share: "0.185", long_debt_share: "0.824", cash: "73.23", receivables: "27.06", inventory: "21.98", cash_and_receivables: "100.29", total_current_assets: "122.27", property_equipment: "110.95", total_assets: "233.22", payables: "13.84", short_term_debt: "18.61", total_current_liabilities: "32.45", long_term_debt: "82.89", total_liabilities: "115.34", total_equity: "117.88" },
            { id: 36, statement_id: 22, company_id: 5, period_id: 7, cash_share: "0.862", receivables_share: "0.349", inventory_share: "0.248", ppe_share: "1.465", payables_share: "0.197", short_debt_share: "0.182", long_debt_share: "0.970", cash: "91.53", receivables: "37.06", inventory: "16.56", cash_and_receivables: "128.59", total_current_assets: "145.15", property_equipment: "155.55", total_assets: "300.70", payables: "13.16", short_term_debt: "19.32", total_current_liabilities: "32.48", long_term_debt: "102.99", total_liabilities: "135.47", total_equity: "165.23" },
            { id: 37, statement_id: 10, company_id: 6, period_id: 7, cash_share: "0.845", receivables_share: "0.384", inventory_share: "0.225", ppe_share: "1.340", payables_share: "0.177", short_debt_share: "0.121", long_debt_share: "0.988", cash: "57.50", receivables: "26.13", inventory: "10.61", cash_and_receivables: "83.63", total_current_assets: "94.24", property_equipment: "91.19", total_assets: "185.43", payables: "8.35", short_term_debt: "8.23", total_current_liabilities: "16.58", long_term_debt: "67.23", total_liabilities: "83.81", total_equity: "101.62" },
            { id: 38, statement_id: 18, company_id: 6, period_id: 10, cash_share: "0.862", receivables_share: "0.313", inventory_share: "0.391", ppe_share: "1.292", payables_share: "0.178", short_debt_share: "0.119", long_debt_share: "0.371", cash: "62.78", receivables: "22.80", inventory: "19.31", cash_and_receivables: "85.58", total_current_assets: "104.89", property_equipment: "94.10", total_assets: "198.99", payables: "8.79", short_term_debt: "8.67", total_current_liabilities: "17.46", long_term_debt: "27.02", total_liabilities: "44.48", total_equity: "154.51" },
            { id: 39, statement_id: 54, company_id: 7, period_id: 4, cash_share: "0.400", receivables_share: "0.288", inventory_share: "0.490", ppe_share: "1.942", payables_share: "0.249", short_debt_share: "0.151", long_debt_share: "0.944", cash: "72.68", receivables: "52.33", inventory: "65.97", cash_and_receivables: "125.01", total_current_assets: "190.98", property_equipment: "352.86", total_assets: "543.84", payables: "33.53", short_term_debt: "27.44", total_current_liabilities: "60.97", long_term_debt: "171.52", total_liabilities: "232.49", total_equity: "311.35" },
            { id: 40, statement_id: 59, company_id: 4, period_id: 10, cash_share: "0.608", receivables_share: "0.386", inventory_share: "0.285", ppe_share: "1.687", payables_share: "0.195", short_debt_share: "0.164", long_debt_share: "0.511", cash: "41.70", receivables: "26.47", inventory: "11.55", cash_and_receivables: "68.17", total_current_assets: "79.72", property_equipment: "115.69", total_assets: "195.41", payables: "7.90", short_term_debt: "11.25", total_current_liabilities: "19.15", long_term_debt: "35.04", total_liabilities: "54.19", total_equity: "141.22" },
            { id: 41, statement_id: 93, company_id: 3, period_id: 6, cash_share: "0.428", receivables_share: "0.303", inventory_share: "0.422", ppe_share: "1.091", payables_share: "0.207", short_debt_share: "0.128", long_debt_share: "0.469", cash: "36.47", receivables: "25.82", inventory: "19.82", cash_and_receivables: "62.29", total_current_assets: "82.11", property_equipment: "92.98", total_assets: "175.09", payables: "9.72", short_term_debt: "10.91", total_current_liabilities: "20.63", long_term_debt: "39.97", total_liabilities: "60.60", total_equity: "114.49" },
            { id: 42, statement_id: 96, company_id: 4, period_id: 11, cash_share: "0.480", receivables_share: "0.421", inventory_share: "0.453", ppe_share: "1.554", payables_share: "0.204", short_debt_share: "0.131", long_debt_share: "0.575", cash: "32.10", receivables: "28.16", inventory: "18.18", cash_and_receivables: "60.26", total_current_assets: "78.44", property_equipment: "103.93", total_assets: "182.37", payables: "8.19", short_term_debt: "8.76", total_current_liabilities: "16.95", long_term_debt: "38.46", total_liabilities: "55.41", total_equity: "126.96" },
            { id: 43, statement_id: 91, company_id: 1, period_id: 4, cash_share: "0.610", receivables_share: "0.305", inventory_share: "0.329", ppe_share: "1.446", payables_share: "0.283", short_debt_share: "0.110", long_debt_share: "0.631", cash: "139.45", receivables: "69.73", inventory: "32.49", cash_and_receivables: "209.18", total_current_assets: "241.67", property_equipment: "330.57", total_assets: "572.24", payables: "27.95", short_term_debt: "25.15", total_current_liabilities: "53.10", long_term_debt: "144.25", total_liabilities: "197.35", total_equity: "374.89" },
            { id: 44, statement_id: 40, company_id: 3, period_id: 3, cash_share: "0.442", receivables_share: "0.352", inventory_share: "0.323", ppe_share: "2.035", payables_share: "0.273", short_debt_share: "0.194", long_debt_share: "0.376", cash: "33.61", receivables: "26.76", inventory: "13.07", cash_and_receivables: "60.37", total_current_assets: "73.44", property_equipment: "154.72", total_assets: "228.16", payables: "11.04", short_term_debt: "14.75", total_current_liabilities: "25.79", long_term_debt: "28.59", total_liabilities: "54.38", total_equity: "173.78" },
            { id: 45, statement_id: 30, company_id: 2, period_id: 4, cash_share: "0.607", receivables_share: "0.379", inventory_share: "0.430", ppe_share: "1.205", payables_share: "0.156", short_debt_share: "0.079", long_debt_share: "0.686", cash: "110.33", receivables: "68.89", inventory: "38.45", cash_and_receivables: "179.22", total_current_assets: "217.67", property_equipment: "219.02", total_assets: "436.69", payables: "13.95", short_term_debt: "14.36", total_current_liabilities: "28.31", long_term_debt: "124.69", total_liabilities: "153.00", total_equity: "283.69" },
            { id: 46, statement_id: 87, company_id: 2, period_id: 1, cash_share: "0.756", receivables_share: "0.443", inventory_share: "0.269", ppe_share: "1.642", payables_share: "0.197", short_debt_share: "0.090", long_debt_share: "0.679", cash: "109.60", receivables: "64.22", inventory: "18.99", cash_and_receivables: "173.82", total_current_assets: "192.81", property_equipment: "238.04", total_assets: "430.85", payables: "13.91", short_term_debt: "13.05", total_current_liabilities: "26.96", long_term_debt: "98.43", total_liabilities: "125.39", total_equity: "305.46" },
            { id: 47, statement_id: 28, company_id: 4, period_id: 1, cash_share: "0.423", receivables_share: "0.311", inventory_share: "0.478", ppe_share: "1.046", payables_share: "0.218", short_debt_share: "0.156", long_debt_share: "0.593", cash: "23.53", receivables: "17.30", inventory: "15.58", cash_and_receivables: "40.83", total_current_assets: "56.41", property_equipment: "58.18", total_assets: "114.59", payables: "7.10", short_term_debt: "8.68", total_current_liabilities: "15.78", long_term_debt: "32.98", total_liabilities: "48.76", total_equity: "65.83" },
            { id: 48, statement_id: 57, company_id: 8, period_id: 11, cash_share: "0.423", receivables_share: "0.392", inventory_share: "0.215", ppe_share: "2.068", payables_share: "0.230", short_debt_share: "0.109", long_debt_share: "0.882", cash: "46.83", receivables: "43.39", inventory: "18.78", cash_and_receivables: "90.22", total_current_assets: "109.00", property_equipment: "228.93", total_assets: "337.93", payables: "20.09", short_term_debt: "12.07", total_current_liabilities: "32.16", long_term_debt: "97.64", total_liabilities: "129.80", total_equity: "208.13" },
            { id: 49, statement_id: 70, company_id: 8, period_id: 4, cash_share: "0.800", receivables_share: "0.292", inventory_share: "0.232", ppe_share: "1.049", payables_share: "0.200", short_debt_share: "0.102", long_debt_share: "0.546", cash: "91.18", receivables: "33.28", inventory: "20.60", cash_and_receivables: "124.46", total_current_assets: "145.06", property_equipment: "119.57", total_assets: "264.63", payables: "17.76", short_term_debt: "11.63", total_current_liabilities: "29.39", long_term_debt: "62.23", total_liabilities: "91.62", total_equity: "173.01" },
            { id: 50, statement_id: 51, company_id: 7, period_id: 10, cash_share: "0.275", receivables_share: "0.327", inventory_share: "0.448", ppe_share: "1.034", payables_share: "0.189", short_debt_share: "0.088", long_debt_share: "0.617", cash: "48.17", receivables: "57.28", inventory: "59.48", cash_and_receivables: "105.45", total_current_assets: "164.93", property_equipment: "181.12", total_assets: "346.05", payables: "25.09", short_term_debt: "15.41", total_current_liabilities: "40.50", long_term_debt: "108.07", total_liabilities: "148.57", total_equity: "197.48" },
            { id: 51, statement_id: 35, company_id: 5, period_id: 10, cash_share: "0.289", receivables_share: "0.327", inventory_share: "0.418", ppe_share: "1.462", payables_share: "0.222", short_debt_share: "0.108", long_debt_share: "0.744", cash: "32.94", receivables: "37.27", inventory: "30.40", cash_and_receivables: "70.21", total_current_assets: "100.61", property_equipment: "166.65", total_assets: "267.26", payables: "16.15", short_term_debt: "12.31", total_current_liabilities: "28.46", long_term_debt: "84.81", total_liabilities: "113.27", total_equity: "153.99" },
            { id: 52, statement_id: 27, company_id: 6, period_id: 5, cash_share: "0.774", receivables_share: "0.273", inventory_share: "0.425", ppe_share: "1.061", payables_share: "0.277", short_debt_share: "0.164", long_debt_share: "0.552", cash: "49.34", receivables: "17.40", inventory: "18.67", cash_and_receivables: "66.74", total_current_assets: "85.41", property_equipment: "67.64", total_assets: "153.05", payables: "12.17", short_term_debt: "10.46", total_current_liabilities: "22.63", long_term_debt: "35.19", total_liabilities: "57.82", total_equity: "95.23" },
            { id: 53, statement_id: 52, company_id: 3, period_id: 4, cash_share: "0.471", receivables_share: "0.331", inventory_share: "0.323", ppe_share: "1.452", payables_share: "0.220", short_debt_share: "0.160", long_debt_share: "0.351", cash: "41.82", receivables: "29.39", inventory: "15.49", cash_and_receivables: "71.21", total_current_assets: "86.70", property_equipment: "128.92", total_assets: "215.62", payables: "10.55", short_term_debt: "14.21", total_current_liabilities: "24.76", long_term_debt: "31.17", total_liabilities: "55.93", total_equity: "159.69" },
            { id: 54, statement_id: 81, company_id: 2, period_id: 10, cash_share: "0.376", receivables_share: "0.377", inventory_share: "0.379", ppe_share: "1.548", payables_share: "0.167", short_debt_share: "0.099", long_debt_share: "0.606", cash: "65.29", receivables: "65.47", inventory: "31.72", cash_and_receivables: "130.76", total_current_assets: "162.48", property_equipment: "268.81", total_assets: "431.29", payables: "13.98", short_term_debt: "17.19", total_current_liabilities: "31.17", long_term_debt: "105.23", total_liabilities: "136.40", total_equity: "294.89" },
            { id: 55, statement_id: 95, company_id: 5, period_id: 1, cash_share: "0.394", receivables_share: "0.383", inventory_share: "0.217", ppe_share: "1.617", payables_share: "0.259", short_debt_share: "0.091", long_debt_share: "0.744", cash: "37.41", receivables: "36.37", inventory: "13.06", cash_and_receivables: "73.78", total_current_assets: "86.84", property_equipment: "153.55", total_assets: "240.39", payables: "15.59", short_term_debt: "8.64", total_current_liabilities: "24.23", long_term_debt: "70.65", total_liabilities: "94.88", total_equity: "145.51" },
            { id: 56, statement_id: 7, company_id: 6, period_id: 4, cash_share: "0.587", receivables_share: "0.261", inventory_share: "0.405", ppe_share: "1.797", payables_share: "0.271", short_debt_share: "0.165", long_debt_share: "0.562", cash: "43.83", receivables: "19.49", inventory: "20.77", cash_and_receivables: "63.32", total_current_assets: "84.09", property_equipment: "134.16", total_assets: "218.25", payables: "13.90", short_term_debt: "12.32", total_current_liabilities: "26.22", long_term_debt: "41.96", total_liabilities: "68.18", total_equity: "150.07" },
            { id: 57, statement_id: 69, company_id: 4, period_id: 7, cash_share: "0.635", receivables_share: "0.360", inventory_share: "0.384", ppe_share: "2.197", payables_share: "0.152", short_debt_share: "0.168", long_debt_share: "0.530", cash: "40.01", receivables: "22.68", inventory: "14.47", cash_and_receivables: "62.69", total_current_assets: "77.16", property_equipment: "138.41", total_assets: "215.57", payables: "5.73", short_term_debt: "10.58", total_current_liabilities: "16.31", long_term_debt: "33.39", total_liabilities: "49.70", total_equity: "165.87" },
            { id: 58, statement_id: 25, company_id: 4, period_id: 4, cash_share: "0.363", receivables_share: "0.402", inventory_share: "0.489", ppe_share: "1.101", payables_share: "0.164", short_debt_share: "0.196", long_debt_share: "0.935", cash: "25.50", receivables: "28.24", inventory: "20.20", cash_and_receivables: "53.74", total_current_assets: "73.94", property_equipment: "77.33", total_assets: "151.27", payables: "6.77", short_term_debt: "13.77", total_current_liabilities: "20.54", long_term_debt: "65.67", total_liabilities: "86.21", total_equity: "65.06" },
            { id: 59, statement_id: 79, company_id: 7, period_id: 7, cash_share: "0.409", receivables_share: "0.256", inventory_share: "0.446", ppe_share: "1.343", payables_share: "0.283", short_debt_share: "0.161", long_debt_share: "0.643", cash: "69.08", receivables: "43.24", inventory: "55.51", cash_and_receivables: "112.32", total_current_assets: "167.83", property_equipment: "226.82", total_assets: "394.65", payables: "35.23", short_term_debt: "27.19", total_current_liabilities: "62.42", long_term_debt: "108.60", total_liabilities: "171.02", total_equity: "223.63" },
            { id: 60, statement_id: 48, company_id: 1, period_id: 11, cash_share: "0.898", receivables_share: "0.308", inventory_share: "0.455", ppe_share: "1.662", payables_share: "0.165", short_debt_share: "0.058", long_debt_share: "0.532", cash: "191.20", receivables: "65.58", inventory: "42.62", cash_and_receivables: "256.78", total_current_assets: "299.40", property_equipment: "353.87", total_assets: "653.27", payables: "15.46", short_term_debt: "12.35", total_current_liabilities: "27.81", long_term_debt: "113.27", total_liabilities: "141.08", total_equity: "512.19" },
            { id: 61, statement_id: 92, company_id: 2, period_id: 9, cash_share: "0.712", receivables_share: "0.337", inventory_share: "0.210", ppe_share: "1.320", payables_share: "0.167", short_debt_share: "0.067", long_debt_share: "0.356", cash: "115.96", receivables: "54.88", inventory: "16.79", cash_and_receivables: "170.84", total_current_assets: "187.63", property_equipment: "214.98", total_assets: "402.61", payables: "13.35", short_term_debt: "10.91", total_current_liabilities: "24.26", long_term_debt: "57.98", total_liabilities: "82.24", total_equity: "320.37" },
            { id: 62, statement_id: 89, company_id: 8, period_id: 6, cash_share: "0.569", receivables_share: "0.356", inventory_share: "0.219", ppe_share: "1.969", payables_share: "0.242", short_debt_share: "0.181", long_debt_share: "0.642", cash: "59.15", receivables: "37.01", inventory: "18.01", cash_and_receivables: "96.16", total_current_assets: "114.17", property_equipment: "204.70", total_assets: "318.87", payables: "19.90", short_term_debt: "18.82", total_current_liabilities: "38.72", long_term_debt: "66.74", total_liabilities: "105.46", total_equity: "213.41" },
            { id: 63, statement_id: 75, company_id: 5, period_id: 11, cash_share: "0.253", receivables_share: "0.379", inventory_share: "0.392", ppe_share: "1.091", payables_share: "0.286", short_debt_share: "0.179", long_debt_share: "0.316", cash: "28.84", receivables: "43.21", inventory: "29.05", cash_and_receivables: "72.05", total_current_assets: "101.10", property_equipment: "124.38", total_assets: "225.48", payables: "21.20", short_term_debt: "20.41", total_current_liabilities: "41.61", long_term_debt: "36.03", total_liabilities: "77.64", total_equity: "147.84" },
            { id: 64, statement_id: 60, company_id: 6, period_id: 11, cash_share: "0.863", receivables_share: "0.396", inventory_share: "0.237", ppe_share: "2.029", payables_share: "0.262", short_debt_share: "0.130", long_debt_share: "0.337", cash: "61.95", receivables: "28.43", inventory: "11.59", cash_and_receivables: "90.38", total_current_assets: "101.97", property_equipment: "145.66", total_assets: "247.63", payables: "12.81", short_term_debt: "9.33", total_current_liabilities: "22.14", long_term_debt: "24.19", total_liabilities: "46.33", total_equity: "201.30" },
            { id: 65, statement_id: 19, company_id: 6, period_id: 12, cash_share: "0.355", receivables_share: "0.414", inventory_share: "0.204", ppe_share: "1.320", payables_share: "0.231", short_debt_share: "0.055", long_debt_share: "0.580", cash: "29.49", receivables: "34.39", inventory: "11.52", cash_and_receivables: "63.88", total_current_assets: "75.40", property_equipment: "109.65", total_assets: "185.05", payables: "13.05", short_term_debt: "4.57", total_current_liabilities: "17.62", long_term_debt: "48.18", total_liabilities: "65.80", total_equity: "119.25" },
            { id: 66, statement_id: 8, company_id: 1, period_id: 8, cash_share: "0.562", receivables_share: "0.444", inventory_share: "0.345", ppe_share: "1.147", payables_share: "0.275", short_debt_share: "0.125", long_debt_share: "0.630", cash: "133.83", receivables: "105.73", inventory: "36.56", cash_and_receivables: "239.56", total_current_assets: "276.12", property_equipment: "273.15", total_assets: "549.27", payables: "29.14", short_term_debt: "29.77", total_current_liabilities: "58.91", long_term_debt: "150.03", total_liabilities: "208.94", total_equity: "340.33" },
            { id: 67, statement_id: 41, company_id: 3, period_id: 12, cash_share: "0.703", receivables_share: "0.292", inventory_share: "0.370", ppe_share: "1.309", payables_share: "0.157", short_debt_share: "0.200", long_debt_share: "0.362", cash: "72.08", receivables: "29.94", inventory: "20.56", cash_and_receivables: "102.02", total_current_assets: "122.58", property_equipment: "134.21", total_assets: "256.79", payables: "8.72", short_term_debt: "20.51", total_current_liabilities: "29.23", long_term_debt: "37.12", total_liabilities: "66.35", total_equity: "190.44" },
            { id: 68, statement_id: 36, company_id: 7, period_id: 11, cash_share: "0.629", receivables_share: "0.367", inventory_share: "0.324", ppe_share: "1.634", payables_share: "0.226", short_debt_share: "0.077", long_debt_share: "0.743", cash: "109.04", receivables: "63.62", inventory: "41.00", cash_and_receivables: "172.66", total_current_assets: "213.66", property_equipment: "283.25", total_assets: "496.91", payables: "28.60", short_term_debt: "13.35", total_current_liabilities: "41.95", long_term_debt: "128.80", total_liabilities: "170.75", total_equity: "326.16" },
            { id: 69, statement_id: 21, company_id: 8, period_id: 9, cash_share: "0.426", receivables_share: "0.319", inventory_share: "0.220", ppe_share: "1.855", payables_share: "0.209", short_debt_share: "0.087", long_debt_share: "0.586", cash: "43.41", receivables: "32.51", inventory: "17.91", cash_and_receivables: "75.92", total_current_assets: "93.83", property_equipment: "189.04", total_assets: "282.87", payables: "17.02", short_term_debt: "8.87", total_current_liabilities: "25.89", long_term_debt: "59.72", total_liabilities: "85.61", total_equity: "197.26" },
            { id: 70, statement_id: 77, company_id: 5, period_id: 4, cash_share: "0.640", receivables_share: "0.412", inventory_share: "0.463", ppe_share: "1.597", payables_share: "0.295", short_debt_share: "0.105", long_debt_share: "0.832", cash: "72.42", receivables: "46.62", inventory: "32.90", cash_and_receivables: "119.04", total_current_assets: "151.94", property_equipment: "180.70", total_assets: "332.64", payables: "20.96", short_term_debt: "11.88", total_current_liabilities: "32.84", long_term_debt: "94.14", total_liabilities: "126.98", total_equity: "205.66" },
            { id: 71, statement_id: 55, company_id: 8, period_id: 10, cash_share: "0.770", receivables_share: "0.379", inventory_share: "0.469", ppe_share: "1.169", payables_share: "0.250", short_debt_share: "0.074", long_debt_share: "0.996", cash: "83.91", receivables: "41.30", inventory: "40.94", cash_and_receivables: "125.21", total_current_assets: "166.15", property_equipment: "127.40", total_assets: "293.55", payables: "21.82", short_term_debt: "8.06", total_current_liabilities: "29.88", long_term_debt: "108.54", total_liabilities: "138.42", total_equity: "155.13" },
            { id: 72, statement_id: 1, company_id: 1, period_id: 3, cash_share: "0.536", receivables_share: "0.322", inventory_share: "0.465", ppe_share: "2.102", payables_share: "0.224", short_debt_share: "0.074", long_debt_share: "0.497", cash: "105.44", receivables: "63.34", inventory: "39.52", cash_and_receivables: "168.78", total_current_assets: "208.30", property_equipment: "413.48", total_assets: "621.78", payables: "19.04", short_term_debt: "14.56", total_current_liabilities: "33.60", long_term_debt: "97.76", total_liabilities: "131.36", total_equity: "490.42" },
            { id: 73, statement_id: 64, company_id: 5, period_id: 3, cash_share: "0.730", receivables_share: "0.298", inventory_share: "0.442", ppe_share: "1.703", payables_share: "0.224", short_debt_share: "0.174", long_debt_share: "0.634", cash: "72.81", receivables: "29.72", inventory: "28.48", cash_and_receivables: "102.53", total_current_assets: "131.01", property_equipment: "169.86", total_assets: "300.87", payables: "14.43", short_term_debt: "17.35", total_current_liabilities: "31.78", long_term_debt: "63.24", total_liabilities: "95.02", total_equity: "205.85" },
            { id: 74, statement_id: 11, company_id: 5, period_id: 12, cash_share: "0.697", receivables_share: "0.329", inventory_share: "0.428", ppe_share: "2.081", payables_share: "0.189", short_debt_share: "0.081", long_debt_share: "0.567", cash: "89.09", receivables: "42.05", inventory: "34.19", cash_and_receivables: "131.14", total_current_assets: "165.33", property_equipment: "265.99", total_assets: "431.32", payables: "15.10", short_term_debt: "10.35", total_current_liabilities: "25.45", long_term_debt: "72.47", total_liabilities: "97.92", total_equity: "333.40" },
            { id: 75, statement_id: 44, company_id: 3, period_id: 9, cash_share: "0.833", receivables_share: "0.256", inventory_share: "0.441", ppe_share: "1.428", payables_share: "0.175", short_debt_share: "0.146", long_debt_share: "0.499", cash: "65.52", receivables: "20.13", inventory: "18.73", cash_and_receivables: "85.65", total_current_assets: "104.38", property_equipment: "112.31", total_assets: "216.69", payables: "7.43", short_term_debt: "11.48", total_current_liabilities: "18.91", long_term_debt: "39.25", total_liabilities: "58.16", total_equity: "158.53" },
            { id: 76, statement_id: 84, company_id: 5, period_id: 2, cash_share: "0.371", receivables_share: "0.421", inventory_share: "0.202", ppe_share: "1.144", payables_share: "0.193", short_debt_share: "0.054", long_debt_share: "0.808", cash: "37.37", receivables: "42.41", inventory: "13.04", cash_and_receivables: "79.78", total_current_assets: "92.82", property_equipment: "115.24", total_assets: "208.06", payables: "12.46", short_term_debt: "5.44", total_current_liabilities: "17.90", long_term_debt: "81.39", total_liabilities: "99.29", total_equity: "108.77" },
            { id: 77, statement_id: 72, company_id: 5, period_id: 5, cash_share: "0.304", receivables_share: "0.265", inventory_share: "0.357", ppe_share: "1.223", payables_share: "0.159", short_debt_share: "0.129", long_debt_share: "0.852", cash: "29.20", receivables: "25.45", inventory: "22.08", cash_and_receivables: "54.65", total_current_assets: "76.73", property_equipment: "117.46", total_assets: "194.19", payables: "9.83", short_term_debt: "12.39", total_current_liabilities: "22.22", long_term_debt: "81.83", total_liabilities: "104.05", total_equity: "90.14" },
            { id: 78, statement_id: 88, company_id: 1, period_id: 7, cash_share: "0.497", receivables_share: "0.363", inventory_share: "0.432", ppe_share: "1.012", payables_share: "0.245", short_debt_share: "0.054", long_debt_share: "0.657", cash: "103.36", receivables: "75.49", inventory: "39.44", cash_and_receivables: "178.85", total_current_assets: "218.29", property_equipment: "210.46", total_assets: "428.75", payables: "22.37", short_term_debt: "11.23", total_current_liabilities: "33.60", long_term_debt: "136.63", total_liabilities: "170.23", total_equity: "258.52" },
            { id: 79, statement_id: 32, company_id: 1, period_id: 1, cash_share: "0.495", receivables_share: "0.315", inventory_share: "0.210", ppe_share: "1.359", payables_share: "0.162", short_debt_share: "0.197", long_debt_share: "0.918", cash: "92.60", receivables: "58.93", inventory: "17.44", cash_and_receivables: "151.53", total_current_assets: "168.97", property_equipment: "254.23", total_assets: "423.20", payables: "13.46", short_term_debt: "36.85", total_current_liabilities: "50.31", long_term_debt: "171.73", total_liabilities: "222.04", total_equity: "201.16" },
            { id: 80, statement_id: 29, company_id: 8, period_id: 2, cash_share: "0.820", receivables_share: "0.312", inventory_share: "0.316", ppe_share: "1.816", payables_share: "0.192", short_debt_share: "0.107", long_debt_share: "0.852", cash: "80.32", receivables: "30.56", inventory: "24.36", cash_and_receivables: "110.88", total_current_assets: "135.24", property_equipment: "177.88", total_assets: "313.12", payables: "14.80", short_term_debt: "10.48", total_current_liabilities: "25.28", long_term_debt: "83.45", total_liabilities: "108.73", total_equity: "204.39" },
            { id: 81, statement_id: 38, company_id: 8, period_id: 3, cash_share: "0.252", receivables_share: "0.277", inventory_share: "0.454", ppe_share: "2.118", payables_share: "0.194", short_debt_share: "0.133", long_debt_share: "0.769", cash: "24.59", receivables: "27.03", inventory: "34.87", cash_and_receivables: "51.62", total_current_assets: "86.49", property_equipment: "206.70", total_assets: "293.19", payables: "14.90", short_term_debt: "12.98", total_current_liabilities: "27.88", long_term_debt: "75.05", total_liabilities: "102.93", total_equity: "190.26" },
            { id: 82, statement_id: 94, company_id: 2, period_id: 12, cash_share: "0.418", receivables_share: "0.320", inventory_share: "0.314", ppe_share: "1.758", payables_share: "0.263", short_debt_share: "0.078", long_debt_share: "0.507", cash: "86.55", receivables: "66.26", inventory: "31.99", cash_and_receivables: "152.81", total_current_assets: "184.80", property_equipment: "364.01", total_assets: "548.81", payables: "26.79", short_term_debt: "16.15", total_current_liabilities: "42.94", long_term_debt: "104.98", total_liabilities: "147.92", total_equity: "400.89" },
            { id: 83, statement_id: 90, company_id: 6, period_id: 8, cash_share: "0.641", receivables_share: "0.388", inventory_share: "0.267", ppe_share: "1.367", payables_share: "0.216", short_debt_share: "0.182", long_debt_share: "0.399", cash: "50.80", receivables: "30.75", inventory: "14.64", cash_and_receivables: "81.55", total_current_assets: "96.19", property_equipment: "108.33", total_assets: "204.52", payables: "11.85", short_term_debt: "14.42", total_current_liabilities: "26.27", long_term_debt: "31.62", total_liabilities: "57.89", total_equity: "146.63" },
            { id: 84, statement_id: 43, company_id: 8, period_id: 12, cash_share: "0.567", receivables_share: "0.428", inventory_share: "0.372", ppe_share: "1.153", payables_share: "0.211", short_debt_share: "0.117", long_debt_share: "0.352", cash: "71.47", receivables: "53.95", inventory: "36.86", cash_and_receivables: "125.42", total_current_assets: "162.28", property_equipment: "145.34", total_assets: "307.62", payables: "20.91", short_term_debt: "14.75", total_current_liabilities: "35.66", long_term_debt: "44.37", total_liabilities: "80.03", total_equity: "227.59" },
            { id: 85, statement_id: 76, company_id: 2, period_id: 8, cash_share: "0.580", receivables_share: "0.310", inventory_share: "0.389", ppe_share: "1.777", payables_share: "0.172", short_debt_share: "0.166", long_debt_share: "0.505", cash: "111.04", receivables: "59.35", inventory: "36.64", cash_and_receivables: "170.39", total_current_assets: "207.03", property_equipment: "340.19", total_assets: "547.22", payables: "16.20", short_term_debt: "31.78", total_current_liabilities: "47.98", long_term_debt: "96.68", total_liabilities: "144.66", total_equity: "402.56" },
            { id: 86, statement_id: 47, company_id: 2, period_id: 3, cash_share: "0.426", receivables_share: "0.295", inventory_share: "0.446", ppe_share: "1.504", payables_share: "0.173", short_debt_share: "0.104", long_debt_share: "0.485", cash: "66.17", receivables: "45.82", inventory: "33.39", cash_and_receivables: "111.99", total_current_assets: "145.38", property_equipment: "233.60", total_assets: "378.98", payables: "12.95", short_term_debt: "16.15", total_current_liabilities: "29.10", long_term_debt: "75.33", total_liabilities: "104.43", total_equity: "274.55" },
            { id: 87, statement_id: 13, company_id: 5, period_id: 9, cash_share: "0.836", receivables_share: "0.436", inventory_share: "0.283", ppe_share: "1.548", payables_share: "0.215", short_debt_share: "0.165", long_debt_share: "0.744", cash: "85.09", receivables: "44.38", inventory: "18.32", cash_and_receivables: "129.47", total_current_assets: "147.79", property_equipment: "157.56", total_assets: "305.35", payables: "13.92", short_term_debt: "16.79", total_current_liabilities: "30.71", long_term_debt: "75.72", total_liabilities: "106.43", total_equity: "198.92" },
            { id: 88, statement_id: 26, company_id: 2, period_id: 5, cash_share: "0.554", receivables_share: "0.269", inventory_share: "0.336", ppe_share: "1.349", payables_share: "0.156", short_debt_share: "0.064", long_debt_share: "0.465", cash: "85.98", receivables: "41.75", inventory: "25.50", cash_and_receivables: "127.73", total_current_assets: "153.23", property_equipment: "209.36", total_assets: "362.59", payables: "11.84", short_term_debt: "9.93", total_current_liabilities: "21.77", long_term_debt: "72.17", total_liabilities: "93.94", total_equity: "268.65" },
            { id: 89, statement_id: 86, company_id: 3, period_id: 1, cash_share: "0.486", receivables_share: "0.392", inventory_share: "0.325", ppe_share: "1.643", payables_share: "0.240", short_debt_share: "0.062", long_debt_share: "0.660", cash: "35.76", receivables: "28.84", inventory: "13.01", cash_and_receivables: "64.60", total_current_assets: "77.61", property_equipment: "120.89", total_assets: "198.50", payables: "9.61", short_term_debt: "4.56", total_current_liabilities: "14.17", long_term_debt: "48.56", total_liabilities: "62.73", total_equity: "135.77" },
            { id: 90, statement_id: 82, company_id: 7, period_id: 3, cash_share: "0.519", receivables_share: "0.409", inventory_share: "0.402", ppe_share: "1.140", payables_share: "0.287", short_debt_share: "0.101", long_debt_share: "0.509", cash: "78.49", receivables: "61.86", inventory: "44.57", cash_and_receivables: "140.35", total_current_assets: "184.92", property_equipment: "172.41", total_assets: "357.33", payables: "31.82", short_term_debt: "15.28", total_current_liabilities: "47.10", long_term_debt: "76.98", total_liabilities: "124.08", total_equity: "233.25" },
            { id: 91, statement_id: 83, company_id: 2, period_id: 2, cash_share: "0.868", receivables_share: "0.374", inventory_share: "0.280", ppe_share: "1.094", payables_share: "0.197", short_debt_share: "0.154", long_debt_share: "0.392", cash: "136.28", receivables: "58.72", inventory: "21.85", cash_and_receivables: "195.00", total_current_assets: "216.85", property_equipment: "171.77", total_assets: "388.62", payables: "15.37", short_term_debt: "24.18", total_current_liabilities: "39.55", long_term_debt: "61.55", total_liabilities: "101.10", total_equity: "287.52" },
            { id: 92, statement_id: 62, company_id: 4, period_id: 3, cash_share: "0.747", receivables_share: "0.304", inventory_share: "0.212", ppe_share: "1.425", payables_share: "0.225", short_debt_share: "0.112", long_debt_share: "0.651", cash: "44.92", receivables: "18.28", inventory: "7.62", cash_and_receivables: "63.20", total_current_assets: "70.82", property_equipment: "85.70", total_assets: "156.52", payables: "8.09", short_term_debt: "6.74", total_current_liabilities: "14.83", long_term_debt: "39.15", total_liabilities: "53.98", total_equity: "102.54" },
            { id: 93, statement_id: 37, company_id: 5, period_id: 8, cash_share: "0.595", receivables_share: "0.443", inventory_share: "0.285", ppe_share: "1.466", payables_share: "0.250", short_debt_share: "0.178", long_debt_share: "0.792", cash: "75.77", receivables: "56.41", inventory: "23.34", cash_and_receivables: "132.18", total_current_assets: "155.52", property_equipment: "186.68", total_assets: "342.20", payables: "20.47", short_term_debt: "22.67", total_current_liabilities: "43.14", long_term_debt: "100.85", total_liabilities: "143.99", total_equity: "198.21" },
            { id: 94, statement_id: 46, company_id: 4, period_id: 5, cash_share: "0.782", receivables_share: "0.446", inventory_share: "0.396", ppe_share: "2.178", payables_share: "0.294", short_debt_share: "0.181", long_debt_share: "0.634", cash: "45.64", receivables: "26.03", inventory: "13.45", cash_and_receivables: "71.67", total_current_assets: "85.12", property_equipment: "127.11", total_assets: "212.23", payables: "9.99", short_term_debt: "10.56", total_current_liabilities: "20.55", long_term_debt: "37.00", total_liabilities: "57.55", total_equity: "154.68" },
            { id: 95, statement_id: 20, company_id: 6, period_id: 2, cash_share: "0.517", receivables_share: "0.329", inventory_share: "0.201", ppe_share: "2.196", payables_share: "0.261", short_debt_share: "0.052", long_debt_share: "0.862", cash: "33.41", receivables: "21.26", inventory: "8.88", cash_and_receivables: "54.67", total_current_assets: "63.55", property_equipment: "141.91", total_assets: "205.46", payables: "11.54", short_term_debt: "3.36", total_current_liabilities: "14.90", long_term_debt: "55.70", total_liabilities: "70.60", total_equity: "134.86" },
            { id: 96, statement_id: 61, company_id: 4, period_id: 2, cash_share: "0.256", receivables_share: "0.298", inventory_share: "0.375", ppe_share: "2.179", payables_share: "0.217", short_debt_share: "0.183", long_debt_share: "0.714", cash: "15.45", receivables: "17.99", inventory: "13.38", cash_and_receivables: "33.44", total_current_assets: "46.82", property_equipment: "131.55", total_assets: "178.37", payables: "7.74", short_term_debt: "11.05", total_current_liabilities: "18.79", long_term_debt: "43.10", total_liabilities: "61.89", total_equity: "116.48" },
        ],
    });
}

main()
    .then(() => prisma.$disconnect())
    .catch(async error => {
        console.error(error);
        await prisma.$disconnect();
        process.exit(1);
    });