A B C D E 1 Employee Building Section Status Comp. 2 A. Dodd 2352 Admin FT 30000 3 J. Smith 2352 HR PT 25000 4 T. Williams 2598 HR FT 55000 5 B. Wiley 2598 Sales FT 45000 6 S. Brown 2352 Sales FT 50000 7 P. Franks 2598 Sales PT 20000
Added by Rocio J.
Close
Step 1
The split is always done based on the selected cell. In this case, the split is between columns B and C. Show more…
Show all steps
Your feedback will help us improve your experience
Mauya Mitchell and 73 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
A. Select the correct option. 1. This is a command of Calc that collates the data from different ranges and places it in a worksheet. a. Consolidate b. Combining C. Subtotals
Sanchit J.
Use the following spreadsheet to answer Exercises 13–15. The split-ratio is entered in cells B2 and C2. For example, the ratio of 2-for-1 would be entered as a 2 in B2 and a 1 in C2. The number of pre-split shares is entered in B3 and the pre-split price is entered in B4. Write the pre-split market cap formula in cell B9 and the post-split market cap formula in C9. $$\begin{array}{|c|c|c|c|}\hline & {A} & {B} & {C} & {} \\ \hline 1 & {} & {\text { Pre-split }} & {\text { Post-spit }} \\ \hline 2 & {\text { Split ratio }} & {2} & {1} \\ \hline 3 & {\text { Outstanding shares }} & {} & {} \\ \hline 4 & {\text { Price per share }} & {} & {} \\ \hline 5 & {\text { Market cap }} & {} & {} \\ \hline\end{array}$$
The Stock Market
Stock Splits
Use the following spreadsheet to answer Exercises 13–15. The split-ratio is entered in cells B2 and C2. For example, the ratio of 2-for-1 would be entered as a 2 in B2 and a 1 in C2. The number of pre-split shares is entered in B3 and the pre-split price is entered in B4. Write the spreadsheet formula that will calculate the post-split number of outstanding shares in C3. $$\begin{array}{|c|c|c|c|}\hline & {A} & {B} & {C} & {} \\ \hline 1 & {} & {\text { Pre-split }} & {\text { Post-spit }} \\ \hline 2 & {\text { Split ratio }} & {2} & {1} \\ \hline 3 & {\text { Outstanding shares }} & {} & {} \\ \hline 4 & {\text { Price per share }} & {} & {} \\ \hline 5 & {\text { Market cap }} & {} & {} \\ \hline\end{array}$$
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD