Statement of Cash Flows and a Balance Sheet
Can someone help me with this excel spreadsheet. Thanks
Name: Date: Professor Course: LANSBURY INC. Balance Sheet December 31, 2013 Cash $20,000 Accounts Payable $30,000 Accounts Receivable 21,200 Notes Payable (long-term) 41,000 Investments 32,000 Common Stock 100,000 Plant Assets (net) 81,000 Retained Earnings 23,200 Land 40,000 $194,200 $194,200 During 2014 the following occurred: $15,000 This transaction resulted in a gain of $3,400 2. A tract of land was purchased for $18,000 cash. $16,000 were retired before maturity by paying $16,000 cash. $20,000 in common stock was issued at par. $8,200 were declared and paid to stockholders. $32,000 after allowing for depreciation of $11,000 $30,000 in bonds. $32,000 Accounts Receivable was $41,600 and Accounts Payable remained at $30,000 Instructions: LANSBURY INC. Statement of Cash Flows For the Year Ended December 31, 2014 Cash flows from operating activities Title Amount Account Title Account Title Amount Account Title Amount Account Title Amount Formula Formula Cash flows from investing activities Account Title Amount Account Title Amount Net cash used in investing Formula Cash flows from financing activities Account Title Amount Account Title Amount Account Title Amount Net cash used by financing activities Formula Net increase in cash Formula Cash at beginning of year Amount Cash at end of year Formula Enter text as appropriate Enter text as appropriate LANSBURY INC. Balance Sheet Intermediate Accounting , 15 th Edition by Kieso, Weygandt, and Warfield P5-6 (Preparation of a Statement of Cash Flows and a Balance Sheet) Lansbury Inc. had the balance sheet shown on the following page at December 31, 2013. 1. Lansbury Inc. sold part of its investment portfolio for for the firm. The company classifies its investments as available-for-sale. 3. Long-term notes payable in the amount of 4. An additional 5. Dividends totaling 6. Net income for 2014 was 7. Land was purchased through the issuance of 8. At December 31, 2014, Cash was (a) Prepare a statement of cash flows for 2014. Net cash provided by operating activities (b) Prepare an unclassified balance sheet as it would appear at December 31, 2014.
Answers
Status NEW
Posted 13 Dec 2017 01:12 PM
My Price 10.00
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------
Not Rated(0)