Hello, can I please get a step by step solution to this question using excel? Thank you!

The balance sheet for Fourth Corp. is shown here in market value terms. There are 5,000 shares of stock outstanding. Market Value Balance Sheet Cash $ 45,100 Equity $ 495,100 Fixed assets 450,000 Total $ 495,100 Total $ 495.100 ' The company has declared a dividend of $1.40 per share. The stock goes exdividend tomorrow. Ignoring any tax effects, what is the stock selling for today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Ignoring any tax effects, what will it sell for tomorrow? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Current stock price New stock pn'ce _ Ignoring any tax effects, what will the balance sheet look like after the dividends are paid? (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Market Value Balance Sheet _