Question

In: Finance

QUESTION 5: A. Income statement and balance sheet From the following financial information of XYZ Ltd,...

QUESTION 5:


A. Income statement and balance sheet
From the following financial information of XYZ Ltd, for the year ended
December 31, 2017. Prepare Income statement and Balance sheet.
Particulars Amount $
Cash 31,000
Accounts Receivable 9,000
Equipment 90,000
Accumulated Depreciation 10,000
Accounts Payable 8,000
Bank Loan(Long term liability) 1,12,000
Sales 65,600
Cost of Goods sold 34,000
Advertising expense 10,000
Fuel expense 4,000
Interest expense 10,000
Income tax expense 2,400
Inventory 200,000
Share Capital 130,000
Short Term Liability 70,000


B. ‘The finance department of an enterprise performs several functions in order to achieve the
objectives. The scope of finance is very wide.’

Solutions

Expert Solution

(A)

Income Statement of XYZ Ltd. for the year ended 31 December,2017

Particulars Amount($)
Sales 65,600
Less: Cost of Goods Sold 34,000
Gross Profit 31,600
Less:
Advertising Expense 10,000
Fuel 4,000
Ineterest 10,000
Profit before tax 7,600
Income tax expense 2,400
PAT 5,200

Balance Sheet of XYZ Ltd. as on 31st Dec,2017

Assets ($) ($)
Non-Current Assets
Equipment 90,000
Accumulated Depreciation 10,000 80,000
Current Assets
Cash 31000 31,000
Inventories 200000 2,00,000
Receivables 9000 9,000
Total Assets 3,20,000
Liabilities
Share Capital 130000
Long-Term Liabilities
Bank Loan 1,12,000
Short-Term Liabilities
Accounts Payable 8,000
Short term Loan 70,000 78,000
Total Liabilities 3,20,000

(B) ‘The finance department of an enterprise performs several functions in order to achieve the
objectives. The scope of finance is very wide.’

Following are the some of the functions performed by the Finance Department of the Company -

(i) Accounting - The Finance dept of a company is responsible for recording each and every transactions in books of Accounts. It manages the preparation of financial statements, cash flow statements. It manages accounts payable, accounts receivables.

(ii) Record Keeper - The Finance dept of a company keeps the financial records of the company. The dept keeps record of financial transaction and events and are kept safely for many years. Each Accounting transaction recorded in books is supported by some documentary evidence and these evidences are kept in the form of vouchers, book keeping.

(iii) Working Capital Management - The finance dept is responsiible to analyze working capital requirement of a company and according it manages the working capital needs.

(iv) Payroll - The Finance dept is responsible to ensure proper payment to all the employees of the company and in timely fashion. It also ensures proper deductions have been done from salary whereever applicable (ex- contribution, tax deductions).

(v) Finance Control - The senior managers in Finance dept ensures proper compliances of statutory payments, proper financial controls are in place and financial processes follow the internal as well as legal guidelines.  

(vi) Strategic Planning - The team performs financial planning and plans short - term and long-term plans of a company based on the assessment of financial health of the company.

(vii) Capital Budgeting Decisions - The Finance dept deeply analyze various investment option available in the market and choose the best one that increases the profitability of the company.

(viii) Risk Management- There are various risk involved in a company related to finance like - interest rate risk, Exchange rate risks, market and currency risk etc. These risks are mitigated through implementation of proper strategy and controls by the Finance Department.

The Aforementioned points proves that Finance dept of a company has wider range of responsibilities and is incharge of money of an Organisation.


Related Solutions

