Prepare a complete cash flow statement using indirect method

Assignment Help Cost Accounting
Reference no: EM131320190

For your Assignment, you will apply the fundamental concepts of accounting and finance that you are studying to complete several problems indicative to real-world business scenarios and challenges. For this Assignment, there will be two questions to answer. Both questions should be submitted together as one document.

Question1:

XYZ Ltd. is a group of doctors, dentists, professional sports players and celebrities with excess funds who wish to find small companies with great innovative ideas and invest in them. Several of the small companies present their idea to XYZ under a televised show broadcasted on national TV.

The following information has been derived from 3 years' financial statements of ABC Ltd., one of the small companies looking for investment from XYZ.

Balance Sheets, December 31

2015 2014 2013

Current assets

Cash 50,000 45,000 94,000

Account receivable, net 130,000 120,000 110,000

Merchandise inventories 250,000 230,000 195,000

Other current assets 45,000 53,000 42,000

Total current assets 475,000 448,000 441,000

Property, plant & equipment, net 196,000 191,000 175,000

Total assets 671,000 639,000 616,000

Current liabilities

Accounts payable 175,000 195,000 185,000

Accrued liabilities 1,000 6,500 21,000

Total current liabilities 176,000 201,500 206,000

Long-term liabilities 230,000 250,000 295,000

Total liabilities 406,000 451,500 501,000

Shareholders' equity

Common shares 110,000 95,000 65,000

Preferred shares, note 5 25,000 25,000 25,000

Retained earnings 130,000 67,500 25,000

Total shareholders' equity 265,000 187,500 115,000

Total liabilities and shareholders' equity 671,000 639,000 616,000

Income statements 2015 2014

Net sales £723,700 £694,000

Cost of goods sold 347,350 344,500

Gross margin 376,350 349,500

Operating expenses 183,500 179,750

Income from operations 192,850 169,750

Interest expense 37,525 39,450

Income before income tax 155,325 130,300

Income tax expense 38,831 32,575

Net income £116,494 £97,725

Additional information:

The common shares are traded on the stock exchange. At the end of 2015, the value of the share was £15.00, and at the end of 2014, the value per share was £14.00.

The number of shares outstanding on the market is as follows:

2015: 25,000

2014: 15,000

2013: 10,000

All sales are made on credit.

The company's income tax rate is 25%.

The preferred shares are cumulative, no par value, £2.50, 10,000 shares authorised and 2,000 shares issued and outstanding.

To answer this question:

Assume that you, the consultant, have been hired by XYZ to assist in the analysis of the financial statements and provide a recommendation whether XYZ should invest or not invest in this company. Justify your recommendation based on the calculation of the following financial ratios:

Current ratio (liquidity)

Operating profit margin (profitability)

ROSF (profitability)

Average settlement period for trade receivables (efficiency)

Earnings per share (investment)

Question 2:

Bulls Corporation has a December 31 fiscal year end. The controller of the company is currently completing the financial statements of the company in order to present them at the next board meeting. He completed most of the work but did not get around to finishing the cash flow statement. He gives you the following financial information in order for you to help him with the preparation of the cash flows.

Balance Sheet 2015 2014

Cash £38,500 £8,000

Accounts receivable, net 20,000 29,500

Merchandise inventory 37,000 38,000

Prepaid insurance 9,500 15,000

Land 54,500 40,600

Equipment, at cost 104,500 90,700

Less: accumulated amortisation (30,500) (15,500)

Patent 49,000 53,200

Total assets £282,500 £259,500

Accounts payable £ 58,500 £ 42,000

Income taxes payable 16,500 11,500

Advertising payable 5,000 -

Dividends payable 40,000 10,000

Notes payable 40,000 83,000

Share capital 93,000 78,500

Retained earnings 29,500 34,500

Total liabilities and shareholders' equity £282,500 £259,500

Sales £1,090,000
Cost of goods sold 672,000
Gross profit 418,000
Operating expense
Salaries expense 195,000
Advertising expense 35,000
Rent expense 67,500
Insurance expense 34,500
Amortisation expense 25,000
Total operating expenses 357,000

Income from operations 61,000
Interest expense 2,500
Gain on sale of equipment 7,500
Income before income taxes 66,000
Income tax expense 4,000
Net income £62,000

Additional information:

Bulls Corp. purchased equipment for £36,300 in cash during the year.

Bulls Corp. sold equipment for cash during the year.

No patent has been purchased nor sold in the year.

Accounts payable relates solely to transactions with suppliers for inventory.

To answer this question

Prepare a complete cash flow statement using the indirect method for the 2015 fiscal year.

Compute the following amounts:

Cash collected from clients during the year.

Cash paid for advertising expense.

Cash paid to suppliers for inventory.

Reference no: EM131320190

Questions Cloud

What is the criterion for a material to be a good conductor : Give two examples of materials that behave as good conductors for frequencies of up to several gigahertz.
Examine your healthcare organization swot analysis : For this discussion, you will obtain information for the Marketing Mix section of your Final Project. Specifically, you will focus on your chosen HCO's marketing opportunities and goals. In addition, examine your healthcare organization's SWOT ana..
Discusses how your classroom is arranged and not decorated : This section discusses how your classroom is arranged, not decorated. Décor is certainly acceptable, but the focus should be on the physical arrangement. Example should be pictorial.
How might creative expression be helpful to people : What was the overall emotional and intellectual effect the performance or artwork had on you? What emotions did you feel? Of what did the experience make you think?Write a summary of how you would like to see the arts made more a part of your com..
Prepare a complete cash flow statement using indirect method : Prepare a complete cash flow statement using the indirect method for the 2015 fiscal year - Compute the amounts - Cash collected from clients during the year and Cash paid for advertising expense.
What is the intrinsic impedance of a material medium : Discuss the consequence of the frequency dependence of the phase velocity of a wave in a material medium.
Reflect on your findings for curriculum design : In an essay of 1,000-1,250 words, reflect on your findings and the implications for curriculum design and social studies instruction in meeting today's standards.
Explain the hiring decision process : What do you feel are the most important assessment methods to use and why? Should internal candidates be assessed first? Explain the hiring decision process between the recruiter and the hiring manager
What is the propagation constant for a material medium : What is the propagation constant for a material medium? Discuss the significance of its real and imaginary parts.

Reviews

Write a Review

 

Cost Accounting Questions & Answers

  Calculate the target cost for expanding the market share

Calculate the target cost for expanding the market share by 20 percent, assuming that the per-unit profitability is maintained as requested by the CEO.

  Case concerning volume-based costing versus activity-based

case concerning volume-based costing versus activity-based costingcoffee bean inc. cbi processes and distributes a

  Explain how cvp analysis may be helpful in evaluating

Explain how full-absorption costing can be abused by management to misstate financial results and Explain how CVP analysis may be helpful in evaluating whether it will be smart to buy a new machine that would reduce labor costs by 60%.

  Calculate interest revenue on notes receivable

Calculate interest revenue on notes receivable

  As of january 1 2011 survival industries inc brought a boat

as of january 1 2011 survival industries inc. brought a boat at a cost of 360000.when purchased the corporation was

  What is the amount of ending finished goods inventory

In most organizations, customer satisfaction is one of the top priorities. As such, attention to customers is necessary for success. Briefly describe the four types of demands customers are currently placing on organizational performance.

  Explain the weakness in internal control

Explain the weakness in internal control and identify the control principle that is violated and suggest a change in the procedure that will result in good internal control.

  What is the cost of the asset being depreciated

What is the cost of the asset being depreciated? What amount, if any, was used in the depreciation calculations for the salvage value for this asset? Which method will produce the highest charge to income in Year 1?

  How do changes in volume affect the break-even point

How do changes in volume affect the break-even point and what important information is conveyed by the margin of safety calculations in CVP analysis?

  Base your answer on the data from paxton inc for marchnbsp

base your answer on the data from paxton inc. for march.nbsp paxton uses the average costing method.paxton inc. for

  Part of the budgeting process

An often used approach to budgeting that simply derives the new year's bud get from the current year's budget is called - Which of the following steps would not usually be part of the budgeting process?

  A current and long-term liability

On January 1, 2007, Didde Co. leased a building to Ellis Corp. for a ten-year term at an annual rental of $80,000. At inception of the lease, Didde received $320,000 covering the first two years' rent of $160,000 and a security deposit of $160..

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