Hello!

I need help with formatting the shown excel spreadsheet to have the correct formulas and formatting of the Marriotts Balance Sheet. The data is pulled from Marriott Corporations SEC Gov. database latest 3 years and must use formulas to get all of the totals in the excel sheet. I am unsure of where there needs to be changes and formulas added in my excel file.

Here are the instructions for this portion of the excel project -

-Go to the Securities and Exchange Commission's EDGAR database and access Marriott's most recent Form 10-K (annual report)

Balance Sheet

- Include the latest three years based on SEC (10-K) filings. Ensure that the worksheet includes a header with: Company Name Financial Statement Name Financial Statement Dates Denomination level ($s in millions or thousands, etc.)

- All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent.

- Dollar signs are included in the first and last numbers of each column.

- Subtotals and totals are preceded by a single underline. Totals are followed by a double underline.

- All extraneous information is removed from the spreadsheet. Sometimes, files downloaded from the SEC website contains extra characters or other things that need to be deleted. - Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read

Please help with correct formatting and formulas.

Thank you.

MARRIOTT
BALANCE SHEET
DECEMBER 31 2020 - DECEMBER 31 2022
DOLLARS IN MILLIONS
CONSOLIDATED BALANCE SHEETS - USD $ in Millions	Dec. 31, 2022	Dec. 31, 2021	Dec. 31, 2020
Current assets
Cash and equivalents	$ 507	$ 1,393	877
Accounts and notes receivable, net	2,571	1,982	1,768
Prepaid expenses and other	235	251	180
Total current assets	3,313	3,626	2,825
Property and equipment, net	1,585	1,503	1514
Intangible assets
Intangible assets	8,747	8,926	8,989
Goodwill	8,872	9,073	9,175
Total intangible assets	17,619	17,999	18,164
Equity method investments	335	387	422
Notes receivable, net	152	144	159
Deferred tax assets	240	228	249
Operating lease assets	987	1,062	752
Other noncurrent assets	584	604	616
Total assets	24,815	25,553	24,701
Current liabilities
Current portion of long-term debt	684	805	1173
Accounts payable	746	726	527
Accrued payroll and benefits	1,299	1,187	831
Accrued expenses and other	1,296	1,167	1,452
Total current liabilities	7,339	6,407	5,752
Long-term debt	9,380	9,333	9,203
Deferred tax liabilities	313	169	83
Operating lease liabilities	1,034	1,098	823
Other noncurrent liabilities	1,842	2,002	2,366
Stockholders' equity
ClassA Common Stock	5	5	5
Additional paid-in-capital	5,965	5,892	5,851
Retained earnings	12,342	10,305	9206
Treasury stock, at cost	(17,015)	(14,446)	(14,497)
Accumulated other comprehensive loss	(729)	(342)	(135)
Shareholder's equity (deficit)	568	1,414	430
Liabilities and deficit, total	24,815	25,553	24,701
Brands
Intangible assets
Intangible assets	5,812	5,979	6,059
Contract acquisition costs and other
Intangible assets
Intangible assets	2,935	2,947	2,930
Guest loyalty program
Current liabilities
Liability for guest loyalty program	3,314	2,522	1,769
Contract with customer	3,280	3,949	4,502
Deferred revenue
Current liabilities
Contract with customer	$ 1,059	$ 1,181	1,542