Prepare a worksheet to develop financial statements

Assignment Help Financial Accounting
Reference no: EM131332361

1. Wellplace Hospital provides you with the following financial statements for 20X2 and 20X1:


December 31


20X2

20X1

Cash

$ 168

$ 211

Temporary investments

126

34

Receivables-patients, net

1,011

893

Inventory

296

315

Prepaid expenses

25

29

Total current assets

1,626

1,482

Long-term investments

466

442

Plant assets, net

8,126

8,185

Other assets

167

88

Total

$10,385

$10,197

Current portion of long-term debt

$ 180

$ 180

Notes payable

125

75

Accounts payable

196

202

Accrued expenses payable

238

217

Payroll taxes withheld

81

63

Advances from third-party payers

75

55

Other

42

29

Total current liabilities

937

821

Long-term debt

1,718

1,865

Total liabilities

2,655

2,686

Net assets

7,730

7,511

Total

$10,385

$10,197


Year Ended 12/31


20X2

20X1

Gross patient services revenues

$ 8,830

$ 7,326

Deductions from patient services revenues

1,430

1,465

Net patient services revenues

7,400

5,861

Other operating revenues

505

407

Total operating revenues

7,905

6,268

Less operating expenses:



Nursing services

2,560

2,197

Other professional services

2,050

1,615

Administrative services

1,350

1,033

Other operating services

1,925

1,614

Total operating expenses

7,885

6,459

Operating income (loss)

20

(191)

Nonoperating revenues, net

224

176

Excess of revenues over expenses (loss) for the year

$ 244

$ (15)

The other operating services include expenses of $520 of depreciation, $110 of interest expense, and $790 of insurance expense.

Required:

(1) Develop a horizontal analysis of these statements.
(2) Convert the above financial statements to common size.
(3) Prepare a ratio analysis of 20X2 operating results.
(4) Prepare a ratio analysis of the December 31, 20X2 financial position.

2. The following is the preadjusted trial balance of Grandtown Hospital at December 31, 20X1, the end of the hospital's current fiscal year:
The following additional information is available:

Acct. No.

 

Dr.

Cr.

101

Cash       

$ 37,500

 

102

Temporary investments    

30,000

 

103

Accrued interest receivable

-0-

 

104

Accounts receivable      

120,000

 

105

Allowance for uncollectible accounts

 

$ -0-

106

Inventory       

14,000

 

107

Prepaid insurance       

3,600

 

120

Land        

25,000

 

130

Buildings      

250,000

 

131

Accumulated depreciation-buildings

 

-0-

140

Equipment        

140,000

 

141

Accumulated depreciation-equipment

 

-0-

201

Accounts payable

 

37,400

203

Accrued interest payable

 

-0-

204

Accrued salaries and wages payable

 

-0-

205

Deferred rental income

 

2,700

250

Bonds payable

 

150,000

301

Hospital net assets

 

395,700

302

Revenue and expense summary

 

-0-

401

Routine services revenue

 

171,200

402

Ancillary services revenue

 

110,300

403

Interest income

 

-0-

404

Rental income

 

-0-

406

Other operating revenues

 

23,500

501

Contractual adjustments    

22,700

 

502

Charity care adjustments   

31,100

 

601

Salaries and wages expense  

155,600

 

602

Supplies expense

33,100

 

603

Utilities expense

14,900

 

604

Insurance expense

-0-

 

605

Repairs expense

6,400

 

607

Depreciation expense

-0-

 

608

Interest expense

4,500

 

609

Bad debt expense

-0-

 

610

Other expenses

2,400

 

 

Totals

$890,800

$890,800

1. The temporary investment consists of $30,000 (face value) of 8 percent bonds acquired by the hospital on November 1, 20X1. These bonds pay interest annually on November 1, commencing on November 1, 20X2.

2. Of the December 31, 20X1, accounts receivable, it is estimated that 14 percent will eventually prove uncollectible by reason of
(1) charity care, 7 percent; (2) contractual adjustments, 4 per- cent; and (3) bad debts, 3 percent.

3. A two-year insurance premium of $3,600 was paid in advance by the hospital on January 1, 20X1.

4. The hospital building, which was acquired on January 1, 20X1, has an estimated useful life of 50 years and a 20 percent salvage value.

5. The equipment, which was acquired on January 1, 20X1, has an estimated useful life of 12 years and a $20,000 salvage value.

6. On January 1, 20X1, the hospital issued $150,000 of 20-year, 6 percent bonds at face value. These bonds pay interest semiannu- ally on January 1 and July 1, commencing July 1, 20X1.

