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

Holding company with more than one subsidiary company, Holding company with...

Holding company with more than one subsidiary company Under this type of structure, the holding company controls more than one company. For example H ltd may Own 80% of S1, 75%

Method of accounting for securities, Settlement Method - Method of ACCOUNTI...

Settlement Method - Method of ACCOUNTING for SECURITIES whereby transactions are recorded on the date securities settle by delivery or receipt of securities and receipt or payment

Prepare partial income statement through fifo and lifo , Prepare Partial In...

Prepare Partial Income Statement through FIFO, And LIFO Methods The records of XYZ Restaurant Supply include the following accounts for cases of coffee cups at December 31 of t

Determine the net cash provided by operating activities, Van Aalst Company'...

Van Aalst Company's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet

INTANGIBLE ASSETS, Baruch Lev, who is a professor of accounting at New York...

Baruch Lev, who is a professor of accounting at New York University and a globally known academic for his research on financial reporting for intangibles, is that the economy has c

Calculate current average cost of processing order, SF is a division of Sel...

SF is a division of Sell.com, an internet retailer. SF operates two large server farms, each of which is a set of interconnected computers and hard drives that are used to process

Correction of errors, How to treat them both which affect the trial balance...

How to treat them both which affect the trial balance and which dont affect the trial balance

Demostrate a labour-leisure trade-off model, Much of the supply-side, fisca...

Much of the supply-side, fiscally conservative economic policies of Margaret Thatcher, Ronald Reagan, and even Mike Harris in Ontario were predicated on the belief that high income

Users of accounting, How is Accounting information useful to A prospective ...

How is Accounting information useful to A prospective Investor?

Compute basic and diluted earnings per share, The following information was...

The following information was taken from the books and records of Ludwick, Inc.: 1. Net income $ 280,000 2. Capital structure: a. Convertible 6% bonds. Each of the 300, $1,000 bond

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