Prepare modupes statement of cash flows

Assignment Help Finance Basics
Reference no: EM133114054 , Length: word count:480

Case Scenario - Modupe

Modupe runs a manufacturing business. Some of her products are manufactured under a licence which was granted on 1 January 20X2. Modupe paid £10,000 for the licence which runs for five years. She is amortising the cost of the licence at the rate of 20 per cent each year for five years.

On 1 March 20X4, Modupe bought a new machine for £18,000. The machine replaced another machine which had been fully depreciated, and which was scrapped on 28 February 20X4. Machinery and most other non-current assets are depreciated on a straight-line basis over 10 years.

There were no other purchases or sales of non-current assets.

Modupe tells you, her financial adviser, that she is worried that the cash at bank figure has fallen by such a large amount since the start of her financial year. She wonders if she should have made the investment in buying a new machine.

Modupe's statement of profit or loss for the year ended 31 May 20X4 was as follows:

                                                                                      £                              £

Revenue

 

 

3,777,242

Cost of sales

 

 

 

Opening inventory 

303,638

 

 

Add: goods manufactured

3,006,162

 

 

 

3,309,800

 

 

Less: closing inventory

(314,447)

 

 

 

 

 

(2,995,353)

Gross profit

 

 

781,889

Expenses

 

 

(885,960)

Interest paid

 

 

(5,000)

Loss for the year

 

 

 

Depreciation of £57,756 is included in expenses. Depreciation of £107,775 is included in cost of goods manufactured. This includes the amount charged to depreciation in respect of the new machine. Amortisation of £2,000 in respect of the patent is also included in cost of goods manufactured.

Modupe's statements of financial position at 31 May 20X4 and 20X3 were as follows:

 

                                                       20X4

20X4

20X3

20X3 

                                                          £

£

£

£

 

 

ASSETS

 

 

 

 

Non-current assets

 

1,745,500

 

1,895,031

 

 

 

 

 

Current assets

 

 

 

 

Inventory

314,447

 

303,638

 

Receivables 

484,393

 

455,660

 

Cash at bank

2,880

 

37,446

 

 

 

  801,720   796,744  

 

2,547,220

 

37,446

 

CAPITAL AND LIABILITIES

 

 

 

 

Capital

 

 

 

 

Capital brought forward

 

2,169,331

 

2,198,061

(Loss)/profit for the year

 

(109,071)

 

1,270

Drawings

 

(96,000)

 

(30,000)

 

 

 

 

 

 

 

CAPITAL AND LIABILITIES

 

 

 

 

Capital

 

 

 

 

Capital brought forward

 

2,169,331

 

2,198,061

(Loss)/profit for the year

 

(109,071)

 

1,270

Drawings

 

(96,000)

 

(30,000)

 

 

 

1,964,260

 

2,169,331

Non-current liabilities

 

 

 

 

Long-term loan

 

150,000

 

142,000

 

 

 

 

 

Current liabilities

 

 

 

 

Payables

 

432,960

 

380,444

 

 

 

 

 

 

 

2,547,220

 

2,691,775

Question 1: Prepare Modupe's statement of cash flows for the year ended 31 May 20X4.

Question 2: Write a brief report to Modupe explaining the reasons why the cash at bank balance has fallen during the year. Advise her on any actions she could take to improve the cash position.

 

Reference no: EM133114054

Questions Cloud

Advice on taxes, banking and financing : He wants to know about the various types of taxes he might have to consider and the various banking and corporate services and products that are available
How much materials cost was assigned to units transferred : How much materials cost was assigned to the units transferred out of the Weather Proofing Department during April
A budget cash flow statement for the three months : A budget cash flow statement for the three months of January, February and March 20X4 and a budget statement of profit or loss for the three months ending
Prepare the cash flows from operating activities section : Staley Inc. reported the following data: Prepare the Cash Flows from Operating Activities section of the statement of cash flows, using the indirect method
Prepare modupes statement of cash flows : Prepare Modupe's statement of cash flows for the year ended 31 May 20X4 and Advise her on any actions she could take to improve the cash position
How will the tax authority decision affect after-tax cost : How will the tax authority's decision affect the after-tax cost of the kiln? The tax rate is 25%, and the opportunity cost of capital is 5%
Calculate his gross and net profit margins : Calculate his gross and net profit margins and Write a brief report - Wazir would like you to explain to him the impact of these events on his business
Prepare the statement of financial position at 30 June 20X3 : Prepare the statement of financial position at 30 June 20X3 and Discuss Hien's cash position. Is there any other information which might be useful to you
What is its net income : Precious Metal Mining has $14 million in sales, its ROE is 18%, and its total assets turnover is 2.5×. What is its net income

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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