Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exhibit 1 Forecast Assumptions Sales growth Cash and cash equivalents Marketable securities Accounts receivable Inventory 2% Students need to calculate Same $ as 2020

image text in transcribedimage text in transcribedimage text in transcribed

Exhibit 1 Forecast Assumptions Sales growth Cash and cash equivalents Marketable securities Accounts receivable Inventory 2% Students need to calculate Same $ as 2020 Use % of sales 2020 Use % of sales 2020 Prepaid expenses and other current assets Use % of sales 2020 Total current assets Property and equipment, net Operating lease right-of-use assets Marketable securities Deferred income taxes and other assets Total Assets Accounts payable Current portion of operating lease liabilities Accrued compensation and benefits Accrued expenses and other current liabilitie Total current liabilities Needs to calculate 22.34% of projected sales Same $ as 2020 Same $ as 2020 Use % of sales 2020 Students need to calculate Use % of sales 2020 Use % of sales 2020 Use % of sales 2020 Use % of sales 2020 Students need to calculate Non-current portion of operating lease liabil Same $ as 2020 Deferred rent and other liabilities Total Liabilities Preferred shares Use % of sales 2020 Students need to calculate Same as 2020 Exhibit 2 Financial Statements 2018-2020 Total Assets Exhibit 3 K Goods Financial Statements Consolidated Balance Sheets - USD ($) $ in Jan. 31, 2020 Jan. 31, 2019 Jan. 31, 2018 Consolidated Balance Sheets - USD ($) $ in Thousands Current assets: Projected" Cash and cash equivalents $221,839 Marketable securities 211,453 Accounts receivable, net of allowance for doubtful accounts of 88,288 $ 358,260 279,232 80,461 $282,220 2021 2020 165,125 Assets 76,962 $880 and $1,499, respectively Cash 55,000 Inventory 409,534 370,507 351,395 Prepaid expenses and other current assets 122,282 114,296 103,055 Account Receivalbe, net Inventory 525,000 275,000 (50,000) 525,000 275,000 Total current assets 1,053,396 1,202,756 978,757 Total current assets 855,000 750,000 Property and equipment, net 890,032 796,029 813,768 Operating lease right-of-use assets 1,170,531 Marketable securities 97,096 57,292 58,688 Fixed Assets, net Total Assets Liabilities 1,250,000 1,250,000 2,105,000 2,000,000 Deferred income taxes and other assets 104,578 104,438 101,567 3,315,633 2,160,515 1,952,780 Current liabilities: Accounts payable 167,871 144,414 128,246 Current portion of operating lease liabilities 221,593 Accrued compensation and benefits 44,041 54,799 36,058 Accounts Payable Other current liabilities Total current liabilities Long Term Debt Total Liabilities Shareholders' Equity 300,000 300,000 250,000 250,000 550,000 550,000 625,000 625,000 1,175,000 1,175,000 Accrued expenses and other current liabilities 205,265 187,431 195,910 Total current liabilities 638,770 386,644 360,214 Non-current portion of operating lease liabilities 1,137,495 Deferred rent and other liabilities 84,013 284,773 291,663 Common shares Additional paid-in-capital Retained earnings Accumulated other comprehensive loss Total Shareholders' Equity Total Liabilities and Shareholders' Equity Cost of sales (excluding store impairment) | Use % of sales 2020 Store impairment Gross profit Use % of sales 2020 Use % of sales 2020 Selling, general and administrative expenses Use % of sales 2020 Goodwill impairment Income from operations Other income Int expenses Income before income taxes Income tax expense Net income Same $ as 2020 Same as 2020 Total Liabilities 1,860,278 671,417 651,877 Shareholders' equity: Common Stock; Par value $0.1 Total Shareholders' Equity Total Liablities and SE Consolidated Statements of Income - USD ($) $ in Thousands 11,500 10,000 Additional Paid in Capital Retained Earnings 793,500 690,000 125,000 125,000 930,000 825,000 2,105,000 2,000,000 Students need to calculate, based on 2020 div payout ratio Preferred shares; $.0001 par value, 10,000,000 shares authorized, none issued Sales 1,837,500 1,750,000 Common shares; $.0001 par value, 200,000,000 shares 10 11 11 Cost of Good Sold authorized, 97,976,815 and 105,642,283 shares issued and Same $ as 2020 outstanding, respectively 918,750 875,000 Students need to calculate Additional paid-in-capital Students need to calculate Retained earnings Accumulated other comprehensive loss Total Shareholders' Equity Total Liabilities and Shareholders' Equity $2,160,515 9,487 1,473,862 684 1,515,506 (28,004) (27,103) 684 1,310,859 (10,651) 1,455,355 $3,315,633 1,489,098 1,300,903 $1,952,780 Gross Profit 918,750 875,000 Use % of sales 2020 Sales, General & Admin Other Operating Expenses Income from Operations Interest Expense Income before income taxes Income tax expense 236,250 225,000 77,700 74,000 604,800 576,000 89,250 85,000 515,550 491,000 128,888 122,750 Use % of sales 2020 Consolidated Statements of Income - USD ($) $ in 12 Months Ended Net income 386,663 368,250 Use % of sales 2020 Thousands Jan. 31, 2020 Jan. 31, 2019 Jan. 31, 2018 Use % of sales 2020 Income Statement "Include investment of $10,500,000 Use % of sales 2020 Net sales Use % of sales 2020 Cost of sales (excluding store impairment) Use % of sales 2020 Store impairment $3,983,789 2,729,352 14,611 Gross profit 1,239,826 Selling, general and administrative expenses 993,990 $3,950,623 2,600,367 3,544 1,346,712 965,399 $3,616,014 2,429,097 11,410 1,175,507 915,615 Exhibit 2 contd. Goodwill impairment Income from operations 13,911 231,925 381,313 259,892 Other income 12,076 10,565 6,314 Int expenses Income before income taxes Income tax expense 4,281 239,720 71,624 6,325 385,553 87,550 4,840 261,366 153,103 Net cash provided by operating activities Net cash used in investing activities Net cash used in financing activities Net income $168,096 $298,003 $108,263 Net income per common share: Basic Diluted $1.68 $1.67 $2.75 $2.72 $ 0.97 $0.96 Summary consolidated Statements of Cash Flows - USD ($) $ in Thousands Effect of exchange rate changes on cash and cash equivalents (Decrease) increase in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Jan. 31, 2020 273,893 Jan. 31, 2018 668 (186,145) (222,047) (2,122) 446,624 303,059 (244,498) (121,380) (118,024) (159,226) (8,062) 11,627 (136,421) 76,040 34,080 358,260 282,220 248,140 221,839 358,260 282,220 12 Months Ended Jan. 31, 2019 Weighted-average common shares outstanding: Basic 99,833,011 108,303,594 Diluted 100,588,677 109,706,007 111,887,308 112,367,924 Summary consolidated Statements of Cash Flows - 12 Months Ended

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

Step: 3

blur-text-image

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

Financial and Managerial Accounting the basis for business decisions

Authors: Jan Williams, Susan Haka, Mark Bettner, Joseph Carcello

16th edition

0077664078, 978-0077664077, 78111048, 978-0078111044

More Books

Students also viewed these Accounting questions