Question: Please provide excel formulas if able. Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information
Please provide excel formulas if able.
| Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows 6 through 11. The required answers are in rows 17 through 24. | |||||||
| Stockton Mineral Operations, Inc. (SMO), currently has 540,000 shares of stock outstanding that sell for $83 per share. Assuming no market imperfections or tax effects exist, what will the share price be after: a. SMO has a 5-for-3 stock split? b. SMO has a 15 percent stock dividend? c. SMO has a 42.5 percent stock dividend? d. SMO has a 4-for-7 reverse stock split? Determine the new number of shares outstanding in parts (a) through (d). | |||||||
| Input Area: | |||||
| Shares outstanding | 540,000 | ||||
| Stock price | $83.00 | ||||
| a. | Stock split | 5 | for | 3 | |
| b. | Stock dividend percent | 15.00% | |||
| c. | Stock dividend percent | 42.50% | |||
| d. | Stock split (shares) | 4 | for | 7 | |
| (Use cells A6 to F11 from the given information to complete this question.) | |||||
| Output Area: | |||||
| a. | Stock split | ||||
| b. | Stock dividend | ||||
| c. | Stock dividend | ||||
| d. | Stock split | ||||
| e. | a. | New shares outstanding | |||
| b. | New shares outstanding | ||||
| c. | New shares outstanding | ||||
| d. | New shares outstanding | ||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
