Download the Excel file attached to this assignment. There are four tabs, each with one problem on it. You must complete all four problems..

Zero growth: Knight Supply Corp. has not grown for the past several years and expects this lack of growth to continue. The firm last paid a dividend of $3.56. If you require a rate of return of 13 percent, what is the current stock price?

File Home Insert Draw Page Layout Formulas Data Review View Help Share Comme AutoSum Arial v 12 ~AP ab Wrap Text NT TIX General 49 O 5 X Cut La Copy Format Painter Fill Paste Insert Delete Format BI U Av Sensitivity + Merge & Center $ - % -29 Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Cells Editing Analysis Sensitivity F13 X fx . B D E F G H J K L M . N O 1 9.7 Zero growth: Knight Supply Corp. has not grown for the past several years and expects this lack of of growth to continue. The firm last paid a dividend of $3.56. If you require a rate of return of 13 percent, what is the current stock price? 4 5 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 22