JTM Airlines, a privately held firm, is looking to buy additional gates at its home airport for $1,200,000. It has money in the bank, but that money may not be spent as it is used to pay salaries, suppliers, and equipment. It asked its bank for a loan, but the bank refused unless the project had a return higher than JTM's weighed average cost of capital. Separately, PAN Airways' CEO approached UTM's CEO to sell the airline. As a result of all this, JTM has contracted you to 3. You were given PAN's 2020 income statement (IS) and balance sheet (BS), along with forecasts of the revenue growth. Forecast the Is and BS for the next 5 years. Hintage D G Actual 2020 2021 Prejected 2023 40% 2022 4,0% Notes 2024 38% 2025 1.4% 8,210 2 Income Statement (in '000 $) Operating Revenue growth rate 4 Total Operating Revenues 5 Wages, benefits, payroll support, incentives 7 Aircraft fuel incl ledging gan losses Aircraft maintenance/tent 9 Landing fees and other rentals Depreciation amortization All other expenses Total Operating Expenses 13 Operating Income Total con operating in.com (expense) Income before taxes Income tax expense (bene) Net Income 2211 1,200 565 432 374 1300 6,677 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 3.04 09: 3.04 40 3.09. 50 Increase at a yearly rate or 50% 1,542 (475) 1,062 24 343 Balance Sheet 1.0 1.249 605 192 4,000 2:11 6,831 Increase Operating Revenue growth rate Increase Operating Revenue prowth rate Plot to make balance sheet balance 20 Cash and vestments 21 Accounts receivable 22. Inventory and supplies, et 22 Other 24 Current Assets 35 Other 26 Total Assets 22 20 Bank Loan Payables 30 CPLTD 31 Other 32 Current Liabilities 3) LTD 34 Equity 35. Total Liabilities & Equity 36 37 Working Capital 38 3.649 248 Increase Operating Revenue growth #034 1.577 920 6,831 LTD of persons year mitru CPLTD of current year Equity of previous year plus net income of current year Exclude Bank Loan 3.635 inalisation Pro STM Balance JTM Airlines, a privately held firm, is looking to buy additional gates at its home airport for $1,200,000. It has money in the bank, but that money may not be spent as it is used to pay salaries, suppliers, and equipment. It asked its bank for a loan, but the bank refused unless the project had a return higher than JTM's weighed average cost of capital. Separately, PAN Airways' CEO approached UTM's CEO to sell the airline. As a result of all this, JTM has contracted you to 3. You were given PAN's 2020 income statement (IS) and balance sheet (BS), along with forecasts of the revenue growth. Forecast the Is and BS for the next 5 years. Hintage D G Actual 2020 2021 Prejected 2023 40% 2022 4,0% Notes 2024 38% 2025 1.4% 8,210 2 Income Statement (in '000 $) Operating Revenue growth rate 4 Total Operating Revenues 5 Wages, benefits, payroll support, incentives 7 Aircraft fuel incl ledging gan losses Aircraft maintenance/tent 9 Landing fees and other rentals Depreciation amortization All other expenses Total Operating Expenses 13 Operating Income Total con operating in.com (expense) Income before taxes Income tax expense (bene) Net Income 2211 1,200 565 432 374 1300 6,677 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 3.04 09: 3.04 40 3.09. 50 Increase at a yearly rate or 50% 1,542 (475) 1,062 24 343 Balance Sheet 1.0 1.249 605 192 4,000 2:11 6,831 Increase Operating Revenue growth rate Increase Operating Revenue prowth rate Plot to make balance sheet balance 20 Cash and vestments 21 Accounts receivable 22. Inventory and supplies, et 22 Other 24 Current Assets 35 Other 26 Total Assets 22 20 Bank Loan Payables 30 CPLTD 31 Other 32 Current Liabilities 3) LTD 34 Equity 35. Total Liabilities & Equity 36 37 Working Capital 38 3.649 248 Increase Operating Revenue growth #034 1.577 920 6,831 LTD of persons year mitru CPLTD of current year Equity of previous year plus net income of current year Exclude Bank Loan 3.635 inalisation Pro STM Balance