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

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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