Accounting

I am working on a problem that wants me to make a balance sheet and income statement for the Argo Sales Company based on some information given that I have no idea how to compute. I have been able to figure out how to do a ratio correctly if I am given the figures to plug into it. (Example: Debt ratio I can figure out if I have the liabilities and asset figures). I cannot figure out how to come up with the figures if the problem says the inventory turnover is 8 per year or the current ratio is 3 to 1 etc. PROBLEM Argo Sales Corporation has in recent years maintained the following relationships among the data on its financial statements: Gross profit margin 40% Net profit margin 10% Rate of selling expenses to net sales 20% Accounts receivable turnover 8 times per year Inventory turnover 6 times per year Quick-asset composition: 8% cash, 32% marketable securities, 60% accounts receivable Acid-test ratio (Quick ratio) 2-to-1 Current ratio: 3-to-1 Asset turnover: 2 per year Ratio of total assets to intangible assets 20-to-1 Ratio of accumulated depreciation to gross property, plant and equipment : 1-to-3 Ratio of accounts receivable to accounts payable: 1.5-to-1 Ratio of working capital to stockholders’ equity: 1-to-1.6 Debt/Equity ratio: 1-to-2 The corporation had a net income of $120,000 for 2004, which resulted in earnings of $5.20 per share of common stock. No common or preferred shares were sold or bought back during 2004. The corporation does not have minority share of earnings, equity income or non-recurring items. Additional information includes the following: Capital stock authorized, issued (all in 1970), and outstanding: Common, $10 per share per share, issued at 10% premium. Preferred, 6% nonparticipating, $100 per share par value, issued at a 10% premium. Market value per share of common at December 31, 2004: $78. Preferred dividends paid in 2004: $3,000. Times interest earned in 2004: 33. The amounts of the following were the same at December 31, 2004, as at January 1, 2004: inventory, accounts receivable, 5% bonds payable – due 2013, total assets and total stockholders’ equity. Assuming there is no income tax expense and specific depreciation expense, but still need the accumulated depreciation for balance sheet. Administration expense, accrued expense payable and prepaid expenses are all backed in numbers. All purchases and sales were on account. Assume the company uses direct write-off method to account for uncollectible accounts. Required: Prepare in good form the balance sheet and income statement for the year ending December 31, 2004. Please show all calculations. Thanks

Answers


To calculate the figures needed to create the balance sheet and income statement for the Argo Sales Corporation, you will need to begin by gathering information about the company's financial records for the relevant time period. Details about the company's assets, liabilities, and equity should be gathered in order to determine the values at the beginning and end of the period. You will also need to determine the financial transactions that took place during the period, such as sales, purchases, assets acquired, liabilities incurred, investments made, and dividends paid. Knowing this information, you can then calculate relevant ratios related to the company's financial performance, such as gross profit margin, net profit margin, rate of selling expenses to net sales, inventory turnover, quick asset composition, acid-test ratio, current ratio, asset turnover, ratio of total assets to intangible assets, ratio of accumulated depreciation to gross property, plant, and equipment, ratio of accounts receivable to accounts payable, ratio of working capital to stockholders' equity, and debt to equity ratio.

After calculating the various ratios, you can then use the ratios to determine the figures that will be needed for the balance sheet and income statement. For example, the gross profit margin ratio can be used to calculate the gross profit figure by subtracting the cost of goods sold from net sales. The inventory turnover ratio can be used to calculate the cost of goods sold by dividing the cost of goods sold by the inventory turnover ratio. From there, the

Answered by karismith

We have mentors from

Contact support