Gade Courses Excel McGraw Hill Excel Question - Saved Search (Alt+Q) File Home Draw Insert Formulas Data Review View Help Calibr B 835 MergeCurrency D E 2 The following are excerpts from a company's balance sheet and income statement. Included also are important rates that apply to the company 89 G 4 Randall-Hecho, Incorporated: Income Statement Projection 5 Profits 6 Shares Outstanding 7 Earnings Per Share & Interest Payments (Pre-tax) 0 (Year Just Ended) $24,630,542 2,500,000 $9.85 $500,000 5 $25,000,000 2,400,000 $10.42 $500,000 $28,125,000 2,400,000 $11.72 $500,000 $30,234,375 2,300,000 $13.15 $500,000 $32,501,953 2,300,000 $34,939,600 2,200,000 $14.13 $500,000 $15.88 $500,000) 4 10 Randall-Hecho, Incorporated: Balance Sheet Projections 2 4 11 Working Capital $4,315,000 $4,250,000 $4,500,000 12 Capital Spending 59,574,815 $10,000,000 $12,000,000 $4,750,000 $12,000,000 $4,750,000 $4,850,000 $13,500,000 $12,000,000 13 Depreciation 58,745.329 58,500,000 $8,600,000 $8,750,000 $8,500,000 $1,250,000) 14 Long-Term Debt $10,416,667 510416,667 $10,416,667 $10,416,667 $10,416,667 $10,416,667 15 76 Randall-Hecho, Incorporated Rates Rates 17 Interest Rate on Debt 16 Corporate Tax Rate 0.05 0.200 10 Sustainable Growth Rate 0.010 EXCM Fie Home Insert Draw Forms Data Review View Help 3 B MergeCurrency f D G 30 11 Working Capital Randall-Hecho, Incorporated: Balance Sheet Projections 2 $4,315,000 $4,250,000 $4,500,000 $4,750,000 $4,750,000 $4,850,000 12 Capital Spending $9,574,815 $10,000,000 $12,000,000 $12,000,000 $13,500,000 $12,000,000 13 Depreciation 58,745,329 $8,500,000 $8,600,000 $8,750,000 $8,500,000 58,250,000 14 Long-Term Debt $10,416,667 $10,416,667 $10,416,667 $10,416,667 510,416,667 $10,416,667 15 16 Randall-Hecho, Incorporated: Rates Rates 17 Interest Rate on Debt 0.06 1 Corporate Tax Rate 0.200 19 Sustainable Growth Rate 0.010) 20 Weighted Average Cost of Capital 0.095 21 22 Required 2) 24 ucing 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. 25 (Use cells A5 to 620 from the given information to complete this question) 26 27 28 Chunees in Workine Capital Randall Hecho, Incorporated Cash Flow Calculations EB Graded Worksheet 4 5 Terminal Excel McGraw Hill Excel Question Saved Search (Alt+Q) Fle Home Imed Draw Formul Data Review View Help Caffor B 835 $ A 18 Corporate Tax Rate 19 Santainable Growth Rate 20 Weighted Average Cost of Capital 21 22 Required: MergeCurrency D 0.200 0,010 0.095 G thing the information in the tables above, please make the necessary cash flow calculation. Then use these projections to determine the intrinsic value of the firm, the equity value, and 23 the stock price per share 24 25 (Use cells A5 to G20 from the given information to complete this question.) 26 27 Randall-Hecho, incorporated: Cash Flow Calculations 20 Changes in Working Capital 29 Aher Tax leerest Payments 10 Free Cmh flow to the Firm 31 Randal Hecho, Incorporated: Firm and Equity Value 33 Presem Value of free Cash Flow to the Firm intrinsic Value) 34 Equity Value 15 Price Per Share 3 4 5 Terminal Value 37 38