资产负债表公式

yanzi1150

根据新准则进行的定义。
B6=QM("1001",月,"借",,,,,,,,)+QM("1002",月,,,,,,,,,)+QM("1012",月,,,,,,,,,)
C6=QC("1001",全年,,,,,)+QC("1002",全年,,,,,)+QC("1012",全年,,,,,)
E6=QM("2001",月,,,年,,)
F6=QC("2001",全年,,,年,,)
B7=QM("1101",月,,,,,,,,,)
C7=QC("1101",全年,,,,,)
E7=QM("2101",月,,,年,,)
F7=QC("2101",全年,,,年,,)
B8=QM("1121",月,"借",,,"",,,,,)-QM("123102",月,"贷",,,,,,,,)
C8=QC("1121",全年,,,,,)-QC("123102",全年,"贷",,,,,,,,)
E8=QM("2201",月,,,年,,)
F8=QC("2201",全年,,,年,,)
B9=QM("1122",月,,,,"",,,,,)+QM("2203",月,"借",,,"",,,,,)-QM("123101",月,"贷",,,,,,,,)
C9=QC("1122",全年,,,,,)+QC("2203",全年,"借",,,"",,,,,)-QC("123101",全年,"贷",,,,,,,,)
E9=QM("2202",月,,,,"",,,,,)+QM("1123",月,"贷",,,"","",,,,)
F9=QC("2202",全年,,,,"",,,,,)+QC("1123",全年,"贷",,,"","",,,,)
B10=QM("1123",月,,,,,)+QM("2202",月,"借",,,"",,,,,)-QM("123103",月,"贷",,,,,,,,)
C10=QC("1123",全年,,,,"","",,,,)+QC("2202",全年,"借",,,"",,,,,)-QC("123103",全年,"贷",,,,,,,,)
E10=QM("2203",月,,,,"",,,,,)+QM("1122",月,"贷",,,"",,,,,)
F10=QC("2203",全年,,,,"",,,,,)+QC("1122",全年,"贷",,,"",,,,,)
B11=QM("1132",月,,,,,,,,,)
C11=QC("1132",全年,,,,,,,,,)
E11=QM("2211",月,,,年,,)
F11=QC("2211",全年,,,年,,)
B12=QM("1131",月,,,,,,,,,)
C12=QC("1131",全年,,,,,,,,,)
E12=QM("2221",月,,,,,,,,,)-QM("2221",月,"借",,,,,,,,)
F12=QC("2221",全年,,,,,,,,,)-QC("2221",全年,"借",,,,,,,,)
B13=QM("1221",月,,,,,,,,,)-QM("123104",月,"贷",,,,,,,,)
C13=QC("1221",全年,,,,,,,,,)-QC("123104",全年,"贷",,,,,,,,)
E13=QM("2231",月,,,年,,)
F13=QC("2231",全年,,,年,,)
B14=QM("1401",月,,,,,,,,,)+QM("1402",月,,,,,,,,,)+QM("1403",月,,,,,,,,,)+QM("1404",月,,,,,,,,,)+QM("1405",月,,,,,,,,,)+QM("1406",月,,,,,,,,,)+QM("1407",月,,,,,,,,,)+QM("1408",月,,,,,,,,,)+QM("1411",月,,,,,,,,,)+QM("1421",月,,,,,,,,,)+QM("1431",月,,,,,,,,,)+QM("1441",月,,,,,,,,,)+QM("1451",月,,,,,,,,,)+QM("1461",月,,,,,,,,,)-QM("1471",月,,,,,,,,,)+QM("1321",月,,,,,,,,,)-QM("2314",月,,,,,,,,,)+QM("5001",月,,,,,,,,,)
C14=QC("1401",全年,,,年,,)+QC("1402",全年,,,年,,)+QC("1403",全年,,,年,,)+QC("1404",全年,,,年,,)+QC("1405",全年,,,年,,)+QC("1406",全年,,,年,,)+QC("1407",全年,,,年,,)+QC("1408",全年,,,年,,)+QC("1411",全年,,,年,,)+QC("1421",全年,,,年,,)+QC("1431",全年,,,年,,)+QC("1441",全年,,,年,,)+QC("1451",全年,,,年,,)+QC("1461",全年,,,年,,)-QC("1471",全年,,,年,,)+QC("1321",全年,,,年,,)-QC("2134",全年,,,年,,)+QC("5001",全年,,,年,,)
E14=QM("2232",月,,,年,,)
F14=QC("2232",全年,,,年,,)
B15=QM("1901",月,,,年,,)
C15=QC("1901",全年,,,年,,)
E15=QM("2241",月,,,年,,)
F15=QC("2241",全年,,,年,,)
B17=ptotal(B6:B16)
C17=ptotal(C6:C16)
E17=QM("2401",月,,,年,,)
F17=QC("2401",全年,,,年,,)
E18=ptotal(E6:E17)
F18=ptotal(F6:F17)
B19=QM("1503",月,,,,,,,,,)
C19=QC("1503",全年,,,年,,)
B20=QM("1501",月,,,年,,)-QM("1502",月,,,年,,)
C20=QC("1501",全年,,,年,,)-QC("1502",全年,,,年,,)
E20=QM("2501",月,,,年,,)
F20=QC("2501",全年,,,年,,)
B21=QM("1531",月,,,年,,)-QM("1532",月,,,年,,)
C21=QC("1531",全年,,,年,,)-QC("1532",全年,,,年,,)
E21=QM("2502",月,,,年,,)
F21=QC("2502",全年,,,年,,)
B22=QM("1511",月,,,年,,)-QM("1512",月,,,年,,)
C22=QC("1511",全年,,,年,,)-QC("1512",全年,,,年,,)
E22=QM("2701",月,,,,,,,,,)-QM("2702",月,,,,,,,,,)
F22=QC("2701",全年,,,,,,,,,)-QC("2702",全年,,,,,,,,,)
B23=QM("1521",月,,,年,,)
C23=QC("1521",全年,,,年,,)
E23=QM("2711",月,,,年,,)
F23=QC("2711",全年,,,年,,)
B24=QM("1601",月,,,年,,)-QM("1602",月,,,年,,)-QM("1603",月,,,年,,)
C24=QC("1601",全年,,,年,,)-QC("1602",全年,,,年,,)-QC("1603",全年,,,年,,)
E24=QM("2801",月,,,年,,)
F24=QC("2801",全年,,,年,,)
B25=QM("1604",月,,,年,,)
C25=QC("1604",全年,,,年,,)
E25=QM("2901",月,,,年,,)
F25=QC("2901",全年,,,年,,)
B26=QM("1605",月,,,年,,)
C26=QC("1605",全年,,,年,,)
B27=QM("1606",月,,,,,,,,,)-QM("1606",月,"贷",,,,,,,,)
C27=QC("1606",全年,,,,,,,,,)-QC("1606",全年,"贷",,,,,,,,)
E27=ptotal(E20:E26)
F27=ptotal(F20:F26)
B28=QM("1621",月,,,年,,)-QM("1622",月,,,年,,)
C28=QC("1621",全年,,,年,,)-QC("1622",全年,,,年,,)
E28=E18+E27
F28=F18+F27
B29=QM("1631",月,,,年,,)-QM("1632",月,,,年,,)
C29=QC("1631",全年,,,年,,)-QC("1632",全年,,,年,,)
B30=QM("1701",月,,,年,,)-QM("1702",月,,,年,,)-QM("1703",月,,,年,,)
C30=QC("1701",全年,,,年,,)-QC("1702",全年,,,年,,)-QC("1703",全年,,,年,,)
E30=QM("4001",月,,,年,,)
F30=QC("4001",全年,,,年,,)
E31=QM("4002",月,,,年,,)
F31=QC("4002",全年,,,年,,)
B32=QM("1711",月,,,年,,)
C32=QC("1711",全年,,,年,,)
E32=QM("4201",月,,,年,,)
F32=QC("4201",全年,,,年,,)
B33=QM("1801",月,,,,,,,,,)
C33=QC("1801",全年,,,年,,)
E33=QM("4101",月,,,年,,)
F33=QC("4101",全年,,,年,,)
B34=QM("1811",月,,,年,,)
C34=QC("1811",全年,,,年,,)
E34=QM("4104",月,,,,,,,,,)-QM("4104",月,"借",,,,,,,,)+QM("4103",月,,,,,,,,,)-QM("4103",月,"借",,,,,,,,)
F34=QC("4104",全年,"贷",,,,,,,,)-QC("4104",全年,"借",,,,,,,,)+QC("4103",全年,"贷",,,,,,,,)-QC("4103",全年,"借",,,,,,,,)
E35=E30+E31-E32+E33+E34
F35=F30+F31-F32+F33+F34
B36=ptotal(B19:B35)
C36=ptotal(C19:C35)
B37=B17+B36
C37=C17+C36
E37=E28+E35
F37=F28+F35