横向和纵向分析财务报表格式

横向和纵向分析财务报表格式

我正在创建水平和垂直分析图。为了演示,以下是我的最小工作示例:

\documentclass[12pt]{article}
\usepackage{float}
\begin{document}    
    Horizontal analysis:
    \begin{table}[H]
        \centering
        \begin{tabular}{l c c c c}
            & & & \multicolumn{2}{c}{Increase (Decrease)}\\ \cline{4-5}
            & FY 2022 & FY 2021 & \$ Amount & Percent\\
            Total Current Assets & & & &\\
            Net Plant, Property, and Equipment & & & &\\
            Total Assets & & & &\\
            Total Current Liabilities & & & &\\
            Total Liabilities & & & &\\
            Total Stockholders' Equity & & & &
        \end{tabular}
    \end{table}

    Vertical analysis:
    \begin{table}[H]
        \centering
        \begin{tabular}{l c c c c}
            & \multicolumn{2}{c}{FY 2022}& \multicolumn{2}{c}{FY 2021}\\ \cline{2-5}
            & \$ Amount & Percent & \$ Amount & Percent\\
            Total Revenue & & & &\\
            Total Cost of Goods Sold & & & &\\
            Gross Profit & & & &\\
            Operating Expenses & & & &\\
            Operating Income & & & &\\
            Income Tax Expense & & & &\\
            Net Income & & & &
        \end{tabular}
    \end{table}
\end{document}

输出: 电流输出

所需的水平分析: 所需的水平分析

所需的垂直分析: 在此处输入图片描述

我已成功绘制出蓝色圆圈所示的顶部水平线。有人能帮忙画出红色箭头和圆圈所示的带断点的水平线吗?

答案1

这可以通过附加列来实现:

\documentclass[12pt]{article}
\usepackage{hhline}
\usepackage{float}
\begin{document}    
    Horizontal analysis:
    \begin{table}[H]
        \centering
        \begin{tabular}{l c c c c c c c}
            & & & & & \multicolumn{3}{c}{Increase (Decrease)} \\ \cline{6-8}
            & FY 2022 & & FY 2021 & & \$ Amount & & Percent \\ \hhline{~-~-~-~-}
            Total Current Assets               & 200 & & 100 & & 100 & & 50 \\
            Net Plant, Property, and Equipment & 200 & & 100 & & 100 & & 50 \\
            Total Assets                       & 200 & & 100 & & 100 & & 50 \\
            Total Current Liabilities          & 200 & & 100 & & 100 & & 50 \\
            Total Liabilities                  & 200 & & 100 & & 100 & & 50 \\
            Total Stockholders' Equity         & 200 & & 100 & & 100 & & 50 \\ \hhline{~=~=~=~=}
        \end{tabular}
    \end{table}

    Vertical analysis:
    \begin{table}[H]
        \centering
        \begin{tabular}{l c c c p{5mm} c c c}
            & \multicolumn{3}{c}{FY 2022} & & \multicolumn{3}{c}{FY 2021} \\ \cline{2-4}\cline{6-8}
            & \$ Amount & & Percent & & \$ Amount & & Percent \\ \hhline{~-~-~-~-}
            Total Revenue            & 200 & & 100 & & 100 & & 50 \\
            Total Cost of Goods Sold & 200 & & 100 & & 100 & & 50 \\
            Gross Profit             & 200 & & 100 & & 100 & & 50 \\
            Operating Expenses       & 200 & & 100 & & 100 & & 50 \\
            Operating Income         & 200 & & 100 & & 100 & & 50 \\
            Income Tax Expense       & 200 & & 100 & & 100 & & 50 \\
            Net Income               & 200 & & 100 & & 100 & & 50 \\ \hhline{~=~=~=~=}
        \end{tabular}
    \end{table}
\end{document}

在此处输入图片描述

您可以使用 类型的列来更改列之间的空间p{<some width>}

对于双水平线,hhline请使用同名包中的命令。

相关内容