Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A projected income statement and unbalanced balance sheet for Chewy, Inc, including the most recent year's data for those two statements as well as the

A projected income statement and unbalanced balance sheet for Chewy, Inc, including the most recent year's data for those two statements as well as the cash flow statement is given under the heading of The Method 1. The same projected income statement and unbalanced balance sheet, but no cash flow statement are given under the heading of The Method 2.

The Method 1

Chewy, Inc. Class A



INCOME STATEMENT



Source: FactSet FundamentalsHistoricalPro Forma

JAN '2001-2021F01-2022F01-2023F
Sales4,846.75,331.45,864.66,451.0
Cost of Goods Sold (COGS) incl. D&A3,751.53,830.53,911.43,994.3
COGS excluding D&A3,702.73,776.73,852.33,929.3
Depreciation40.344.348.753.6
Amortization of Intangibles8.69.510.411.4
Gross Income1,095.21,500.91,953.22,456.7
SG&A Expense1,347.91,415.31,457.81,486.1
EBIT (Operating Income)-252.785.6495.4970.6
Nonoperating Income - Net0.40.00.00.0
Interest Expense-4.34.44.9
Pretax Income-252.481.3491.0965.7
Taxes
20.3122.7241.4
Net Income-252.461.0368.2724.3
All figures in millions of U.S. Dollar



Chewy, Inc. Class A



BALANCE SHEET



Source: FactSet FundamentalsHistoricalPro Forma

JAN '2001-2021F01-2022F01-2023F
Assets



Cash & Short-Term Investments212.1233.3256.6282.3
Excess Cash



Short-Term Receivables81.189.298.1107.9
Inventories317.8349.6384.5423.0
Other Current Assets18.820.722.725.0
Total Current Assets629.8692.8762.0838.2
Net Property, Plant & Equipment297.8327.6360.3396.3
Other Assets4.75.25.76.3
Total Assets932.31,025.61,128.11,240.9
Liabilities & Shareholders' Equity



Revolver



ST Debt & Curr. Portion LT Debt15.515.515.515.5
Accounts Payable683.0751.4826.5909.1
Other Current Liabilities402.0442.2486.4535.1
Total Current Liabilities1,100.51,209.11,328.41,459.7





Long-Term Debt200.4220.5242.5266.8
Other Liabilities35.338.842.747.0
Total Liabilities1,336.31,468.41,613.71,773.5





Preferred Stock (Carrying Value)0.00.00.00.0
Common Equity-404.0(343.0)25.2749.5
Total Equity-404.0(343.0)25.2749.5
Total Liabilities & Shareholders' Equity932.31,125.41,638.92,523.0
All figures in millions of U.S. Dollar








Balance Sheet Check
99.8510.81,282.1

Chewy, Inc. Class A



CASH FLOW STATEMENT



Source: FactSet FundamentalsHistoricalPro Forma

JAN '2001-2021F01-2022F01-2023F
Operating Activities



Net Income / Starting Line-252.4


Depreciation, Depletion & Amortization48.9


Other Funds136.00.00.00.0
Changes in Working Capital123.0


Accounts Receivable



Inventories



Other Current Assets



Accounts Payable



Other Current Liabilities



Net Operating Cash Flow55.4







Investing Activities



Capital Expenditures-48.64


Other Funds-1.23(27.6)(30.4)(33.4)
Net Investing Cash Flow-49.86







Financing Activities



Change in Capital Stock110.350.00.00.0
Issuance/Reduction of Debt, Net-10.53


Other Funds18.380.00.00.0
Net Financing Cash Flow118.19







Net Change in Cash123.76







Beginning Excess Cash/(Revolver)



Ending Excess Cash/(Revolver)0.00


All figures in millions of U.S. Dollar




The Method 2

Chewy, Inc. Class A



INCOME STATEMENT



Source: FactSet FundamentalsHistoricalPro Forma

JAN '2001-2021F01-2022F01-2023F
Sales4,846.75,331.45,864.66,451.0
Co

Step by Step Solution

3.43 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

Method 1 Chewy Inc Class A INCOME STATEMENT Source FactSet Fundamentals Historical Pro Forma JAN 20 012021F 012022F 012023F Sales 48467 53314 58646 64... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 1 attachment)

Excel file Icon
6051da9f8568a_727811.xlsx

300 KBs Excel File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship and Effective Small Business Management

Authors: Norman M. Scarborough, Jeffrey R. Cornwall

11th edition

133506320, 978-0133506327

More Books

Students also viewed these Finance questions