Question

In: Finance

7 Balance sheet preparation  Adam and Arin Adams have collected their personal asset and liability information and...

7 Balance sheet preparation  Adam and Arin Adams have collected their personal asset and liability information and have asked you to put together a balance sheet as of December 31, 2015. The following information is received from the Adams family.

  1. Cash $ 300 Retirement funds, IRA $ 2,000
    Checking 3,000 2014 Sebring 15,000
    Savings 1,200 2010 Jeep 8,000
    IBM stock 2,000 Money market funds 1,200
    Auto loan 8,000 Jewelry and artwork 3,000
    Mortgage 100,000 Net worth 76,500
    Medical bills payable 250 Household furnishings 4,200
    Utility bills payable 150 Credit card balance 2,000
    Real estate 150,000 Personal loan 3,000
    1. Create a personal balance sheet as of December 31, 2015. It should be similar to a corporate balance sheet.

    2. What must the total assets of the Adams family be equal to by December 31, 2015?

    3. What was their net working capital (NWC) for the year? (Hint: NWC is the difference between total liquid assets and total current liabilities.

Solutions

Expert Solution

Balance sheet is one of the financial statement in which the financial position of assets and liabilities are reflected as on particular date.
a.
Adam and Arin Adams
Balance Sheet
As on 31st December 2015
Assets Liabilities and net worth
Liquid assets Current liabilities
Cash $300 Utility Bills $150
Checking $3,000 Medical Bills $250
Savings $1,200 Credit card balance $2,000
Money market funds $1,200 Total current liabilities $2,400
Total liquid assets $5,700
Long term liabilities
Investments Mortgage $100,000
IBM Stock $2,000 Auto Loan $8,000
Retirement funds, IRA $2,000 Personal Loan $3,000
Total investments $4,000 Total long term liabilities $111,000
Real estate $150,000 Total liabilities
Personal property
2015 Sebring $15,000 Total net worth $76,500
2010 Jeep $8,000
Household furnishings $4,200
Jewelry and artwork $3,000
Total personal property $30,200
Total assets $189,900 Total liabilities and net worth $189,900
b.
The total assets is equal to the total liabilities plus the net worth of the family.
As on 31st December 2015, the total assets is equal to $189,900
c.
Net working capital = Total liquid assets -Total current liabilities
Net working capital 5700-2400
Net working capital $3,300

Related Solutions

2. How does one distinguish between an off-balance-sheet asset and an off-balance-sheet liability?
2. How does one distinguish between an off-balance-sheet asset and an off-balance-sheet liability?
Discuss how an OBS activity moves onto the balance sheet as an asset or liability and...
Discuss how an OBS activity moves onto the balance sheet as an asset or liability and discuss the risks and benefits of OBS activities to a bank.
The balance sheet for Bank A is as follows: *Assets/Liabilities and Asset/Liability Rates Included* Assets Floating...
The balance sheet for Bank A is as follows: *Assets/Liabilities and Asset/Liability Rates Included* Assets Floating Rate: $700 @ 7% Fixed Rate: $350 @ 10% Non-Earning: $150 Liabilities Floating Rate: $600 @ 5% Fixed Rate: $420 @ 6% Equity $180 A) What is the repricing gap? B) Calculate the net interest income. C) Calculate the net interest margin. D) If rates go up by 50 basis points, was the bank hedged accurately in anticipation of the rate change? Why or...
Problem 7-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that...
Problem 7-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.5 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 24% Total liabilities-to-assets ratio: 35% Quick ratio: 0.95 Days sales outstanding (based on 365-day year): 31.5 days Inventory turnover ratio: 5.0 Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $   Cost of goods...
Balance Sheet Adjustment and Preparation) Presented below is the balance sheet of Sargent Corporation for the...
Balance Sheet Adjustment and Preparation) Presented below is the balance sheet of Sargent Corporation for the current year, 2020. Sargent Corporation Balance Sheet December 31, 2020 Current assets 485,000  $ Current liabilities 380,000  $ Investments 640,000 Long-term liabilities 1,000,000 Property, plant, and equipment 1,720,000 Stockholders' equity 1,770,000  Intangible assets 305,000    $3,150,000 $3,150,000 The following information is presented. 1.The current assets section includes cash $150,000, accounts receivable $170,000 less $10,000 for allowance for doubtful accounts, inventories $180,000, and unearned rent revenue...
(Balance Sheet Adjustment and Preparation) Presented below is the balance sheet of Sargent Corporation for the...
(Balance Sheet Adjustment and Preparation) Presented below is the balance sheet of Sargent Corporation for the current year, 2020. Sargent Corporation Balance Sheet December 31, 2020 Current assets 485,000  $ Current liabilities 380,000  $ Investments 640,000 Long-term liabilities 1,000,000 Property, plant, and equipment 1,720,000 Stockholders' equity 1,770,000  Intangible assets 305,000    $3,150,000 $3,150,000 The following information is presented. 1.The current assets section includes cash $150,000, accounts receivable $170,000 less $10,000 for allowance for doubtful accounts, inventories $180,000, and unearned rent revenue...
The balance sheet for the LR Corp is presented below. The only asset on balance sheet...
The balance sheet for the LR Corp is presented below. The only asset on balance sheet is in excess of fair market value is inventory, which has a FMV of $60,000. LR is planning to undertake a quasi-reorganization. A. Explain why a company in LR's position may want to undertake a quasi-reorganization? B. What steps are involved in a quasi-reorganization? C. Present the necessary journal entries? Cash 30,000 Receivables 55,000 Inventory 70,000 PP&E (net) 175,000 Total Assets 330,000 Liabilities 150,000...
Calls in arrears' is shown in the balance sheet on the liability side _____________.
Calls in arrears' is shown in the balance sheet on the liability side _____________.A. By deducting the amount from the called up capitalB. Under the heading Reserves and SurplusC. By deducting the amount from the called up capital reservesD. By deducting the amount from the shares forfeited account
Balance Sheet Preparation The December 31, 2016, balance sheet accounts of Hitt Company are shown here...
Balance Sheet Preparation The December 31, 2016, balance sheet accounts of Hitt Company are shown here in alphabetical order: Accounts Payable $20,800 Equipment $72,400 Accounts Receivable 21,000 Inventory 37,200 Accumulated Depreciation: Buildings 53,000 Land 30,000 Accumulated Depreciation: Equipment 35,100 Marketable Securities (short-term) 6,100 Additional Paid-in Capital on Common Stock 24,000 Patents (net) 9,500 Additional Paid-in Capital on Preferred Stock 11,500 Preferred Stock, $100 par 21,000 Allowance for Doubtful Accounts 800 Retained Earnings 53,740 Bonds Payable (due 2024) 77,000 Revenues 107,000...
Unclaimed dividend is shown on the liability side of the balance sheet of a company as ___________.
Unclaimed dividend is shown on the liability side of the balance sheet of a company as ___________.A. Share CapitalB. Current LiabilitiesC. Reserves & SurplusD. Non-Current Liability 
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT