Question

In: Finance

Trevor’s furniture company accounts’ information for 2019 is as follows: near-cash is $500, the amount of...

Trevor’s furniture company accounts’ information for 2019 is as follows:

near-cash is $500, the amount of money that customers currently owe to the com-
pany for goods that were purchased on credit is $10,000, the amount of accounts

payable is $9,000. Products in inventory are worth $40,000, accumulated deprecia-
tion is 15% of total gross fixed assets. Lands, buildings and equipment were valued

$126,000. 5-Year Debt is $22,950, common stock is $26,000 and retained earnings
at the end of the year is $31,058. Gross profit is $64,000. Fixed cash operating
expenses, variable operating expenses and depreciation are $21,000, $16,000 and

$15,000 respectively. Interest expenses are $6,000 and the tax rate is 21%. Addi-
tionally, regarding stock, the paid in capital in excess of par is $0.75 per common

stock. The number of common stock is 74,000. On the other hand, the cost of
goods sold is half as much as sales. The preferred stock dividend rate is 2% for a
face-value stock value of $9,000. A short-term bank loan of $3,000 is going to be
paid o↵ next month. Finally, promised bonuses for employees (to be paid o↵ soon)
accrue $1,092.

(a) Construct the income statement for this company.
(b) Construct the balance-sheet statement for this company.
(c) Calculate the current ratio and ROE.

Solutions

Expert Solution

Assume Sales is S
So COGS is 0.5S
Gross Profit =S-0.5S=0.5S
Gross Profit =$64,000
So Sales ==64000/0.5=$128000
Ans a.
Let us construct the Income statement
Trevor's Furniture Company
Income Statement
for the Year 2019
Particulars Amt $
Sales                    128,000
Less : Cost of Goods Sold                      64,000
Gross Profit                      64,000
Operating Expense:
Fixed Cash expense                      21,000
Variable cash expense                      16,000
Depreciation expense                      15,000
Bonus expense                         1,092
Total Operating Expense                      53,092
EBIT                      10,908
Interest Expense                         6,000
EBT                         4,908
Income Tax @21%                         1,031
Net Profit /(Loss)                         3,877
Assuming bonus accrued is not part of operating expenses given.
Ans b.
Trevor's Furniture Company
As on Dec 31,2019
Assets Amt $ Liabilities & Equity Amt $
Current Assets Current Laibilities
Cash & Cash Equivalents                            500 Accounts Payable                  9,000
Accounts Receivable                      10,000 Short term Bank Loan                  3,000
Inventory                      40,000 Bonus payable 1092
Total Current Assets                      50,500 Total .Current Laibilities                13,092
LT -Loan                22,950
Fixed Asset Total Liabilities                36,042
Gross Land , Buildings , Equipments                    126,000 Stockholders' Equity
Accumlated Depreciation(15% of Gross Fixed asset)                     (18,900) Common stock (74000, issued,at par $0.35)                26,000
Net Fixed Asset                    107,100 Additional paid in capital in excess of par =                55,500
Preferred stock 2%                  9,000
Retained Earning                31,058
Total Stockholders' Equity              121,558
Total Assets                    157,600 Total Liabilities & Equity              157,600
Ans c.
Current Ratio=Current Assets/Current Liabilties =                           3.86
ROE =Net Income/Equity = 2.46%

Related Solutions

Trevor’s furniture company accounts’ information for 2019 is as follows: near-cash is $500, the amount of...
Trevor’s furniture company accounts’ information for 2019 is as follows: near-cash is $500, the amount of money that customers currently owe to the com- pany for goods that were purchased on credit is $10,000, the amount of accounts payable is $9,000. Products in inventory are worth $40,000, accumulated deprecia- tion is 15% of total gross fixed assets. Lands, buildings and equipment were valued $126,000. 5-Year Debt is $22,950, common stock is $26,000 and retained earnings at the end of the...
Trevor’s company accounts’ information for 2018 is as follows: near-cash is $500
Trevor’s company accounts’ information for 2018 is as follows: near-cash is $500,the amount of money that customers currently owe to the company for goods that werepurchased on credit is $16,000. Inventories are worth $45,500, accumulated depreciationis 30.2% of total fixed assets. Accounts payable and short-term bank notes are $69,000.Lands, buildings and equipment were valued $126,000. 10-Year Debt is $22,950, commonstock is $31,500 and retained earnings is $26,498. Gross profit is $64,000. Fixed cashoperating expenses, variable operating expenses and depreciation are...
Selected balance sheet accounts for Tibbetts Company on September 30, 2019, are as follows: Cash $...
Selected balance sheet accounts for Tibbetts Company on September 30, 2019, are as follows: Cash $ 41,600 Marketable securities 117,000 Accounts receivable, net 143,000 Inventory 162,500 Prepaid expenses 18,200 Total current assets $ 482,300 Accounts payable $ 81,000 Other accrued liabilities 19,800 Short-term debt 36,000 Total current liabilities $ 136,800 Required: Calculate the working capital, current ratio, and acid-test ratio for Tibbetts Company as of September 30, 2019. Summarized here are the transactions/events that took place during the fiscal year...
Selected balance sheet accounts for Tibbetts Company on September 30, 2019, are as follows: Cash $...
Selected balance sheet accounts for Tibbetts Company on September 30, 2019, are as follows: Cash $ 32,000 Marketable securities 90,000 Accounts receivable, net 110,000 Inventory 125,000 Prepaid expenses 14,000 Total current assets $ 371,000 Accounts payable $ 90,000 Other accrued liabilities 22,000 Short-term debt 40,000 Total current liabilities $ 152,000 Required: Calculate the working capital, current ratio, and acid-test ratio for Tibbetts Company as of September 30, 2019. Summarized here are the transactions/events that took place during the fiscal year...
Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts...
Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts Receivable $25,000.00 Inventory $10,000.00 Inventory $15,000.00 Total current assets $45,000.00 Total current assets $50,000.00 Net Plant and equipment $50,000.00 Net Plant and equipment $60,000.00 Total assets $95,000.00 Total assets $110,000.00 Liabilities and equity Liabilities and equity Accounts payable $5,000.00 Accounts payable $7,000.00 Accruals $2,000.00 Accruals $3,000.00 Notes payable $10,000.00 Notes payable $5,000.00 Total current liabilities $17,000.00 Total current liabilities $15,000.00 Long term debts $25,000.00...
The ledger accounts of AXX Internet Company appear as follows on March 31, 2019: ACCOUNT NO....
The ledger accounts of AXX Internet Company appear as follows on March 31, 2019: ACCOUNT NO. ACCOUNT BALANCE 101 Cash $ 65,000 111 Accounts Receivable 35,860 121 Supplies 9,100 131 Prepaid Insurance 23,500 141 Equipment 103,000 142 Accumulated Depreciation—Equipment 39,820 202 Accounts Payable 11,500 301 Aretha Hinkle, Capital 115,000 302 Aretha Hinkle, Drawing 11,500 401 Fees Income 311,000 510 Depreciation Expense—Equipment 19,660 511 Insurance Expense 9,900 514 Rent Expense 31,500 517 Salaries Expense 151,000 518 Supplies Expense 4,100 519 Telephone...
Account balances from the ledger of Crosby Company on December 31, 2019, are as follows: Accounts...
Account balances from the ledger of Crosby Company on December 31, 2019, are as follows: Accounts Payable .................................................................................. $   23,000 Accounts Receivable ............................................................................. 38,000 Accumulated Depreciation--Equipment .................................................   64,000 Allowance for Doubtful Accounts ........................................................... 2,000 Patent .................................................................................................... 8,400 Capital Stock, $10 par ........................................................................... 100,000 Cash ...................................................................................................... 60,260 Inventory ................................................................................................ 105,000 Sales Supplies Inventory ....................................................................... 900 Interest Expense .................................................................................... 6,600 Inventory, December 31, 2018 .............................................................. 104,850 Contributed Capital in Excess of Par Value ........................................... 15,000 Long-Term Note Receivable, 14% ......................................................... 12,000 Mortgage Payable,...
PART 1 The following information is available for a company as of January 1, 2019: Accounts...
PART 1 The following information is available for a company as of January 1, 2019: Accounts Receivable $300,000 Allowance for Doubtful Accounts (14,000)    Accounts Receivable (net) 286,000 The following events took place during 2019: During the year, the company sold services for $500,000 cash and $3,000,000 on credit. On December 31, a decision was made to estimate bad debts as 0.5% of credit sales. Accounts Receivable of $1,000 from prior years was determined to be uncollectible and was written...
The following information pertains to ABC Company. Estimated netincome for 2019 = $500 Beginning retained...
The following information pertains to ABC Company. Estimated net income for 2019 = $500 Beginning retained earnings, January 1, 2019 = $2,100 Estimated distributions to owners during 2019 = $300 What is the company's ending balance in retained earnings at the end of the year, December 31, 2019?
Selected balance sheet accounts for Tibbetts Company on September 30, 2016, are as follows: Cash $...
Selected balance sheet accounts for Tibbetts Company on September 30, 2016, are as follows: Cash $ 44,800 Marketable securities 126,000 Accounts receivable, net 154,000 Inventory 175,000 Prepaid expenses 19,600 Total current assets $ 519,400 Accounts payable $ 99,000 Other accrued liabilities 24,200 Short-term debt 44,000 Total current liabilities $ 167,200 a. Calculate the working capital, current ratio, and acid-test ratio for Tibbetts Company as of September 30, 2016. (Round "Ratio" answers to 2 decimal places.) b. Summarized here are the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT