Question 2. Financial Modeling (2.1) CF Valuation Model The JMR Company is a family business that currently uses no debt in its capital structure. The owner-managers agreed on a plan to issue a large amount of debt to expand the company's operations. Their plan is to finance the entire transaction by borrowing $15 million of bank loan at an interest rate of 9%, and the debt repayment schedule is fixed. The company also plans on a recapitalization to reach a target capital structure of 20% debt at the end of Year 3. The company's chief financial officer prepared a set of financial forecasts that reflects this plan. The income statement, balance sheet, and cash flow statement forecasts are included in the tables as shown on the next page. The forecasts assume the company will issue the debt at the end of year 0, which is reflected in the balance sheet for that year. The forecasts do not, however, reflect the debt recapitalization at the end of Year 3. The company is expected to enter the constant growth stage starting Year 4 and grow at the long-run inflation rate of 2%. The debt cost of capital will not change while the company is paying off its debt, but it will decrease to 7% when they recapitalize the company to 20% debt at the end of Year 3. Its cost of equity is 15% and the unlevered cost of capital is 10%. The company's income tax rate for all revenues and expenses is 40%. Apply the appropriate valuation model to estimate the intrinsic value of JMR and intrinsic value of equity in year 0. Forecast Actual Year-t Actual Year 0 Forecast Year 2 Forecast Year 3 Forecast Year 4 Year 1 ($ in thousands) $ 7,968 -3.187 -1,000 $ 8,765 -3,506 -1.273 $14,462 -5.785 -2.220 $14.823 -5.929 Income Statement Revenue... Operating expenses Depreciation expense. Earrings before interest and taxes. Interest expense..... Income before taxes. income tax expense $13,147 -5.259 -1.875 $ 6,014 -1,500 S 3,787 0 $ 3,986 0 $ 6,400 -1.320 $15,194 -6,076 -2,557 $ 6,560 -1,190 $ 5.370 -2,148 $ 3.986 $ 3,781 -1,512 $ 2.268 $ 4.514 -1.805 -2,004 $ 9,006 $ 5,080 -2.032 $ 3,048 $ 2,392 Net Income $ 3,222 Balance Sheet Cash..... Net operating working capital Property, plant & equipment (net). 80 1.514 11.686 $ 88 1.605 16,434 $ 131 1,972 18,077 $ 2.169 18,529 148 2.224 18.993 $ 152 2.279 19,467 $21,898 $13,280 $18,187 $20,181 $20.843 Total assets. $21,364 . $ 13.280 $13,280 $15,000 3 187 Debt Equity Total liabilities and equities. $74,400 5,781 $20,181 $13,200 7.643 $20,943 $11.900 9,464 $21,364 $12.198 9.701 $21.898 $18,187 ---- $ 3048 S 2.392 1,273 -151 $ 2.708 1,875 $ 3,006 2.226 -197 $ 3,222 2,557 -56 $ 3,513 $ 4.276 $ 5,036 $ 5,723 Cash Flow Statement Cash flows from operations Net income...... + Depreciation expense. - Change in net operating working capital.. Cash flow from operations Investing activities - Capital expenditures Financing activities + Change in debt financing + Change in common equity financing Common equity dividends paid. Cash flows from financing activities. Change in cash balance.. $-6,020 $-3,518 $-2.678 $-2,958 $-3,031 $15.000 S-600 $-1,200 0 $-1,300 0 - 1,227 297 0 -2.985 --12 485 $ 2,515 S-714 $-2,344 S-2,527 S-2,688 ----- $ $ 4 S 13 4 $ Exhibit may contain small rounding errors Question 2. Financial Modeling (2.1) CF Valuation Model The JMR Company is a family business that currently uses no debt in its capital structure. The owner-managers agreed on a plan to issue a large amount of debt to expand the company's operations. Their plan is to finance the entire transaction by borrowing $15 million of bank loan at an interest rate of 9%, and the debt repayment schedule is fixed. The company also plans on a recapitalization to reach a target capital structure of 20% debt at the end of Year 3. The company's chief financial officer prepared a set of financial forecasts that reflects this plan. The income statement, balance sheet, and cash flow statement forecasts are included in the tables as shown on the next page. The forecasts assume the company will issue the debt at the end of year 0, which is reflected in the balance sheet for that year. The forecasts do not, however, reflect the debt recapitalization at the end of Year 3. The company is expected to enter the constant growth stage starting Year 4 and grow at the long-run inflation rate of 2%. The debt cost of capital will not change while the company is paying off its debt, but it will decrease to 7% when they recapitalize the company to 20% debt at the end of Year 3. Its cost of equity is 15% and the unlevered cost of capital is 10%. The company's income tax rate for all revenues and expenses is 40%. Apply the appropriate valuation model to estimate the intrinsic value of JMR and intrinsic value of equity in year 0. Forecast Actual Year-t Actual Year 0 Forecast Year 2 Forecast Year 3 Forecast Year 4 Year 1 ($ in thousands) $ 7,968 -3.187 -1,000 $ 8,765 -3,506 -1.273 $14,462 -5.785 -2.220 $14.823 -5.929 Income Statement Revenue... Operating expenses Depreciation expense. Earrings before interest and taxes. Interest expense..... Income before taxes. income tax expense $13,147 -5.259 -1.875 $ 6,014 -1,500 S 3,787 0 $ 3,986 0 $ 6,400 -1.320 $15,194 -6,076 -2,557 $ 6,560 -1,190 $ 5.370 -2,148 $ 3.986 $ 3,781 -1,512 $ 2.268 $ 4.514 -1.805 -2,004 $ 9,006 $ 5,080 -2.032 $ 3,048 $ 2,392 Net Income $ 3,222 Balance Sheet Cash..... Net operating working capital Property, plant & equipment (net). 80 1.514 11.686 $ 88 1.605 16,434 $ 131 1,972 18,077 $ 2.169 18,529 148 2.224 18.993 $ 152 2.279 19,467 $21,898 $13,280 $18,187 $20,181 $20.843 Total assets. $21,364 . $ 13.280 $13,280 $15,000 3 187 Debt Equity Total liabilities and equities. $74,400 5,781 $20,181 $13,200 7.643 $20,943 $11.900 9,464 $21,364 $12.198 9.701 $21.898 $18,187 ---- $ 3048 S 2.392 1,273 -151 $ 2.708 1,875 $ 3,006 2.226 -197 $ 3,222 2,557 -56 $ 3,513 $ 4.276 $ 5,036 $ 5,723 Cash Flow Statement Cash flows from operations Net income...... + Depreciation expense. - Change in net operating working capital.. Cash flow from operations Investing activities - Capital expenditures Financing activities + Change in debt financing + Change in common equity financing Common equity dividends paid. Cash flows from financing activities. Change in cash balance.. $-6,020 $-3,518 $-2.678 $-2,958 $-3,031 $15.000 S-600 $-1,200 0 $-1,300 0 - 1,227 297 0 -2.985 --12 485 $ 2,515 S-714 $-2,344 S-2,527 S-2,688 ----- $ $ 4 S 13 4 $ Exhibit may contain small rounding errors