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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!