Question: table {mso-displayed-decimal-separator:.; mso-displayed-thousand-separator:,;} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;}
table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl76 {text-align:left;} .xl83 {font-weight:700; text-align:center; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; background:#D7DCE6; mso-pattern:black none;} .xl84 {font-weight:700; text-align:center; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; background:#D7DCE6; mso-pattern:black none; white-space:normal;} .xl85 {font-weight:700; text-align:center; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:#D7DCE6; mso-pattern:black none;} .xl86 {font-weight:700; text-align:center; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:#D7DCE6; mso-pattern:black none; white-space:normal;} .xl88 {font-weight:700; text-align:center; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7DCE6; mso-pattern:black none;} .xl89 {border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext;} .xl96 {border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl99 {border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none;} .xl101 {text-align:right;} .xl106 {border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl110 {font-weight:700;} .xl111 {text-align:left; white-space:normal;} .xl114 {color:#C00000; font-weight:700; text-align:left;} .xl122 {text-align:left; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext;} .xl185 {background:#B4C6E7; mso-pattern:black none;} .xl186 {border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:#B4C6E7; mso-pattern:black none;} .xl187 {border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:#B4C6E7; mso-pattern:black none;} .xl188 {border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#B4C6E7; mso-pattern:black none;}
| The following are excerpts from a company's balance sheet and income statement. Included also are important rates that apply to the company. | |||||||
| Randall-Hecho, Incorporated: Income Statement Projection | 0 (Year Just Ended) | 1 | 2 | 3 | 4 | 5 | |
| Profits | $24,630,542 | $25,000,000 | $28,125,000 | $30,234,375 | $32,501,953 | $34,939,600 | |
| Shares Outstanding | 2,500,000 | 2,400,000 | 2,400,000 | 2,300,000 | 2,300,000 | 2,200,000 | |
| Earnings Per Share | $9.85 | $10.42 | $11.72 | $13.15 | $14.13 | $15.88 | |
| Interest Payments (Pre-Tax) | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | |
| Randall-Hecho, Incorporated: Balance Sheet Projections | 0 | 1 | 2 | 3 | 4 | 5 | |
| Working Capital | $4,315,000 | $4,250,000 | $4,500,000 | $4,750,000 | $4,750,000 | $4,850,000 | |
| Capital Spending | $9,574,815 | $10,000,000 | $12,000,000 | $12,000,000 | $13,500,000 | $12,000,000 | |
| Depreciation | $8,745,329 | $8,500,000 | $8,600,000 | $8,750,000 | $8,500,000 | $8,250,000 | |
| Long-Term Debt | $10,416,667 | $10,416,667 | $10,416,667 | $10,416,667 | $10,416,667 | $10,416,667 | |
| Randall-Hecho, Incorporated: Rates | Rates | ||||||
| Interest Rate on Debt | 0.06 | ||||||
| Corporate Tax Rate | 0.200 | ||||||
| Sustainable Growth Rate | 0.010 | ||||||
| Weighted Average Cost of Capital | 0.095 | ||||||
| Required: | |||||||
| Using the information in the tables above, please make the necessary cash flow calculations. Then use these projections to determine the intrinsic value of the firm, the equity value, and the stock price per share. | |||||||
| Randall-Hecho, Incorporated: Cash Flow Calculations | 1 | 2 | 3 | 4 | 5 | Terminal Value | |
| Changes in Working Capital | |||||||
| After-Tax Interest Payments | |||||||
| Free Cash Flow to the Firm | |||||||
| Randall-Hecho, Incorporated: Firm and Equity Value | |||||||
| Present Value of Free Cash Flow to the Firm (Intrinsic Value) | |||||||
| Equity Value | |||||||
| Price Per Share |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
