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

  Prepare a summary journal entry to record factory

Prepare a summary journal entry to record factory labor used - During January, its first month of operations, Knox Company accumulated

  What should be the overall effect on the companys monthly

What should be the overall effect on the company's monthly net operating income of this change - The sole product of Mav corp is priced at $200 per unit

  Describing activity-based costing

What is generally true regarding overhead allocation to high-volume products versus low-volume products under the traditional costing system?

  Cost of goods manufactured-cost of goods sold

During the year, the company purchased $100,000 of raw material and spent $340,000 on direct labor. Other data: Manufacturing overhead incurred $450,000; sales, $1,560,000; selling and administrative expenses, $90,000; income tax rate, 30%.

  Alfonza incorporated presents its statement of cash flows

Alfonza Incorporated presents its statement of cash flows using the indirect method.

  Prepare a summary journal entry to record raw materials

Prepare a summary journal entry to record raw materials used - In January, Knox Company requisitions raw materials for production

  What are the cash collections budgeted for june

What are the cash collections budgeted for June?A) $150,500B) $193,500C) $123,500D) $204,000

  Determine whether dawson company should drop any game

Determine whether Dawson Company should drop any game and write a memo to the manager with your recommendation.

  Identifies and explains the strong points of the managers

Identifies and explains the strong points of the managers. Identifies and explains areas in which improvements are needed. Analyzes the basic legal, social, and economic environment in which the organizations operate.

  What measures of performance should the company

Identify three of the most successful companies or organizations today, in your opinion. Explain why they are so successful

  Prepare a scatter graph of loan processing cost

Estimate total profit in a month when 275 loans are processed. (Round to the nearest dollar.)

  The two opposing forces- cost reduction and adaption

The two opposing forces- cost reduction and adaption to local markets- that firms face when entering international markets

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