7. Unpaid salaries and wages at December 31, 20X1, amounted to $12,300.

8. The hospital received one year's rent of $2,700 in advance on June 1, 20X1.

Required:

(1) Prepare a worksheet to develop financial statements in the manner illustrated in table.
(2) Prepare, in good form, a complete set of financial statements for 20X1.
(3) Prepare, in general journal form, the necessary adjusting entries at December 31, 20X1, for the year then ended.
(4) Prepare, in general journal form, the necessary closing entries on December 31, 20X1, for the year then ended.

Reference no: EM131332361

Questions Cloud

Why did the federal reserve agree to this policy : In World War II the Federal Reserve engaged in a rudimentary form of Open Market Operations and   purchased large amounts of Liberty Bonds directly from the US Treasury. Why did the Federal Reserve agree to this policy? Under today’s conditions, this..
Does the game have another nash equilibrium : Exercise shows that an extensive-form perfect equilibrium is not necessarily a strategic-form perfect equilibrium.- Does the game have another Nash equilibrium? Does it have another subgame perfect equilibrium?
Effective annual cost of trade credit under terms : Pets Store Inc. sells on terms of 3/20, net 75. What is the effective annual cost of trade credit under these terms? Use a 365-day year.
What were economic consequences of federal reserve actions : In 1929 The U.S. Stock Market crashed. In response to this domestic financial emergency, The Federal Reserve sharply raised the discount rate (shrinking the money supply). List all the reasons the Federal Reserve took this action in 1929? What were t..
Prepare a worksheet to develop financial statements : Prepare a worksheet to develop financial statements in the manner illustrated in table. Prepare, in good form, a complete set of financial statements for 20X1.
Determining the annual coupon rate : Fresh Fruit, Inc. has a $1,000 par value bond that is currently selling for $1,277. it has an annual coupon rate of 12.86 percent, paid semiannually, and has 28-years remaining until maturity. What would the annual yield to maturity be on the bond..
Firm using discount rate : Consider the following projects, for a firm using a discount rate of 10%: Project NPV IRR A $200,000 10.2% B $(200,001) 11% C $1 10% D $(235,000) 9% If the projects are independent, which, if any, project(s) should the firm accept?
Issued nonconvertible preferred stock : Potter's Violin Co. has just issued nonconvertible preferred stock with a par value of $100 and an annual dividend rate of 18.66 percent. The preferred stock is currently selling for $119.42 per share. which rate of return does the investor expect..
Show that the given game has a unique nash equilibrium : Show that the following game has a unique Nash equilibrium, and in particular a unique extensive-form perfect equilibrium and a unique strategic-form perfect equilibrium.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Shrinkage in the most recent year

The Home Depot experienced no shrinkage in the most recent year. Using both companies' balance sheet and income statement

  Indicate dollar amount to be reported as a current liability

Norma Smith is the controller of Baylor Corporation and is responsible for the preparation of the year-end financial statements. The following transactions occurred during the year.

  Compute the degree of operating leverage for each company

Compute the degree of operating leverage for each company. Assume that sales revenue decreases by 20%. Prepare a CVP income statement for each company.

  Tvm calculations

What is the time value of money (TVM)? Why is this concept important in accounting? Under what circumstances might we use TVM calculations?

  Consumer goods companies take regional approach to marketing

Which of the following is a reason why consumer goods companies take a regional approach to marketing? Which of the following is a similarity between a stock market and a labor market? Which of the following is an advantage of a multisegment targetin..

  Which company is larger in terms of assets and revenues

Which company is larger in terms of assets and in terms of revenues? What do you think is the best way to measure the size of a company?

  Representation of assets at fmv isnbsp it rightgenerally

representation of assets at fmv isnbsp it right.generally accepted accounting principles require that most assets be

  Provide journal entries to record actual overhead costs

Provide appropriate journal entries to record actual overhead costs, standard overhead costs applied to production, and all four overhead variances.

  Consultation regarding their personal taxes

A couple comes into your office for a consultation regarding their personal taxes. They make $178,000 combined but want to discuss some potential deductions. They inform you they may have new capital losses, depreciation of capital assets, and may ha..

  A major perspective on accounting financial reporting

a major perspective on accounting financial reporting regulation views regulation as being required to protect the

  Describe whether you believe an accounting process

it was the accounting rule that caused the financial institutions' balance sheets to look bad. Describe whether you believe that following an accounting process can cause a company to experience economic problems.

  Prepare single-step income statement and retained earnings

Prepare a single-step income statement and a retained earnings statement. McGrath Co. has 275,000 shares of common stock outstanding.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd