The stockholders' equity section of Creighton Company's balance sheet is shown as follows. 3 4 Review View Stockholders' equity Preferred stock, $10 stated value, 7% cumulative, 300 shares authorized, 50 issued and outstanding 8 Common stock, $10 par value, 250 shares authorized, 100 issued and outstanding 9 Common stock, class B, $20 par value, 400 shares authorized, 150 issued and outstanding 10 Common stock, no par, 150 shares authorized, 100 issued and outstanding 13 Paid-in capital in excess of par value-dass B common 14 Retained earnings 15 Total stockholders' equity 16 CREIGHTON COMPANY As of December 31, Year 3 Help 26 (Use cell references from the given Information to complete this question.) 27 B f-1. Based on the stockholders' equity section shown earlier, can you determine the market value of the preferred stock? f-2. If yes, what is the market value of one share of this stock? 28 la. Cash collected on issue 29 b. Company's legal capital 30 c Amount of assets to be retained 31 d. Class B common stock available to sell 32 e Number of Shares of stock outstanding 33 f-1. Market value can be determined by analyzing the stockholders' equity section 34 f-2. Market value of one share of the stock 35 36 27 $500 $1,000 $3,000 $2,200 $600 $1,200 $750 $7,000 $16,250 17 Required 18 a. Assuming the preferred stock was originally issued for cash, determine the amount of cash that was collected when the stock was issued. 19 b. Based on the class B common stock alone, determine the amount of the company's legal capital. 20 C. Based on the class B common stock alone, determine the minimum amount of assets that must be retained in the company as protection for creditors. d. Determine the number of shares of class B common stock that are available to sell as of December 31, Year 3. 21 22 e. Assuming Creighton purchases treasury stock consisting of 25 shares of its no par common stock on January 1, Year 4, determine the amount of the no-par common stock that would be outstanding immediately after the purchase. C $1,100 $3,000 D $10 $10 $20 150 250 shares shares E General 7% 250 400 100 300 100 150 G 50 25 V 00

please help to understand how to find the excel formuals using the actual cells pictured

Home Insert Draw lomulas Dats Review Vow Heip - X A Accessibilyy tab summarr: Given informetion foc this queution is presented latows 2 through 15 . Aequirement information is presented in rows 17 through 34 A. B. As of December 31, Year 3 Srocknolders equiry Common stock, 510 per value, 250 shures nuthorited, 100 iswed and ovistandine Common stod, no pr, 150 shares buthoried, 100 issued and cutsundine. Paid in capital in ercess of strited value-pefered pas in capital in exess of per value commion Padin copitalin erress of per vabe-dess common 14 peained earnes 15. Teal stooholders equity Required: b. Bried on the clans b common stock done, oetermine the amount of the company ketul captal common siod that would be outitanding immedinely rater the purchuse 25 30 - Amount of miets to he retained 31. a clas B common inook malate is set