Calculate cash recieved page,

Do a partial balance sheet with liabilities an OE on the next,

And then the ratios using given calcualtions page as well

e Layout Formulas Data Review View C Label Dialog Aria Help ERNAL NFIDENTIALFavourites B I Urasi Alignment Font Classifier The company could issue 500,000 additional shares of $1 par value common stock for $5.20 per share T KTZFIG Consulting and Sales Inc Cash Received/Annual Cash Payment Requirement The company could issue 500,000 additional shares of $1 par value common stock for $5.20 per share The company will begin paying a dividend to ALL the common shareholders of $0.13 per share and this will continue into the future. Cash Received Annual Cash Required number of existing shares number of new shares total shares at year end market price Dividend rate Dividend period PIC year end PIC> par year end 15 16 18 21 31 NoahGodlewskiProject3part2orig [Compatibil Insert Page LayoutFormulasData Review View C Label Dialog Arial PUBIC INTERNAL Hep anter CONFIDENTIAL-Favourites . B 1 u-1,-a- HMerge & Center 1 s Font Alignment Classfier The company could issue 500,000 additional shares of $1 par value common stock for $5.20 per share The company will begin pa The company could issue 500,000 additional shares of $1 par value common stock for $5.20 per share The company will begin paying a dividend to ALL the common shareholders of $0.13 per share and this will continue into the future dfrom the lst ay, October 30. day, Sephember edfronlast day, October 30.. y of pew wW411. 15 16 nday, September 20 ednesday, Augst 25 18 (version 1) xhb ated from te Priday, October 26 23 Thursday, October 2 0 MP NoahGodlewskiProject3part2orig (Compatibility Mode esert Page Layout Formulas Data Review Vew General C Label Dialog Calbri Help ENTERNIAL CONFIDENTIAL Favourtes Number Font The company could issue The company could issue $3,000,000 of The company could issue $2,500,000 of long-term shares of $1 par value common stock long-term bonds bonds due in7 for $5.20 per in 8 years a stated of interest years with a stated rate of interest, paid share The company will begin paying a dividend to ALL the Ratios paid semiannually, of The market for similar of 6%, The market rate for similar debt is debt is 6%. shareholders of $0.13 per share and this will continue into the future bt to Asset Ratio MFU