Show what formulas are used in excel to solve problems please.

What role does capital budgeting play in the firm's overall financial planning program? answer must be at least 300 words.

2 COMMON STOCK VALUATION Crosby Corporation common stock paid $1.32 in dividends last year and is expected to grow indefinitely at an annual 7 percent rate. What is the value of the stock if you require an 11 percent return? 4 6 DATA 7 Growth rate 8 Dividend (Do) ?? Required rate 10 11 SOLUTION 12 Value 13 14 Requirements: 70% S1.32 1 1 .0% 1. Start Excel. Download and open the workbook named: Keown Martin Petty Problem 8-8 Start. Important note: All calculations must be shown using cell references. Do NOT enter absolute numbers in the cells. 15 2. Calculate the value of the common stock by using the dividend 16 valuation model in cell B12. (1 point)