L2

xlsx

School

Temple University *

*We aren’t endorsed by this school

Course

3901

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

9

Uploaded by joeyleone

Report
ADVANCED PROBLEM 2-2 FOR SPREADSHEET APPLICATIO Solution Balance Sheet as ASSETS 2014 2013 Current assets Cash $ 26,000 $ 23,000 Marketable securities $ 58,000 Accounts receivable $ 518,000 Inventory $ 910,000 $ 639,000 Total current assets $ 994,000 $ 1,242,000 Fixed assets $ 4,975,000 $ 4,387,000 Accumulated depreciation $ -1,364,000 Intangible assets $ 431,000 $ 465,000 Total long-term assets $ 4,042,000 TOTAL ASSETS $ 5,036,000 $ 5,085,000 Does the change in the total assets equal the change in the total liabiliti Balance sheet. Reach Manufacturing has lost its computer systems and information out of its crashed computer: a. Reconstruct the balance sheets for 2013 and 2014 using a spreadshee assets, current liabilities, total liabilities, total owners' equity, and total years. Verify that the changes in the total assets equal the changes in th b. Find the cash flow from assets for the year 2013 if the OCF for 2013 a. Reconstruct the balance sheets for 2013 and 2014 using a spreadshee assets, current liabilities, total liabilities, total owners' equity, and total years. Verify that the changes in the total assets equal the changes in th b. Find the cash flow from assets for the year 2013 if the OCF for 2013
Operating cash flow (OCF) Net working capital (NWC) for 2013 Net working capital (NWC) for 2014 Change in fixed assets from 2013 to 2014 Change in intangible assets from 2013 to 2014 Requirements 1. Start Excel. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. - Change in NWC - Capital spending = Cash flow from assets In cell D22 , by using cell references, calculate the total long-term sheet. In cell D23 , by using a cell reference, calculate the total assets for Note: The total assets must equal the total liabilities and owners' e In cell D18 , by using cell references, calculate the total current as In cell D16 , by using cell references, calculate the accounts receiv In cell H14 , by using cell references, calculate the accounts payab In cell H22 , by using cell references, calculate the total owners' eq sheet. In cell H18 , by using cell references, calculate the total liabilities In cell H17 , by using cell references, calculate the long-term debt In cell E15 , by using cell references, calculate the marketable sec sheet. In cell E22 , by using cell references, calculate the total long-term sheet. In cell E20 , by using cell references, calculate the accumulated de In cell I16 , by using cell references, calculate the total current liab sheet. In cell I18 , by using cell references, calculate the total liabilities f In cell I23 , by using a cell reference, calculate the total liabilites a the balance sheet. In cell I22 , by using cell references, calculate the total owners' eq In cell I21 , by using cell references, calculate the retained earning In cell F14 , by using cell references, calculate the change in the c In cell range F15:F23 , by using cell references, calculate the chan from cell F14 and paste it to cell range F15:F23 .
20. 21. 22. 23. 24. 25. 26. 27. 28. Save the workbook. Close the workbook and then exit Excel. Sub In cell J14 , by using cell references, calculate the change in the ac In cell ranges J15:J18 and J20:J23 , by using cell references, calc 2013 to 2014. Copy the content from cell J14 and paste it to cell r In cell H25 , type either Yes or No depending on whether the chan In cell F30 , by using cell references, calculate the net working cap In cell F31 , by using cell references, calculate the net working cap In cell F32 , by using cell references, calculate the change in NWC to 2014. Use cells F33 and F34 . In cell F36 , by using cell references, calculate the cash flow from
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ON Reach Manufacturing s of December 31, 2014, and December 31, 2013 Change LIABILITIES 2014 2013 Current liabilities $ 0 Accounts payable $ 419,000 #DIV/0! Notes payable $ 210,000 $ 390,000 $ -1 Total current liabilities $ 889,000 $ 0 Long-term debt $ 3,540,000 $ -0 Total liabilities $ 1,099,000 $ 4,349,000 $ 0 OWNERS' EQUITY #DIV/0! Common stock $ 330,000 $ 330,000 $ -0 Retained earnings $ 701,000 #DIV/0! Total owners' equity $ 1,031,000 $ 330,000 $ -0 $ 5,832,000 $ 4,679,000 ies and owners' equity? Yes d must reconstruct the last two years of its balance sheet. The company has been ab et, and find the change in each account and each category balance (current assets, lo liabilities and owners' equity) from 2013 to 2014. The balance sheet has the same a he total liabilities and owners' equity. 3 is $389,000. Note : Treat intangible assets as a capital spending item. et, and find the change in each account and each category balance (current assets, lo liabilities and owners' equity) from 2013 to 2014. The balance sheet has the same a he total liabilities and owners' equity. TOTAL LIABILITIES AND OWNERS' EQUITY 3 is $389,000.
$ 389,000 $ 406,000 $ -796,000 $ -2 $ 0 $ -0 m assets for year 2014. Use the relevant cells from the given data in the balance r year 2014. Refer to the relevant cell from the given data in the balance sheet. equity. ssets for year 2014. Use the relevant cells in the balance sheet. vable for year 2014. Use the relevant cells in the balance sheet. ble for year 2014. Use the relevant cells from the given data in the balance sheet. quity for year 2014. Use the relevant cells from the given data in the balance for year 2014. Use the relevant cells in the balance sheet. t for year 2014. Use the relevant cells in the balance sheet. curities for year 2013. Use the relevant cells from the given data in the balance m assets for year 2013. Use the relevant cells from the given data in the balance epreciation for year 2013. Use the relevant cells in the balance sheet. bilities for year 2013. Use the relevant cells from the given data in the balance for year 2013. Use the relevant cells in the balance sheet. and owners' equity for year 2013. Refer to the relevant cell from the given data in quity for year 2013. Use the relevant cells in the balance sheet. gs for year 2013. Use the relevant cells in the balance sheet. cash from 2013 to 2014. nge in other accounts of the firm's assets from 2013 to 2014. Copy the content
bmit the workbook as directed. ccounts payable from 2013 to 2014. culate the change in other accounts of the firm's liabilities and owners' equity from ranges J15:FJ18 and J20:J23 . nges in the total assets equal the changes in the total liabilities and owners' equity. pital (NWC) for year 2013. Use the relevant cells from the balance sheet in part a . pital (NWC) for year 2014. Use the relevant cells from the balance sheet in part a . C from 2013 to 2014. Use cells F30 and F31 . m assets. Use cells F29 , F32 , and F35 .
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Change $ -1 $ -0 #DIV/0! $ -1 $ -1 #DIV/0! $ - #DIV/0! $ 2 $ 0 ble to get some ong-term assets, total accounts in both ong-term assets, total accounts in both
Points 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help