Financial analysis measures

Assignment Help Accounting Basics
Reference no: EM13843685

Bring together various financial analysis measures and interpret their meaning in order to draw conclusions about various companies.

Note that each situation provided is to be considered independently of the others.

Situation A: The following tables represent selected data from recent financial statements of Lincoln and Samuelson, Inc. (dollars in thousands of dollars):

Problem 3, Table 1: Lincoln and Samuelson, Inc. Selected Items from Balance Sheets

Assets (in thousands)

December 31, 2012

December 31, 2011

Current assets: Cash and cash equivalents

$4,000

$3,400

Accounts receivable (net of allowances of $32 and $28, respectively)

$6,500

$5,700

Selected Income Statement Data for the Year Ended December 31

Problem 3, Table 2: Lincoln and Samuelson, Inc. Selected Income Statement Data

Account

2012

2011

2010

Net sales (in millions)

$6,020

$5,425

$5,000

Net income (in millions)

$300

$285

$220

The company also reported bad debt expense of $62,000 in 2012; $55,000 in 2011; and $49,500 in 2010.

Using the data provided, complete the following for Lincoln and Samuelson, Inc.:

1. Compute the dollar amount of uncollectible accounts receivable that the company wrote off as uncollectible in 2012. Show all of your work.

2. Assuming all sales were on credit, what amount of cash did the company collect on accounts receivable in 2012? Show all of your work.

3. Compute the company's net profit margin for the three years presented. What does the trend suggest to you about the company?

Situation B: The Israel Manners Entertainment Group uses the allowance approach to estimate bad debt expense, as is required of all companies with significant sales on accounts receivable. At the end of 2012, the Manners Group reported a balance in accounts receivable of $4,350,000 and estimated that $44,000 of its accounts receivable would likely be uncollectible. The allowance for doubtful accounts has a $1,500 debit balance at year-end, prior to the adjustment needed to raise it to the $44,000 desired amount. Use this information to answer the following questions:

4. How is it possible that the allowance for doubtful accounts has developed a debit balance instead of a credit balance?

5. What amount of bad debt expense should be recorded for 2012?

6. What amount will be reported on the 2012 balance sheet as the net realizable amount of accounts receivable?

Situation C: At the end of 2012, the unadjusted trial balance of Donovan, Inc. included $6,000,000 in accounts receivable, a credit balance of $50,000 in the allowance for doubtful accounts, and sales revenue (all on credit) of $200,000,000. Based on knowledge that the current economy is in distress, Donovan increased its bad debt rate estimate to 0.4 percent on credit sales. Use this information to answer the following:

7. What amount of bad debt expense should be recorded for 2012?

8. What amount will be reported on the 2012 balance sheet for the net realizable amount of accounts receivable, after being reduced by the balance in the allowance for uncollectible accounts?

Situation D:BrightStar Company reported the following inventory records for June, 2012:

Problem 3, Table 3: BrightStar Company Inventory Records

Date

Activity

# of Units

Cost/Unit

June 1

Beginning balance

200

$40

June 5

Purchase

600

$42

June 8

Sale @ $100 per unit

500


June 17

Purchase

400

$45

June 23

Sale @ $100 per unit

500


Selling, administrative, and depreciation expenses for the month were $20,000. BrightStar's tax rate is 35 percent. Use this information and the table above to complete the following:

9. Calculate the cost of ending inventory and the cost of goods sold under each of the following methods:

1. First-in, first-out.

2. Last-in, first-out.

3. Weighted average.

10. Using your answers from question 1 above, answer the following:

1. What is the gross profit percentage under the FIFO Method?

2. What is net income under the LIFO method?

3. Which method would you recommend to BrightStar for tax purposes? Explain your recommendation.

4. If BrightStar also used the method that you recommended for tax purposes on its balance sheet, would BrightStar's current ratio suffer, compared to the use of FIFO?

11. BrightStar uses the lower of FIFO cost or market method to value its inventory for reporting purposes at the end of the month. If inventory had a market replacement value of $44 per unit, what would BrightStar report in its balance sheet for inventory? Why?

Situation E:BlackBurn Company purchased the following on January 1, 2012:

  • Office Equipment at a cost of $100,000 with an estimated useful life to the company of five years and a residual value of $10,000. The company uses the double-declining-balance method of depreciation for the equipment.
  • Factory equipment at an invoice price of $780,000 plus shipping costs of $20,000. The equipment has an estimated useful life of 100,000 hours and no residual value. The company uses the units-of-production method of depreciation for the equipment.
  • A patent at a cost of $450,000 with an estimated useful life of 15 years. The company uses the straight-line method of amortization for intangible assets with no residual value.

Use the information above to complete the following:

15. Prepare a partial depreciation schedule for 2012, 2013, and 2014 for the following assets. Round your answers to the nearest dollar.

1. Office equipment.

2. Factory equipment. The company used the equipment for 8,000 hours in 2012; 9,000 hours in 2013; and 8,500 hours in 2014.

16. On January 1, 2014, BlackBurn altered its corporate strategy dramatically. The company sold the factory equipment for $700,000 in cash. Record the entry related to the sale of the factory equipment.

17. On January 1, 2014, when the company changed its corporate strategy, its patent had estimated future cash flows of $300,000 and a fair value of $250,000. What would the company report on the income statement (account and amount) regarding the patent on January 2, 2014? Explain your answer. Hint: You may need to research this question using Internet sources.

Reference no: EM13843685

Questions Cloud

Write code in vba to determine the row number : Write code in VBA to determine the row number of the last row with data. Are there any precautions/edge cases to be aware of for that code
Contrast differences in accounting processes and procedure : contrast the differences in accounting processes and procedures
Write a prolog program to solve the water jugs problem : Write a Prolog program to solve the water jugs problem: There are two jugs, one holding 3 and the other 5 litres of water. A number of things can be done with the jugs: they can be filled, emptied, and dumped one into the other either until the pou..
Suppose that daily demand for bagels at the local coffee : Suppose that daily demand for bagels at the local coffee shop where you work is found to be Normally distributed with a mean of 250 and a standard deviation of 75 units
Financial analysis measures : Bring together various financial analysis measures and interpret their meaning in order to draw conclusions about various companies. Note that each situation provided is to be considered independently of the others.
Most widely associated with workers'' compensation : Summarize briefly the problems most widely associated with workers' compensation. What does the insurance industry use Experience Modification Rate (EMR) to determine?
Ethical issue: reclassification of receivables : Reclassification of Receivables
What is the delphi method in operations management : What is the delphi method in operations management? Can you please explain how the delphi method works?
Which of the following is a contra receivable account? : Which of the following is a contra receivable account?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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