Please show all calculations and formulas.If using Excel, please show data, formulas, etc.

Practice example 9:

Pluto's has 14,000 shares of stock outstanding with a par value of $1 per share. The market value is $39.60 per share. The balance sheet shows $522,500 in the capital in excess of par account, $14,000 in the common stock account, and $429,700 in the retained earnings account. The firm just announced a 10 percent (small) stock dividend. What will be the balance in the retained earnings account after the dividend?