Question: Write the spreadsheet formula that will calculate the post-split number of outstanding shares in C3. The ratio for the split is entered in cells B2

Write the spreadsheet formula that will calculate the post-split number of outstanding shares in C3.

The ratio for the split 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.

Step by Step Solution

★★★★★

3.55 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The spreadsheet formula is B2C2D2 The spreadsheet formula will be shown in a moment The ... View full answer

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 Financial Algebra Advanced Algebra Questions!

Write the spreadsheet formula that will calculate the post-split price per share in C4. The ratio for the split is entered in cells B2 and C2. For example, the ratio of 2-for-1 would be entered as a...

Discuss what would be observed as a sample of water is taken along a path that encircles and is close to its critical point.

1. Determine whether this case would be prosecuted as a criminal or civil offense, and state reasons to support your conclusion. 2. Who are the victims of this late-trading scheme, and what losses do...

Hello my friend please assist me with my discussion Interest Rates Negotiation is a soft skill that might just be one of the most important skills you will ever learn. For this Discussion you will...

Write the pre-split market cap formula in cell B5 and the post-split market cap formula in C5. The ratio for the split is entered in cells B2 and C2. For example, the ratio of 2-for-1 would be...

Artists Unlimited Company has provided the stockholders' equity section of the balance sheet as of December 31. The Controller has asked you to calculate different distribution options to...

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

answer this workbook please : https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/EQNuFz9ESMBBi1zuzV0w9uYB2I2aaFXcclMlPPc6JndcLQ?e=12fYP0 18 19 Horizontal Analysis 0...

Prepare the financial analysis to support your decision between bankruptcy,voluntary reorganization,and Chapter11reorganization.It must be complete and prepared in a professional level,with the...

Oxford Inc. currently has 1,200,000 common shares outstanding and $12,000,000 debt (face value is equal to market value) with a coupon rate of 8%. At the current level of operations, the firm's EBIT...

For what reasons might a company restrict a portion of its retained earnings?

what is the % difference between $ 6 0 5 , 6 8 0 and $ 2 , 3 1 9 , 3 4 0 ?

2. Describe the effects that a merger may have on employees. What can management do to lessen the more negative effects of a merger? What can employees do to protect themselves when they start to...

Compare your results in Problems 9.18 and 9.20, and discuss which method you feel is more appropriate here? Hypertension Polyunsaturated fatty acids in the diet favorably affect several risk factors...

Answer the question in Problem 9.50 using permutation test methods? Cancer Serum estradiol is an important risk factor for breast cancer in postmenopausal women. To better understand the etiology of...

Implement the test in Problem 9.49, and report a two-tailed p-value based on large sample methods? Cancer Serum estradiol is an important risk factor for breast cancer in postmenopausal women. To...

we blackboard.com/atta/course/ 1964 /outlineident:255409 t/overview/attempt 697099 17courseld_8964 1 Question 4 1 Point Gerry Co. has a gross profit of $1,200,000 and depreciation expense of...

A 5 year semiannual coupon bond with a face value of $1,000 trades at $856. The marketdetermined discount rate is 7%. What is the coupon rate? Answer in percent and round to two decimal places

apter 6 Matching Exercise (5 pts/match) ich the tax type listed on the right with the descriptions provided on the left by entering the correct letter (a, b, c, d, or e) in the blank Please match the...