Create a schedule of accounts receivable balances

Assignment Help Accounting Basics
Reference no: EM131861677

Question: Please complete following questions in excel, and putting answers in the worksheet (in excel).

1. Schedules of accounts

a. Create a schedule of accounts receivable balances as at the end of June.

b. Create a schedule of accounts payable balances as at the end of June.

2. Financial statements

a. Prepare an income statement for the month of June.

b. Prepare a statement of stockholders' equity for the month of June.

c. Prepare a balance sheet as at the end of June.

3. Closing entries

a. Journalise closing entries in the general journal.

b. Post the closing entries from the general journal to the relevant ledger accounts.

4. Post-closing trial balance

Prepare a post-closing trial balance as at the end of June.

Information related to above question is enclosed below:

Attachment:- excel.rar

Reference no: EM131861677

Questions Cloud

Pessimistic about the future for an extended period : When an economy dips unto a recession, consumers will often be relatively pessimistic about the future for an extended period of time
Possibly affect our international business : Discuss the political risk factors, and identify those that could possibly affect our international business.
Form of government assistance fundamentally : How is this form of government assistance fundamentally different from conventional welfare programs? In your opinion, does one present a greater moral hazard?
Why aggregate income and aggregate production are equal : Explain why aggregate income and aggregate production are equal.
Create a schedule of accounts receivable balances : Please complete following questions in excel, and putting answers in the worksheet (in excel). Create a schedule of accounts receivable balances.
Interest rate if the government decreases : Using the market for loanable funds (draw the graphs for yourself) Explain what happens to:
Explain the actions of the fed in regard to the three tools : Explain the actions of the Fed in regard to the three tools. Buying or selling government securities when conducting expansionary monetary policy.
Managers and for policymakers : Explain why a crisp definition of a "barrier to entry" is useful for managers and for policymakers.
Impose a martial law and to restrict movement : Indicate if the long run growth of real GDP is likely to increase or decrease. Ceteris Paribus means all else constant.

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