Question

Simple-Balance Sheet no answers-Template - Excel ayout Formulas Data Add-ins EE Help - Team Review View Wrap Text Merge & Cen
image.png
Clipboard Merge & Center - $ - % 9 Alignment M1 X ✓ Number for E HAB 16 Prepaid expenses 17 Total Current Assets Accrued payr
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Assets Asset amount Liabilities Liabilities amount
CURRENT ASSETS CURRENT LIABILITIES
Bank 11874 Due to employees 3145
Suppliers 8060
FIXED ASSETS LONG TERM LIABILITIES
Land 4348 10 year bonds 3450
Building 10000
Equipment 4389 SHAREHOLDERS' EQUITY
Owner investment plus retained earnings 15956
30611 30611

Please note that the bifurcation between owner investment and retained earnings is not readily ascertainable as how many shares the owner owns in the company and the face value of the shares is not given. The investment / down payment can be from retained earnings or from fresh issue of shares.  

Add a comment
Know the answer?
Add Answer to:
Simple-Balance Sheet no answers-Template - Excel ayout Formulas Data Add-ins EE Help - Team Review View...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • ? X SSB HOME INSERT Preparing a classified balance sheet - Excel FORMULAS DATA REVIEW -...

    ? X SSB HOME INSERT Preparing a classified balance sheet - Excel FORMULAS DATA REVIEW - Sign In PAGE LAYOUT VIEW Paste B I U. . Clipboard Font - A - Alignment Number Conditional Format as Cell Cells Formatting Table Styles - Styles fic The following transactions occurred for Lantana Company during its first month A1 X H The following transactions occurred for Lantana Company during its first month of operations and have been recorded in the T-accounts below. 4...

  • please help fill out this sheet Preparation of Balance Sheet Ari Company's December 31 post-closing trial balance contai...

    please help fill out this sheet Preparation of Balance Sheet Ari Company's December 31 post-closing trial balance contains the following normal balances: Cash $19,000 Accounts payable 20,000 Building 439,500 Long-term notes payable 785,000 Common stock 950,000 Retained earnings 75,000 Accumulated depreciation-Equipment 180,000 Land 877,000 Accounts receivable 22,500 Accumulated depreciation-Building 135,000 Wages payable 6,000 Patent (net of amortization) 120,000 Notes payable (short term) 131,000 Inventory 206,000 Equipment 600,000 Allowance for doubtful accounts 2,000 DUSITISSUUUISE Balance Sheet December 31 Assets Current Assets:...

  • Prepare a classified balance sheet ignoring monetary amounts. We were unable to transcribe this imageLess: Accumulated...

    Prepare a classified balance sheet ignoring monetary amounts. We were unable to transcribe this imageLess: Accumulated depreciation-equipment Net property, plant, and equipment Intangible assets Copyright Patent Total intangible assets Total assets Liabilities and Shareholders' Equity Current liabilities Notes payable Wages payable Accounts payable Rent payable Taxes payable Total current liabilities Long-term liabilities Bonds payable Notes payable Total current liabilities Shareholders' equity Preferred stock Common stock Retained earnings Total liabilities and shareholders' equity Name of Company Balance Sheet At [date] Assets...

  • 2) XYZ Company has provided balance sheet information for the year just ended, August 31, 2016:...

    2) XYZ Company has provided balance sheet information for the year just ended, August 31, 2016: Cash                                                                                      $40,000 Accounts receivable                                                            50,000 Building                                                                                100,000 Accumulated depreciation                                           (40,000) Total assets                                                                        $150,000                 Accounts payable                                                             $30,000 Long-Term Loan                                                                    70,000 Total liabilities                                                                   100,000 Shareholders' Equity                                                           50,000 Total Liabilities & Shareholders' Equity                   $150,000 The company has also provided the following information for the upcoming year: Revenue is expected to be $200,000 and...

  • Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments...

    Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments Property, plant, and equipment Intangible assets Total assets Current liabilities Long-term liabilities Shareholders' equity Total liabilities and shareholders' equity $ 640,000 530,000 2,280,000 220,000 $3,670,000 $ 440.000 830,000 2,400,000 $3,670,000 The captions shown in the summarized statement above include the following: a. Current assets: cash, $160,000; accounts receivable (net). $210,000; inventory, $235,000; and prepaid insurance, $35,000 b. Investments: investment in equity securities, short term,...

  • Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments...

    Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments Property, plant, and equipment Intangible assets Total assets Current liabilities Long-term liabilities Shareholders' equity Total liabilities and shareholders' equity $ 660,000 545,000 2,420,000 230,000 $3,855,000 $ 460,000 695,000 2,700,000 $3,855,000 The captions shown in the summarized statement above include the following: a. Current assets: cash, $165,000; accounts receivable (net). $215,000; inventory $240,000; and prepaid insurance, $40,000, b. Investments: Investment in equity securities, short term,...

  • ? - 6 X Sign In KD 9.. Preparing a classified balance sheet - Excel FILE...

    ? - 6 X Sign In KD 9.. Preparing a classified balance sheet - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11AA = % D D BIU- B A Alignment Number Conditional Format as Cell Formatting Table Styles Clipboard Styles Paste Cells - Editing Font A1 The following transactions occurred for Lantana Company during its first month DEF 4 . Received $50.000 cash from owners in exchange for common stock 5 6. Purchased land for...

  • Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments...

    Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments Property, plant, and equipment Intangible assets Total assets Current liabilities Long-term liabilities Shareholders' equity Total liabilities and shareholders' equity $ 604,000 503,000 2,028,000 202,000 $3,337,000 $ 404,000 1,073,000 1,860,000 $3,337,000 The captions shown in the summarized statement above include the following: a. Current assets: cash, $151,000; accounts receivable (net), $201,000; inventory, $226,000; and prepaid insurance, $26,000. b. Investments: investment in equity securities, short term,...

  • Preparation of Balance Sheet Ari Company's December 31 post-closing trial balance contains the following normal balances:...

    Preparation of Balance Sheet Ari Company's December 31 post-closing trial balance contains the following normal balances: Cash $19,000 Accounts payable 20,000 Building 439,500 Long-term notes payable 785,000 Common stock 950,000 Retained earnings 75,000 Accumulated depreciation-Equipment 180,000 Land 877,000 Accounts receivable 22,500 Accumulated depreciation-Building 135,000 Wages payable 6,000 Patent (net of amortization) 120,000 Notes payable (short term) 131,000 Inventory 206,000 Equipment 600,000 Allowance for doubtful accounts 2,000 Required Prepare a December 31 classified balance sheet for Ari Company Do not use...

  • Data Review View Developer Page Layout Formulas 10 VA Hep 1 X Cut Power Pot Tell...

    Data Review View Developer Page Layout Formulas 10 VA Hep 1 X Cut Power Pot Tell me what you want to de Arial Copy Paste W ISH Format Painter Clipboard . Font Alignment M27 Simple Balance Sheet Exercise Make the calculations asked for in the green cells Accounts payable Accounts receivable Accumulated depreciation Cash Common stock Inventories Long term debt Other current assets Other current liabilities Other long-term assets Other long-term liabilities Plant and equipment Retained earnings Short-term debt Short-term...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT