Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Simon has taken to increase their liquidity. Do an analysis on how these steps benefit liquidity and comment on the impact on all financial statements.
Simon has taken to increase their liquidity. Do an analysis on how these steps benefit liquidity and comment on the impact on all financial statements. For this exercise, assume Simon will have a decrease in revenue of up to 50% for this upcoming quarter and 75% for the quarter after that. What does the future look like?
for balence sheet
Assets | Q3 2019 | Q4 2019 | Q1 2020 | |||
Q2 2019 | 8/31/19 | 11/30/19 | 2/29/20 | |||
5/31/19 | ||||||
Cash and Short Term Invs | 1,202 | 1,153 | 518 | 1,354 | ||
Total Receivables, Net | 615 | 588 | 598 | 405 | ||
Total Inventory | 501 | 482 | 427 | 440 | ||
Prepaid Expenses | 498 | 468 | 472 | 687 | ||
Restricted Cash - Current | -- | -- | 13 | -- | ||
Other Current Assets | 19 | 21 | 31 | -1 | ||
Other Curr. Assets, Total | 19 | 21 | 44 | -1 | ||
Total Current Assets | 2,835 | 2,712 | 2,059 | 2,885 | ||
Prop./Plant/Equip. - Net | 36,814 | 36,466 | 38,131 | 39,492 | ||
Goodwill, Net | 2,907 | 2,886 | 2,912 | 2,176 | ||
Intangibles - Net | 1,172 | 1,166 | 1,174 | 1,173 | ||
Other Long Term Assets | 784 | 771 | 782 | 1,217 | ||
Total Assets | 44,512 | 44,001 | 45,058 | 46,943 | ||
Liabilities | Q3 2019 | Q4 2019 | Q1 2020 | |||
Q2 2019 | 8/31/19 | 11/30/19 | 2/29/20 | |||
5/31/19 | ||||||
Accounts Payable | 792 | 695 | 756 | 904 | ||
Accrued Expenses | 1,665 | 1,706 | 1,801 | 1,922 | ||
Notes Payable/ST Debt | 480 | 238 | 231 | 1,004 | ||
Curr. Port. LT Dbt/Cap Ls. | 1,614 | 1,607 | 1,596 | 2,196 | ||
Customer Advances | 5,815 | 4,674 | 4,735 | 4,690 | ||
Other Current Liabilities | 11 | 12 | 8 | -- | ||
Other Curr. Lblts, Total | 5,826 | 4,686 | 4,743 | 4,690 | ||
Total Current Liabilities | 10,377 | 8,932 | 9,127 | 10,716 | ||
Total Long Term Debt | 9,080 | 8,893 | 9,675 | 9,738 | ||
Total Debt | 11,174 | 10,738 | 11,502 | 12,938 | ||
Other Liabilities, Total | 947 | 881 | 891 | 2,199 | ||
Total Liabilities | 20,404 | 18,706 | 19,693 | 22,653 | ||
Shareholder | Q3 2019 | Q4 2019 | Q1 2020 | |||
Equity | Q2 2019 | 8/31/19 | 11/30/19 | 2/29/20 | ||
5/31/19 | ||||||
Common Stock | 365 | 365 | 365 | 366 | ||
Additional Paid-In Capital | 8,785 | 8,798 | 8,807 | 8,829 | ||
Ret. Earn.(Accum. Deficit) | 25,138 | 26,576 | 26,653 | 25,527 | ||
Treasury Stock - Common | -8,104 | -8,261 | -8,394 | -8,404 | ||
Other Equity, Total | -2,076 | -2,183 | -2,066 | -2,028 | ||
Total Equity | 24,108 | 25,295 | 25,365 | 24,290 | ||
Total Liabilities & Shareholders Equity | 44,512 | 44,001 | 45,058 | 46,943 | ||
Shr Outs.-Com. Primary Iss. | 527 | 527 | 527 | 528 | ||
Shr Outs.-Com. Stk. Iss. 2 | 163 | 160 | 157 | 157 | ||
Ttl Comm. Shares Outs. | 690 | 687 | 684 | 685 | ||
Trsy. Shrs-Comm. Primary Iss. | 130 | 130 | 130 | 130 | ||
Trsy. Shrs-Comm. Iss. 2 | 54 | 57 | 60 | 60 |
|
and cash flow
Q2 2019 5/31/19 Q3 2019 8/31/19 Q4 2019 11/30/19 Q1 2020 2/29/20 787 -781 2,567 1,607 1,059 2,990 2,160 26 570 37 89 115 -114 O -101 Net Income Depreciation Depletion Unusual Items Other Non-Cash Items Non-Cash Items Accounts Receivable Inventories Prepaid Expenses Accounts Payable Accrued Expenses Changes in Working Capital Total Cash from Operations Plus: Cash from/Used by Investing Activities Values displayed are in millions. 1,062 -53 1,009 21 -15 - 120 148 120 79 -302 -220 -254 68 -25 34 80 48 1,286 3,169 63 147 4,414 119 211 5,476 917 Q3 2019 Q2 2019 5/31/19 -3,021 8/31/19 -3,448 Q4 2019 11/30/19 -5,429 Q1 2020 2/29/20 -1,326 226 0 -6 -6 122 -61 Capital Expenditures Sale of Fixed Assets Investment, Net Other Investing Cash Flow Other InvestCashFlowltms, Tot Total Cash from Investing Plus: Cash from/Used by Financing Activities Values displayed are in millions. 103 103 -2,918 131 132 152 -5,277 165 - 1,161 -3,317 Q1 2020 2/29/20 -25 Financing Cash Flow Items Total Cash Dividends Paid Iss (Retirmnt) of Stock, Net Short Term Debt, Net Long Term Debt Issued Long Term Debt Reduction Long Term Debt, Net Iss (Retirmnt) of Debt, Net Total Cash From Financing Equals: Increase/Decrease in CashValues displayed are in millions. Q2 2019 5/31/19 -43 -694 -316 -357 1,722 -338 1,384 1,027 -26 Q3 2019 8/31/19 -49 - 1,041 -472 -600 1,722 -472 1,250 Q4 2019 11/30/19 -83 - 1,387 -603 -605 3,674 - 1,651 2,023 1,418 -344 -12 779 823 - 132 691 1,470 1,089 650 -912 -655 Q2 2019 5/31/19 Foreign Exchange Effects Net Change in Cash NetCash-BeginBal/RsvdforFul NetCash-EndBal/RsrvforFutu Depreciation, Supplemental 220 996 1,215 1,059 Q3 2019 8/31/19 -11 174 996 1,170 1,607 Q4 2019 11/30/19 -9 -465 996 530 2,160 Q1 2020 2/29/20 -7 838 530 1,368 570 Q2 2019 5/31/19 Q3 2019 8/31/19 Q4 2019 11/30/19 Q1 2020 2/29/20 787 -781 2,567 1,607 1,059 2,990 2,160 26 570 37 89 115 -114 O -101 Net Income Depreciation Depletion Unusual Items Other Non-Cash Items Non-Cash Items Accounts Receivable Inventories Prepaid Expenses Accounts Payable Accrued Expenses Changes in Working Capital Total Cash from Operations Plus: Cash from/Used by Investing Activities Values displayed are in millions. 1,062 -53 1,009 21 -15 - 120 148 120 79 -302 -220 -254 68 -25 34 80 48 1,286 3,169 63 147 4,414 119 211 5,476 917 Q3 2019 Q2 2019 5/31/19 -3,021 8/31/19 -3,448 Q4 2019 11/30/19 -5,429 Q1 2020 2/29/20 -1,326 226 0 -6 -6 122 -61 Capital Expenditures Sale of Fixed Assets Investment, Net Other Investing Cash Flow Other InvestCashFlowltms, Tot Total Cash from Investing Plus: Cash from/Used by Financing Activities Values displayed are in millions. 103 103 -2,918 131 132 152 -5,277 165 - 1,161 -3,317 Q1 2020 2/29/20 -25 Financing Cash Flow Items Total Cash Dividends Paid Iss (Retirmnt) of Stock, Net Short Term Debt, Net Long Term Debt Issued Long Term Debt Reduction Long Term Debt, Net Iss (Retirmnt) of Debt, Net Total Cash From Financing Equals: Increase/Decrease in CashValues displayed are in millions. Q2 2019 5/31/19 -43 -694 -316 -357 1,722 -338 1,384 1,027 -26 Q3 2019 8/31/19 -49 - 1,041 -472 -600 1,722 -472 1,250 Q4 2019 11/30/19 -83 - 1,387 -603 -605 3,674 - 1,651 2,023 1,418 -344 -12 779 823 - 132 691 1,470 1,089 650 -912 -655 Q2 2019 5/31/19 Foreign Exchange Effects Net Change in Cash NetCash-BeginBal/RsvdforFul NetCash-EndBal/RsrvforFutu Depreciation, Supplemental 220 996 1,215 1,059 Q3 2019 8/31/19 -11 174 996 1,170 1,607 Q4 2019 11/30/19 -9 -465 996 530 2,160 Q1 2020 2/29/20 -7 838 530 1,368 570Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started