Do the adjusting journal entry

Assignment Help Managerial Accounting
Reference no: EM132277089

Problem Set A

Copeland Company had the following account balances at December 31, 2016, before recording bad debt expense for the year:

Unadjusted Trial Balance

Accounts receivable
$1,400,000
Allowance for uncollectible accounts (credit balance) 22,000
Credit sales for 2016
1,950,000
Ending 12/31/2015

Balance in Accounts receivable on 1/1/2016
$1,200,000
Balance in Allowance for uncollectible accounts (credit balance) on 1/1/2016             24,000

Copeland is considering the following approaches for estimating bad debts for 2016:
Option A: Based on 3% of credit sales
Option B: Based on an aging of year-end accounts receivable

Days Amount Outstanding Estimated % Uncollectible
0-30 $800,000 3%
31-60 300,000 6%
61-120 200,000 9%
Over 120  100,000 24%

$1,400,000

REQUIRED:

1 Do the adjusting journal entry under Option A and Option B.

2 What amounts would be reported on the 12/31/2016 financial statements related to Accounts Receivable under Option A and Option B?
Make sure to include the effect on the Income Statement, Balance Sheet and Statement of Cash Flows (under the Direct AND Indirect Method), and the Statement of Stockholders' Equity.

3 What is the difference in accounts receivable turnover and the credit risk ratio under Option A v. Option B?

4 Which option may management prefer? Which option may shareholders or regulators prefer? Please discuss

Problem Set B

You are the accountant for Madie Corporation, a manufacturer of jets.

On January 1, 2013 Madie Corporation sold a new Lear Jet to a customer, Animal, Inc.

Animal, Inc. did not have the cash upfront and therefore opted to issue a note to Madie Corporation as payment for the jet.

The note contained terms for Animal, Inc. (the customer) to pay interest semiannually on June 30 and December 31.

Portions of the amortization schedule appear below:

Payment Cash Interest Payment Effective Interest Discount or Premium Amortization Carrying Value




6,627,273
1 320,000 331,364 11,364 6,638,637
2 320,000 331,932 11,932 6,650,569
3 320,000 332,528 12,528 6,663,097
4 320,000 333,155 13,155 6,676,252
5 320,000 333,813 13,813 6,690,065
6 320,000 334,503 14,503 6,704,568
- - - - -
- - - - -
- - - - -
38 320,000 389,107 69,107 7,851,247
39 320,000 392,562 72,562 7,923,809
40 320,000 396,191 76,191 8,000,000

REQUIRED:

1. What is the face value of the note?

2. What was the initial selling price of the Lear Jet?

3. Did the note indicate a premium or discount?

4. What is the term to maturity in years?

5. What is the stated annual interest rate?

6. What is the effective (market) annual interest rate?

7. Do the journal entry for the note received by Madie Corporation on January 1, 2013.

8. Do the journal entry for the first interest payment received on June 30, 2013.

9. Assuming Madie Corporation's fiscal year end is September 30, do the adjusting journal entry for September 30, 2013.

10. If the customer repaid the note at 95 on January 1, 2016 (after the recording and payment of interest on December 31, 2015), would Madie record a gain or loss?

Attachment:- Excel Assignment.rar

Verified Expert

The task is about excel workbook problem where two problem set have been solved, in Problem set A - Journal entries, accounts receivable turnover and the credit risk ratio have been solved. In Problem set B – ten different questions related to company has been solved.

Reference no: EM132277089

Questions Cloud

How current dtgov infrastructure could be replicated : Explain the types of Cloud Architectures that you think would be useful for DTGOV to use as part of their webserver infrastructure in the Cloud.
Discuss the application of accountable care organizations : Prepare a three-page essay that discusses review of literature related to accountable care organizations (ACOs) in a health care facility (hospital)
Explain the effect of increase in government expenditure : Explain the effect of increase in government expenditure with reference to "crowd out" effect in IS-LM framework
Write functions of each layer of osi reference model : Write functions of each layer of OSI reference model, also differentiate between hardware and software layers. Explain your view; why Network layer of OSI model
Do the adjusting journal entry : What is the difference in accounts receivable turnover and the credit risk ratio under Option A v. Option B - Which option may management prefer
Response on the art of self-reflective process : Post your response on the art of self-reflective process based on new learning from: Effective Supervision and Evaluation: The Self-Reflective Process
Explain ethical hacking from a christian worldview : Port scanning and enumeration are one of the key steps of ethical hacking. Do you think ethical hacking can be morally justified from a Christian worldview?
Summarize the mitigating strategies you would recommend : Summarize the mitigating strategies you would recommend to your CEO that affirm the organization's privacy and security practice among social network sites.
New technology to attain competitive advantage : How are they impletementing this new technology to attain (obtain) competitive advantage while sustaining (keeping) competitive advantage

Reviews

len2277089

4/8/2019 12:54:15 AM

Please answer the excel workbook problem. The instruction are attached to the files section and the others are attached to this message below: Accounts Receivable and Calculating Bad Debt Expense (30 points-graded for accuracy and format, including Excel spreadsheet links). Notes Receivable (20 points-graded for accuracy).

Write a Review

Managerial Accounting Questions & Answers

  Why are separate price and quantity variances computed

What is meant by the term management by exception? Why are separate price and quantity variances computed? Who is generally responsible for the materials price variance? The materials quantity variance?

  A petty cash fund

Morris Company established a petty cash fund with a $400 balance

  The annual sales budget shows forecasts

The annual sales budget shows forecasts for the different products and their expected selling price per unit as follows:

  Determine the contribution margin at the break-even point

Calculate the break-even point in dollars and Break-even point fares and determine the contribution margin at the break-even point.

  Find net present value and internal rate of return

Calculate net present value (NPV), internal rate of return (IRR), and payback for the investment opportunity What information will you and your staff need to analyze this investment opportunity - how will you go about making the decision?

  Why might it be easier for an investor desiring to diversify

Why might it be easier for an investor desiring to diversify his portfolio internationally to buy depository receipts rather than the actual shares of the company?

  Adjusted trial balance to prepare the income statement

Adjusted trial balance to prepare the income statement for the year ended December 31, 2011 and the statement of owner's equity for the year ended December 31, 2011

  Which is preferable: a single overhead rate

Which is preferable: a single overhead rate or separate rates by production department?Explain.

  Designing reports for a responsibility accounting system

List five important factors that should be considered in designing reports for a responsibility accounting system.

  Classify each of these transactions as an operating

For purposes of the statement of cash flow, classify each of these transactions as an operating, investing, or financing activity. Additionally, indicate whether the activity is a source of cash or a use of cash.

  What is the predetermined overhead allocation rate

The cost of direct labor is $40 per hour. What is the predetermined overhead allocation rate for FooRah

  What would be the benefit to the firm of gaining

Focusing only on the Model C210 chisel and the model D400 chisel, what would be the benefit to the firm of gaining one more hour of production time in coating and sharpening?

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