Calculate Statement of Cash flows

Assignment Help Financial Management
Reference no: EM133134876

PREPARING THE FINANCIAL STATEMENTS

Thank you for submitting your advice regarding sources of finance. Your client has carefully considered your advice in setting up the new business. As you will see below, the client may have acted on all, some or none of your advice. That is the nature of being a consultant. Nevertheless, the client is happy with the advice you offered and seeks further assistance from you.

As the client looked further into the feasibility of the new business, it soon became clear that there was much more demand than previously realised, and immediate plans were made to increase the size of the operation. This meant raising significant amounts of capital, and it was felt that this would be difficult as a private company. It was therefore decided to set up a public company.

New Business Name: Anoushka Enterprises Ltd

The new business commenced operations on 31 December 2020. It is now just over one year later - the middle of January 2022. Your client has asked you for assistance in preparing financial statements.

Your task: Prepare the following financial statements, based on the information below.
1. Balance Sheet as at 31 December 2020.
2. Profit and Loss Statement for the year ending 31 December 2021.
3. Balance Sheet as at 31 December 2021.
4. Statement of Cash Flows for the year ending 31 December 2021.

Financial Information: The company was initially set up by issuing 200,000 shares at an issue price of $1 each.
A factory was purchased at a cost of $530,000.
The new factory was largely financed by taking out a $472,000 mortgage loan.

The company was initially set up by issuing 200,000 shares at an issue price of $1 each. A factory was purchased at a cost of $530,000.
The new factory was largely financed by taking out a $472,000 mortgage loan.
In addition to the mortgage loan, the company took out a $562,000 interest-only unsecured bank loan. In addition to the factory, the company purchased the following:
Plant and Equipment to the value of $270,000.
Furniture, Fixtures and Fittings to the value of $120,000.
Inventory to the value of $196,000.
All of the above transactions occurred late in December 2020.
Any cash remaining after these purchases was put into a bank account.
On 1 March 2021, the company took out a bank overdraft. The outstanding balance on 31 December 2021 was $35,000. (This is to be recorded separately from the cash balance rather than combined.)
On 1 July 2021, motor vehicles to the value of $100,000 were purchased.
On 31 December 2021, the company issued corporate bonds to the value of $710,000, and used the proceeds to purchase an additional factory costing $710,000.
On 31 December 2021, the company issued 73,000 new ordinary shares at a price of $2 each and 129,000 new preference shares at a price of $1 each. Some of the amount raised was used to buy additional plant and equipment for the new factory at a cost of $230,000.
During the course of the year ending 31 December 2021, the following transactions occurred:

During the course of the year ending 31 December 2021, the following transactions occurred:
Products to the value of $2,098,000 were sold and delivered. These sales were made on the basis of one month's credit. Of the $2,098,000 in sales occurring in 2021, products to the value of $147,000 were delivered in December 2021 and will not be paid for until January 2022.
Raw materials to the value of $1,196,000 were ordered and taken delivery of. These purchases were made on the basis of one month's credit. Of the $1,196,000 in raw materials purchased in 2021, raw materials to the value of $104,000 were ordered and taken delivery of in December 2021 and will not be paid for until January 2022.
Payment of Wages ($138,000).
Payment of Rent ($85,000).
Payment of Motor Vehicle Running Expenses ($42,000). Payment of Insurance ($39,000).
Payment of Interest ($52,000).
Payment for Printing & Stationery ($25,000).
Payment for Heating and Lighting ($24,000).
Payment for Telephone, Postage and Internet Charges ($15,000).
Further, an additional $55,000 was paid in December forJanuary's rent.
In addition to the above interest payment, the principal owing on the mortgage loan was reduced by $32,000.

In addition to the above interest payment, the principal owing on the mortgage loan was reduced by $32,000.
The value of inventory on 31 December 2021 was $220,000.

Additional Information: Depreciation on motor vehicles, plant and equipment and furniture, fixtures and fittings is calculated on a straight-line basis at the rate of 10% per year. Land and Buildings is not depreciated.

Instructions: The company faces a tax rate of 40%. The company's Dividend Payout Ratio is 55%.

Complete the boxes in the "Part 2 (A) to (D)" tabs, save this file and upload it as your submission. You do not need to complete every cell in those tabs. Complete as many cells as you need to construct the various financial statements. Enter whole numbers, in thousands of dollars (i.e. round off numbers to the nearest whole number of thousands of dollars).

Calculate these for Anoushka Enterprises Ltd

a) Balance sheet as at 31 december 2020

b) Profit and loss statement for the year ending 31 December 2021

c) Statement of Cash flows for the year ending 31 December 2021

d) Balance sheet as at 31 december 2021

Reference no: EM133134876

Questions Cloud

Kind of economic system was put in place in venezuela : Under Chavez's leadership, what kind of economic system was put in place in Venezuela? How would you characterize the political system?
What is the depreciation expense in the year of purchase : The business's year-end is December 31. Cost of equipment = 149000 and Residual value = 17000. What is the depreciation expense in the year of purchase
Explain the workflow of maryam company : Explain the workflow of Maryam Company by defining outputs, required activities and inputs
Commitment to occupational safety and health : Three actions upper management can take to demonstrate their commitment to Occupational Safety and health to other members of the organization
Calculate Statement of Cash flows : Profit and loss statement for the year ending 31 December 2021 and Statement of Cash flows for the year ending 31 December 2021
What are the functions of human resources : What are the functions of Human Resources? What HR services are used?
Represent financial opportunities for providers : How do participation contracts represent financial opportunities for providers?
How much did she have in december : Dr. Sisters has been secretly depositing $3,200 in her savings account every December starting in 2001. How much did she have in December 2008
Conventional hrm we use tools of hrm : In conventional HRM we use tools of HRM in same way on every organization while in SHRM we use such tool and matrix which are important for organizational goal

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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