ABDE1AssetsCash67,9715,10023Accounts Receivable4 Inventory5 Current Assets6 Property & Equipment7 Goodwill7,80580,87645,50020,000146,376Total Assets10 Liabilities11 Short Term Debt12 Accounts Payable13 Current Liabilities3,9023,90250,00053,90214 Long Term Debt15 Total Liabilities16 Shareholder's Equity17 Equity Capital18 Retained Earnings19 Shareholder's Equity20 Total Liabilities & Shareholder's Equity70,0002,47472,474126,37621=IF(D8=D20,"OK")222324Given the above screenshot, what is the resultingvalue in cell D22?ERRORTRUEOKFALSE

Generally the balance sheet should give asset= liability. If function in Excel used to validate a…

C D 1 Assets 2 Cash 3 Accounts Receivable 67,971 5,100 7,805 80,876 4 Inventory 5 Current Assets 6 Property & Equipment 7 Goodwill 8 Total Assets 45,500 20,000 146,376 9. 10 Liabilities 11 Short Term Debt 12 Accounts Payable 13 Current Liabilities 3,902 3,902 14 Long Term Debt 50,000 53,902 15 Total Liabilities 16 Shareholder's Equity 17 Equity Capital 18 Retained Earning 19 Shareholder's Equity 20 Total Liabilities & Shareholder's Equity 70,000 2,474 72,474 126,376 21 22 =IF(D8=D20,"OK") 23 24

C D 1 Assets 2 Cash 3 Accounts Receivable 67,971 5,100 7,805 80,876 4 Inventory 5 Current Assets 6 Property & Equipment 7 Goodwill 8 Total Assets 45,500 20,000 146,376 9. 10 Liabilities 11 Short Term Debt 12 Accounts Payable 13 Current Liabilities 3,902 3,902 14 Long Term Debt 50,000 53,902 15 Total Liabilities 16 Shareholder's Equity 17 Equity Capital 18 Retained Earning 19 Shareholder's Equity 20 Total Liabilities & Shareholder's Equity 70,000 2,474 72,474 126,376 21 22 =IF(D8=D20,"OK") 23 24

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter9: Metric-analysis Of Financial Statements

Section: Chapter Questions

Problem 9.23E: Unusual income statement items Assume that the amount of each of the following items is material to...

See similar textbooks

Similar questions

Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) (a)Current ratioenter the ratio rounded to 2 decimal places (b)Acid-test ratioenter the ratio rounded to 2 decimal places…
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) Inventory turnoverenter the number rounded to 2 decimal places Days in inventoryenter the number of days rounded to 0 decimal…
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83)
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) (a)Current ratioenter the ratio rounded to 2 decimal places
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) Inventory turnoverenter the number rounded to 2 decimal places Days in inventoryenter the number of days rounded to 0 decimal…
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) (i)Earnings per share$enter a dollar amount rounded to 2 decimal places (j)Payout ratioenter percentages rounded to 0 decimal…
Swifty Corporation’s comparative balance sheets are presented below. SWIFTY CORPORATIONBalance SheetsDecember 3120222021Cash$12,500 $6,100 Accounts receivable18,400 26,600 Inventory13,200 10,200 Land34,200 30,200 Building76,200 76,200 Accumulated depreciation(17,200) (14,200)Total137,300 135,100 Accounts payable19,500 33,300 Common stock ($5 par)74,500 74,500 Retained earnings43,300 27,300 Total137,300 135,100 Swifty’s 2022 income statement included net sales of $122,000, cost of goods sold of $82,000, and net income of $31,000. Compute the following ratios for 2022. (Round Debt to total assets ratio to 1 decimal place, e.g 1.8 and all percentage and days answers to 0 decimal places, e.g 18 or 25% and all other answers to 2 decimal places, e.g. 1.83) Asset turnoverenter the number rounded to 2 decimal places (g)Return on assetsenter percentages rounded to 0 decimal places…
Distressed Corporation is undergoing liquidation. Relevant information as of January 1, 20x1 is shown below:ASSETSCarryingAmountNet RealizableValueCash P250,000 P300,000Accounts Receivable 150,000 355,649Equipment-net 600,000 200,000Land 1,700,000 1,500,000TOTAL ASSETS P2,700,000 P2,355,649LIABILITIESCarryingAmountSettlementAmountAccounts Payable P1,000,000 P1,000,000Salaries Payable 500,000 500,000Notes Payable 800,000 805,234Loan Payable 800,000 800,000TOTAL LIABILITIES P3,100,000 P3,105,234EQUITYShare Capital P1,600,000Retained Earnings (2,000,000)Capital Deficiency (400,000)TOTAL LIABILITIES & EQUITY P2,700,000Additional Information:• Administrative expenses amounting to P180,744 are expected to be incurred during the liquidationprocess.• The equipment is pledged to the loan payable.• The land is pledged to the notes payable.QUESTIONS:1. What is the amount paid to unsecured creditors without priority? 2. What is the amount paid to partially secured creditors?
Distressed Corporation is undergoing liquidation. Relevant information as of January 1, 20x1 is shown below:ASSETSCarryingAmountNet RealizableValueCash P250,000 P300,000Accounts Receivable 150,000 355,649Equipment-net 600,000 200,000Land 1,700,000 1,500,000TOTAL ASSETS P2,700,000 P2,355,649LIABILITIESCarryingAmountSettlementAmountAccounts Payable P1,000,000 P1,000,000Salaries Payable 500,000 500,000Notes Payable 800,000 805,234Loan Payable 800,000 800,000TOTAL LIABILITIES P3,100,000 P3,105,234EQUITYShare Capital P1,600,000Retained Earnings (2,000,000)Capital Deficiency (400,000)TOTAL LIABILITIES & EQUITY P2,700,000Additional Information:• Administrative expenses amounting to P180,744 are expected to be incurred during the liquidationprocess.• The equipment is pledged to the loan payable.• The land is pledged to the notes payable.QUESTIONS:1. How much are the total free assets? _____________2. How much are the unsecured liabilities with priority? _____________3. How much are the…
The following items were excerpted from Poeltl, Inc.'s balance sheets: December 31, 2023December 31, 2022Cash$86,300$59,000Accounts receivable65,60070,600Inventory157,000150.300Property and equipment794,500745,400Accumulated depreciation(184,000)(168,200)Accounts payable61,00050,600Wages payable20,40023,000 Poeltl's 2023 income statement showed net income of $463,000, depreciation expense of $57,000, and a gain on disposal of equipment of $16,000. On Poeltl's 2023 statement of cash flows, how much is Net Cash Provided by Operating Activities?
Capital 1 January 2019 350 000Drawings 20 000Sales (70% on credit) 950 000Gross profit 250 000Total expenses 80 000Bank favourable 26 000Net profit 74 000Trade creditors 26 000Property, plant and equipment 350 000Fixed deposit 20 000Inventory 72 000Trade Debtors 80 000Mortgage Loan 100 000 Additional InformationThe opening balance of the inventory, debtors and creditors was R50 000, R60 000 and R30 000respectively. Assume a 365 day year. Calculate the following ratios and explain what each ratio means in relation to theindustry average given in brackets. Show your calculations as marks will be awardedfor these. Round off to 2 decimal places. Q.2.1.3 Average creditors settlement period (60 days). Assume purchases are equalto cost of sales and 60% of all purchases are on credit. Q.2.2 Discuss how the solvency ratio is calculated and what is measured by this ratio. Please help with the both questions mentioned
Capital 1 January 2019 350 000Drawings 20 000Sales (70% on credit) 950 000Gross profit 250 000Total expenses 80 000Bank favourable 26 000Net profit 74 000Trade creditors 26 000Property, plant and equipment 350 000Fixed deposit 20 000Inventory 72 000Trade Debtors 80 000Mortgage Loan 100 000 Additional InformationThe opening balance of the inventory, debtors and creditors was R50 000, R60 000 and R30 000respectively. Assume a 365 day year. Calculate the following ratios and explain what each ratio means in relation to theindustry average given in brackets. Show your calculations as marks will be awardedfor these. Round off to 2 decimal places. Q.2.1.3 Average creditors settlement period (60 days). Assume purchases are equalto cost of sales and 60% of all purchases are on credit. Q.2.2 Discuss how the solvency ratio is calculated and what is measured by this ratio.