Please solve the question below showing ALL work on excel. Similar questions to this have already been solved so all you will need to do is plug in the values. It should be and straight forward. I'm attaching an image of the question below. I'll make sure to give a thumbs up. Thank you!

Here's the question:

Balance sheets, net income Financial information related to Montana Interiors for October and November 20Y8 is as follows: October 31, 2048 November 30, 2048 Accounts payable $62,400 $67,400 Accounts receivable 137,900 158,500 Capital stock ? ? Retained earnings 130,000 170,000 Cash 243,400 413,100 Supplies 12,200 10,100 a. Prepare a balance sheet for Montana Interiors as of October 31, 20Y8. Montana Interiors Balance Sheet October 31, 2048 Assets Cash Accounts receivable Supplies 100 Total assets Liabilities Accounts payable Stockholders' Equity Capital stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity Prepare a balance sheet for Montana Interiors as of November 30, 20Y8. Montana Interiors Balance Sheet August 31, 2048 Assets Cash Accounts receivable Supplies Total assets Liabilities Accounts payable Stockholders' Equity 9 Capital stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity b. Determine the amount of net income for November, assuming that no additional capital stock was issued and no dividends were paid during the month. c. Determine the amount of net income for November, assuming that no additional capital stock was issued, but dividends of $50,500 were paid during the month