If you could answer a and b with work shown that would be great.
Case description: Terence Breezeway, the CEO of Prairie Home Stores, wondered what retirement would be like. It was almost 20 years to the day since his uncle Jacob Breezeway, Prairie Home's founder, had asked him to take responsibility for managing the company. Now it was time to spend more time riding and fishing on the old Lazy Beta Ranch. Under Mr. Breezeway's leadership Prairie Home had grown slowly but steadily and was solidly profitable. (Table 7.6 shows earnings, dividends, and book asset values for the last 5 years.) Most of the company's supermarkets had been modernized and its brand name was well known. Toble 76 Financial data for Prairie Home Stores, 2019-2023 (figures in millions) w 2019 2020 2021 2022 2023 562.7 $66.1 $69.0 $73.9 $76,5 9.7 9.3 11.8 11.0 112 Book value, start of year Earnings Dividends Retained earnings Book value, end of year 6.3 6.6 6.9 74 7.7 3.4 2.9 4.9 26 3.5 66.1 69,0 73.9 76.5 800 Notes Prane Home Stores has 400,000 common the 2. The completo pay cathens equal to 10 of start of your book Mr. Breezeway was proud of this record, although he wished that Prairie Home could have grown more rapidly. He had passed up several opportunities to build new stores in adjacent counties. Prairie Home was still just a family company. Its common stock was distributed among 15 grandchildren and nephews of Jacob Breezeway, most of whom had come to depend on generous regular dividends. The commitment to high dividend payout had reduced the earnings available for reinvestment and thereby constrained growth. The company traditionally paid out cash dividends equal to 10% of start-of-period book value see Table 7.6.) Mr. Breezeway believed the time had come to take Prairie Home public. Once its shares were traded in the public market, the Breezeway descendants who needed (or just wanted) more cash a to spend could sell off part of their holdings. Others with more interest in the business could hold on to their shares and be rewarded by higher future earnings and stock prices. But if Prairie Home did go public, what should its shares sell for? Mr. Breezeway worried that shares would be sold, cither by Breezeway family members or by the company itself, at too low a price. One relative was about to accept a private offer for $200, the current book value per share, but Mr. Breezeway had intervened and convinced the would-be seller to wait. Prairie Home's value depended not just on its current book value or earnings but on its future prospects, which were good. One financial projection (shown in the top panel of Table 7.7) called for growth in earnings of over 100% by 2030. Unfortunately, this plan would require reinvestment of all of Prairie Home's earnings from 2024 to 2027. After that the company could resume its normal dividend payout and growth rate. Mr. Breezeway believed this plan was feasible. Tobie 77 Financial projections for Prairie Home Stores 2024-2029 (figures in milions) 2024 2025 2026 2027 2028 2029 Rapid-Growth Scenario $105.8 $1217 $50 $92.0 $1399 $1469 12 13.8 159 183 21.0 220 Book value, start of year Earnings Dividends Retained earnings Book value, end of year 0 0 0 O 140 147 12 1.S 159 13 70 74 92 105. 1469 1503 1217 1399 Constant Growth Senario $80 $ 840 5882 $926 5972 5102 12 126 132 139 106 150 Book value, start of year Earnings Dividends Retained earnings Book value, end of year $ 8.4 SS 9.3 9.7 10.2 4 4.4 5.1 54 88.2 926 972 102.1 1022 1. Both panels assume earrings equal to 15 of start of yearbook This probably rates constart 2. The top panel assumes al earnings are beinvested from 2004-2007 2028 and later years to the learnings upelidostas cuenta de reinvested 3. The bottom panel assume two thirds of eemings we paid out as dividends in eye 4 Columns may not add up because of rounding He was determined to step aside for the next generation of top management. But before retiring, he had to decide whether to recommend that Prairie Home Stores "go public"--and before that decision he had to know what the company was worth. The next morning he rode thoughtfully to work. He left his horse at the south corral and ambled down the dusty street to Mike Gordon's Saloon, where Francine Firewater, the company's CFO, was having her usual steak-and-beans breakfast. He asked Ms. Firewater to prepare a formal report to Prairie Home stockholders, valuing the company on the assumption that its shares were publicly traded. Ms. Firewater asked two questions immediately. First, what should she assume about investment and growth? Mr. Breezeway suggested two valuations, one assuming more rapid expansion (as in the top panel of Table 7.7) and another just projecting past growth (as in the bottom panel of Table 7.7). Second, what rate of return should she use? Mr. Breezeway said that 15%, Prairie Home's usual return on book equity, sounded right to him, but he referred her to an article in the Journal of Finance indicating that investors in rural supermarket chains, with risks similar to Prairie Home Stores, expected to earn about 11% on average. Assignment: This case is taking place in the beginning of 2024. Do valuation of the company as of that time, using the dividend discount model, separately based on each of the two scenarios in Table 7.7. Starting after 2029, you can assume constant perpetual growth of dividends of 3% per year for both scenarios. a) Which discount rate is "theoretically" the correct one (15% or 11%)? Why? b) How does your answer regarding the value per share differ depending on the rapid- growth vs. constant-growth scenario? Which scenario should the company choose to maximize its share price (the present value of all future dividends)? c) How does the valuation depend on the discount rate? For the rapid-growth scenario, graph the relationship between value per share (y-axis) and the discount rate (x-axis) in the range between 9% and 16%, holding the growth rate constant at 3%. d) How does the valuation depend on the long-run growth rate after 2029? For the rapid- growth scenario, graph the relationship between value per share (y-axis) and the growth rate (x-axis) in a range between 0% and 6%, holding the discount rate constant at the rate you chose from part (a). Case description: Terence Breezeway, the CEO of Prairie Home Stores, wondered what retirement would be like. It was almost 20 years to the day since his uncle Jacob Breezeway, Prairie Home's founder, had asked him to take responsibility for managing the company. Now it was time to spend more time riding and fishing on the old Lazy Beta Ranch. Under Mr. Breezeway's leadership Prairie Home had grown slowly but steadily and was solidly profitable. (Table 7.6 shows earnings, dividends, and book asset values for the last 5 years.) Most of the company's supermarkets had been modernized and its brand name was well known. Toble 76 Financial data for Prairie Home Stores, 2019-2023 (figures in millions) w 2019 2020 2021 2022 2023 562.7 $66.1 $69.0 $73.9 $76,5 9.7 9.3 11.8 11.0 112 Book value, start of year Earnings Dividends Retained earnings Book value, end of year 6.3 6.6 6.9 74 7.7 3.4 2.9 4.9 26 3.5 66.1 69,0 73.9 76.5 800 Notes Prane Home Stores has 400,000 common the 2. The completo pay cathens equal to 10 of start of your book Mr. Breezeway was proud of this record, although he wished that Prairie Home could have grown more rapidly. He had passed up several opportunities to build new stores in adjacent counties. Prairie Home was still just a family company. Its common stock was distributed among 15 grandchildren and nephews of Jacob Breezeway, most of whom had come to depend on generous regular dividends. The commitment to high dividend payout had reduced the earnings available for reinvestment and thereby constrained growth. The company traditionally paid out cash dividends equal to 10% of start-of-period book value see Table 7.6.) Mr. Breezeway believed the time had come to take Prairie Home public. Once its shares were traded in the public market, the Breezeway descendants who needed (or just wanted) more cash a to spend could sell off part of their holdings. Others with more interest in the business could hold on to their shares and be rewarded by higher future earnings and stock prices. But if Prairie Home did go public, what should its shares sell for? Mr. Breezeway worried that shares would be sold, cither by Breezeway family members or by the company itself, at too low a price. One relative was about to accept a private offer for $200, the current book value per share, but Mr. Breezeway had intervened and convinced the would-be seller to wait. Prairie Home's value depended not just on its current book value or earnings but on its future prospects, which were good. One financial projection (shown in the top panel of Table 7.7) called for growth in earnings of over 100% by 2030. Unfortunately, this plan would require reinvestment of all of Prairie Home's earnings from 2024 to 2027. After that the company could resume its normal dividend payout and growth rate. Mr. Breezeway believed this plan was feasible. Tobie 77 Financial projections for Prairie Home Stores 2024-2029 (figures in milions) 2024 2025 2026 2027 2028 2029 Rapid-Growth Scenario $105.8 $1217 $50 $92.0 $1399 $1469 12 13.8 159 183 21.0 220 Book value, start of year Earnings Dividends Retained earnings Book value, end of year 0 0 0 O 140 147 12 1.S 159 13 70 74 92 105. 1469 1503 1217 1399 Constant Growth Senario $80 $ 840 5882 $926 5972 5102 12 126 132 139 106 150 Book value, start of year Earnings Dividends Retained earnings Book value, end of year $ 8.4 SS 9.3 9.7 10.2 4 4.4 5.1 54 88.2 926 972 102.1 1022 1. Both panels assume earrings equal to 15 of start of yearbook This probably rates constart 2. The top panel assumes al earnings are beinvested from 2004-2007 2028 and later years to the learnings upelidostas cuenta de reinvested 3. The bottom panel assume two thirds of eemings we paid out as dividends in eye 4 Columns may not add up because of rounding He was determined to step aside for the next generation of top management. But before retiring, he had to decide whether to recommend that Prairie Home Stores "go public"--and before that decision he had to know what the company was worth. The next morning he rode thoughtfully to work. He left his horse at the south corral and ambled down the dusty street to Mike Gordon's Saloon, where Francine Firewater, the company's CFO, was having her usual steak-and-beans breakfast. He asked Ms. Firewater to prepare a formal report to Prairie Home stockholders, valuing the company on the assumption that its shares were publicly traded. Ms. Firewater asked two questions immediately. First, what should she assume about investment and growth? Mr. Breezeway suggested two valuations, one assuming more rapid expansion (as in the top panel of Table 7.7) and another just projecting past growth (as in the bottom panel of Table 7.7). Second, what rate of return should she use? Mr. Breezeway said that 15%, Prairie Home's usual return on book equity, sounded right to him, but he referred her to an article in the Journal of Finance indicating that investors in rural supermarket chains, with risks similar to Prairie Home Stores, expected to earn about 11% on average. Assignment: This case is taking place in the beginning of 2024. Do valuation of the company as of that time, using the dividend discount model, separately based on each of the two scenarios in Table 7.7. Starting after 2029, you can assume constant perpetual growth of dividends of 3% per year for both scenarios. a) Which discount rate is "theoretically" the correct one (15% or 11%)? Why? b) How does your answer regarding the value per share differ depending on the rapid- growth vs. constant-growth scenario? Which scenario should the company choose to maximize its share price (the present value of all future dividends)? c) How does the valuation depend on the discount rate? For the rapid-growth scenario, graph the relationship between value per share (y-axis) and the discount rate (x-axis) in the range between 9% and 16%, holding the growth rate constant at 3%. d) How does the valuation depend on the long-run growth rate after 2029? For the rapid- growth scenario, graph the relationship between value per share (y-axis) and the growth rate (x-axis) in a range between 0% and 6%, holding the discount rate constant at the rate you chose from part (a)
