Project 1: Stockholders Equity (10 points) Required: Answer the questions an the fellowing poge in Excel and uplodd your file to Moodle by the deodline specified by your instructer, Shown below is the stackholders' oquity section of Holiday Travels' belance shent et Decenber 31, 2022. Duning 2023, the following events pocurred: ? Hslidoy Truirels was eutherized to sell 120,000 shares of $100 par, 6% preferred stock 7. Holidoy sold 28,000 shores of the preferred stock at por value: - A cash dividend 45$206,000 was declared end paid * Holidoy Truvels declored and issued o 10% stock dividend on the common stock when the frarket velue of the stock was $17 per share * Net incone for the year wos $1,490,000 Answer the fellowing, besed on the inf emation given on the precesing page: Copital stock, es ef Decenber 31, 2023 : H of common shares athsrized If of comnon shares iseses ond outstanding If of preferred shares ispued and sutstonding Amount of cash dividend to common stsckhelders Amount of cash dividend to preferned stockhelders Total debit to Stock Dividends aceount Additienal paid-in copital, as Decenker 31, 2023 Retained eernings, of Joruary 1, 2023 Aletoined eernings, at December 31,2023 Totai stockhalers Equifiat becenber 31, 2023 1 5 5 $ 5 5 Project 2: Cost of Goods Manufoctured \& Cost of Goods Sold Schedules (10 peinti) (10 points) Upload your file to Moodle by the seadine specified: De NoT emel yeur filel ne fallowina information relates to Ceeper Cenpary Instructiens fer Project 21 1 Uning Excel, prepore a Cost of Goeds Monufectured schedule. Refer to Divitration 14.11 in your textbook 2. Using Ewcel, prepare Cost of Gosds Sold schedule. Refer to Illustration 14.9 in your textboek. Instructions Frepore your solution in Excel and uplad your Excel the se Moodie by The follewing information pertoins to Fun in the Sun, Inc, a beoch bell monufacturer B. budgeted selling and edministrative costs for the coming year Fixed selling & odmin expense Shipping cest per ball 23,350 In the coming year. Fun in the Sun plans to produce and sell 6,700 beoch bolls at a price of $31 each. Instructions for Project 3: 1. Prepore a CVP income stotement. 2. Calculate the breakeven peint in units and saler dollars. 3. Colculate the mangin of safety. 4. Calculate the margin of safety ratio. 5. If Fun in the sun wants to earn net inceme of 560,000 , how many units must it sell