PLEASE USE EXCEL Jackson Park Company has current assets of $32,450, net fixed assets of $72,340,...

PLEASE USE EXCEL

Jackson Park Company has current assets of $32,450, net fixed assets of $72,340, current liabilities of $17,842, and long-term debt of $53,200.

a. Prepare the Balance Sheet for the company and answer the following:

b. What is the value of shareholder’s equity account for the firm?

c. How much is net working capital?

Solutions

Expert Solution

Following is the excel worksheet showing the required answers:-

Following is the Formula Sheet of above excel worksheet for easy understanding of the formulas used:-

[ Note:- Shareholder’s equity = Total Assets - ( Current liabilities + Long-term debt)

Net Working Capital = Current assets - Current liabilities ]

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Kroeger, Inc., has current assets of $2,320, net fixed assets of $10,800, current liabilities of $1,425,...

Kroeger, Inc., has current assets of $2,320, net fixed assets of $10,800, current liabilities of $1,425, and long-term debt of $4,130. (Enter your answer as directed, but do not round intermediate calculations.) Requirement 1: What is the value of the shareholders’ equity account for this firm? Shareholder's equity $ Requirement 2: How much is net working capital? Net working capital

1 Building a Balance Sheet KCCO, Inc. has current assets of $5,300, net fixed assets of $23,900,...

1 Building a Balance Sheet KCCO, Inc. has current assets of $5,300, net fixed assets of $23,900, current liabilities of $4,100, and long-term debt of $10,600. What is the value of shareholder’s equity for this firm? How much is net working capital?

Bing, Incorporated, has current assets of $4,750, net fixed assets of $23,900, current liabilities of $3,000, and long-term debt of $13,400.

Bing, Incorporated, has current assets of $4,750, net fixed assets of $23,900, current liabilities of $3,000, and long-term debt of $13,400.a. What is the value of the shareholders' equity account for this firm? (Do not round intermediate calculations.)b. How much is net working capital? (Do not round intermediate calculations.)a. Shareholders' equity _____b. NWC ______

Bing, Incorporated, has current assets of $4,750, net fixed assets of $23,900, current liabilities of $3,000, and long-term debt of $13,400.

Arredondo, Inc., has current assets of $2,076, net fixed assets of $10,157, current liabilities of $684, and long-term debt of $1,753.

Arredondo, Inc., has current assets of $2,076, net fixed assets of $10,157, current liabilities of $684, and long-term debt of $1,753. What is the value of the shareholders’ equity account for this firm?

The balance sheet of MT Co. shows current assets of $14,000, net fixed assets of $21,800,...

The balance sheet of MT Co. shows current assets of $14,000, net fixed assets of $21,800, current liabilities of $4,300, long-term debt of $2,600, and equity of $28,900. The balance sheet of LF Inc. has current assets of $4,700, net fixed assets of $8,100, current liabilities of $2,200, long-term debt of $1,200, and equity of $9,400. The market value of LF's fixed assets is $14,100. MT purchases LF for $20,000 and raises the funds through an issue of long-term debt....

Assume XYZ total assets $1,000,000 and net fixed $600,000. But current liabilities $200,000. Calculate the company...

Assume XYZ total assets $1,000,000 and net fixed $600,000. But current liabilities $200,000. Calculate the company current ratio? Select one : a. 3x b. 2x c. 1.5x d. 4x q2:An investor is considering purchasing a 10-year zero-coupon bond of $1,000 par value. If the current interest rate for equally risky bonds is 13%. The bond will be sold at? Select one: a. Premium. b. Fair value. c. Discount. Assume a bond is trading at par, and it pays a coupon...

Net capital spending is equal to: ending net fixed assets minus beginning net fixed assets plus...

Net capital spending is equal to: ending net fixed assets minus beginning net fixed assets plus depreciation. ending total assets minus beginning total assets plus depreciation. ending net fixed assets minus beginning net fixed assets minus depreciation. beginning net fixed assets minus ending net fixed assets plus depreciation.

Colter Steel has $5,050,000 in assets. Temporary current assets $ 2,100,000 Permanent current assets 1,555,000 Fixed...

Colter Steel has $5,050,000 in assets. Temporary current assets $ 2,100,000 Permanent current assets 1,555,000 Fixed assets 1,395,000 Total assets $ 5,050,000 Assume the term structure of interest rates becomes inverted, with short-term rates going to 14 percent and long-term rates 2 percentage points lower than short-term rates. Earnings before interest and taxes are $1,070,000. The tax rate is 30 percent. If long-term financing is perfectly matched (synchronized) with long-term asset needs, and the same is true of short-term...

Colter Steel has $5,450,000 in assets. Temporary current assets $ 2,900,000 Permanent current assets 1,595,000 Fixed...

Colter Steel has $5,450,000 in assets. Temporary current assets $ 2,900,000 Permanent current assets 1,595,000 Fixed assets 955,000 Total assets $ 5,450,000 Short-term rates are 7 percent. Long-term rates are 12 percent. Earnings before interest and taxes are $1,150,000. The tax rate is 20 percent. If long-term financing is perfectly matched (synchronized) with long-term asset needs, and the same is true of short-term financing, what will earnings after taxes be?

Subjects