Question

Please calculate the current ratio and acid test from the balance sheet and income statement below....

Please calculate the current ratio and acid test from the balance sheet and income statement below.

I am not sure what I am doing wrong here to calculate the current ratio and acid test ratio for 2017 and 2018. Do I need to include the current notes payable due this within the year as a current liability ?

Marin Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% of the common stock, was one of the organizers of Marin and is its current president. The company has been successful, but it currently is experiencing a shortage of funds. On June 10, 2018, Daniel Brown approached the Topeka National Bank, asking for a 24-month extension on two $34,920 notes, which are due on June 30, 2018, and September 30, 2018. Another note of $5,970 is due on March 31, 2019, but he expects no difficulty in paying this note on its due date. Brown explained that Marin’s cash flow problems are due primarily to the company’s desire to finance a $300,720 plant expansion over the next 2 fiscal years through internally generated funds.

The commercial loan officer of Topeka National Bank requested the following financial reports for the last 2 fiscal years.

Balance Sheet
               2018               2017
Assets
Cash               18,120               12,410
N/R             148,700             130,840
A/R             132,830             125,880
Inventories             104,150               50,010
PPE         1,440,600         1,429,490
Total assets         1,844,400         1,748,630
Liabilities and Stockholders Equity
A/P               78,220               90,330
N/P               75,500               61,590
Accrued Liab                 2,760               23,230
C/S         1,298,610         1,290,550
RE             389,310             282,930
Total Liab and SE         1,844,400         1,748,630
aCash dividends were paid at the rate of $1 per share in fiscal year 2017 and $2 per share in fiscal year 2018.
Income Statement
               2018            2017
Sales Revenue         2,992,720         2,693,360
COGS         1,514,810         1,418,870
Gross Margin         1,477,910         1,274,490
Operating Exp.             856,040             775,840
Income before             621,870             498,650
    taxes
Income taxes             248,748             199,460
Net Income             373,122             299,190

INcome statement - Depreciation charges on the plant and equipment of $100,020 and $102,710 for fiscal years ended March 31, 2017 and 2018, respectively, are included in cost of goods sold.

Homework Answers

Answer #1

Solution:

Current ratio = Current assets / Current liabilties

Current Assets = Cash + N/R + A/r + Inventories

Current assets 2018 = $18,120 + $148,700 + $132,830 + $104,150 = $403,800

Current assets 2017 = $12,410 + $130,840 + $125,880 + $50,010 = $319,140

Current liabilities 2018 = A/P + N/P + Accrued liabilities = $78,220 + $75,500 + $2,760 = $156,480

Current liabilities 2017 = $90,330 + $61,590 + $23,230 = $175,150

Current ratio:

2018 = $403,800 / $156,480 = 2.58:1

2017 = $319,140 / $175,150 = 1.82:1

Acid test ratio = Quick assets / Current liabilities

Quick assets = Current assets - Inventories

Quick assets 2018 = $403,800 - $104,150 = $299,650

Quick Assets 2017 = $319,140 - $50,010 = $269,130

Acid test ratio 2018 = $299,650 / $156,480 = 1.91:1

