Question

In: Finance

A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is...

A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here:  

a.  How much is the​ firm's net working​ capital?

b.  Complete an income statement and a balance sheet for Belmond.

c. If you were asked to respond to parts ​(a​) and (b​) as part of a training​ exercise, what could you tell your boss about the​ company's financial condition based on your​ answers?

SHEET

Inventory

6,510

Common stock

45,100

Cash

16,590

Operating expenses

1,390

​Short-term notes payable

640

Interest expense

930

Depreciation expense

510

Sales

12,830

Accounts receivable

9,610

Accounts payable

4,770

​Long-term debt

55,270

Cost of goods sold

5,760

Buildings and equipment

121,560

Accumulated depreciation

34,020

Taxes

1,400

General and administrative expense

820

Retained earnings

​?  

Solutions

Expert Solution

Net working capital = Current Asset - Current Liability

Current Asset = Inventory + Cash+ Account receivable

= 6510 + 16590 + 9610

= 32710

Current liability = Short term notes payable + Accounts payable

= 640 + 4770

= 5410

Net working capital = 32710 - 5410

= 27300

b )

Income statement
Sales 12830
Less Cost of good sold 5760
Gross Profit 7070
Less Operating expense 1390
General and Administrative expense 820
Depreciation expense 510
Operating profit 1390
Less Interest 930
Profit before tax 2030
Less Tax 1400
Net income 630
Balance sheet
Current Asset :
Inventory 6510
Cash 16590
Account receivable 9610
Total Current Asset 32710
Fixed Asset :
Building and equipment 121560
Less depreciation 510
Total Fixed assset 121050
Total Asset 153760
Liabilities :
Current liability :
Accounts payable 4770
Short-term notes payab 640
Total Current liability 5410
Long term liability :
Long term debt 55270
Long term liability : 55270
Total liabilities 60680
Shareholders equity :
Common stock 45100 45100
Retained earning =[ Total Asset - Total liability - Common stock] 47980
Total liability and shareholders equity 153760

c )  

  • Current asset are $32710 , current liabilities are $5410 hence it has strong net wroking capital of $27300
  • Cost of good sold is only 44.89 % of sales ,operating expense is 10% and interest expense is7.24% so it has managing it costs well
  • Cash is higher than sales

financial statements are showed to be well managed and good financial condition


Related Solutions

A scrambled list of accounts from the income statement and balance sheet of? Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of? Belmond, Inc. is found? here: Inventory   $6,450 Common stock   45,010 Cash   16,550 Operating expenses   1,390 Short-term notes payable   560 Interest expense   920 Depreciation expense    530 Sales   12,750 Accounts receivable   9,560 Accounts payable   4,840 Long-term debt   55,160 Cost of goods sold   5,720 Buildings and equipment   122,050 Accumulated depreciation   34,400 Taxes   1,440 General and administrative expense   810 Retained earnings   ? ?? a.??How much is the? firm's net working?...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here:   Inventory 6,490 Common stock 45,000 Cash 16,550 Operating expenses 1,400 ​Short-term notes payable 570 Interest expense 850 Depreciation expense 470 Sales 12,710 Accounts receivable 9,630 Accounts payable 4,770 ​Long-term debt 54,610 Cost of goods sold 5,780 Buildings and equipment 121,650 Accumulated depreciation 33,790 Taxes 1,440 General and administrative expense 850 Retained earnings ​?  a.  How much is the​ firm's net working​ capital?...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is...
A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here:  . Inventory 6,460 Common stock 44,950 Cash 16,580 Operating expenses 1,350 ​Short-term notes payable 630 Interest expense 850 Depreciation expense 450 Sales 12,710 Accounts receivable 9,560 Accounts payable 4,760 ​Long-term debt 55,420 Cost of goods sold 5,740 Buildings and equipment 122,330 Accumulated depreciation 33,580 Taxes 1,490 General and administrative expense 880 Retained earnings ​?   a.  How much is the​ firm's net working​...
(Review of financial​ statements) A scrambled list of accounts from the income statement and balance sheet...
(Review of financial​ statements) A scrambled list of accounts from the income statement and balance sheet of​ Belmond, Inc. is found​ here: a. How much is the​ firm's net working​ capital? b. Complete an income statement and a balance sheet for Belmond. Inventory   6,480 Common stock   45,090 Cash   16,510 Operating expenses   1,330 Short-term notes payable   560 Interest expense   900 Depreciation expense    500 Sales   12,850 Accounts receivable   9,640 Accounts payable   4,780 Long-term debt   54,750 Cost of goods sold   5,770 Buildings...
Prepare a balance sheet and income statement for​ TNT, Inc., from the scrambled list of items...
Prepare a balance sheet and income statement for​ TNT, Inc., from the scrambled list of items found​ here: LOADING.... a. Prepare an income statement for TNT. b. Prepare a balance sheet for TNT. c. What can you say about the​ firm's financial condition based on these financial​ statements? a. Prepare an income statement for TNT. Depreciation_expense $98,700 Cash 337,900 Long-term_debt 501,300 Sales 859,200 Accounts_payable 154,000 General_and_administrative_expense 117,700 Buildings_and_equipment 1,342,400 Notes_payable 113,000 Accounts_receivable 251,195 Interest_expense 7,060 Accrued_expenses 11,880 Common_stock 433,500 Cost_of_goods_sold...
For the below scrambled Income Statement and Balance Sheet, you are to match the Available Choices...
For the below scrambled Income Statement and Balance Sheet, you are to match the Available Choices with the Accounts that are missing numbers. Total Revenue 41,366; Preferred Stock 734; Common Stock 323; Paid-In Capital/Capital Surplus 3,505; Cost of Revenue _______; Income Tax Expense 858; Prepaid Rent _______; Total Current Assets _______; Property Plant and Equipment 6,910; Selling General and Administrative 9,249; Long Term Investments 1,134; Other Long Term Assets 734; Total Assets _______; Accounts Payable 8,065; Current Portion of Long...
Re-organize the scrambled accounts into the income statement for Pet Land Inc., a pet food and...
Re-organize the scrambled accounts into the income statement for Pet Land Inc., a pet food and accessories retailer in a small Canadian town. You will have to calculate Sales Revenue, Cost of Goods Sold, the amount of tax that was paid, the totals for the sections of the statement and determine Gross Margin, Operating Margin, Income Before Tax and Net Income. Compile Sales Revenue from Gross Sales Revenue and record it on the statement. Compile the Cost of Goods Sold...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a private company reporting under ASPE, for the year ended December 31. Martinez Inc. Comparative Balance Sheet, at December 31 2017 2016 Cash                                                                                 $92,150                $46,150 Accounts receivable 90,700                  36,150 Inventory                                                                           122,000                102,550 Investments in land 85,100                  107,150 Property, plant, and equipment 285,200                201,000 Accumulated depreciation (48,260)               (40,000)                                                                                         $626,890             $454,000 Accounts payable                                                             52,700                   48,410 Accrued liabilities                                                            ...
Prepare Income Statement and Balance Sheet from the following Accounts payable 249,750 Accounts receivable 777,000 Accumulated...
Prepare Income Statement and Balance Sheet from the following Accounts payable 249,750 Accounts receivable 777,000 Accumulated depreciation 416,250 Advertising expense 55,500 Allowance for doubtful accounts 57,665 Bad debt expense 41,070 Capital gains 12,210 Capital stock (common) 999,000 Cash 376,623 Charitable contributions 29,970 Compensation expense 1,443,000 Cost of goods sold 921,300 Depreciation expense 22,200 Dividends (paid) 88,800 Dividends (received) 13,320 Entertainment expense 6,771 Equipment 832,500 Federal income tax expense 278,388 Gain from disposition of fixed assets 4,496 Interest expense 68,820 Interest...
Prepare Income Statement and Balance Sheet from the following Accounts payable 249,750 Accounts receivable 777,000 Accumulated...
Prepare Income Statement and Balance Sheet from the following Accounts payable 249,750 Accounts receivable 777,000 Accumulated depreciation 416,250 Advertising expense 55,500 Allowance for doubtful accounts 57,665 Bad debt expense 41,070 Capital gains 12,210 Capital stock (common) 999,000 Cash 376,623 Charitable contributions 29,970 Compensation expense 1,443,000 Cost of goods sold 921,300 Depreciation expense 22,200 Dividends (paid) 88,800 Dividends (received) 13,320 Entertainment expense 6,771 Equipment 832,500 Federal income tax expense 278,388 Gain from disposition of fixed assets 4,496 Interest expense 68,820 Interest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT