Chat with usLiveChat

Connecting to a pal for your paper

October 2, 2023

Complete part 3 of the excel project and combined previous parts 1 and 2 into a single document for the final part of the project. Instructions for part 3 are attached.Project needs to be done by

Complete part 3 of the excel project and combined previous parts 1 and 2 into a single document for the final part of the project. Instructions for part 3 are attached.

Project needs to be done by 7pm PST on Monday the 2nd of October.

Company Information

ACCT 370 Excel Project
AMAZON
Brianna Moore
Company Name	AMAZON.COM, INC.
Ticker Symbol	AMZN
Industry	E-Commerce and Technology
Products and Services Offered	E-Commerce, Kindle, Amazon Prime, Amazon Web Services (AWS), Amazon Echo and Alexa, Amazon Fresh and Whole Foods Market, Amazon Prime Video, Amazon Advertising, Amazon Music, Amazon Business, Amazon Logistics, Amazon Pharmacy, Audible, Twitch, Amazon Studios, Amazon Go
Major Competitors	Grocery and Food Delivery: Walmart,Instacart Streaming Services: Netflix, Disney+ Online Advertising: Google, Facebook Retail Technology: Shopify Pharmacy Services: CVS Health, Walgreens Smart Home Devices: Google (Nest), Apple (HomeKit) Cloud Computing (AWS): Microsoft Azure, Google Cloud Platform (GCP) E-Commerce: Walmart, Alibaba Group

Historical Income Statements

AMAZON.COM, INC.
Consolidated Statements of Comprehensive Income (Loss)
As of December 31, 2022, December 31, 2021 and December 31, 2020
USD ($) $ in Millions
	12 Months Ended
	Dec. 31, 2022	Dec. 31, 2021	Dec. 31, 2020
Statement of Comprehensive Income
Net income (loss)	$ (2,722)	$ 33,364	$ 21,331
Other comprehensive income (loss):
Foreign currency translation adjustments, net of tax of $(36), $47, and $100	(2,586)	(819)	561
Net change in unrealized gains (losses) on available-for-sale debt securities:
Unrealized gains (losses), net of tax of $(83), $72, and $159	(823)	(343)	273
Reclassification adjustment for losses (gains) included in “Other income (expense), net,” net of tax of $8, $13, and $0	298	(34)	(28)
Net unrealized gains (losses) on available-for-sale debt securities	(525)	(377)	245
Other comprehensive income (loss)	(3,111)	(1,196)	806
Comprehensive income (loss)	$ (9,469)	$ 30,595	$ 23,188

Historical Balance Sheets

AMAZON.COM, INC.
Consolidated Balance Sheets
As of December 31, 2022, December 31, 2021 and December 31, 2020
USD ($) $ in Millions
	Dec. 31, 2022	Dec. 31, 2021	Dec. 31, 2020
Current assets:
Cash and cash equivalents	$ 53,888	$ 36,220	$ 42,122
Marketable securities	16,138	59,829	42,274
Inventories	34,405	32,640	23,795
Accounts receivable, net and other	42,360	32,891	24,542
Total current assets	146,791	161,580	132,733
Property and equipment, net	186,715	160,281	113,114
Operating leases	66,123	56,082	37,553
Goodwill	20,288	15,371	15,017
Other assets	42,758	27,235	22,778
Total assets	462,675	420,549	321,195
Current liabilities:
Accounts payable	79,600	78,664	72,539
Accrued expenses and other	62,566	51,775	44,138
Unearned revenue	13,227	11,827	9,708
Total current liabilities	155,393	142,266	126,385
Long-term lease liabilities	72,968	67,651	52,573
Long-term debt	67,150	48,744	31,816
Other long-term liabilities	21,121	23,643	17,017
Total Liabilities	316,632	282,304	227,791
Stockholders’ equity:
Preferred stock ($0.01 par value; 500 shares authorized; no shares issued or outstanding)	0	0	0
Common stock ($0.01 par value; 100,000 shares authorized; 10,644 and 10,757 shares issued; 10,175 and 10,242 shares outstanding)	108	106	5
Treasury stock, at cost	(7,837)	(1,837)	(1,837)
Additional paid-in capital	75,066	55,437	42,865
Accumulated other comprehensive income (loss)	(4,487)	(1,376)	(180)
Retained earnings	83,193	85,915	52,551
Total stockholders’ equity	146,043	138,245	93,404
Total liabilities and stockholders’ equity	$ 462,675	$ 420,549	$ 321,195

Historical Statement of Cash Fl

AMAZON.COM, INC.
Consolidated Statements of Cash Flows
As of December 31, 2022, December 31, 2021 and December 31, 2020
USD ($) $ in Millions
	12 Months Ended
	Dec. 31, 2022	Dec. 31, 2021	Dec. 31, 2020
Statement of Cash Flows [Abstract]
CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD	$ 36,477	$ 42,377	$ 36,410
OPERATING ACTIVITIES:
Net income (loss)	(2,722)	33,364	21,331
Adjustments to reconcile net income (loss) to net cash from operating activities:
Depreciation and amortization of property and equipment and capitalized content costs, operating lease assets, and other	41,921	34,433	25,180
Stock-based compensation	19,621	12,757	9,208
Other expense (income), net	16,966	(14,306)	(2,582)
Deferred income taxes	(8,148)	(310)	(554)
Net Income Adjustments	70,360	32,574	31,252
Adjusted Net income (loss)	67,638	65,938	52,583
Changes in operating assets and liabilities:
Inventories	(2,592)	(9,487)	(2,849)
Accounts receivable, net and other	(21,897)	(18,163)	(8,169)
Accounts payable	2,945	3,602	17,480
Accrued expenses and other	(1,558)	2,123	5,754
Unearned revenue	2,216	2,314	1,265
Net cash provided by (used in) operating activities	46,752	46,327	66,064
INVESTING ACTIVITIES:
Purchases of property and equipment	(63,645)	(61,053)	(40,140)
Proceeds from property and equipment sales and incentives	5,324	5,657	5,096
Acquisitions, net of cash acquired, and other	(8,316)	(1,985)	(2,325)
Sales and maturities of marketable securities	31,601	59,384	50,237
Purchases of marketable securities	(2,565)	(60,157)	(72,479)
Net cash provided by (used in) investing activities	(37,601)	(58,154)	(59,611)
FINANCING ACTIVITIES:
Common stock repurchased	(6,000)	0	0
Proceeds from short-term debt, and other	41,553	7,956	6,796
Repayments of short-term debt, and other	(37,554)	(7,753)	(6,177)
Proceeds from long-term debt	21,166	19,003	10,525
Repayments of long-term debt	(1,258)	(1,590)	(1,553)
Principal repayments of finance leases	(7,941)	(11,163)	(10,642)
Principal repayments of financing obligations	(248)	(162)	(53)
Net cash provided by (used in) financing activities	9,718	6,291	(1,104)
Foreign currency effect on cash, cash equivalents, and restricted cash	(1,093)	(364)	618
Net increase (decrease) in cash, cash equivalents, and restricted cash	17,776	(5,900)	5,967
CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD	$ 54,253	$ 36,477	$ 42,377

,

Company Information

ACCT 370 Excel Project
AMAZON
Company Information
Student Name
Company Name	AMAZON.COM, INC.
Ticker Symbol	AMZN
Industry	E-Commerce and Technology
Products and Services Offered	E-Commerce, Kindle, Amazon Prime, Amazon Web Services (AWS), Amazon Echo and Alexa, Amazon Fresh and Whole Foods Market, Amazon Prime Video, Amazon Advertising, Amazon Music, Amazon Business, Amazon Logistics, Amazon Pharmacy, Audible, Twitch, Amazon Studios, Amazon Go
Major Competitors	Grocery and Food Delivery: Walmart,Instacart Streaming Services: Netflix, Disney+ Online Advertising: Google, Facebook Retail Technology: Shopify Pharmacy Services: CVS Health, Walgreens Smart Home Devices: Google (Nest), Apple (HomeKit) Cloud Computing (AWS): Microsoft Azure, Google Cloud Platform (GCP) E-Commerce: Walmart, Alibaba Group

Historical Income Statements

AMAZON.COM, INC.
Consolidated Statements of Comprehensive Income (Loss)
As of December 31, 2022, December 31, 2021 and December 31, 2020
USD ($) $ in Millions
	12 Months Ended
	Dec. 31, 2022	Dec. 31, 2021	Dec. 31, 2020
Statement of Comprehensive Income
Net income (loss)	$ (2,722)	$ 33,364	$ 21,331
Other comprehensive income (loss):
Foreign currency translation adjustments, net of tax of $(36), $47, and $100	(2,586)	(819)	561
Net change in unrealized gains (losses) on available-for-sale debt securities:
Unrealized gains (losses), net of tax of $(83), $72, and $159	(823)	(343)	273
Reclassification adjustment for losses (gains) included in “Other income (expense), net,” net of tax of $8, $13, and $0	298	(34)	(28)
Net unrealized gains (losses) on available-for-sale debt securities	(525)	(377)	245
Other comprehensive income (loss)	(3,111)	(1,196)	806
Comprehensive income (loss)	$ (9,469)	$ 30,595	$ 23,188

Historical Balance Sheets

AMAZON.COM, INC.
Consolidated Balance Sheets
As of December 31, 2022, December 31, 2021 and December 31, 2020
USD ($) $ in Millions
	Dec. 31, 2022	Dec. 31, 2021	Dec. 31, 2020
Current assets:
Cash and cash equivalents	$ 53,888	$ 36,220	$ 42,122
Marketable securities	16,138	59,829	42,274
Inventories	34,405	32,640	23,795
Accounts receivable, net and other	42,360	32,891	24,542
Total current assets	146,791	161,580	132,733
Property and equipment, net	186,715	160,281	113,114
Operating leases	66,123	56,082	37,553
Goodwill	20,288	15,371	15,017
Other assets	42,758	27,235	22,778
Total assets	462,675	420,549	321,195</td Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions. Common Sized Balance Sheets (Tabs 12), Common Sized Income Statements (Tab 13), Horizontal Analysis Balance Sheets (Tab 14), Horizontal Analysis Income Statements (Tab 15), and Projected Financial Is what the New Orleans hotels were doing acceptable practice during the two high-profile citywide events of Mardi Gras and the Super Bowl? 2. Were they practicing revenue management or were they Related Posts Uncategorized The goal of this project is to integrate your various components into polished, professional products. Follow the instructions below to ensure a succe Uncategorized The goal of this project is to integrate your various components into polished, professional products. Follow the instructions below to ensure a succe Uncategorized The goal of this project is to integrate your various components into polished, professional products. Follow the instructions below to ensure a succe Why Choose Us Best Essay Writing Services- Get Quality Homework Essay Paper at Discounted Prices At the risk of sounding immodest, we must point out that we have an elite team of writers. Ours isn’t a collection of individuals who are good at searching for information on the Internet and then conveniently re-writing the information obtained to barely beat Plagiarism Software. Who can’t do that? Our writers have strong academic backgrounds with regards to their areas of writing. A paper on History will only be handled by a writer who is trained in that field. A paper on health care can only be dealt with by a writer qualified on matters health care. Thesis papers will only be handled by Masters’ Degree holders while Dissertations will strictly be handled by PhD holders. With such a system, you needn’t worry about the quality of work. Quality isn’t just an option, it is the only option. We don’t just employ writers, we hire professionals. We have writers spread into all fields including but not limited to Philosophy, Economics, Business, Medicine, Nursing, Education, Technology, Tourism and Travels, Leadership, History, Poverty, Marketing, Climate Change, Social Justice, Chemistry, Mathematics, Literature, Accounting and Political Science. Our writers are also well trained to follow client instructions as well adhere to various writing conventional writing structures as per the demand of specific articles. They are also well versed with citation styles such as APA, MLA, Chicago, Harvard, and Oxford which come handy during the preparation of academic papers. They also have unrivalled skill in writing language be it UK English or USA English considering that they are native English speakers. You also needn’t worry about logical flow of thought, sentence structure as well as proper use of phrases. Our writers are also not the kind to decorate articles with unnecessary filler words. We respect your money and most importantly your trust in us. In writing, we will be precise and to the point and fill the paper with content as opposed to words aimed at beating the word count. Our shift-system also ensures that you get fresh writers each time you send a job. This helps overcome occupational hazards brought about by fatigue. Hence, quality will consistently be at the top. From our writers, you expect; good quality work, friendly service, timely deliveries, and adherence to client’s demands and specifications. Once you’ve submitted your writing requests, you can go take a stroll while waiting for our all-star team of writers and editors to submit top quality work. How Our Website Works Get an Essay from Us College Essays is the biggest affiliate and testbank for WriteDen. We hire writers from all over the world with an aim to give the best essays to our clients. Our writers will help you write all your homework. They will write your papers from scratch. We also have a team of editors who read each paper from our writers just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. Step 1 To make an Order you only need to click ORDER NOW and we will direct you to our Order Page. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Deadline range from 6 hours to 30 days. Step 2 Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email. Step 3 Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost. Is it Safe to use our services? We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper. Pricing and Discounts Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure. Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you. Recent Posts Imagine you are the principal of a local public school. You experienced a higher than usual amount of turnover with your teaching staff. You want to implemen This assignment is based off of the book by Carson, Clarence B. / Cleveland, Paul A. (4th ed., 2018). Basic Economics, Birmingham, AL ISBN 978-0-9727401-4-2? Imagine you work for a breakfast cereal company that makes prepared products that are served cold. Your company wants to introduce a new hot breakfast cereal Visit CDS Central and download the CDS Dissertation Guide.This assignment is to help acclimate you to the dissertation journey and to resources available in Did you know you can earn a post master’s certificate based on your chosen elective after successfully completing the electives content courses associated wi College Pal All Rights Reserved Terms and Conditions College pals.com Privacy Policy 2010-2018