Acid test ratio 2017 = $269,130 / $175,150 = 1.54:1

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Marigold Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown,...
Marigold Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% of the common stock, was one of the organizers of Marigold and is its current president. The company has been successful, but it currently is experiencing a shortage of funds. On June 10, 2021, Daniel Brown approached the Topeka National Bank, asking for a 24-month extension on two $34,970 notes, which are due on June 30, 2021, and September 30, 2021....
Income statement and balance sheet data for The Sports Shack are provided below. The Sports Shack...
Income statement and balance sheet data for The Sports Shack are provided below. The Sports Shack Income Statements For the years ended December 31 2019 2018 Sales revenue $8,200,000 $6,600,000 Cost of goods sold 6,100,000 4,700,000 Gross profit 2,100,000 1,900,000        Expenses:            Operating expenses 1,450,000 1,400,000            Depreciation expense 90,000 100,000            Interest expense 25,000 50,000            Income tax expense 95,000 80,000                Total expenses 1,660,000 1,630,000 Net income $440,000 $270,000 The Sports Shack Balance Sheets December 31 Assets 2019 2018 2017 Current assets:         Cash...
Sheridan Corporation was formed five years ago through an initial public offering (IPO) of common shares....
Sheridan Corporation was formed five years ago through an initial public offering (IPO) of common shares. Daniel Brown, who owns 15% of the common shares, was one of the organizers of Sheridan and is its current president. The company has been successful, but it is currently experiencing a shortage of funds. On June 10, 2020, Daniel Brown approached the Hibernia Bank, asking for a 24-month extension on two $34,800 notes, which are due on June 30, 2020, and September 30,...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below:...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below: Company A Income Statement For the Years Ended 2017 Sales 550.00 Cost of sales 275.00 Gross profit 275.00 SG&A 55.00 Depreciation 60.00 Interest 14.47 Pretax income 145.53 Tax 43.66 Net income 101.87 Company A Balance Sheet As of 2017 Cash 60.00 Accounts receivable 5.00 Inventory 8.00 Total current assets 73.00 PP&E - gross 600.00 Accumulated depreciation 200.00 PP&E - net 400.00 Total assets 473.00...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below:...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below: Company A Income Statement For the Years Ended 2017 Sales 550.00 Cost of sales 275.00 Gross profit 275.00 SG&A 55.00 Depreciation 60.00 Interest 14.47 Pretax income 145.53 Tax 43.66 Net income 101.87 Company A Balance Sheet As of 2017 Cash 60.00 Accounts receivable 5.00 Inventory 8.00 Total current assets 73.00 PP&E - gross 600.00 Accumulated depreciation 200.00 PP&E - net 400.00 Total assets 473.00...
Instructions: Using the Income Statement and Balance Sheet below, calculate each of the ratios below in...
Instructions: Using the Income Statement and Balance Sheet below, calculate each of the ratios below in the yellow cell. Use formulas to show your work. INCOME STATEMENT - HIGH PLAINS MEDICAL CENTER 2019 Patient service revenue $179,305 Less: Provision for bad debts 9,655     Net patient service revenue $169,650 Premium revenue 7,250 Other revenue 3,214     Total operating revenue $180,114 Nursing services $85,620 Dietary services 8,373 General services 29,907 Administrative services 23,674 Employee health and welfare 13,375 Malpractice insurance 1,792...
complete a Trial Balance, Income Statement, Statement of Retained Earnings, Balance Sheet, and calculate all of...
complete a Trial Balance, Income Statement, Statement of Retained Earnings, Balance Sheet, and calculate all of the ratios. Accounts Receivable        16,250 Accumulated depreciation: Office equipment        25,000 Cash        25,300 Land        58,500 Merchandise inventory        25,250 Office equipment        41,000 Office supplies          4,410 Prepaid rent          1,800 Cost of Goods Sold      112,575 Depreciation expense: office equipment          2,750 Income tax expense          9,000 Insurance expense          1,900 Office supplies expense              520 Rent expense          5,700...
Required information The following are the balance sheet and consolidated statement of earnings of The Home...
Required information The following are the balance sheet and consolidated statement of earnings of The Home Depot, Inc. THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS millions, except per share data February 3, 2019 January 28, 2018 January 29, 2017 Assets Current Assets: Cash and Cash Equivalents $ 1,778 $ 3,595 $ 2,538 Receivables, net 1,936 1,952 2,029 Merchandise Inventories 13,925 12,748 12,549 Other Current Assets 890 638 608 Total Current Assets 18,529 18,933 17,724 Net Property and Equipment 22,375 22,075...
The balance sheet and income statement shown below are for Koski Inc. Note that the firm...
The balance sheet and income statement shown below are for Koski Inc. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. Balance Sheet (Millions of $)   Assets      2018 Cash and securities      $3,000 Accounts receivable      15,000 Inventories      18,000 Total current assets      $36,000 Net plant and equipment      $24,000 Total assets     ...
Exhibit 4.1 The balance sheet and income statement shown below are for Koski Inc. Note that...
Exhibit 4.1 The balance sheet and income statement shown below are for Koski Inc. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. Balance Sheet (Millions of $)   Assets      2018 Cash and securities      $3,000 Accounts receivable      15,000 Inventories      18,000 Total current assets      $36,000 Net plant and equipment      $24,000 Total...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT