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 9 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 S 317.00 336.00 $ 348.00 11 Inventory 71.00 $ 74.00 S 87.00 $ 109.00 158.00 2 Other Current Assets 123.00 $ 122.00 120.00 148.00 $ 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 S 261.00 $ 299.00 S 298.00 349.00 $ 399.00 18 Other Assets $ 597.00 854.00 $ 1,322.00 $ 1,425.00 1,377.00 Total Non-Current/Fixed Assets 9,257.00 $ 9,424.00 S 10,184.00 $ 11,449.00 |$ 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 $ 641.00 $ 619.00 26 Accrued Expenses and Other Current Liabilities 624.00 $ 839.00 984.00 1,100.00 $ 1,205.00 27 Current Portion of Debt and Leases 450.00 $ 355.00 554.00 $ 307.00 $ 392.00 28 Total Current Liabilities 1,439.00 $ 1,693.00 S 2,070.00 $ 2,048.00 |$ 2,216.00 2930 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Long-Term Liabilities Long-Term Debt and Lease Obligations 5 4,413.00 | 3,651.00 | $ 3,093.00 | 4,409.00 | $ 8,147.00 Other Long-Term Liabilities 5 78.00 |S 552.00 | $ 494.00 | $ 449.00 | $ 376.00 Total Long-Term Liabilities S 4,491.00 | $ 4,203.00 | $ 3,587.00 | $ 4,358.00 | $ 8,523.00 Total Liabilities Ls 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.00 | 5 5.00 | 5.00 | 5 5.00 Additional Paid in Capital S 2,959.00 |S 3,047.00 | $ 3,129.00 |S 3,221.00 | $ 3,320.00 Retained Earnings 5 2,968.00 |S 2,786.00 | $ 2,424.00 |S 2,114.00 | $ 1,319.00 Other Equity 5 - 5 - 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 [$___11,862.00[$ _11,734.00/$ _11,215.00[$ _12,242.00| $ 15,385.00 Check Digit: This should be 0 or the balance sheet is out of balance. Check your work. 5 (395.00) $ 111.00 $ 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!