Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The first picture is the question. Stock Valuation: a.) Using year 2021 data, what was the common dividends paid per share? b.) Let's say you

The first picture is the question.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Stock Valuation: a.) Using year 2021 data, what was the common dividends paid per share? b.) Let's say you bought the stock at $52.61 at the beginning of 2021 and then sold it at $41.73 at the end of the year. What is the dividend yield (use your answer from la above), capital gain(loss), and total percentage return? c.) If the dividend per share calculated in la above is expected to grow by 3.05% for the next three years, and then grow by 2.25% in perpetuity afterwards, and the expected return on the stock is 8.25%, what is the value of the stock today? IF B C D Incomeatment Reclassified 12 months JU-30-2017 USD Recified 12 months 1-29-2018 USD 12 months JU-28-2019 USO 12 months Aug-02-2020 USO 12 months Aug-01-2021 USO 5,8370 66150 1070 36610 0.4750 63370 5,6150 4,107.0 8,6910 1,4780 w the Focal Period Ending 14 15 Cummy 16 17. He 10 OR 10 You are 20 21 odsad 22 Grous Prote 23 24 nap 25 RSD 26 Deproton hot Cthe operates 30 2 4,1540 24610 501900 2.7110 5.6830 30030 2.8140 11770 10000 30 1.3830 30 1.6790 920 1.380 340 2003 2110 1230 Todo Om Operating Ep. Total 450 16. 11 17170 29 20 12010 Operating income 1,5030 14040 1,1170 1 2010 6100 (11503 E. 34 and income Melhores Exp (1030 30 (1800) 050.00 20 73540 345 40 (31.03 2100 TO 200 (1156 Income Statement Balance Sheet Cash Flow G Feedback to Micro typer towards O - 0 c B (1950) E F D (3540) G H A 35 Nainers Exp 30 37 Cucum (L) ingine ET E Unus (10070) (3410) (2000) (15.09 10 00) (103 1,730 1.2260 7650 MO 1.4000 (0) 02000) HOYO (1210 (000) (30) 21 Charge Bed at hon food 44 45 min of Aus 46 st Window 47 legte 100) (100) (0) (400) (6409 (5401 (220) (100) 40 ET in Unustas 13780 2300 6250 7680 15300 52 Earnings from Contos 300 320 1060 7240 1510 4740 1740 SZO 1280 10000 Dedos 5m Chero But home to Company (11 (1) 2009 10360 10 STO 2010 2170 TO 1,00270 Income Statement Balance Sheet Cash Flow Inten B D TY H 47 o Settlements 48 Other Unlos 49 EBT Inc. Unusual TU (220) wn 1.3160 83070 525.0 7660 1,350.0 3920 51 Income Tax Expense Sz Earnings from Cont. Opis 5 5 of Oecond Ops 55 ad fom count Change 56 Net Income to company 1060 7240 1510 4740 1740 592.0 3280 1.008.0 70 14630) (203.03 10360 (60) 1870 2010 2110 1.62870 1700220 8870 211.0 1620 39 GO 61 09 53 19020 > | 68 69 70 Income Statement Balance Sheet Cash Flow D G JU-30-2017 USO Reclassified Jul-29-2018 USD Jul-28-2019 USD Aug-02-2020 USD Aug-01-2021 USO 3190 319,0 490 49.0 31.0 31.0 8590 859.0 690 69,0 5500 550 6050 5100 5070 563.0 12 13 Balance Sheet Balance Sheet as of 14 15 Currency 16 ASSETS 17 Cash And Events 16 Total Cash & ST Investments 19 20 Accounts Recente 21 Other Receivables 22 Total Receivables 22 24urstory 25 Other Curton Asets 26 Total Current Assets 27 28 Clows Property and gament 29 Accumulated Depreciation 30 Nel Property. Plant & Equipment 31 Longdom Investments 33 Goodwin Chirag 35 Dodar Assets 5250 480 574,0 5100 450 575.0 5440 510 5950 0020 740 1.9000 8870 7970 22360 3630 4990 1.667.0 SONRA 8710 800 2385.0 83370 080 196850 0,0430 (3,5890) 2,454.0 5.2390 12.77303 2,466.0 5,2150 (27000) 2456.0 55190 (2.9170 276220 5,72440 13.11.09 2.605.0 090 2.1150 1.1180 380 520 38660 3.6640 20 77.0 4.0170 3.4150 3.906.0 3.3500 3.5810 3.2.0.0 Income Statement Balance Sheet Cash Flow - Worlook Statistics Grreland B D 3.8640 3.6040 20 21450 40170 3,4150 E 30000 3,3500 2 1150 1 1180 360 340 200 F 3381 32300 1.2170 13.148,0 29.0 123O 2140 6660 4040 33 Goodwill 34 Other Intangibles 35 Deferred lax Asses.LT 36 Othew Long-Term Assets 37 Total Asset 38 39 LIABILITIES 40 Accounts Payable 41 AdEx 42 Short term Borowings Con Port of LT Debt 44 Cu Port of Los 45 CT Income Taxes Payable 46 Other Current Liais 47 Total Current Liabilities 48 49 Long-Term Det 50 Long Term Cose 51 Person Omer Post Retiro Benatts 52 De Tax bit, Non Curr 53 Other Non Current Lines 54 Total Liabilities 55 56 Camo Stock 7050 4910 1.1350 3000 10700 5730 37,0 10360 220 10 200 1500 8140 5720 8500 5000 210 150 6130 3,3850 10490 6030 2780 9210 700 240 1300 370750 10.0 3000 375640 050 50 1240 1,8140 7,9010 24020 70 5080 490.0 TRDO 6.0810 3470 9000 2640 13.156.0 71010 20 3890 9240 235.0 12.0360 49000 1880 0320 0140 1720 9.800.0 5.000 108.0 3410 1,0510 1840 8.580.0 120 1590 120 Von 120 120 . 120 14 Income Statement Balance Sheet Cash Flow B D E F G 120 120 3500 2,3850 (1.000.0 (53.0) 349.0 22240 (1,1030) (118.00 1.3646 120 3720 1,890.0 (1.0760) (1980) 1,100.0 120 3940 3.1900 (1,023.0) (100) 25630 120 4140 3.7420 1102101 50 376270 BO 90 00 55 56 Common Stock 57 Additional Pardin Capital 58 Remned Eamungs 59 Tresory Stock 60 Corse and other 61 Total Common Equity f2 63 Monty Inter 64 65 Total Equity 66 Total Labs And Equity 58 59 Supplementos 70 Tot stures on Bace Shoot Dan 71 72 Market Price of Sex 60 20 1,645.0 13730 121120 2.500 21540 7.726,0 14 5290 13.148.0 1272.0 11,7340 3010 3010 3010 3020 $40 20 $4500 $5201 5417 74 75 78 5 Income Statement Balance Sheet Cash Flow Model D Cash Flow For the Fiscal Period Ending - 5 Currency Restated 12 months Jul-30-2017 USD Restated 12 months Jul-29-2018 USD Rostated 12 months Jul-28-2019 USO Restated 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD 8870 1920 10 1930 261.0 2590 200 279.0 211.0 3150 40 36370 1.002.0 2750 1,628.0 2050 430 3280 3170 >> 7 Net Income 8 Depreciation & Amort 9 Arnort of Goodwill and Intangibles Depreciation & Amort. Total 21 22 ans Loss From Sale Of Assets e (Coin Loss On Sale Of Invest 24 Assel Witdown & Restructuring Costs Stock Based Compensation 26 No Cash From Discontinued Ops 27 Other Operating Activities 28 Change Ac Receivable 29 Change in inventores 30 Change in Acc Payablo 31 Change in the Net Operating Assos 32 Cash from Ops 39 34 Expenditure Cash Acres (0750) 400 90 010 210 640 180 600 2850 (2000) 28.0 460 (480) (270) 1.236.0 100 1160 610 9140 (3080) 560 1640) 780 27.0 1,410.0 320 10 470 580 3120 770 (110) 300 1250 (10) 1.250.0 2040 (300) 20.01 1450 30 1.3900 1910) (200) (70) (1610) 280 1.0350 13380) 14070) 171 3840) 17 209.09 cm Q750) 2 m Income Statement Balance Sheet Cash Flow Work Statistics GE General B (3380) E A 34 Capital Expenditure 35 Cash Acquisitions 36 Ovestures 37 Invest in Marketable & Equity Securt 38 Net Inc) Dec in Loons Onginated Sold 39. Other investing Activities 40 Cash from investing c (407) 16.7810) 100 D 134 (470) 310 (150) 25480 300 F (2380 20 11 130.0) (3680) (10) (70) 5530 15370 40 158.0) 50.00 200 82470 2910 6,400 8.000 44000 TG740270) 10 2220 62240 16,446.0 0.944 630 (1070070) 5.30 (6,2060 (700.0 CO) 56170 10000 170 169000) 208 (9.177.01 3800 112101 1500) 42 Short Term Debitissued 43 Long Term Debited Total Debt issued 45 Short Term Debt Repaid 46 Long Term Debt Repad 47 Total Debt Repaid 48 49 sono of Common Stock 50 Repurchase of common stock 51 52 Common Dividends Paid 53 Total Dividends Paid 54 Spoche Doond Paid Other Fahong Acties Cash from Financing 20 (472.00 230 20 11000) VO (4200) (420,0) (2003 (4260) 40 (463) HOOD 14.20.00 (480) 30 (08.0 01.0) 5.807.0 110) (1.501.0) (10) 286703 Income Statement Balance Sheet Cash Flow f A B C D E Common Dividends Paid Total Dividends Paid (4200) (4200) (4260) (4260) (4230) (42309 11200) (4260) (300 140 Special Ondand Paid Other Financing Activities Cash from Financing 30 08.09 (070) 6.8070 100 (1.6910) (120 (2.9870) (1,800.00 9 Foreign Exchange Rated 0 Net Change in Cash 1 2 110 2901 0000 150 17.01 (1950) (10) 0000 55 56 68 69 70 71 172 73 74 75 Income Statement Balance Sheet Cash Flow ORDU Stock Valuation: a.) Using year 2021 data, what was the common dividends paid per share? b.) Let's say you bought the stock at $52.61 at the beginning of 2021 and then sold it at $41.73 at the end of the year. What is the dividend yield (use your answer from la above), capital gain(loss), and total percentage return? c.) If the dividend per share calculated in la above is expected to grow by 3.05% for the next three years, and then grow by 2.25% in perpetuity afterwards, and the expected return on the stock is 8.25%, what is the value of the stock today? IF B C D Incomeatment Reclassified 12 months JU-30-2017 USD Recified 12 months 1-29-2018 USD 12 months JU-28-2019 USO 12 months Aug-02-2020 USO 12 months Aug-01-2021 USO 5,8370 66150 1070 36610 0.4750 63370 5,6150 4,107.0 8,6910 1,4780 w the Focal Period Ending 14 15 Cummy 16 17. He 10 OR 10 You are 20 21 odsad 22 Grous Prote 23 24 nap 25 RSD 26 Deproton hot Cthe operates 30 2 4,1540 24610 501900 2.7110 5.6830 30030 2.8140 11770 10000 30 1.3830 30 1.6790 920 1.380 340 2003 2110 1230 Todo Om Operating Ep. Total 450 16. 11 17170 29 20 12010 Operating income 1,5030 14040 1,1170 1 2010 6100 (11503 E. 34 and income Melhores Exp (1030 30 (1800) 050.00 20 73540 345 40 (31.03 2100 TO 200 (1156 Income Statement Balance Sheet Cash Flow G Feedback to Micro typer towards O - 0 c B (1950) E F D (3540) G H A 35 Nainers Exp 30 37 Cucum (L) ingine ET E Unus (10070) (3410) (2000) (15.09 10 00) (103 1,730 1.2260 7650 MO 1.4000 (0) 02000) HOYO (1210 (000) (30) 21 Charge Bed at hon food 44 45 min of Aus 46 st Window 47 legte 100) (100) (0) (400) (6409 (5401 (220) (100) 40 ET in Unustas 13780 2300 6250 7680 15300 52 Earnings from Contos 300 320 1060 7240 1510 4740 1740 SZO 1280 10000 Dedos 5m Chero But home to Company (11 (1) 2009 10360 10 STO 2010 2170 TO 1,00270 Income Statement Balance Sheet Cash Flow Inten B D TY H 47 o Settlements 48 Other Unlos 49 EBT Inc. Unusual TU (220) wn 1.3160 83070 525.0 7660 1,350.0 3920 51 Income Tax Expense Sz Earnings from Cont. Opis 5 5 of Oecond Ops 55 ad fom count Change 56 Net Income to company 1060 7240 1510 4740 1740 592.0 3280 1.008.0 70 14630) (203.03 10360 (60) 1870 2010 2110 1.62870 1700220 8870 211.0 1620 39 GO 61 09 53 19020 > | 68 69 70 Income Statement Balance Sheet Cash Flow D G JU-30-2017 USO Reclassified Jul-29-2018 USD Jul-28-2019 USD Aug-02-2020 USD Aug-01-2021 USO 3190 319,0 490 49.0 31.0 31.0 8590 859.0 690 69,0 5500 550 6050 5100 5070 563.0 12 13 Balance Sheet Balance Sheet as of 14 15 Currency 16 ASSETS 17 Cash And Events 16 Total Cash & ST Investments 19 20 Accounts Recente 21 Other Receivables 22 Total Receivables 22 24urstory 25 Other Curton Asets 26 Total Current Assets 27 28 Clows Property and gament 29 Accumulated Depreciation 30 Nel Property. Plant & Equipment 31 Longdom Investments 33 Goodwin Chirag 35 Dodar Assets 5250 480 574,0 5100 450 575.0 5440 510 5950 0020 740 1.9000 8870 7970 22360 3630 4990 1.667.0 SONRA 8710 800 2385.0 83370 080 196850 0,0430 (3,5890) 2,454.0 5.2390 12.77303 2,466.0 5,2150 (27000) 2456.0 55190 (2.9170 276220 5,72440 13.11.09 2.605.0 090 2.1150 1.1180 380 520 38660 3.6640 20 77.0 4.0170 3.4150 3.906.0 3.3500 3.5810 3.2.0.0 Income Statement Balance Sheet Cash Flow - Worlook Statistics Grreland B D 3.8640 3.6040 20 21450 40170 3,4150 E 30000 3,3500 2 1150 1 1180 360 340 200 F 3381 32300 1.2170 13.148,0 29.0 123O 2140 6660 4040 33 Goodwill 34 Other Intangibles 35 Deferred lax Asses.LT 36 Othew Long-Term Assets 37 Total Asset 38 39 LIABILITIES 40 Accounts Payable 41 AdEx 42 Short term Borowings Con Port of LT Debt 44 Cu Port of Los 45 CT Income Taxes Payable 46 Other Current Liais 47 Total Current Liabilities 48 49 Long-Term Det 50 Long Term Cose 51 Person Omer Post Retiro Benatts 52 De Tax bit, Non Curr 53 Other Non Current Lines 54 Total Liabilities 55 56 Camo Stock 7050 4910 1.1350 3000 10700 5730 37,0 10360 220 10 200 1500 8140 5720 8500 5000 210 150 6130 3,3850 10490 6030 2780 9210 700 240 1300 370750 10.0 3000 375640 050 50 1240 1,8140 7,9010 24020 70 5080 490.0 TRDO 6.0810 3470 9000 2640 13.156.0 71010 20 3890 9240 235.0 12.0360 49000 1880 0320 0140 1720 9.800.0 5.000 108.0 3410 1,0510 1840 8.580.0 120 1590 120 Von 120 120 . 120 14 Income Statement Balance Sheet Cash Flow B D E F G 120 120 3500 2,3850 (1.000.0 (53.0) 349.0 22240 (1,1030) (118.00 1.3646 120 3720 1,890.0 (1.0760) (1980) 1,100.0 120 3940 3.1900 (1,023.0) (100) 25630 120 4140 3.7420 1102101 50 376270 BO 90 00 55 56 Common Stock 57 Additional Pardin Capital 58 Remned Eamungs 59 Tresory Stock 60 Corse and other 61 Total Common Equity f2 63 Monty Inter 64 65 Total Equity 66 Total Labs And Equity 58 59 Supplementos 70 Tot stures on Bace Shoot Dan 71 72 Market Price of Sex 60 20 1,645.0 13730 121120 2.500 21540 7.726,0 14 5290 13.148.0 1272.0 11,7340 3010 3010 3010 3020 $40 20 $4500 $5201 5417 74 75 78 5 Income Statement Balance Sheet Cash Flow Model D Cash Flow For the Fiscal Period Ending - 5 Currency Restated 12 months Jul-30-2017 USD Restated 12 months Jul-29-2018 USD Rostated 12 months Jul-28-2019 USO Restated 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD 8870 1920 10 1930 261.0 2590 200 279.0 211.0 3150 40 36370 1.002.0 2750 1,628.0 2050 430 3280 3170 >> 7 Net Income 8 Depreciation & Amort 9 Arnort of Goodwill and Intangibles Depreciation & Amort. Total 21 22 ans Loss From Sale Of Assets e (Coin Loss On Sale Of Invest 24 Assel Witdown & Restructuring Costs Stock Based Compensation 26 No Cash From Discontinued Ops 27 Other Operating Activities 28 Change Ac Receivable 29 Change in inventores 30 Change in Acc Payablo 31 Change in the Net Operating Assos 32 Cash from Ops 39 34 Expenditure Cash Acres (0750) 400 90 010 210 640 180 600 2850 (2000) 28.0 460 (480) (270) 1.236.0 100 1160 610 9140 (3080) 560 1640) 780 27.0 1,410.0 320 10 470 580 3120 770 (110) 300 1250 (10) 1.250.0 2040 (300) 20.01 1450 30 1.3900 1910) (200) (70) (1610) 280 1.0350 13380) 14070) 171 3840) 17 209.09 cm Q750) 2 m Income Statement Balance Sheet Cash Flow Work Statistics GE General B (3380) E A 34 Capital Expenditure 35 Cash Acquisitions 36 Ovestures 37 Invest in Marketable & Equity Securt 38 Net Inc) Dec in Loons Onginated Sold 39. Other investing Activities 40 Cash from investing c (407) 16.7810) 100 D 134 (470) 310 (150) 25480 300 F (2380 20 11 130.0) (3680) (10) (70) 5530 15370 40 158.0) 50.00 200 82470 2910 6,400 8.000 44000 TG740270) 10 2220 62240 16,446.0 0.944 630 (1070070) 5.30 (6,2060 (700.0 CO) 56170 10000 170 169000) 208 (9.177.01 3800 112101 1500) 42 Short Term Debitissued 43 Long Term Debited Total Debt issued 45 Short Term Debt Repaid 46 Long Term Debt Repad 47 Total Debt Repaid 48 49 sono of Common Stock 50 Repurchase of common stock 51 52 Common Dividends Paid 53 Total Dividends Paid 54 Spoche Doond Paid Other Fahong Acties Cash from Financing 20 (472.00 230 20 11000) VO (4200) (420,0) (2003 (4260) 40 (463) HOOD 14.20.00 (480) 30 (08.0 01.0) 5.807.0 110) (1.501.0) (10) 286703 Income Statement Balance Sheet Cash Flow f A B C D E Common Dividends Paid Total Dividends Paid (4200) (4200) (4260) (4260) (4230) (42309 11200) (4260) (300 140 Special Ondand Paid Other Financing Activities Cash from Financing 30 08.09 (070) 6.8070 100 (1.6910) (120 (2.9870) (1,800.00 9 Foreign Exchange Rated 0 Net Change in Cash 1 2 110 2901 0000 150 17.01 (1950) (10) 0000 55 56 68 69 70 71 172 73 74 75 Income Statement Balance Sheet Cash Flow ORDU

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

The Infographic Guide To Personal Finance

Authors: Michele Cagan CPA, Elisabeth Lariviere

1st Edition

1507204663, 978-1507204665

More Books

Students also viewed these Finance questions