Reference no: EM133534201

Introduction to Accounting And Finance

ASSIGNMENT - BUSINESS SIMULATION

Your task in this Assignment is to act as a consultant to a hypothetical business. Periodically throughout the semester, the business will come to you with questions and problems and will seek your advice on a range of different matters associated with the business. You will make regular submissions which will comprise your advice to the client. You may find that sometimes the client will take your advice, while other times they may not. That is the nature of consulting. The nature of the tasks will closely follow the weekly topics in this subject.
Please read the Assignment instructions carefully on the LMS - in particular, submission requirements.

If you have general questions about how to approach the Assignment, please post them on the relevant Discussion Forum on the LMS, so that all students can benefit from the answers. If you have a question that relates to your personal circumstances, please use email.

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: Krupabahen Enterprises Ltd

The new business commenced operations on 31 December 2021. It is now just over one year later - the middle of January 2023. 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 2021.
2. Profit and Loss Statement for the year ending 31 December 2022.
3. Balance Sheet as at 31 December 2022.
4. Statement of Cash Flows for the year ending 31 December 2022.
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 $510,000.
The new factory was largely financed by taking out a $454,000 mortgage loan.
In addition to the mortgage loan, the company took out a $575,000 interest-only unsecured bank loan. In addition to the factory, the company purchased the following:
Plant and Equipment to the value of $290,000.
Furniture, Fixtures and Fittings to the value of $110,000.
Inventory to the value of $205,000.
All of the above transactions occurred late in December 2021.
Any cash remaining after these purchases was put into a bank account.
On 1 March 2022, the company took out a bank overdraft. The outstanding balance on 31 December 2022 was $38,000. (This is to be recorded separately from the cash balance rather than combined.)
On 1 July 2022, motor vehicles to the value of $100,000 were purchased.
On 31 December 2022, the company issued corporate bonds to the value of $700,000, and used the proceeds to purchase an additional factory costing $700,000.
On 31 December 2022, the company issued 97,000 new ordinary shares at a price of $2 each and 147,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 2022, the following transactions occurred:
Products to the value of $1,868,000 were sold and delivered. These sales were made on the basis of one month's credit. Of the $1,868,000 in sales occurring in 2022, products to the value of $112,000 were delivered in December 2022 and will not be paid for until January 2023.
Raw materials to the value of $1,102,000 were ordered and taken delivery of. These purchases were made on the basis of one month's credit. Of the $1,102,000 in raw materials purchased in 2022, raw materials to the value of $122,000 were ordered and taken delivery of in December 2022 and will not be paid for until January 2023.
Payment of Wages ($118,000).
Payment of Rent ($70,000).
Payment of Motor Vehicle Running Expenses ($40,000). Payment of Insurance ($34,000).
Payment of Interest ($51,000).
Payment for Printing & Stationery ($19,000).
Payment for Heating and Lighting ($21,000).
Payment for Telephone, Postage and Internet Charges ($13,000).
Further, an additional $47,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 $30,000.

The value of inventory on 31 December 2022 was $242,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.
The company faces a tax rate of 20%. The company's Dividend Payout Ratio is 60%.
Instructions: 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).

Question A: Krupabahen Enterprises Ltd - Prepare Balance Sheet as at 31 December 2021

Question B: Krupabahen Enterprises Ltd - Prepare Profit & Loss Statement for the year ending 31 December 2022

Question C: Krupabahen Enterprises Ltd - Prepare Statement of Cash Flows for the year ending 31 December 2022

Question D: Krupabahen Enterprises Ltd - Prepare Balance Sheet as at 31 December 2022

Attachment:- Accounting And Finance.rar