Answered step by step
Verified Expert Solution
Question
1 Approved Answer
WACC is 3.98 Net Present Value and Discounted Payback Period Using the amount of capital expenditures incurred in 2021 from 2b above (which is considered
WACC is 3.98
Net Present Value and Discounted Payback Period Using the amount of capital expenditures incurred in 2021 from 2b above (which is considered to be an initial investment outflow), assume the company will generate operating cash inflows of $15 million the first year, $28 million the second year, 558 million the third year, $72 million the fourth year, $85 million the fifth year, and $55 million the sixth year. WACC IS 3.98 a.) What is the NPV using the company's WACC calculated in 2a above as the discount rate and what is the Internal Rate of Return? b.) Did the company make a good investment decision using the NPV criteria? c.) If the company had a discounted payback period policy of four years, did it make a sound investment decision (use the company's calculated WACC for the discount rate)? D E F For the Fiscal Period Ending B Reclassified 12 months Jul-30-2017 USD C Reclassified 12 months Jul-29-2018 USD Currency 12 months Jul-28-2019 USD 12 months Aug-02-2020 USO 12 months Aug-01-2021 USD Revenue Other Revenue Total Revenue 5,8370 6.615 0 8 1070 3.6910 8.47650 6,8370 6,615.0 8,1070 8,691.0 8.476.0 Cost of Goods Sold Gross Profit 33910 2.445.0 415440 2.461.0 5.390 2,711,0 5,6830 3,000.0 5.620 2.810.0 Solin Conral Admin Exp SRS DE Depreciation Amort Other Opening Expense Income) OOO 900 1.1770 910 10 1,5190 920 10 14.0 (2400) 1211 ) 1230 1060 (2000) 3 Other Operating Exp., Total 9430 1,057,0 1,594.0 1,7170 1,204.0 1 Operating income 1,503.0 1.404.0 1.1170 1,291.0 1,610.0 (1150) 3 rest Expense Interest and Invest Income Net Interest Exp (1830) 30 (1800) (360) 20 (354.0) 450) 40 (3410) (2100) 10 (2090) (115.0) (150) 1.0 (20) (10) 1,3730 1,225.0 7630 7 Currency Exchange Gans (Loss) 8 Other Non-Operating Inc (Esp) -9 EBT Excl. Unusual items 0 -1 Restructuring Charges 2 Merger & Related Restruct Charges Income Statement Balance Sheet 948.0 1.400.0 (480) (2020) (1070) (121) (690) (530) - Cash Flow A B D m Interest Expenso Interest and Invest income Net Interest Exp (1150) (1800) (2100) 30 (356.0) 20 (354.0) (3450) 40 (3410) to (115.0) (1800) (2000) Currency Exchange Gains (Loss) Other Non Operating Inc (Exp) EBT Excl. Unusual items (150) 10 (20) (10) 1,373.0 1,225.0 7630 94.0 1,400.0 (10) (2020) (070) (1210) (090) 630) (90) (100) (10) Restructuring Charges Norger & Rolated Restruct Charges Impartment of Goodwill Gain (LOS) On Sale Of Invest Gain (Loss) On Sale Of Assets Asset Widown Legal Setter Other Unusual loss EBT Incl. Unusual Items (490) (64) 99 (110 (540) 1720) (160) 1,316,0 130.0 625.0 7660 1.3360 Income Tax Expense Earnings from Cont. Ops. 3920 9240 1060 724,0 1510 4740 1740 5820 3200 1.0000 (370) (06:10) 1263 09 1 006 0 (50) Earnings of Descontinued Ops 5 Extraord Hem & Account Change Net Income to Company 8870 261.0 211.0 1,6280 1,0020 8 Minority Int in Earnings Net Income 337 251.0 2010 1.620.0 1.0020 ON 3 UN income Statement Balance Sheet Cash Flow e sheet on ol: D E F Currency ASSETS Cash And Equivalents Total Cash & ST Investments Jul 30 2017 USD C Reclassified Jul 29 2018 USD Jul 28 2019 USD Aug 02.2020 USD Aug 01 2021 USD 3190 319.0 490 49.0 310 31.0 8590 859.0 590 69.0 Accounts Recewable Other Recewables Total Receivables 5500 55.0 605.0 510.0 53.0 563.0 5250 49.0 574.0 530.0 450 575.0 544 0 510 595.0 Inventory Other Current Assets Total Current Assets 9020 740 1,900.0 8870 7970 2.296.0 8630 499.0 1,967.0 8710 800 2.385.0 9330 980 1,695.0 6,0430 (3.589.0) 2.454.0 5.2390 2770 2.466.0 5,2150 2.760,0) 2.455.0 5.5990 12.917 01 2.622.0 5.7240 (2.119.03 2,605,0 Gross Property, Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment Long-term Investments Goodwill Other Intangibles Deferred Tax Assets, LT Other Long-Term Assets Total Assets 69.0 2 1150 1118 0 360 340 7.126.0 920 3,8640 3 664 0 20 21450 14.529,0 770 40170 3.415 0 3,9860 3.3500 3,9810 3.2390 1.2170 13.148.0 290 1243720 2140 117340 LIABILITIES Accounts Payable Accrued Exp Short term Borrowings Curt Port of LT Debt Curt Port of Leases Curr Income Taxes Payable Other Current Liabilities Total Current Liabilities 666 0 4940 1,0360 22.0 10 200 1560 2.395.0 7050 4940 1 1350 3900 10700 5130 370 8140 5720 8500 500.0 210 150 613.0 3,385.0 10490 6030 2780 9210 700 240 1300 3,075.0 100 8600 3,5940 650 50 1240 1.814.0 7.991.0 Long-Term Debt Long Term Leases Pension & Other Post Retiro Benefits Der Tax Liability Non-Cum Other Non-Current Liabilities Income Statement 2.4920 70 508.0 4900 1890 347.0 5600 2640 71010 20 3890 9240 2350 4.990 0 1380 4620 9140 1740 5,0020 1880 2410 1.0510 1810 Balance Sheet Cash Flow A B Deferred Tax Assets, LT Other Long Term Assets Total Assets D E F 360 34.0 7.725.0 20 2 1450 1.2170 13.148.0 29.0 12,372.0 2140 11.734.0 6660 4940 10360 220 10 20.0 1560 2.395.0 7050 4940 1.1350 390 0 1,070 0 5130 370 8140 5720 8500 500.0 210 150 5130 3.385,0 10490 6030 2780 9210 700 240 1300 3,075.0 10,0 360.0 650 50 1240 1,814.0 3.594,0 7,9910 2.4920 70 5080 4900 1890 6,081,0 3470 9600 2640 13,156.0 71010 20 1890 9240 235.0 12.03.0 4,900 1000 4620 9140 1740 9,800 5.0020 1880 3410 10510 1840 8,580.0 LIABILITIES Accounts Payable Accrued Exp Short-term Borrowing Curt Port of LT Debt Curt Port of Leases 5. Curr Income Taxes Payable Other Current Liabilities Total Current Liabilities 3 Long Term Debt Long Term Leases 1 Pension & Other Post Retie Benefits 2. Det Tax Liability, Non Curr 3 Other Non Current Liabilities Total Liabilities 5 5 Common Stock 7 Additional Paid in Capital 3 Retained Earnings 9 Treasury Stock O Comprehensive Inc. and Other 1 Total Common Equity 2 3 Minority Interest 4 55 Total Equity 56 57 Total Liabilities And Equity 58 39 Supplemental Items 0 Total Shares Out on Balance Sheet Date 1 2 73 24 120 120 359.0 23050 (1.066.0) 1920) 1,637.0 120 3490 2,2240 (1.1030) (1180 1,364.0 120 3720 1.9930 (10760) (1980) 1,100.0 3940 3.1900 (1.0230) (100) 2.563.0 120 414.0 3.7420 (1021) SD 3.152.0 3.0 90 90 60 20 1.545.0 1.3730 111120 2.569.0 3.1540 7./26.0 14,529.0 12.148.0 12.12.0 1.744.0 3010 3010 3010 3020 1020 75 Income Statement Balance Sheet Cash Flow B For the Fiscal Period Ending Restated 12 months Jul-29-2018 USD Restated 12 months Jul-30-2017 USO Currency D Restated 12 months Jul-28-2019 USD E Restated 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD Net Income Depreciation & Amort Amort of Goodwill and intangibles Depreciation & Amort., Total 8870 1920 10 1930 261.0 259.0 200 279.0 211.0 3150 180 363.0 1,6280 285 0 430 328.0 1,0020 2750 420 3170 TO (Gain) Loss From Sale Of Assets (Gain Loss On Sale Of Invest Asset Writdown & Restructuring Costs Stock-Based Compensation Net Cash From Discontinued Ops Other Operating Activities Change in Ace Racob Change in Inventories Change in Ace Payable Change in Other Net Operating Assets Cash from Ops 19750 490 90 610 10.0 118.0 610 9140 (3000) 210 640 180 500 2850 (2000) 280 460 (480) (270) 1,236.0 320 10 470 580 3120 770 (110) MO 1250 (10) 1 2500 960 (540) 780 270 1,410,0 2010 (300 (200) 145.0 (30) 1.390 (910) (200) (77. (154) (280) 1,8350 (3380) (070) (0.7810) 100 (340) (470) 310 (299) (110) 2580 300 27500 20 1110 Capital Expenditure Cash Acquisitions 5 Diverses Invest in Marble & Equity Securt B Net (Inc) Doc Loans Originald/Sold 3 Other investing Activities 0 Cash from Investing 1 2 Short Term Debt Issued Income Statement Balance Sheet 000 (3680) (190) (7.1970) 5530 153.0 10 2.272.0 10 (15000) 2470 10 2220 5.000 516170 3200 Cash Flow . B D E 13380) Capital Expenditure Cash Acquisitions Divestitures Invest in Marketable & Equity Secuit Net (Ino y Doc in Loans Ongled Sold Omor investing Activities Cash from investing (4070) (0.781 ) 100 (3040) (470) 310 (299.01 (110 2,5480 300 02750 (20) 1110 0300 (360,0) (190 17.1970) 5510 1530 40 2,272.0 RO (1500 2200 Short Term Debt issued Long Tor Dettissued Total Debt issued Short Term Debt Repaid Long-Term Debt Repaid Total Debt Repaid 0,2470 2110 8,4580 (5.0020) (490.0) (8.492.0) 10,272 0 0,2240 16,4460 (9.1440) (30) (10,0070) 5,8390 (6.2960 (7020) (6.990.0) 5,017.0 1,0000 6,6170 10.9000) 12.2010) 10.177.93 3300 (580) (9210) (1.501,0) Issuance of Common Stock Repurchase of Common Stock 20 (4500) 230 (120) (1000) (80) 20 510) Common Dividends Paid Total Dividends Paid (43901 (4200) (420,0) (4260) (426.0) (4730) (423.0) (4250 (626) 5. Special Dividend Paid Other Financing Activities Cash from Financing 30 1903.0) (97.02 5.8070 (10) (1,591.0) (120) (2.087.0) (1 6090 e Foreign Exchange Rate Ad Net Change in Cash 110 129.01 (80) 12.0 (70) (1950) 20 7090 6800 insame Statement Balance Sheet Cash Flow 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