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

Valuing callable bonds, Valuing Callable Bonds: Bowdeen Manufacturing i...

Valuing Callable Bonds: Bowdeen Manufacturing intends to issue callable, perpetual bonds with annual coupon payments. The bonds are callable at $1,350. One-year interest rates

The paper Contemporary Issues in International Accounting, Requirements: P...

Requirements: Part I Access the IFRS and the Generally Accepted Accounting Principles (GAAP) of your country. a. Note ten differences between the two sets of GAAP. Part II Ac

Journalize the transaction, received 16,000 contribution in exchange for co...

received 16,000 contribution in exchange for common stock

Explain the term - providing a service, Explain the term - Providing a serv...

Explain the term - Providing a service One way of viewing accounting is as a form of service. Accountants provide economic information to their 'clients', who are numerous user

When youre using accounting software, when youre using accounting software ...

when youre using accounting software why would you use hot keys and shortcuts a.to quickly access commands b.to input data for you c.to start the program d.to write checks

Business, #Which of the two ratios are the greatest? 1.67.1 or 0.29.1

#Which of the two ratios are the greatest? 1.67.1 or 0.29.1

Determine the basis of the ultimate cost of the payment, Given information:...

Given information: Offered a $20 million commercial loan priced using a 3month LIBOR index+100bp. After some preliminary research, using a money center bank's swap trading desk

Absorption costing, Absorption costing is a cost accounting method that ...

Absorption costing is a cost accounting method that tries to charge all direct costs and all production costs of an organization to specific units of pr

Financial ratio analysis, Financial ratio analysis Financial rati...

Financial ratio analysis Financial ratio analysis is a statistical tool that measures the relationship between two financial figures. It 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