need to make balance sheet for 31 dec 2018

via info provided. use the following key words to fill the blanks . first pic is the key words, the one in green back ground has the info and details regarding the question. the one in blue is where we have to fill in the blanks and answer

IMPORTANT NOTE The description fields on thistab are designed to use dropdown boxes. Unless you enter descriptions that exactly match the descriptions in those dropdown boxes, you will be marked as incorrect. If your device or software does not support dropdown boxes, it is critically important that you enter descriptions that exactly match the descriptions in the following list, including capitalisation, spelling and punctuation. If you find you cannot select from dropdown boxes when entering descriptions in the fields to the left, it is strongly recommended that you copy and paste descriptions from the following list. Land & Buildings Bank Loans Plant & Equipment Ordinary Shares Accounts Payable less Depreciation on Plant & Equipment Retained Earnings Mortgage Loans Income Tax Payable less Depreciation on Motor Vehicles Corporate Bonds Accounts Receivable Bank Overdraft Preference Shares Cash less Depreciation on Furniture, Fixtures & Fittings Inventory Dividends Payable Pre-paid Expenses Furniture, Fixtures & Fittings Motor Vehicles 100% E3 x & fx N 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: Rakshith Enterprises Ltd The new business commenced operations on 31 December 2018. It is now just over one year later the middle of January 2020. 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 Sheetas at 31 December 2018 2. Profit and loss Statement for the year ending 31 December 2019 3. Balance Sheet as at 31 December 2013 4. Statement of Cash Flows for the year ending 31 December 2019 Financial Information The company was set up by issuing 240,000 shares at an issue price of $ each A factory was purchased at a cost of $550,000 The new factory was largely financed by taking Out 5457.000 mortgage loan In addition to the mortgage loan, the company took out 5618.000 interest-only secured bank loan In addition to the factory, the company purchased the following Plant and Equipment to the value $290,000 Furniture, Fitures and Fittings to the value of $140,000 Inventory to the value of $194,000 All of the above transactions occurred late in December 2013 Any cash remaining her these purchases was put into a bank account On 1 March 2019, the company took out a bankoveda The outstanding balance on 31 December 2019 was $36,000. (This is to be recorded separately from the cash balance rather than combined Oni 2019, motor vehicles to the value of $160.000 were purchased On 31 December 2013, the company red corporate bond to the of $660,000, and used the proceeds to purchase an additional factory costing S660,000 On 11 December 2019, the company wed 117.000 new ordinary heat price of $2 each and 215.000 new preference shares ata price of each some of the amounted was used to buy adapt and ement for the new factory at a cost of $250.000 During the course year ending December 2019, the following transactions occurred: Products to the value 091.000 were sold and delivered. These sales were made on the banks of one month's credit of the $2,091,000 in ocching in 2018.products to the value of $167.000 were delivered in December 2019 and will not be paid for und lauary 2010 Rawls to the value of $1,171,000 ordered and taken delivery of. These purchases were made on the base on mon's ord of the $1,171,000 Imate purchased in 2015, was to the value of $131.000 ordered and taken delivery in December 2013 and not be paid for a 2020 Enter Student No. Part 2 - Data and Instructions Part 2 (A) Part 2 (3) Part 2 (C) esc Merge & Centre . E3 fx N Raw materials to the value of $1,171,000 were ordered and taken delivery of. These purchases were made on the basis of one month's credit. Of the $1,171,000 in raw materials purchased in 2019, raw materials to the value of $131,000 were ordered and taken delivery of in December 2019 and will not be paid for until January 2020 Payment of Wages ($125,000 Payment of Rent for 2019 ($104,000). Payment of Motor Vehicle Running Expenses ($43,000). Payment of insurance for 2019 ($40,000). Payment of Interest ($65,000). Payment for Printing & Stationery ($21.000). Payment for Heating and Lighting for 2019 (524,000). Payment for Telephone, Postage and intemet Charges ($17,000). In addition, an additional $38,000 was paid in December for January's rent. In addition to the above interest payment, the principal owing on the mortgage loan was reduced by $43,000 The value of inventory on 31 December 2019 was $225,000 Additional Information: Depreciation on motor vehicles, plant and equipment and furniture, foxtures 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 65%. Instructions: Complete the boxes in the "Part 2 (A) to ("tabs, save this file and upload it as your submission. You do not need to complete every celin those tabs. Complete as many cells as you need to construct the various financial statements. Enter whole numbers, in thousands of dollars (Le round off numbers to the nearest whole number of thousands of dollars). Submission Deadline: 11.55pm Sunday 13 September 2020 Format. Please do not change the name of this file. There is No need to include your Student Number or your name in the file name Word limit: Not Applicable BUE. BUSSIAF Assignment Part 2 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me X - A A EE Merger a Corte % Conditional Forma Formatting as tab KIS xfx Rakshith Enterprises Ltd Balance Sheet as at 31 December 2018 Note: All values should be whole numbers of thousands of dollars. All values should be positive except for depreciation LABUTES Current Total Current Totalrent Ensuite Put Data and instructions Part 2 Part 2 Part 2 Part 2 esc @ # $ % 2 3 5 097 & 7 8 9 Q W E 20 T Y U Paste 5% Conditional Format Formatting as Table SE 3 BA x fx K15 Non-current Assets Total Non-current Assets Total Non-current Liabilities TOTAL LLABILITIES SHAREHOLDERS' EQUITY TOTAL SHAREHOLDERS' EQUITY TOTAL ASSETS TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY Enter Student No. Part 2 - Data and Instructions Part 2 A Part 23 Part 2 Part 20 esc @ & 1 2 $ 4 3 5 6 7 8 09 IMPORTANT NOTE The description fields on thistab are designed to use dropdown boxes. Unless you enter descriptions that exactly match the descriptions in those dropdown boxes, you will be marked as incorrect. If your device or software does not support dropdown boxes, it is critically important that you enter descriptions that exactly match the descriptions in the following list, including capitalisation, spelling and punctuation. If you find you cannot select from dropdown boxes when entering descriptions in the fields to the left, it is strongly recommended that you copy and paste descriptions from the following list. Land & Buildings Bank Loans Plant & Equipment Ordinary Shares Accounts Payable less Depreciation on Plant & Equipment Retained Earnings Mortgage Loans Income Tax Payable less Depreciation on Motor Vehicles Corporate Bonds Accounts Receivable Bank Overdraft Preference Shares Cash less Depreciation on Furniture, Fixtures & Fittings Inventory Dividends Payable Pre-paid Expenses Furniture, Fixtures & Fittings Motor Vehicles 100% E3 x & fx N 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: Rakshith Enterprises Ltd The new business commenced operations on 31 December 2018. It is now just over one year later the middle of January 2020. 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 Sheetas at 31 December 2018 2. Profit and loss Statement for the year ending 31 December 2019 3. Balance Sheet as at 31 December 2013 4. Statement of Cash Flows for the year ending 31 December 2019 Financial Information The company was set up by issuing 240,000 shares at an issue price of $ each A factory was purchased at a cost of $550,000 The new factory was largely financed by taking Out 5457.000 mortgage loan In addition to the mortgage loan, the company took out 5618.000 interest-only secured bank loan In addition to the factory, the company purchased the following Plant and Equipment to the value $290,000 Furniture, Fitures and Fittings to the value of $140,000 Inventory to the value of $194,000 All of the above transactions occurred late in December 2013 Any cash remaining her these purchases was put into a bank account On 1 March 2019, the company took out a bankoveda The outstanding balance on 31 December 2019 was $36,000. (This is to be recorded separately from the cash balance rather than combined Oni 2019, motor vehicles to the value of $160.000 were purchased On 31 December 2013, the company red corporate bond to the of $660,000, and used the proceeds to purchase an additional factory costing S660,000 On 11 December 2019, the company wed 117.000 new ordinary heat price of $2 each and 215.000 new preference shares ata price of each some of the amounted was used to buy adapt and ement for the new factory at a cost of $250.000 During the course year ending December 2019, the following transactions occurred: Products to the value 091.000 were sold and delivered. These sales were made on the banks of one month's credit of the $2,091,000 in ocching in 2018.products to the value of $167.000 were delivered in December 2019 and will not be paid for und lauary 2010 Rawls to the value of $1,171,000 ordered and taken delivery of. These purchases were made on the base on mon's ord of the $1,171,000 Imate purchased in 2015, was to the value of $131.000 ordered and taken delivery in December 2013 and not be paid for a 2020 Enter Student No. Part 2 - Data and Instructions Part 2 (A) Part 2 (3) Part 2 (C) esc Merge & Centre . E3 fx N Raw materials to the value of $1,171,000 were ordered and taken delivery of. These purchases were made on the basis of one month's credit. Of the $1,171,000 in raw materials purchased in 2019, raw materials to the value of $131,000 were ordered and taken delivery of in December 2019 and will not be paid for until January 2020 Payment of Wages ($125,000 Payment of Rent for 2019 ($104,000). Payment of Motor Vehicle Running Expenses ($43,000). Payment of insurance for 2019 ($40,000). Payment of Interest ($65,000). Payment for Printing & Stationery ($21.000). Payment for Heating and Lighting for 2019 (524,000). Payment for Telephone, Postage and intemet Charges ($17,000). In addition, an additional $38,000 was paid in December for January's rent. In addition to the above interest payment, the principal owing on the mortgage loan was reduced by $43,000 The value of inventory on 31 December 2019 was $225,000 Additional Information: Depreciation on motor vehicles, plant and equipment and furniture, foxtures 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 65%. Instructions: Complete the boxes in the "Part 2 (A) to ("tabs, save this file and upload it as your submission. You do not need to complete every celin those tabs. Complete as many cells as you need to construct the various financial statements. Enter whole numbers, in thousands of dollars (Le round off numbers to the nearest whole number of thousands of dollars). Submission Deadline: 11.55pm Sunday 13 September 2020 Format. Please do not change the name of this file. There is No need to include your Student Number or your name in the file name Word limit: Not Applicable BUE. BUSSIAF Assignment Part 2 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me X - A A EE Merger a Corte % Conditional Forma Formatting as tab KIS xfx Rakshith Enterprises Ltd Balance Sheet as at 31 December 2018 Note: All values should be whole numbers of thousands of dollars. All values should be positive except for depreciation LABUTES Current Total Current Totalrent Ensuite Put Data and instructions Part 2 Part 2 Part 2 Part 2 esc @ # $ % 2 3 5 097 & 7 8 9 Q W E 20 T Y U Paste 5% Conditional Format Formatting as Table SE 3 BA x fx K15 Non-current Assets Total Non-current Assets Total Non-current Liabilities TOTAL LLABILITIES SHAREHOLDERS' EQUITY TOTAL SHAREHOLDERS' EQUITY TOTAL ASSETS TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY Enter Student No. Part 2 - Data and Instructions Part 2 A Part 23 Part 2 Part 20 esc @ & 1 2 $ 4 3 5 6 7 8 09