Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the most recent financial statements for Target (FY2021). Sales for FY2022 are expected to grow by 3 percent. The following assumption must hold in

Given the most recent financial statements for Target (FY2021). Sales for FY2022 are expected to grow by 3 percent. The following assumption must hold in the pro forma financial statements. The tax rate (percentage), the interest expense (39), and the dividend payout ratio (percentage) will remain constant. COGS, SGA, Depreciation, Cash, Inventory, Other Current Assets, Net PPE, and accounts payable and other current liabilities increase spontaneously with sales. Calculate the pro forma value of total assets for FY22, if the firm operates at full capacity and no new debt or equity is issued.

Target (TGT)
Numbers are in millions.
Income Statement Balance Sheet
FY2021 FY2021
Sales 106,005 Cash 5911
COGS 74,963 Inventory 13902
SGA 19,752 Other Current Assets 1760
Deprec. 2,344 Total Current Assets 21573
EBIT 8,946 Net PPE 32238
Interest Expense 39 Total Assets 53811
EBT 8,907
Taxes 1,961 Accounts Payable 15478
Net Income 6,946 Other CL 6098
Current portion of LTD 171
Dividends 8,648 Total CL 21747
Add to RE -1,702 Long-term Debt 19,237
Total Liab. 40984
Shares out 488 Common Stock 6460
Price $161.97 Retained Earnings 6367
Amortization 500 Total Equity 12827
Total L and E 53811

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

The Handbook Of Financial Communication And Investor Relations

Authors: Alexander V. Laskin

1st Edition

1119240786, 978-1119240785

More Books

Students also viewed these Finance questions

Question

Write formal and informal proposals.

Answered: 1 week ago

Question

Describe the components of a formal report.

Answered: 1 week ago

Question

Write formal and informal reports.

Answered: 1 week ago