green blank answer- use in excel foula

A B C D E F G H The MCU Inn's noncurrent assets from its comparative balance sheet for June 30, 20X6, were as follows: W N June 30 20x5 20x6 Invesements $65,000 $75,000 Property and Equipment: Land $200,000 $200,000 Buildings $1,600,000 $1,600,000 10 Furniture and Equipment $250,000 $280,000 11 Accumulated Depreciation $450,000 $490,000 12 Other Assets: 13 Franchise Fee $30,000 $25,000 14 Organization Costs $8,000 $4,000 15 16 17 Other information is as follows: 18 1. Investments costing $10,000 were sold for $15,000 during 20X6. 19 2.Fully depreciated equipment costing $15,000 was sold for $5,000 during 20X6. 20 3.Reductions in other assets relate to amortization of these items during 20X6. 21 4.Any other changes (unexplained) in the listed accounts are due to single cash transactions. 22 23 Prepare a schedule showing cash flow from investing activities. 24 25 26 27 Answer 28 MCU Inn Account Analysis 29 Cash Flow from Investing Activities Investment 30 12/31/x3 Balance $65,000 31 Sales of Investment $10,000 32 Cash Flows from Investing Activities: + Purchase of Investment 33 Proceeds from Sale of Investments = 12/31/x4 Balance $75,000 34 Proceeds from Sale of Equipment 35 Purchase of Investments 36 Purchase of Equipment Furniture and Equipment 37 12/31/x3 Balance $250,000 38 Net Cash Flows from Investing Activities - Sales of Equipment $15,000 39 + Purchase of Equipment 40 = 12/31/x4 Balance $280,000