Complete the balance sheet Cash 30,000 Marketable securities 25,000 Accounts rec
ID: 2507603 • Letter: C
Question
Complete the balance sheet
Cash 30,000
Marketable securities 25,000
Accounts receivable ???
Inventories ???
Total Current Assets ???
Net Fixed Assets ???
Total Assets ???
Accounts Payable 120,000
Line of Credit ???
Accurals 20,000
Total Current Liabilities ???
Long Term Debt ???
Shareholders equity ???
Total Liabailities and sharholders equity ???
The following is given:
Sales totaled 1,825,000
Gross margin was 25%
Average age of inventory was 60 days
average collection period was 40 days
the current ratio was 1.60
the total asset turnover ratio was 1,25
the debt ratio was 60%
Explanation / Answer
Average age of inventory was 60 days
365 / (Cost of Goods Sold / Inventory)
Since gross margin is 25% of sales, COGS is 75%
1,825,000 x 75% = $1,368,750 COGS
Plug that into the formula to get Inventory = $225,000
average collection period was 40 days
365 / (Sales / Accounts Receivable)
Plug the Sales amount (1,825,000) to get A/R = $200,000
the current ratio was 1.60
Current Assets / Current Liabilities
Now that you have all the current assets ($480,000) plug that in to get Current Liabilities = $300,000
Now that you have total Current Liabilities you can also calculate Line of Credit (also a current liability)
A/P + LOC + Acc = Total Liabilities
Line of Credit = $160,000
the total asset turnover ratio was 1,25
Sales / Total Assets
By plugging in Sales you can find total assets.
Total Assets = $1,460,000
Then subtract current assets from total assets to get
Fixed Assets = $980,000
the debt ratio was 60%
Total Liabilities / Total Assets
You can calculate Total Liabilities (and Long-Term Debt) by plugging in Total assets.
Total Liabilities = $876,000
876,000 - 300,000 (current liabilities) = $576,000 L/T Debt
Now you have every thing except Shareholders' Equity. Just use the basic accounting equation:
Assets = Liabilities + Equity
Plug in Total Assets and Liabilities to get Equity = $584,000
584,000 + 876,000 = $1,460,000 Total liabilities and shareholders' equity
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.