I need the answers to the blue colored cells. Can you please show me how...

50.1K

Verified Solution

Question

Finance

image

I need the answers to the blue colored cells.

Can you please show me how you would calculate the answers using excel, Thank you so much!

One way to lower the market price of a firm's stock is via a stock split. Rock-O Corporation finds itself in a different situation: Its stock has been selling at relatively low prices. To increase the market price of the stock, the company chooses to use a reverse stock split of 2- for-3 The company currently has 700,000 common shares outstanding and no preferred stock. The common stock carries a par value of $1. At this time, the paid-in capital in excess of par is $7,000,000, and the firm's retained earnings are $3,500,000. To Do Create a spreadsheet to determine the following: a. The stockholders' equity section of the balance sheet before the reverse stock split b. Calculate the effect on the par value and number of shares after the reverse plit Solution No. of common shares outstanding 700,000 1.00 Par value of each share Paid-in capital in excess of par Retained earnings of the firm Reverse stock split S 7,000,000 3,500,000 2 for 3.00 a. The stockholders' equity section of the balance sheet before the reverse stock split Par value of common stock Paid-in capital in excess of par Retained earnings 7,000,000 3,500,000 S Common stock b. Calculate the effect on the par value and number of shares after the reverse plit Number of common shares after reverse split Par value of each share after reverse split The stockholders' equity section of the balance sheet after the reverse stock split. Par value of common stock Paid-in capital in excess of par Retained earnings $ 7,000,000 3,500,000 Common stock

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students