Please consilidate these balance sheets using the blank template.

PAN Balance Sheet 1.934 2,015 1,249 1,301 645 672 192 200 4,020 4.189 2.811 2.929 6,831 7.118 2,096 1,354 699 208 4.356 3.046 7.403 2,180 1.408 727 216 4,531 3.168 7,699 2,262 1.461 755 225 4.703 3.288 7,991 2,339 1,511 780 232 4,863 3,400 8,263 19 20 Cash and investments 21 Accounts receivable 22 Inventory and supplies, net 23 Other 24 Current Assets 25 Other 26 Total Assets 27 28 Bank Loan 29 Payables 30 CPLTD 31 Other 32 Current Liabilities 33 LID 34 Equity 35 Total Liabilities & Equity 36 37 Working Capital 940 290 51 109 146 300 53 112 3,649 2.18 44 93 4,034 1.877 920 6,831 3,054 258 46 97 3,455 1.831 1,832 7.118 2.399 269 48 101 2,816 1.783 2.803 7,403 1.695 280 50 105 2.129 1.734 3.836 7,699 1,390 1.682 4,918 7,991 611 1,629 6,022 8,263 3,635 3,788 3,939 4,097 4,397 4,252 A E 1 250 B Actual 2020 240 7,013 5,588 192 13,033 3.325 16,358 D Projected 2021 2022 250 8,385 9,998 6.630 7,905 195 232 15,460 18,385 3,830 4,393 19,290 22,778 2023 Notes 250 12,040 9,520 280 22,090 5,105 27,195 2 JTM Balance Sheet 3 Cash 4 Notes and Acc. Rec. 5 Inventory 6 Prepaid 7 Current Assets 8 Other 9 Total Assets 10 11 Bank Loan 12 Payables 13 CPLTD 14 Other 15 Current Liabilities 16 LTD 17 Equity 18 Total Liabilities & Equity 19 20 Ratios: 21 Bank Loan to Receivables 22 Liabilities / Equity 23 Debt / Equity 24 600 3.057 433 1.477 5,567 2.458 8,333 16,358 656 3.705 450 1.712 6,523 2.008 10.759 19,290 657 4,417 450 1.994 7,518 1,558 13,702 22,778 680 5,320 450 2,350 8,800 1.108 17,287 27,195 0.1 0.1 ci 0.1 1.0 0.4 0.8 0.7 0.2 0.1 0.6 0.1 0.3 25 A D 1 E F B Actual 2020 Projected 2022 2021 2023 2 Balance Sheet 3 Cash 4 Notes and Acc. Rec. 5 Inventory 6 Prepaid 7 Current Assets 8 Other 9 Total Assets 10 11 Bank Loan 12 Payables 13 CPLTD 14 Other 15 Current Liabilities 16 LTD 17 Equity 18 Total Liabilities & Equity 19 20 Ratios: 21 Bank Loan to Receivables 22 Liabilities / Equity 23 Debt/Equity 24 PAN Balance Sheet 1.934 2,015 1,249 1,301 645 672 192 200 4,020 4.189 2.811 2.929 6,831 7.118 2,096 1,354 699 208 4.356 3.046 7.403 2,180 1.408 727 216 4,531 3.168 7,699 2,262 1.461 755 225 4.703 3.288 7,991 2,339 1,511 780 232 4,863 3,400 8,263 19 20 Cash and investments 21 Accounts receivable 22 Inventory and supplies, net 23 Other 24 Current Assets 25 Other 26 Total Assets 27 28 Bank Loan 29 Payables 30 CPLTD 31 Other 32 Current Liabilities 33 LID 34 Equity 35 Total Liabilities & Equity 36 37 Working Capital 940 290 51 109 146 300 53 112 3,649 2.18 44 93 4,034 1.877 920 6,831 3,054 258 46 97 3,455 1.831 1,832 7.118 2.399 269 48 101 2,816 1.783 2.803 7,403 1.695 280 50 105 2.129 1.734 3.836 7,699 1,390 1.682 4,918 7,991 611 1,629 6,022 8,263 3,635 3,788 3,939 4,097 4,397 4,252 A E 1 250 B Actual 2020 240 7,013 5,588 192 13,033 3.325 16,358 D Projected 2021 2022 250 8,385 9,998 6.630 7,905 195 232 15,460 18,385 3,830 4,393 19,290 22,778 2023 Notes 250 12,040 9,520 280 22,090 5,105 27,195 2 JTM Balance Sheet 3 Cash 4 Notes and Acc. Rec. 5 Inventory 6 Prepaid 7 Current Assets 8 Other 9 Total Assets 10 11 Bank Loan 12 Payables 13 CPLTD 14 Other 15 Current Liabilities 16 LTD 17 Equity 18 Total Liabilities & Equity 19 20 Ratios: 21 Bank Loan to Receivables 22 Liabilities / Equity 23 Debt / Equity 24 600 3.057 433 1.477 5,567 2.458 8,333 16,358 656 3.705 450 1.712 6,523 2.008 10.759 19,290 657 4,417 450 1.994 7,518 1,558 13,702 22,778 680 5,320 450 2,350 8,800 1.108 17,287 27,195 0.1 0.1 ci 0.1 1.0 0.4 0.8 0.7 0.2 0.1 0.6 0.1 0.3 25 A D 1 E F B Actual 2020 Projected 2022 2021 2023 2 Balance Sheet 3 Cash 4 Notes and Acc. Rec. 5 Inventory 6 Prepaid 7 Current Assets 8 Other 9 Total Assets 10 11 Bank Loan 12 Payables 13 CPLTD 14 Other 15 Current Liabilities 16 LTD 17 Equity 18 Total Liabilities & Equity 19 20 Ratios: 21 Bank Loan to Receivables 22 Liabilities / Equity 23 Debt/Equity 24