I have answered the question below using excel and have attached the image below.
Please up vote for the same and thanks!!!
Do reach out in the comments for any queries
Answer:
Answer to Part a)
Debt to Asset Ratio = Total Liabilities / Total Assets
Assets = Total Liabilities + Equity fund
Therefore, total assets = $ 6,834,000
Total Liabilities = Total Assets - Common Equity
Total Liabilities =$ 6,834,000– 4,947,000
Total Liabilities = $ 1,887,000
Debt to Asset Ratio = Total Liabilities / Total Assets
Debt to Assets Ratio = $ 1,887,000 / $ 6,834,000
Debt to Assets Ratio = 27.61%
Answer to Part b)
Since, the Campbell is planning to purchase a new warehouse using the long term debt for $ 1.2 million, its assets and liabilities will increase by $ 1.2 million
New Assets = $ 6,834,000 + $ 1,200,000 = $ 8,034,000
New Liabilities = $ 1,887,000+ $ 1,200,000 = $ 3,087,000
Debt to Assets Ratio = $ 3,087,000/$ 8,034,000
Debt to Assets Ratio = 38.42%
(Related to Checkpoint 4.2) (Capital structure analysis) The liabilities and owners' equity for Campbell Industries is...
(Related to Checkpoint 4.2) (Capital structure analysis) The liabilities and owners' equity for Campbell Industries is found here: a. What percentage of the firm's assets does the firm finance using debt (liabilities)? b. If Campbell were to purchase a new warehouse for $1.1 million and finance it entirely with long-term debt, what would be the firm's new debt ratio? a. What percentage of the firm's assets does the firm finance using debt liabilities)? The fraction of the firm's assets that...
(Capital structure analysis) The liabilities and owners' equity for Campbell Industries is found here: . Accounts payable $ 459 comma 000$459,000 Notes payable $250,000 Current liabilitie $709,000 Long-term debt $1,217,000 Common equity $4,841,000 Total liabilities and equity $6,767,000 a. What percentage of the firm's assets does the firm finance using debt (liabilities)? b. If Campbell were to purchase a new warehouse for $ 1.3$1.3 million and finance it entirely with long-term debt, what would be the firm's new debt ratio?...
Question 2. (10 points total) Use this data table of Campbell Industries liabilities and owners' equity to complete parts a and b Accounts payable Notes payable Current liabilities Long-term debt Common equity Total liabilities and equity S330,000 S252,000 782,000 1,127,000 $4,939,000 S6,348,000 (5 points) What percentage of the firm's assets does the firm finance using debt (liabilities)? Round to one decimal place.) a. (5 points) If Campbell were to purchase a new warehouse for $1.3 million and finance it entirely...
Accounts payable $454,000 Notes payable $246,000 Current liabilities $700,000 Long-term debt $1,136,000 Common equity $5,261,000 Total liabilities and equity $7,097,000 (Related to Checkpoint 4.2) (Capital structure analysis) The liabilities and owners' equity for Campbell Industries is found here: . a. What percentage of the firm's assets does the firm finance using debt (liabilities)? b. If Campbell were to purchase a new warehouse for $ 1.2 million and finance it entirely with long-term debt, what would be the firm's new debt...
Need insight on question b. please COMPANY ABC Accounts payable $510,000 , Notes payable $256,000, Current liabilities $766,000, Long-term debt $1,114,000, Common equity $4,779,000, Total liabilities & equity $6,659,000 a. What percentage of the firm's assets does the firm finance using debt (liabilities)? The fraction of the firm's assets that the firm finances using debt is 28.2%. b. If ABC were to purchase a new warehouse for $ 1.1 million and finance it entirely with long-term debt, what would be...
a. What percentage of the firm's assets does the firm finance using debt (liabilities)? b. If Rogers were to purchase a new warehouse for $1.1 million and finance it entirely with long-term debt, what would be the firm's new debt ratio? Accounts payable $471,000 Notes payable $244,000 Current liabilities $715,000 Long-term debt $1,206,000 Common equity $4,704,000 Total liabilities and equity $6,625,000 PLEASE answer questions a. and b. legibly. Thank you.
JUST DEW IT CORPORATION . 2017 and 2018 Balance Sheets Assets Liabilities and Owners' Equity 2017 2018 2017 2018 Current assets Current liabilities $ 39,040 48,720 17,280 $ 4,000 11.280 20,400 90,480 $80,800 122,160 Cash Accounts Accounts payable Notes payable 14,880 12,960 receivable Inventory 61,920 Total $52.000 66,000 $ 48,000 36,000 Total Long-term debt Owners' equity surplus Common stock and paid-in $60,000 60,000 160,000 318,000 $220,000 $378.000 Total liabilities and owners' $320,000 $480,000 Retained earnings Net plant and equipment $239,200...
Complete the table below for the liabilities and owners' equity
part of the balance sheet
Barron Pizza, Inc. Balance Sheet as of December 31, 2012, 2013, and 2014 (S in thousands) LIABILITIES 2014 2013 2012 Current liabilities Accounts payable s $ 74.480 $ 66,107 Short-term debt $ 271 $ $ 300 Total current liabilities $ 80,948 $ 74,712 $ Long-term debt $ 60,984 $C $ 184,975 Other liabilities $ 28,817 $ 20,182 Total liabilities $ 187,832 $ 243,549 $ OWNERS'...
JUST DEW IT CORPORATION 2017 and 2018 Balance
Sheets
Assets
Liabilities and Owners’ Equity
2017
2018
2017
2018
Current assets
Current liabilities
Cash
$
11,250
$
19,440
Accounts payable
$
30,600
$
49,200
Accounts receivable
11,850
16,080
Notes payable
24,900
31,200
Inventory
39,150
60,240
Total
$
62,250
$
95,760
Total
$
55,500
$
80,400
Long-term debt
$
27,000
$
24,000
Owners’ equity
Common stock and paid-in
surplus
$
48,000
$
48,000
Retained earnings
169,500
327,600
Net plant and equipment
$...
JUST DEW IT CORPORATION
2017 and 2018 Balance Sheets
Assets
Liabilities and Owners’ Equity
2017
2018
2017
2018
Current assets
Current liabilities
Cash
$
6,600
$
12,750
Accounts payable
$
50,000
$
68,750
Accounts receivable
12,200
14,250
Notes payable
19,000
35,500
Inventory
78,200
95,250
Total
$
97,000
$
122,250
Total
$
69,000
$
104,250
Long-term debt
$
48,000
$
45,000
Owners’ equity
Common stock and paid-in
surplus
$
50,000
$
50,000
Retained earnings
233,000
300,750
Net plant and equipment
$...