I need the answer to this problem in Accounting using excel for success, 2nd edition. PR15-3A Stock investment transactions, equity method and available-for-sale securities.

White Way Inc., produces and sells theater set designs and costumes. the company began operations on January 1,2012. The following transactions relate to securities acquired by White Way Inc, which has a fiscal year ending on December 31:

2012

Jan.10. Purchased 8,000 shares of Lott Inc as an available-for-sale security at $14 per share, including the brokerage commission.

Mar.10. Received the regular cash dividend of the $0.12 per share on Lott Inc. stock.

Sept.9. Lott Inc. stock was split two for one. The regular cash dividend of $0.06 per share was received on the stock after the stock split.

Oct. 16, Sold 2,000 shares of Lott Inc. stock at $5 per share, less a brokerage commission of $100.

Dec. 31. Lott Inc. is classified as an available-for-sale investment and is adjusted to a fair value of $8.50 per share. Use the valuation allowance for available-for-sale investments account in making the adjustment.

2013

Jan. 5. Purchased an influential interest in Stage Hand Inc. for $235,000 by purchasing 50,000 shares directly from the estate of the founder of Stage Hand Inc. There are 200,000 shares of Stage Hand Inc. stock outstanding.

Mar. 9, Received the regular cash divided of $0.07 per share on the Lott Inc. stock

Sept. 10. Received the regular cash dividend of $0.07 per share plus an extra dividend of $0.03 per shar on Lott Inc. stock

Dec.31. Received $21,500 of cash dividends on Stage Hand Inc. stock. Stage Hand Inc. reported net income of $136.000 in 2013. White Way Inc. uses the equity method of accounting for its investment in Stage Hand Inc.

Dec.31 Lott Inc. is classified as an available-for-sale investment and is adjusted to a fair value of $8 per share. Use the valuation allowance for available-for-sale investments account in making the adjustment for the decrease in fair value from $8.50 to $8.00 per share.

Instructions

1) Journalize the entries to record these transactions.

2) Prepare the investment-related asset and the stockholders' equity balance sheet disclosures for White Way Inc. on December 31, 2013, assuming the Retained Earnings balance on December 31, 2013, is $310,000