Prepare balance sheet and an income statement for corp xyz given the following information: Inventory $...
Prepare balance sheet and an income statement for corp xyz given the following information: Inventory $ 6,500 Common Stock 45,000 Cash 15,550 Operating expenses 1,350 Short-term notes payable 600 Interest expense 900 depreciation expense 500 sales 12,800 accounts receivable 9,600 Accounts payable 4,800 long-term debt 55,000 Cost of goods sold 5,750 Buildings and equipment 122,000 Accumulated depreciation 34,000 Taxes 1,440 General and Administrative expenses 850 retained earnings? Using previously worked financial statements, determine the following financial ratios. Please interpret each...
Three financial statements, the balance sheet, income statement, and statement of retained earnings for XYZ, Inc.,...
Three financial statements, the balance sheet, income statement, and statement of retained earnings for XYZ, Inc., an accounting and consulting firm, are included below. XYZ, Inc. Balance Sheet As of December 31, 2018 Assets: Liabilities and Shareholder's Equity: Cash $12,000 Accounts payable $2,000 Accounts receivable 22,000 Salaries payable 6,000 Supplies 7,000 Utilities payable 1,000 Land 18,000 Notes payable 25,000 Equipment (net) 30,000 Common stock 42,000 Retained earnings 13,000 Total assets $89,000 Total liabilities & stockholder's equity $89,000 XYZ, Inc. Income...
1. The following is selected financial information from Tilly’s, Inc. Prepare the Income Statement, Balance Sheet...
1. The following is selected financial information from Tilly’s, Inc. Prepare the Income Statement, Balance Sheet and Cash Flow for February 2014 and 2013 using the below info. Tillys info ($thousands) Feb 1 2014 Feb 2 2013 Cash and cash equlvalents 25412 17315 Cash flow from operations 43794 41730 Cost of goods sold 343542 317096 Total liabilities 91484 88085 Total assets 232407 205381 Cash flow from financing 1834 22819 Sales revenue 495837 467291 Cash flow from investing (37530) (72326) Other...
Create a balance sheet and income statement using the following information: WIth proper financial statement formatting...
Create a balance sheet and income statement using the following information: WIth proper financial statement formatting Any missing information, please fill in. Total Shareholder Equity Long Term Debt: 3,650,000 Inventories: 350,000 Income Taxes: 85,000 Total Non-Operating Expenses, Net Common stock: 100,000 Total Assets Retained Earnings: 3,000,000 Cost of Goods Sold: 2,000,000 Interest Income: 20,000 Accounts Receivable: 1,500,000 General and Administrative Costs: 1,000,000 Accruals: 800,000 Preferred Stock Net Earnings Goodwill & Other Intangibles: 1,800,000 Net Revenue: 4,500,000 Earnings Before Income Taxes...
Question 7 Use the following income statement and balance sheet information to put together a statement...
Question 7 Use the following income statement and balance sheet information to put together a statement of cash flows. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) 2017 Sales $1,242,000 Cost of goods sold $685,000 Gross profit $557,000 Gen'l & admin expense $156,000 Selling & mkt expense $135,000 Depreciation $24,000 Operating income $242,000 Interest $140,000 Income before taxes $102,000 Income taxes (27%) $27,540 Net income $74,460 Dividends paid $25,000 Assets 2017...
Based on the following financial information, construct the balance sheet and income statement below for Tonka...
Based on the following financial information, construct the balance sheet and income statement below for Tonka Trucking LLC for the year ending December 31, 2019. Be sure to format them as accurately as possible. Accounts Receivable $40,000 Depreciation Expense $50,000 Accumulated Depreciation $200,000 Cost of Goods Sold $50,000 Income Tax Expense $50,000 Cash $50,000 Sales Revenue $400,000 Equipment (Net of Accumulation) $200,000 Selling, General, and Administrative Expenses $100,000 Common Stock (1,000 shares) $100,000 Accounts Payable $50,000 Retained Earnings $200,000 Interest...
The following information was obtained from the financial statements of XYZ Corporation. Balance Sheet Trading Securities,...
The following information was obtained from the financial statements of XYZ Corporation. Balance Sheet Trading Securities, 12/31/19 $181 Trading Securities, 12/31/20 $89 Income Statement Unrealized Gain on Trading Securities $48 Loss on Sale of Trading Securities $15 Determine the amount of "Cash Received from Sale of Trading Securities" which should be reported on XYZ Corporation's statement of cash flows for the year ending 12/31/20.
Describe the information provided by each of these financial statements: Income Statement, Balance Sheet, Statement of...
Describe the information provided by each of these financial statements: Income Statement, Balance Sheet, Statement of Cash Flow. Identify ten business questions that can be answered by using financial accounting information. For each question, indicate which financial statement (or statements) would be most helpful in answering the question, and why. Identify ten business questions that can be answered by using financial accounting information. For each question, indicate which financial statement (or statements) would be most helpful in answering the question,...
Income Statement, Retained Earnings Statement, and Balance Sheet The following financial data were adapted from a...
Income Statement, Retained Earnings Statement, and Balance Sheet The following financial data were adapted from a recent annual report of Target Corporation for the year ending January 31. In millions Accounts payable $ 7,759 Cash 2,210 Common stock 53 Cost of goods sold 51,278 Debt and other borrowings 12,705 Income tax expense 1,204 Interest expense 882 Inventories 8,790 Other assets 4,446 Other expenses 6,214 Other liabilities 6,943 Property, plant, and equipment 25,958 Sales 72,618 Selling, general, and administrative expenses 14,676...
Using the information below to answer question (a) to (e). The balance sheet and income statement...
Using the information below to answer question (a) to (e). The balance sheet and income statement shown below are for Rebel Inc. Note that the firm has no amortization charges and it does not lease any assets. Its tax rate is 35%. Balance Sheet (Millions of $) 2014 2013 Assets Cash and securities $2,500 $2,000 Accounts receivable 11,500 $11,000 Inventories 16,000 15,500 Total current assets $30,000 $28,500 Net plant and equipment $20,000 $19,500 Total assets $50,000 $48,000 Liabilities and Equity...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT