Question: I need help for the Balance Sheet through Excel spreadsheet for JetBlue Airways Corporation for Period Dec. 31, 2020 through Dec. 31, 2024 . I

I need help for the Balance Sheet through Excel spreadsheet for JetBlue Airways Corporation for Period Dec. 31, 2020 through Dec. 31, 2024.

I had to use JetBlue 10-K Forms to fill in 2020-2024 in Excel sheet (in light font; not bolded font since its automated for you). JetBlue 2024 10-K Form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0001158463/000115846325000005/jblu-20241231.htm#fact-identifier-1370

JetBlue 2022 10-K Form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0001158463/000115846323000002/jblu-20221231.htm

JetBlue 2020 10-K Form: https://www.sec.gov/ix?doc=/Archives/edgar/data/0001158463/000162828021003705/jblu-20201231.htm

I need help for the Balance Sheet through ExcelI need help for the Balance Sheet through Excel
A B C D E F JetBlue Airways Corporation Balance Sheet For Period December 31, 2020 through December 31, 2024 (in millions) Financial Statements 2020 2021 2022 2023 2024 Assets Current Assets Cash and Cash Equivalents $ 1,918.00 $ 2,018.00 : $ 1,042.00 $ 1,166.00 $ 1,921.00 10 Accounts Receivable Net 98.00 207.00 | $ 317.00 336.00 $ 348.00 11 Inventory 71.00 $ 74.00 | $ 87.00 109.00 158.00 12 Other Current Assets 123.00 $ 122.00 | $ 120.00 148.00 S 142.00 13 Total Current Assets 2,210.00 $ 2,421.00 $ 1,566.00 $ 1,759.00 $ 2,569.00 14 15 Non-Current Assets 16 Property, Plant, and Equipment Net 8,399.00 $ 8,271.00 $ 8,564.00 $ 9,675.00 $ 10,656.00 17 Intangibles 261.00 299.00 $ 298.00 349.00 $ 899.00 18 Other Assets 597.00 $ 854.00 S 1,322.00 $ 1,425.00 1,377.00 19 Total Non-Current/Fixed Assets $ 9,257.00 $ 9,424.00 10,184.00 $ 11,449.00 S 12,432.00 20 21 Total Assets $ 11,467.00 | $ 11,845.00 $ 11,750.00 | $ 13,208.00 $ 15,001.00 22 23 Liabilities and Owners' Equity 24 Current Liabilities 25 Accounts Payable $ 365.00 $ 499.00 | $ 532.00 $ 541.00 $ 619.00 26 Accrued Expenses and Other Current Liabilities 524.00 $ 839.00 $ 984.00 $ 1,100.00 S 1,205.00 27 Current Portion of Debt and Leases 450.00 S 355.00 | $ 654.00 307.00 $ 392.00 28 Total Current Liabilities 1,439.00 $ 1,693.00 S 2,070.00 2,048.00 S 2,216.00 29 30 Long-Term Liabilities 31 Long-Term Debt and Lease Obligations 4,413.00 3,651.00 | $ 3,093.00 $ 4,409.00 $ 8,147.0032 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Other Long-Term Liabilities Total Long-Term Liabilities S 78.00 | $ 552.00 | $ 494.00 | 449.00 | $ 376.00 $ 4,491.00 | 4,203.00 | $ 3,587.00 | $ 4,858.00 | 8,523.00 Total Liabilities [s 5,930.00 | $ 5,896.00 | $ 5,657.00 | $ 6,906.00 | $ 10,739.00 | Owners' Equity Common Stock, Less Treasury 5 5.00} 5 5.00 | 5 5.00) 5 5.00 | 5 5.00 Additional Paid in Capital $ 2,959.00 | $ 3,047.00 | 3,129.00 | $ 3,221.00 | $ 3,320.00 Retained Earnings S 2,968.00 | $ 2,786.00 | 2,424.00 | $ 2,114.00 | $ 1,319.00 Other Equity S - S - 5 - 5 (4.00) $ 2.00 Total Equity $ 5,932.00 | $ 5,838.00 | $ 5,558.00 | $ 5,336.00 | 4,646.00 Total Liabilities & Equity [S$ _11,862.00]$ _11,734.00]$ _11,215.00|$ _12,242.00[$ 15,385.00 | Check Digit: This should be O or the balance sheet is out of balance. Check your work. $ (395.00) $ 111.00 55 535.00 $ 966.00 (384.00)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!