Financial accounting , Financial Accounting

Assignment Help:

a. Create a worksheet in your excel file and name it "Part A Q2". In column A to E set up general journal and input the necessary journal entries to record the transactions and events listed above. Explanations (narrations) for your journal entries are required. Copy it to the word document.

Clearly show all supporting calculations in the columns to the right of the journal entries.  Leave column G empty and input the heading "Calculations area:" in cell H2.  Perform all calculations in this area of the worksheet.  Show the calculations in narrative form in the cell next to the cell containing the formula (e.g. "(=$20,000*0.08=$1,600)").  Calculations should be rounded to the nearest cent (i.e. to two decimal places). Copy all the calculations to the word document.

b.  Based on the transaction on 5th January 2010, do you think that the bad debt estimation was correct in 2009?  Record your answer in word file.

c.  In the rows below your journal, create a running balance ledger account. Prepare the account for Allowance for Bad Debts. To arrive at closing you must use the formula and these formulae will be checked. Copy it to the word document.

d.  What closing balance of Allowance for Bad Debts you have arrived at? Is this balance equal to 2% of net credit sales? Why or why not? Give explanations. Record your answer in word document.

e.  In the rows below the running balance ledger account, provide an extract from the balance sheet for the end of December 2010, showing how the assets from the transactions above would be reported under the Current Assets heading in the balance sheet. Copy it to the word document.


Related Discussions:- Financial accounting

Create a trial balance and income statement, Create a Trial Balance and Inc...

Create a Trial Balance and Income Statement Cash                                     $18,470    A/R                                         14,333                            A

Cashflows from operating activities-group activities, Cashflows from operat...

Cashflows from operating activities  operating activities are the principle revenue generating activities of the business and examples of such cashflows include: Cash re

Wilson wonders''s bonds, Wilson Wonders's bonds have 15 years remaining to ...

Wilson Wonders's bonds have 15 years remaining to maturity. Interest is paid yearly, the bonds have a $1,000 par value, and the coupon interest rate is 12%. The bonds sell at a pri

Determine the features of accounting information system, Determine the Feat...

Determine the Features of Accounting information system Accounting information system must have certain features which are common to all valid information systems within a bus

Explain forward loading with example, Q. Explain Forward loading with examp...

Q. Explain Forward loading with example? Terms may involve option to be issued with price to be determined based upon lowest price as of the issue date or for the subsequent 30

Prepare a statement of partnership liquidation, After discontinuing the ord...

After discontinuing the ordinary business operations and closing the accounts on May 7, the ledger of the partnership indicate the following: Cash $75,000 Non cash 105,000 Liabilit

Transactions affecting retained earnings, shown below in T-account format a...

shown below in T-account format are the changes affecting the retained earnings of Brenner-Jude Corporation during 2011. At January 1,2011, the corporation had outstanding 105 mill

National association of state boards of accountancy, National Association o...

National Association of State Boards of Accountancy - serves as a forum for 54 State Boards of Accountancy, that administer the uniform CPA examination, license Certified Public Ac

What is deferred taxation, Deferred taxation is caused by timing differenc...

Deferred taxation is caused by timing differences that arise when a transaction is recognized differently for accounting and tax purposes; for i.e, capital expenditure, that invol

Write Your Message!

Captcha
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