5. Last, you will consolidate the calculated balance sheet for PAN and the actual balance sheet for JTM and calculate the three ratios shown in the JTM balance sheet 4417 A E B Actual 2020 16,358 2021 19,290 D Projected 2022 22,778 2023 Notes 27,195 2 Balance Sheet 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 0.1 1.0 0.4 0.8 0.3 0.7 0.2 0.1 0.6 0.1 A E F 1 B Actual 2020 D Projected 2021 2022 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 S 5. Last, you will consolidate the calculated balance sheet for PAN and the actual balance sheet for JTM and calculate the three ratios shown in the JTM balance sheet R24 X C F G B Actuall 2020 H 2021 4.296 8,564 D Projected 2022 2023 4,096 4.06 8,907 9,263 Notes 8.219 2024 3.896 9,615 2025 3.98 9,942 2.563 2.075 2,211 1.790 565 437 374 1.300 6,677 2.277 1.844 582 458 385 1,565 6.911 2,346 1,899 599 480 397 1,43% 7,154 2.416 1.956 617 503 409 1.505 7.406 2.488 2,015 636 527 421 1580 7.667 655 532 Increase at a yearly rate of Increase at a yearly rate of Increase at a yearly rate of Increase at a yearly rate of Increase at a yearly rate of Increase at a yearly rate of 3046 30% 3.09 4.89 3.0% 5094 434 1659 7.938 1,542 (473 1.067 1 653 (499) 1.154 Increase at a yearly rate of 509 1 2 Income Statement (in '000 $) 3 Operating Revenue growth rate 4 Total Operating Revenues 5 6 Wages, benefits, payroll support, incentives 7 Aircraft fel, inel hedging gains losses 8 Aircraft maintenance/rent 9 Landing fees and other rentals Depreciation amortization 11. All other expenses Total Operating Expenses 13 Operating Income 5 Total non-operating income (expense) 16 Income before taxes Income tax expense benefit) 8 Net Income 19 20 Cash and investments 21 Accounts receivable 22 Inventory and supplies, net 23 Other 24 Current Assets 25 Other 25 Total Assets 22 20 Bank Loan 29 Payables 30 CPLTD Other 12. Current Liabilities LTD 04 Equity 35 Total Liabilities & Equity 1.753 1857 1,9482.004 (524 (550) (572606 1.219 307 1.370 1:397 258 274288 971 1.033 1,083 1.101 242 293 843 PAN AIRWAYS 912 Balance Sheet 1.934 2015 1840 1301 045 672 192 4,020 4.189 2.811 2.929 6,831 2.118 Increase at Operating Revenue growth rate 200 2006 1354 699 208 4356 3,046 7.403 2180 1,408 727 216 4.531 3.168 7.699 2262 1461 755 225 42703 3.288 17,091 22:39 LSID 780 232 5863 3.400 5,263 Increase at Operating Revenue growth rate 3.649 1.095 280 Se 940 290 31 146 300 Plus to make balance sheet balance Increase at Operating Revenue growth rate 100 44 03 4,034 1.37 920 6.831 258 46 97 ASS 1,831 1832 TAILS 22399 269 43 101 2916 1.783 2.SO 7,103 105 2.129 1 734 3.836 7,099 1390 10 4,918 7901 112 011 1,629 6021 8.263 LTD of previous year mus CPLTD of current year Equity of previous year plus net income of current year Worlding Capital 3,615 3.788 3.939 4,097 2397 Exchade Bank Loan Merge & Center Clipboard $ % 000 Font Conditional Format as Formatting Table Alignment G11 Number fx E F B Actual 2020 240 7,013 3.588 192 13,033 3.325 16.358 D Projected 2021 2022 250 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,103 27,195 JTM BALANCE A 1 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 13 Current Liabilities 16 LTD 17 Equity 18 Total Liabilities & Equity 19 20 Ratios: 21 Bank Loan to Receivables 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 3,320 450 2,350 8.800 1,108 17,287 27.195 0.1 1.0 0.4 0.1 0.8 0.3 0.1 0.7 0.2 0.1 0.6 0.1 25 Font Merge & Center - $ - % P16 00 X Alignment fx Number A 1 B Actual 2020 E F D Projected 2022 2021 2023 2 Balance Sheet 3 Cash 4 Notes and Acc. Rec. 5 Inventory 6 Prepaid 7 Current Assets S 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 5. Last, you will consolidate the calculated balance sheet for PAN and the actual balance sheet for JTM and calculate the three ratios shown in the JTM balance sheet 4417 A E B Actual 2020 16,358 2021 19,290 D Projected 2022 22,778 2023 Notes 27,195 2 Balance Sheet 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 0.1 1.0 0.4 0.8 0.3 0.7 0.2 0.1 0.6 0.1 A E F 1 B Actual 2020 D Projected 2021 2022 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 S 5. Last, you will consolidate the calculated balance sheet for PAN and the actual balance sheet for JTM and calculate the three ratios shown in the JTM balance sheet R24 X C F G B Actuall 2020 H 2021 4.296 8,564 D Projected 2022 2023 4,096 4.06 8,907 9,263 Notes 8.219 2024 3.896 9,615 2025 3.98 9,942 2.563 2.075 2,211 1.790 565 437 374 1.300 6,677 2.277 1.844 582 458 385 1,565 6.911 2,346 1,899 599 480 397 1,43% 7,154 2.416 1.956 617 503 409 1.505 7.406 2.488 2,015 636 527 421 1580 7.667 655 532 Increase at a yearly rate of Increase at a yearly rate of Increase at a yearly rate of Increase at a yearly rate of Increase at a yearly rate of Increase at a yearly rate of 3046 30% 3.09 4.89 3.0% 5094 434 1659 7.938 1,542 (473 1.067 1 653 (499) 1.154 Increase at a yearly rate of 509 1 2 Income Statement (in '000 $) 3 Operating Revenue growth rate 4 Total Operating Revenues 5 6 Wages, benefits, payroll support, incentives 7 Aircraft fel, inel hedging gains losses 8 Aircraft maintenance/rent 9 Landing fees and other rentals Depreciation amortization 11. All other expenses Total Operating Expenses 13 Operating Income 5 Total non-operating income (expense) 16 Income before taxes Income tax expense benefit) 8 Net Income 19 20 Cash and investments 21 Accounts receivable 22 Inventory and supplies, net 23 Other 24 Current Assets 25 Other 25 Total Assets 22 20 Bank Loan 29 Payables 30 CPLTD Other 12. Current Liabilities LTD 04 Equity 35 Total Liabilities & Equity 1.753 1857 1,9482.004 (524 (550) (572606 1.219 307 1.370 1:397 258 274288 971 1.033 1,083 1.101 242 293 843 PAN AIRWAYS 912 Balance Sheet 1.934 2015 1840 1301 045 672 192 4,020 4.189 2.811 2.929 6,831 2.118 Increase at Operating Revenue growth rate 200 2006 1354 699 208 4356 3,046 7.403 2180 1,408 727 216 4.531 3.168 7.699 2262 1461 755 225 42703 3.288 17,091 22:39 LSID 780 232 5863 3.400 5,263 Increase at Operating Revenue growth rate 3.649 1.095 280 Se 940 290 31 146 300 Plus to make balance sheet balance Increase at Operating Revenue growth rate 100 44 03 4,034 1.37 920 6.831 258 46 97 ASS 1,831 1832 TAILS 22399 269 43 101 2916 1.783 2.SO 7,103 105 2.129 1 734 3.836 7,099 1390 10 4,918 7901 112 011 1,629 6021 8.263 LTD of previous year mus CPLTD of current year Equity of previous year plus net income of current year Worlding Capital 3,615 3.788 3.939 4,097 2397 Exchade Bank Loan Merge & Center Clipboard $ % 000 Font Conditional Format as Formatting Table Alignment G11 Number fx E F B Actual 2020 240 7,013 3.588 192 13,033 3.325 16.358 D Projected 2021 2022 250 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,103 27,195 JTM BALANCE A 1 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 13 Current Liabilities 16 LTD 17 Equity 18 Total Liabilities & Equity 19 20 Ratios: 21 Bank Loan to Receivables 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 3,320 450 2,350 8.800 1,108 17,287 27.195 0.1 1.0 0.4 0.1 0.8 0.3 0.1 0.7 0.2 0.1 0.6 0.1 25 Font Merge & Center - $ - % P16 00 X Alignment fx Number A 1 B Actual 2020 E F D Projected 2022 2021 2023 2 Balance Sheet 3 Cash 4 Notes and Acc. Rec. 5 Inventory 6 Prepaid 7 Current Assets S 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