Part I. $(10$ points$).$ You are studying for your Intermediate Accounting Exam. You are just not getting

how to deal with stock splits. You wonder: "There is no journal entry for them. What is actually.

happening?" You decide to come up with a hypothetical stock split scenario and use your trusty Excel

skills to visualize what is going on$.$

There are three parts to this problem. Use Excel to perform the following:

a$)$ Use formulas to complete the Total Common Stock Table from the information given above.

Calculate the new number of shares, the new par value, and the total Common Stock.

b$)$ Prepare a combination chart with a bar for the number of shares and a line for the par value.

Use separate axes. Include a legend and proper title.

c$)$ Discuss the relationships that you see between number of shares, par value and Total Common

Stock for the different number of shares received in the stock split.