Effect of transactions on current position analysis
Data pertaining to the current position of Lucroy Industries Inc. follow:
Instructions
- 1. Compute (a) the
working capital , (b) thecurrent ratio , and (c) the quick ratio. Round ratios in parts b through j to one decimal place. - 2. List the following captions on a sheet of paper:
Compute the working capital, the current ratio, and the quick ratio after each of the following transactions and record the results in the appropriate columns. Consider each transaction separately and assume that only that transaction affects the data given. Round to one decimal place.
- a. Sold marketable securities at no gain or loss, $500,000.
- b. Paid accounts payable, $287,500.
- c. Purchased goods on account, $400,000.
- d. Paid notes payable, $125,000.
- e. Declared a cash dividend, $325,000.
- f. Declared a common stock dividend on common stock, $150,000.
- g. Borrowed cash from bank on a long-term note, $1,000,000.
- h. Received cash on account, $75,000.
- i. Issued additional shares of stock for cash, $2,000,000.
- j. Paid cash for prepaid expenses, $200,000.
1. a)
Compute Working capital.
Explanation of Solution
Financial Ratios: Financial ratios are the metrics used to evaluate the liquidity, capabilities, profitability, and overall performance of a company.
Compute working capital.
Description:
Working capital is the difference between current assets and current liabilities.
Formula:
Thus, working capital is $1,200,000.
b)
Compute Current ratio.
Given info: Total current assets and current liabilities.
Explanation of Solution
Compute current ratio.
Description:
Current Ratio: Current ratio is used to determine the relationship between current assets and current liabilities. Current ratio is determined by dividing current assets and current liabilities.
Formula:
The ideal current ratio is 2:1.
Current assets and current liabilities are determined as follows:
Thus, current ratio is 1.6.
2.
Compute Working capital, Current ratio, and Quick ratio considering the given transactions.
Explanation of Solution
a)
Sale of marketable securities at no gain or loss, $500,000.
When sale of marketable securities is considered, it increases the cash and decreases the marketable securities by same amount. So, there is no effect in the working capital, current ratio, and quick ratios that are calculated in the requirement 1. Thus, working capital, current ratio, and quick ratio are determined as follows:
Ratios | Working capital | Current ratio | Quick ratio |
$1,200,000 | 1.6 | 1.1 |
b)
Payment of accounts payable at $287,500.
Payment of accounts payable involves cash and accounts payable accounts. It decreases the accounts payable and cash. Cash is a current asset and accounts payable is a current liability. Both are the decreased by $287,500.
Determine the new current assets, quick assets, and current liabilities as below:
Thus, ratios are determined as follows:
Compute working capital.
Compute current ratio.
Compute quick ratio.
c)
Purchase of goods on account $400,000.
Purchase of goods on account involves Merchandise inventory and accounts payable account. Merchandise inventory is a current asset and it is increased due to purchases made. Accounts payable is increased due to purchases made on account. So, both are increased by $400,000.
Determine the new current assets, quick assets, and current liabilities as below:
Thus, ratios are determined as follows:
Compute working capital.
Compute current ratio.
Compute quick ratio.
d)
Payment of notes payable $125,000.
Notes payable involves notes payable and cash. Notes payable is a current liability and is decreased. Cash is a current asset and decreased due to payment made. So, reduce notes payable and cash by $125,000.
Determine the new current assets, quick assets, and current liabilities as below:
Thus, ratios are determined as follows:
Compute working capital.
Compute current ratio.
Compute quick ratio.
e)
Cash dividend of $325,000 was declared.
Cash dividends involve cash dividends and dividends payable. Cash dividends are a stockholders’ equity. Dividend payable is a current liability and is increased.
Determine the new current assets, quick assets, and current liabilities as below:
Thus, ratios are determined as follows:
Compute working capital.
Compute current ratio.
Compute quick ratio.
f)
Declaration of common stock dividend on common stock, $150,000.
Common stock dividend declaration involves common stock dividends and dividends payable. Common stock dividends are a stockholders’ equity. Dividend payable is a current liability and is increased.
Determine the new current assets, quick assets, and current liabilities as below:
Thus, ratios are determined as follows:
Compute working capital.
Compute current ratio.
Compute quick ratio.
g)
Borrow cash from bank on a long-term note for $1,000,000.
Borrow cash from bank on a long-term note involves cash and long-term notes payable. Cash is a current asset and is increased due to borrowable of cash. Note is a long-term note and long-term liability is increased. So, only current assets and working capital is affected.
Determine the new current assets, quick assets, and current liabilities as below:
Thus, ratios are determined as follows:
Compute working capital.
Compute current ratio.
Compute quick ratio.
h)
Received cash on account, $75,000.
Receipt of cash on account is $75,000. Cash and accounts receivable are assets. Cash is an asset and increases due to receipt of cash. Accounts receivable is an asset and is decreased. So, there is no effect of this transaction.
Determine the new current assets, quick assets, and current liabilities as below:
Thus, ratios are determined as follows:
Compute working capital.
Compute current ratio.
Compute quick ratio.
i)
Issue of additional shares of stock fro cash $2,000,000
Issue of additional shares of stock for cash involves Cash and common stock. Cash is an asset and increases due to issue of additional shares. Common stock is a stock and is increases. So, this affects common stock.
Determine the new current assets, quick assets, and current liabilities as below:
Thus, ratios are determined as follows:
Compute working capital.
Compute current ratio.
Compute quick ratio.
j.
Payment of cash for prepaid expenses, $200,000.
Payment of cash for prepaid expenses involves prepaid expenses and cash. Prepaid expenses are asset. Prepaid expenses decrease and cash decreases. Thus, there is no effect.
Determine the new current assets, quick assets, and current liabilities as below:
Thus, ratios are determined as follows:
Compute working capital.
Compute current ratio.
Compute quick ratio.
The calculated ratios are as follows:
Transaction | Working capital | Current ratio | Quick ratio |
a. | $1,200,000 | 1.6 | 1.1 |
b. | $1,200,000 | 1.7 | 1.1 |
c. | $1,200,000 | 1.5 | 0.9 |
d. | $1,200,000 | 1.6 | 1.1 |
e. | $875,000 | 1.4 | 0.9 |
f. | $1,200,000 | 1.6 | 1.1 |
g. | $2,200,000 | 2.1 | 1.6 |
h. | $1,200,000 | 1.6 | 1.1 |
i. | $3,200,000 | 2.6 | 2.1 |
j. | $1,200,000 | 1.6 | 1.0 |
Want to see more full solutions like this?
Chapter 17 Solutions
Financial Accounting
- Effect of transactions on current position analysis Data pertaining to the current position of Forte Company follow: Instructions 1. Compute (a) the working capital, (b) the current ratio, and (c) the quick ratio. Round ratios in parts b through j to one decimal place. 2. List the following captions on a sheet of paper: Compute the working capital, the current ratio, and the quick ratio after each of the following transactions and record the results in the appropriate columns. Consider each transaction separately and assume that only that transaction affects the data given. Round to one decimal place. a. Sold marketable securities at no gain or loss, 70,000. b. Paid accounts payable, 125,000. c. Purchased goods on account, 110,000. d. Paid notes payable, 100,000. e. Declared a cash dividend, 150,000. f. Declared a common stock dividend on common stock, 50,000. g. Borrowed cash from bank on a long-term note, 225,000. h. Received cash on account, 125,000. i. Issued additional shares of stock for cash, 600,000. j. Paid cash for prepaid expenses, 10,000.arrow_forwardFinancial Statements, Closing Entries & Ratio Analysis You are asked to support Telcel Company with its Financial Reporting requirements. The Senior Manager provided you with the following Adjusted Trial Balance: Telcel Company TRIAL BALANCE (Adjusted) 31-Mar-21 Debit Credit Cash 10,450 Accounts Receivable 16,800 Prepaid Rent Supplies 7,600 1,500 Inventory Buildings Equipment 6,400 125,000 32,000 Accumulated Depreciation – Equipment 7,200 Accumulated Depreciation – Buildings Accounts Payable Notes Payable (due 2024) 21,000 13,900 49,000 Unearned Service Revenue 9,450 Share Capital Retained Earnings 76,000 31,650 Dividends 8,000 Service Revenue 68,400 Advertising Expense Salaries and Wages Expense 1,750 47,800 Utilities Expense 5,400 Supplies Expense Depreciation Expense Interest Expense Rent Expense 2,600 8,400 1,100 1,800 Total 276,600 276,600 Additional Information: 2020 Data Accounts Receivable $8,100 Total Assets $158,930arrow_forwardActivity 4: Compute the following financial ratios using the given financial statements below. Round off your answer to the nearest hundreds a. Gross profit ratio b. Operating income ratio c. Net profit ratio d. Return on asset (ROA) e. Return on equity (ROE) f. Asset turnover g. Fixed asset turnover h. Inventory turnover i.Days in Inventory j.Accounts receivables turnoverarrow_forward
- Required: Evaluate the performance of RBL Paving Company using the below ratios. Define each ratio, perform the calculation, and provide an explanation of the result. a. Return on equityb.Total assets turnoverc. Return on assetsd. Current ratioe. Receivables turnoverarrow_forwardIdentify how each of the following separate transactions through 10 affects financial statements. For increases, place a "+" and the dollar amount in the column or columns. For decreases, place a "-" and the dollar amount in the column or columns. Some cells may contain both an increase (+) and a decrease (-) along with dollar amounts. The first transaction is completed as an example. Required: a. For the balance sheet, identify how each transaction affects total assets, total liabilities, and total equity. For the income statement, identify how each transaction affects net income. b. For the statement of cash flows, identify how each transaction affects cash flows from operating activities, cash flows from investing activities, and cash flows from financing activities. Transaction 1. Owner invests $750 cash in business in exchange for stock 2. Receives $550 cash for services provided 3. Pays $350 cash for employee wages 4. Buys $480 of equipment on credit 5. Purchases $580 of supplies…arrow_forwardRequirements: a. Prepare horizontal analysis based on the above statements presented (for percent: round of your answers to 2 decimal places) Music Lover, Inc.xlsx b. Evaluate the company's financial position and results of operation using the comparative statement analysis i. Short-term solvency analysis ii. Long-term financial position analysis iii. Operating efficiency and profitability analysisarrow_forward
- Please Complete the Following: 1. Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement", use total assets on the balance sheet and net sales on the income statement for your vertical analysis. 2. Using the balance sheet and income statement, complete the ratios on the tab labeled "Ratios" 3. Answer the final OBSERVATION QUESTION (listed under Ratios calculations) Consolidated Balance Sheets (USD $) 12/31/2020 Vertical Analysis 12/31/2019 Vertical Analysis Horizontal Analysis In Millions, unless otherwise specified Current Assets: Cash and Cash Equivalents $1,723 $1,929 Receivables, net 1,484 1,398 Merchandise Inventories 11,079 11,057 Other Current Assets 1,016 895 Total Current Assets 15,302 15,279 Property and Equipment, at…arrow_forwardRequired: (a) You are required to calculate the following ratios:(i) Gross profit margin(ii) Operating profit margin(iii) Expenses to sales(iv) Return on Capital Employed(v) Asset turnover(vi) Non-current asset turnover(vii) Current Ratio(viii) Quick Ratio(ix) Inventory days(x) Receivables days(xi) Payable days(xii) Interest cover (b) In light of your calculations comment on the performance of the company over thelast two years.arrow_forwardDetermine the following: (a) debt ratio, (b) ratio of fixed assets to long-term liabilities, (c) ratio of liabilities to stockholders' equity, (d) asset turnover, (e) return on total assets, (f) return on stockholders' equity, and (g) return on common stockholders' equity. Round to two decimal places. a. Debt ratio b. Ratio of fixed assets to long-term liabilities C. Ratio of liabilities to stockholders' equity d. Asset turnover e. Return on total assets f. Return on stockholders' equity g. Return on common stockholders' equity 23.08✔ % 1.4 ✓ 0.3 ✔ 2.97 X % % %arrow_forward
- In performing vertical analysis, we express each item in a financial statement as a percentage of a base amount. What base amount is commonly used for income statement accounts? For balance sheet accounts?arrow_forwardBelow are the two basic financial statements of Chiz Trading Company. You are tasked to prepare an analysis using Horizontal and Vertical Analysis of their two-dated financial statements. In addition to this you have been tasked to prepare financial ratios measuring the company’s: Liquidity Status Current Ratios Quick Asset Ratios Efficiency Status Asset Turnover Fixed Asset Turnover Inventory Turnover Days in Inventory Accounts Receivable Turnover Days in Receivable Profitability Status: Gross Profit margin Ratio Operating Income Ratio Net Profit Ratio Return on Assets Return on Equityarrow_forwarda)Please calculate all the ratios of companies - Profitability ratios(Profit margin, Return on assets , Return on equity) , Asset utilization ratios (Receivables turnover, Average collection period, Inventory turnover, Fixed asset turnover, Total asset turnover) Liquidity ratios (Current ratio, Quick ratio) & Debt utilization ratios (Debt total assets, Times interest earned, Fixed charge coverage) b) Calculate all your ratios in and Excel File. You need to show all your calculations in excel file but use the calculated value in your main report. c) Discuss each of the ratios for two years and explain their implications for the company. Analyze the ratios that you have calculated d) Use graphs, charts in your analysis.arrow_forward
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College