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

Cumulative and substitutional legacies and devises, Cumulative and substitu...

Cumulative and substitutional legacies and devises Where a will makes two gifts of unequal amounts to the same person, they are assumed, in the absence of a contrary indication

Choice of an appropriate discount rate, Choice of an appropriate discount r...

Choice of an appropriate discount rate The difficulty with selecting a discount rate rests on whether the correct rate for the risk/return has been derived. A number of things

Discuss limitations of ratio analysis, Question : Financial analysts wi...

Question : Financial analysts will use ratios to compare performance of companies in the same industry. Lenders will frequently use ratio analysis to help them decide whethe

Explain your findings and conclusion, When the stock market is going up ove...

When the stock market is going up over a long period of time, investors can become complacent about the risks of being a stockholder. After the significant decline of the stock mar

Cash budget, Beginning balance 24,000 cash Sales 250,000 Gross profit 45% o...

Beginning balance 24,000 cash Sales 250,000 Gross profit 45% of sales Accounts receivable increase by 24,000 Accounts payable increased by 51,000 Inventory increased by 98,000 Sell

Prepare journal entries to record liquidation transaction, Terry Marks is a...

Terry Marks is a well-known architect. He wants to start his own business and convinces Rob Norris, his cousin and a civil engineer, to contribute capital. Together, they form a pa

Explain about tax ramifications, Q. Explain about Tax Ramifications? i)...

Q. Explain about Tax Ramifications? i) Exercise price effects capital gains of individual and effects compensation expense used by corporation for calculating company's compens

Financial reporting, Describe Following questions:- Q.1 What organizatio...

Describe Following questions:- Q.1 What organizations are responsible for governing financial reporting? What is the role of each organization? How have the roles changed in the

First meeting of creditors-public examination, First Meeting of creditors ...

First Meeting of creditors The Official Receiver must convene this meeting within 60 days of the receiving order, unless the court extends the time, by giving notice to each c

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