Prepare Statement of Cash Flows for the year

Assignment Help Accounting Basics
Reference no: EM132748746

Question - Jefferson County operates a centralized motor pool to service county vehicles. At the end of 2016, the Motor Pool Internal Service Fund had the following account balances:

Debits Credits

Due from General Fund $6,500

Cash 18,000

Capital assets 35,000

Supplies inventory 4,000

Accounts payable $ 5,500

Accrued wages payable 300

Accumulated depreciation 6,500

Advance from enterprise fund 25,000

Net position 26,200

Total $63,500 $63,500

The following events took place during 2017:

1. Additional supplies were purchased on account in the amount of $38,000.

2. Services provided to other departments on account totaled $98,000. A total of $68,000 was for departments in the General Fund and $30,000 for enterprise fund departments.

3. Supplies used amounted to $36,700.

4. Payments made on accounts payable amounted to $38,800.

5. Cash collected from the General Fund totaled $62,000, and cash collected from the enterprise fund totaled $30,000.

6. Salaries were paid in the amount of $48,700. Included in this amount is the accrued wages payable at the end of 2016. All of these are determined to be part of the cost of services provided.

7. In a previous year, the enterprise fund loaned the motor pool money under an advance for the purpose of purchasing garage equipment. In the current year, the motor pool repaid the enterprise fund $8,000 of this amount.

8. On July 1, 2017, the Motor Pool Fund borrowed $12,000 from the bank, signing a 12 percent note that is due in two years with annual interest payments on June 30. The borrowings are not related to capital asset purchases but were made to provide working capital. Additional information includes:

9. Depreciation for the year amounted to $6,900.

10. The payment of interest on the note is payable on June 30, 2018.

11. Unpaid wages relating to the final week of the year totaled $770.

Required - Using the Excel template provided (a separate tab is provided for each of the requirements):

a. Prepare journal entries and post entries to the T-accounts.

b. Prepare closing entries.

c. Prepare Statement of Revenues, Expenses, and Changes in Fund Net Position.

d. Prepare Statement of Net Position.

e. Prepare Statement of Cash Flows for the year.

Reference no: EM132748746

Questions Cloud

What advice give regarding use of social media : Your sister is a college senior. What advice would you give her regarding her use of social media and its relationship to the business world?
Leverage interactivity in data visualizations : What are effective ways to leverage interactivity in data visualizations? Provide 3 examples of how you would effectively interactivity in data visualization
Explain the concept of sourcing : Two of the newest recruitment sources are Twitter and Pinterest (See Week Three Video). Explain how and when each should be used.
What suggestions can be made to management : What suggestions can be made to management when it comes to negotiating with unions about health care? What are some suggestions that would work
Prepare Statement of Cash Flows for the year : Salaries were paid in the amount of $48,700. Included in this amount is the accrued wages payable at the end of 2016. Prepare Statement of Cash Flows for year
Should the individual be accommodated in the workplace : Should the individual be accommodated in the workplace? Or would the requested accommodation impose an undue hardship on the employer? Why?
How could friend reduce worker compensation costs : Suppose after Brock your friend starts a car detailing company. How could your friend reduce worker's compensation costs before and after an accident?
How much should the stock prices of a company : The average price of the shares owned by S & P500 is $30 and the standard deviation is $8.20. How much should the stock prices of a company be to be between 10%
Discuss manage educator in virtual test environment : Identify and critically discuss 5 mechanisms one would implement to effectively manage educators in virtual test environments. Provide the example.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd