Prepare Statement of Cash Flows for the year

Assignment Help Accounting Basics
Reference no: EM132772088

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: EM132772088

Questions Cloud

Compute the optimal investment proportion : Based on these data, compute the following for Mr. Tom: Optimal investment proportion during COVID19 crisis period in risky portfolio
Prepare summary of total cost for waste cleaning system : Workers' compensation claims $5,500. Prepare a summary of the total cost for the waste cleaning system for the next 10 years
Identify a charismatic leader and a leader : Identify a charismatic leader and a leader with little charisma. What are the traits and skills that allow them to succeed in their roles? How can you incorpora
Discuss porter five forces model : Discuss Porter's five forces model. How does it help managers to identify the opportunities and threats confronting a company?
Prepare Statement of Cash Flows for the year : Additional supplies were purchased on account in the amount of $38,000. Prepare Statement of Cash Flows for the year
Prepare the journal entries to record previous transactions : Prepare the journal entries to record the previous transactions occurred during December 2018 and January 2019
How much revenue would Bryant recognize : Bryant Magazine Company's fiscal year ends December 31. How much revenue would Bryant recognize from this amount for the current year
Make a journal entry for the transaction : Share capital - ordinary $ 40 par value (100,000 shares authorized, 65,000 shares issued and outstanding) $2,600,000. Make journal entry for the transactions
What is the amount of gross profit earned by Love Co : Kind Co. paid the invoice within the discount period. What is the amount of gross profit earned by Love Co. on the above transactions

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