Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1.calculate NPV and IRR 2.discuss the area of working capital management and identify the ways in which inventory, account receivable and cash could be efficiently
1.calculate NPV and IRR
2.discuss the area of working capital management and identify the ways in which inventory, account receivable and cash could be efficiently managed?
you have to solve the problem from the photos below and take the numbers and all the questions needs from the pictures .
CALUCLATE AND SOLVE FROM THE PICTURES BELOW. (1) Capital Budgeting Techniques: Assume an investment proposal and develop a cash flow projection for the same. Make the necessary assumptions and clearly state each one them, like the life of the investment project, initial investment and the net cash flows. Apply any two capital budgeting techniques to evaluate the proposal. Caluclate Capital Budgeting: Payback period = Cash outlay (investment) / Annual cash inflow. ARR= Average income/Average Investment NPV = PVB - PVC. PI = PV cash inflows/Initial cash outlay A, PI = NPV (benefits) / NPV (Costs). (2) Working Capital management: Discuss the areas of working capital management and identify the ways in which inventory, accounts receivable and cash could be efficiently managed. Walmart Inc. Consolidated Statements of Shareholders' Equity (3) 11 6 2.965 Accumulated Total Capital in Other Walmart Common Stock Escess of Retained Comprehensive Shareholders' No controlling Total (Amunt i million Shares Amount Par Value Earnings Income (Loss) Equity Interest Equity Balances as of February 1 2018 2,952 5 2955 26885 851075 (10,181) 77.8695 2.9535 30.102 Adoption of new accounting standards, niet of income 2361 tines (1,436) 925 934 Consolidated net income 6670 6,670 509 7.17 Other comprehensive income Kloss), net of income taxes 75 75 (113) Case dividends declared (5208 per share) (6,102) 16.102 (6,102) Purchase of Company stock (80) (8) (245) 1234) Cash dividend declared to Goncontrolling interest () Noncontrolling interest of acquired entity 4345 4 35 Other 562 546 554 Balances as of January 31. 2019 2878 25 80,785 (11.5.2) 72.16 7.133 79634 Adoption of new accounting standards on February 1 2019. met of income taxes (266) (266) (300) Consolidated net income 14881 3.20 15.301 Other comprehensive income (loss), net of income taxes (1.263) (126) 1.235) Cash dividends declared (52 12 per share) (6.018) (60450 (6.0) Purchase of Company stock (51) () (1991 (5,435) 15,639 57639 Cash dividend declared to noncontrolling interest 4075 Other 481 26 SOS 1944 Balances as of January 31. 2020 2.02 284 3.247 33,90 (1205) 14.66 1552 Consolidated net income 13,310 13510 13.706 Other compechensive income (los), nct of income taxes 1019 1039 (203 06 Cash dividends declared (52 16 per share) 16,116) 16116) Purchase of Company lock (20) 23 (2.559) 2.658) Cash dividends declared to controlling interest 0165) 365 Other 196 (15) Balance ws of January 31, 2031 2.2015 2805 3.6465 38,7635 0.925 0055 7501 LITT 1151-11 105 Se accompagne Walmart Inc. Consolidated Statements of Income Fiscal Year Ended January 31, 2020 2019 2021 $ S 333 233 3918 559151 $19.926 4,03 $2396 310,329 4,076 514,405 191603 420.115 216283 2230 108,291 20.368 38 301 107,147 21.952 mounts in mor, xvprper share data) Revenues Net sales Mernbership and other income Total revenues Costs and expenses: Cost of sales Operating, selling general and administrative expenses Operating income Interest: Debt Finance, capital case and financing obligations Interest income Interest, net Other (gains) and losses Income before income taxes Provision for income taxes Consolidated net income Consolidated net income attributable to no controlling interest Consolidated set income attributable to Walmart Net Income per common share Basie net income per common share attributable to Wilman Diluted net income per common share to butable 1 Walmart Weighted average common shares outstanding Basic Diluted 1.976 3.39 (120) 2.194 210) 0564 6.85 1.3.206 (196) UTO 260 1993 12 191 (189) (217) 2.410 2129 1,955) 8.368 20.116 184 4,915 4.251 15,201 7,17 (220 (500 ANA S70 1122 4.75 22 22 519 250 231 2847 2.999 2.45 Dividends declared per common share 216 5 2.12 $ Sed companying Walmart Inc. Consolidated Balance Sheets As of January 31, 2021 2020 sinis) ASSETS Current set Cad and cash equivalents Receivables et lavestories Prepaid expenses and other Total currentes 17:45 6316 40 0851 0.067 9465 62X4 H45 1622 61806 92.291 105:20 13.642 17:44 4DOS 4317 25983 31.073 23.59 16.567 3529 5236495 Property and equipment, net Operating lease right-of-use assets Finance care right-of-use acts, net Goodwill Other long-term assets Total sets LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt doe within one year Operating lease obligations due within one year Finance case obligations due within one year Totul current liabilities Long-term debe Long-term operating cusc obligation Long-term finance lease obligations Deferred income taxes and other 234 S 140 3166 20 SITES 1.466 291 925 575 46973 22296 250 5.362 TEM 311 77. 1,194 12.00 37 1410 03.14 16.170 4307 12961 Commitments and contingencie Equity: Common stock Capital in cices of pur value Reted carings Acumulated other comprehensive less Total Walmart shareholders equity Nance trolling inte 254 3.347 2390 (203 111.766 Toul 7331 2595 Total liabilities and equity Seping SS3 2009 5 Walmart Inc. Consolidated Statements of Cash Flows Fiscal Year Ended January 31, 2021 2020 2019 5 13.7065 73.201 5 7179 11,752 (8.39) 5:401 10,67% 3.576 *850 Milioni) Cash flows from operating activities Consolidated act income Adjustments to reconcile consolidated net income ta net cash provided by operating activities Depreciation and amortizato Net unrealized and realized (gains) and losses Les on disposal of business operations Asda pension conti Deretted income taxes Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions and despions Receivables, et Inventores Accounts payable Accrued liabilities Accrued income takes Net cash provided by operating activities 10.97 (1856) 15 (1.036) 320 7.981 1,911 1.321 (499 1,714 (1.080) 12.395) 6.966 4623 (136) 36,074 134 (300) (274) TRS 193 30 an 11 153 27255 (1024) 215 Cal news from investing activities Payments for property and equipment Proceeds from the disposal of property and bent Proceeds from the disposal of certain operations Payments for business squisitions, net of cash acquired Other investing activities Nef cashed investing activities (10,705) 321 33 156 36 (10) 100 (10.0713 10340 319 $75 (144567 401) 1340161 479 19,123 304 Cashows from inscing activities Net change in short-term borrowings Proceeds from cance of long-term det Repayments of long-term dele Dividend paid Purchase of Company stock Dividends paid to annog interest Other incing activities Nec in fing sctvities 15:30 (116) (2.625 HU (1.236) 16.117 5492 . (6) (5,711 1539 20 1142 153 1372 . 16.1093 (410) 190 Hlot of change rates Casqualent and restricted catch 10,121 1.79 70 Net increase in cuivalents and restricted cash Curvandres held for sale Cashchuivalent and restricted as a baginning of your Cocaillende 9,315 2018 775 Supplemental delare och flow informatica Income se pod Interest and 5 5 1616 2454 SIRE COMPARISON OF 3 YEAR CUMULATIVE TOTAL RETURN Anong Walmart Inc., the S&P 500 Index and S&P 500 Retailing Index (Fiscal Years Ended January 31) 250 5300 SI56 $100 so 2016 2017 2018 2019 2030 3031 Walle A S&P ---- *As 100 levels Frary 1, 2016 A Dhideeds Rested Fhealed away 31, 2021 S Fiscal Year Ended January 31, 2016 2012 2018 2019 2020 2021 Walmar Inc 100005 103 505 169 56 5 156 055 190.21 21733 S&P 500 Index 100.00 12004 151.74 14821 ISO 17 21148 S&P 500 Retailing in der 100.00 12000 17449 18629 219.46 3180 Issuer Repurchases of Equity Securities From time to time, we repurchase shares of our common stock under share repurchase programs authorized by the Company's Board of Directors All repurchases made during fiscal 2021 were made under the S20.0 billion share repurchase program approved in October 2017. of which authorvation for $3.0 billion of share repurchases remained as of January 31, 2021. On February 18, 2021, the Board of Directors approved a new $20.0 billion share repurchase program which, beginning February 22, 2021, replaced the previous share repurchase program. Any repurchased shares are constructively retired and returned to an unissued status CALUCLATE AND SOLVE FROM THE PICTURES BELOW. (1) Capital Budgeting Techniques: Assume an investment proposal and develop a cash flow projection for the same. Make the necessary assumptions and clearly state each one them, like the life of the investment project, initial investment and the net cash flows. Apply any two capital budgeting techniques to evaluate the proposal. Caluclate Capital Budgeting: Payback period = Cash outlay (investment) / Annual cash inflow. ARR= Average income/Average Investment NPV = PVB - PVC. PI = PV cash inflows/Initial cash outlay A, PI = NPV (benefits) / NPV (Costs). (2) Working Capital management: Discuss the areas of working capital management and identify the ways in which inventory, accounts receivable and cash could be efficiently managed. Walmart Inc. Consolidated Statements of Shareholders' Equity (3) 11 6 2.965 Accumulated Total Capital in Other Walmart Common Stock Escess of Retained Comprehensive Shareholders' No controlling Total (Amunt i million Shares Amount Par Value Earnings Income (Loss) Equity Interest Equity Balances as of February 1 2018 2,952 5 2955 26885 851075 (10,181) 77.8695 2.9535 30.102 Adoption of new accounting standards, niet of income 2361 tines (1,436) 925 934 Consolidated net income 6670 6,670 509 7.17 Other comprehensive income Kloss), net of income taxes 75 75 (113) Case dividends declared (5208 per share) (6,102) 16.102 (6,102) Purchase of Company stock (80) (8) (245) 1234) Cash dividend declared to Goncontrolling interest () Noncontrolling interest of acquired entity 4345 4 35 Other 562 546 554 Balances as of January 31. 2019 2878 25 80,785 (11.5.2) 72.16 7.133 79634 Adoption of new accounting standards on February 1 2019. met of income taxes (266) (266) (300) Consolidated net income 14881 3.20 15.301 Other comprehensive income (loss), net of income taxes (1.263) (126) 1.235) Cash dividends declared (52 12 per share) (6.018) (60450 (6.0) Purchase of Company stock (51) () (1991 (5,435) 15,639 57639 Cash dividend declared to noncontrolling interest 4075 Other 481 26 SOS 1944 Balances as of January 31. 2020 2.02 284 3.247 33,90 (1205) 14.66 1552 Consolidated net income 13,310 13510 13.706 Other compechensive income (los), nct of income taxes 1019 1039 (203 06 Cash dividends declared (52 16 per share) 16,116) 16116) Purchase of Company lock (20) 23 (2.559) 2.658) Cash dividends declared to controlling interest 0165) 365 Other 196 (15) Balance ws of January 31, 2031 2.2015 2805 3.6465 38,7635 0.925 0055 7501 LITT 1151-11 105 Se accompagne Walmart Inc. Consolidated Statements of Income Fiscal Year Ended January 31, 2020 2019 2021 $ S 333 233 3918 559151 $19.926 4,03 $2396 310,329 4,076 514,405 191603 420.115 216283 2230 108,291 20.368 38 301 107,147 21.952 mounts in mor, xvprper share data) Revenues Net sales Mernbership and other income Total revenues Costs and expenses: Cost of sales Operating, selling general and administrative expenses Operating income Interest: Debt Finance, capital case and financing obligations Interest income Interest, net Other (gains) and losses Income before income taxes Provision for income taxes Consolidated net income Consolidated net income attributable to no controlling interest Consolidated set income attributable to Walmart Net Income per common share Basie net income per common share attributable to Wilman Diluted net income per common share to butable 1 Walmart Weighted average common shares outstanding Basic Diluted 1.976 3.39 (120) 2.194 210) 0564 6.85 1.3.206 (196) UTO 260 1993 12 191 (189) (217) 2.410 2129 1,955) 8.368 20.116 184 4,915 4.251 15,201 7,17 (220 (500 ANA S70 1122 4.75 22 22 519 250 231 2847 2.999 2.45 Dividends declared per common share 216 5 2.12 $ Sed companying Walmart Inc. Consolidated Balance Sheets As of January 31, 2021 2020 sinis) ASSETS Current set Cad and cash equivalents Receivables et lavestories Prepaid expenses and other Total currentes 17:45 6316 40 0851 0.067 9465 62X4 H45 1622 61806 92.291 105:20 13.642 17:44 4DOS 4317 25983 31.073 23.59 16.567 3529 5236495 Property and equipment, net Operating lease right-of-use assets Finance care right-of-use acts, net Goodwill Other long-term assets Total sets LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt doe within one year Operating lease obligations due within one year Finance case obligations due within one year Totul current liabilities Long-term debe Long-term operating cusc obligation Long-term finance lease obligations Deferred income taxes and other 234 S 140 3166 20 SITES 1.466 291 925 575 46973 22296 250 5.362 TEM 311 77. 1,194 12.00 37 1410 03.14 16.170 4307 12961 Commitments and contingencie Equity: Common stock Capital in cices of pur value Reted carings Acumulated other comprehensive less Total Walmart shareholders equity Nance trolling inte 254 3.347 2390 (203 111.766 Toul 7331 2595 Total liabilities and equity Seping SS3 2009 5 Walmart Inc. Consolidated Statements of Cash Flows Fiscal Year Ended January 31, 2021 2020 2019 5 13.7065 73.201 5 7179 11,752 (8.39) 5:401 10,67% 3.576 *850 Milioni) Cash flows from operating activities Consolidated act income Adjustments to reconcile consolidated net income ta net cash provided by operating activities Depreciation and amortizato Net unrealized and realized (gains) and losses Les on disposal of business operations Asda pension conti Deretted income taxes Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions and despions Receivables, et Inventores Accounts payable Accrued liabilities Accrued income takes Net cash provided by operating activities 10.97 (1856) 15 (1.036) 320 7.981 1,911 1.321 (499 1,714 (1.080) 12.395) 6.966 4623 (136) 36,074 134 (300) (274) TRS 193 30 an 11 153 27255 (1024) 215 Cal news from investing activities Payments for property and equipment Proceeds from the disposal of property and bent Proceeds from the disposal of certain operations Payments for business squisitions, net of cash acquired Other investing activities Nef cashed investing activities (10,705) 321 33 156 36 (10) 100 (10.0713 10340 319 $75 (144567 401) 1340161 479 19,123 304 Cashows from inscing activities Net change in short-term borrowings Proceeds from cance of long-term det Repayments of long-term dele Dividend paid Purchase of Company stock Dividends paid to annog interest Other incing activities Nec in fing sctvities 15:30 (116) (2.625 HU (1.236) 16.117 5492 . (6) (5,711 1539 20 1142 153 1372 . 16.1093 (410) 190 Hlot of change rates Casqualent and restricted catch 10,121 1.79 70 Net increase in cuivalents and restricted cash Curvandres held for sale Cashchuivalent and restricted as a baginning of your Cocaillende 9,315 2018 775 Supplemental delare och flow informatica Income se pod Interest and 5 5 1616 2454 SIRE COMPARISON OF 3 YEAR CUMULATIVE TOTAL RETURN Anong Walmart Inc., the S&P 500 Index and S&P 500 Retailing Index (Fiscal Years Ended January 31) 250 5300 SI56 $100 so 2016 2017 2018 2019 2030 3031 Walle A S&P ---- *As 100 levels Frary 1, 2016 A Dhideeds Rested Fhealed away 31, 2021 S Fiscal Year Ended January 31, 2016 2012 2018 2019 2020 2021 Walmar Inc 100005 103 505 169 56 5 156 055 190.21 21733 S&P 500 Index 100.00 12004 151.74 14821 ISO 17 21148 S&P 500 Retailing in der 100.00 12000 17449 18629 219.46 3180 Issuer Repurchases of Equity Securities From time to time, we repurchase shares of our common stock under share repurchase programs authorized by the Company's Board of Directors All repurchases made during fiscal 2021 were made under the S20.0 billion share repurchase program approved in October 2017. of which authorvation for $3.0 billion of share repurchases remained as of January 31, 2021. On February 18, 2021, the Board of Directors approved a new $20.0 billion share repurchase program which, beginning February 22, 2021, replaced the previous share repurchase program. Any repurchased shares are constructively retired and returned to an unissued status Step 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