Consolidation worksheet, consolidated financial statements

On 1 July 2018, Ghostbusters Ltd acquired all the shares of Bat Ltd for $305 000 on an ex-div. basis. On this date, the equity and liabilities of Bat Ltd included the following balances:

At acquisition date, all the identifiable assets and liabilities of Bat Ltd were recorded at

amounts equal to fair value except for:

Goodwill was not impaired in any period. The plant and equipment had a further 5-year life at acquisition date and was expected to be used evenly over that time. The trademark was considered to have an indefinite life. The machinery, which was estimated to have a further 4-year life at acquisition date, was sold on 1 January 2020. Any adjustments for differences between carrying amounts at acquisition date and fair values are made on consolidation.

During the year ended 30 June 2019, all inventories on hand at acquisition date were sold, and the land was sold on 1 June 2020. Any valuation reserves created are transferred on consolidation to retained earnings when assets are sold or fully consumed.

Additional information

Of the interim dividend paid by Bat Ltd in the current year, $5000 was from profits before acquisition date. All other dividends were from current year profits. Shareholder approval is not required in relation to dividends.

On 1 July 2019, Bat Ltd has on hand inventory worth $12 000, being transferred from Ghostbusters Ltd in June 2019. The inventory had previously cost Ghostbusters Ltd $8000. On 31 March 2020, Bat Ltd transferred an item of plant with a carrying amount of $10 000 to Ghost Ltd for $15 000. Ghostbusters Ltd treated this item as inventory. The item was still on hand at the end of the year. Bat Ltd applied a 20% depreciation rate to this plant.

On 1 January 2020, Bat Ltd acquired $8000 inventory from Ghostbusters Ltd. This inventory originally cost Ghostbusters Ltd $5000. The profit in inventory on hand at 30 June 2020 was $1000.

During the year ending 30 June 2020, Bat Ltd sold inventory costing $12 000 to Ghostbusters Ltd for $18 000. Two-thirds of this was sold to external parties for $9000.

On 1 January 2019, Ghostbusters Ltd sold furniture to Bat Ltd for $8000. This had originally cost Ghostbusters Ltd $12 000 and had a carrying amount at the time of sale of $7000. Both entities charge depreciation at a rate of 10% p.a.

Ghostbusters Ltd sold some land to Bat Ltd in December 2019. The land had originally cost Ghostbusters Ltd $25 000, but was sold to Bat Ltd for only $20 000. To help Bat Ltd pay for the land, Ghostbusters Ltd gave Bat Ltd an interest-free loan of $12 000. Bat Ltd has as yet made no repayments on the loan.

The tax rate is 30%.

On 30 June 2020 the trial balances of Ghostbusters Ltd (Ghost) and Bat Ltd were as follows:

Required

Prepare the consolidation journal / worksheet entries for Ghostbusters Ltd for 30/6/2020.

Update and complete the consolidation worksheet for 30/6/2020. Use the worksheet provided below

Marmidan Mold Shop Inc. designs and builds molds for the automotive and aircraft industries. The account balances in the company’s general ledger on January 1, 2020 (first day of the new annual fiscal year) were as follows (all account balances are in their normal position):

Cash                                                                    $     3,700

Accounts receivable                                                   5,900

Supplies inventory                                                    29,300

Land                                                                        168,500  

Buildings                                                                 116,500

Accumulated depreciation, buildings                       37,500   

Equipment                                                                 58,500

Accumulated depreciation, equipment                     18,000

Accounts payable                                                      25,200

Income tax payable                                                   16,600

Interest payable                                                           4,200

Wages payable (due in 2020)                                    15,700                                         

9% Notes payable ($10,000 due June 30, 2021,

     balance due June 30, 2022)                                  61,500

Common shares                                                       151,500

Retained earnings, Dec. 31, 2019                              52,200  

Transactions during 2020:

1.The company provided sales services to customers, on credit, for $ 210,300. In addition, the company produced cash sales to customers of $ 62,300.

2.Accounts receivable from customers of $ 15,600 remain to be collected at December 31, 2020.

3.Inventory of $ 62,900 was purchased on credit and debited to the supplies inventory account.

4.Minor parts were purchased with cash for $ 7,400 and debited to the supplies inventory account.

5.Wages payable at the beginning of 2020 were paid early in 2020. In addition, wages were earned by employees and paid during 2020 in the amount of $ 112,000.

6.Income tax payable at the beginning of 2020 was paid early in 2020.

7.Payments of $ 73,000 were made to creditors for supplies previously purchased on credit.

8.One year’s interest at 9% was paid on the notes payable at July 1, 2020.

9. During 2020, Don Tallint, the principal shareholder, purchased a new car for his wife

    Debbie. The new car cost $ 45,000 and was paid for with cash from personal sources.

10.Property taxes were paid on the land and buildings in the amount of $ 17,000 with cash.

11.Dividends were declared and paid in caah in the amount of $ 7,200.

Information available for year end adjusting entries:

12.•Supplies inventory was counted on December 31, 2020 and it was determined the supplies inventory still on hand at yearend was $ 31,900.

13. •Annual depreciation on the buildings is $ 6,000.

14•Annual deprecation on the equipment is $ 5,500

15•Additional wages of $4,000 were earned but are unpaid and unrecorded at December 31, 2020.

16•Interest for six months at 9% per year on the notes payable is unpaid and unrecorded at December 31, 2020..

17•Income taxes of $ 16,500 were unpaid and unrecorded at December 31, 2020.

Required:

1.Record beginning 2020 beginning balances in T accounts. Prepare journal entries for transactions 1 to 11 above as required and record the journal entries in T accounts while

adding any new T accounts that you need as you complete this task.

2.Prepare any necessary adjusting journal entries fpr items 11 to 17 above and record the adjusting journal entries in the T accounts while adding any new T accounts that you need as you complete this task.

3. Prepare a single step income statement for Marmidan Mold Shop Inc. for the year ended December 31, 2020.

4.Prepare a statement of retained earnings for Marmidan Mold Shop Inc. for the year ended December 31, 2020.

5.Prepare a classified statement of financial position for Marmidan Mold Shop Inc. as at December 31, 2020

Homespun Company manufactures pillows. For 2020​, the company expects fixed overhead costs of $120,000. Homespun uses​ machine-hours to allocate fixed overhead costs and anticipates 6,000 hours during the year to manufacture 24,000 pillows. During 2020​, Homespun manufactured 23,000 pillows and spent $116,000 on fixed overhead costs. Calculate the​ following:

a. The fixed overhead rate for 2020

b. The fixed overhead spending variance for 2020

c. The​ production-volume variance for

On January 1, 2020, Creative Accounting (CA) Company capitalized $500,000 of costs it incurred to internally develop a patent. CA Company paid these costs in cash. It reported an amortization expense in the 2020 fiscal year for the patent. CA Company estimated the amortization expense for 2020 for the patent to be one tenth of the original cost. What is the effect of these journal entries on 2020 financial statements? Specifically, calculate the numerical impact on Net Income, Assets, Liabilities and shareholders’ equity

On April 1, 2020, Darius acquired 2,000 ordinary shares at P48 per share in Alan Enterprises and classified the Equity investment FVOCI. In addition, the broker’s commissions for this transaction were P2,400. During 2020, Darius received P7,200 in cash dividends, and on July 1, 2020, a 5% stock dividend was issued. On December 1, Alan issued a 2-for-1- stock split. At December 31, 2020, the book value per ordinary share held by Darius is?

Riverbed Corporation had 2020 net income of $777,000. During 2020, Riverbed paid a dividend of $2 per share on 45,500 shares of preferred stock. During 2020, Riverbed had outstanding 245,000 shares of common stock. Compute Riverbed’s 2020 earnings per share. (Round answer to 2 decimal places, e.g. 3.56.) Earnings per share $enter earnings per share in dollars rounded to 2 decimal places per share

Marmidan Mold Shop Inc. designs and builds molds for the automotive and aircraft industries. The account balances in the company’s general ledger on January 1, 2020 (first day of the new annual fiscal year) were as follows (all account balances are in their normal position):

Cash                                                                    $     3,700

Accounts receivable                                                   5,900

Supplies inventory                                                    29,300

Land                                                                        168,500  

Buildings                                                                 116,500

Accumulated depreciation, buildings                       37,500   

Equipment                                                                 58,500

Accumulated depreciation, equipment                     18,000

Accounts payable                                                      25,200

Income tax payable                                                   16,600

Interest payable                                                           4,200

Wages payable (due in 2020)                                    15,700                                         

9% Notes payable ($10,000 due June 30, 2021,

     balance due June 30, 2022)                                  61,500

Common shares                                                       151,500

Retained earnings, Dec. 31, 2019                              52,200         

Transactions during 2020:

1.The company provided sales services to customers, on credit, for $ 210,300. In addition, the company produced cash sales to customers of $ 62,300.

2.Accounts receivable from customers of $ 15,600 remains to be collected at December 31, 2020.

3.Inventory of $ 62,900 was purchased on credit and debited to the supplies inventory account.

4.Minor parts were purchased with cash for $ 7,400 and debited to the supplies inventory account.

5.Wages payable at the beginning of 2020 were paid early in 2020. In addition, wages were earned by employees and paid during 2020 in the amount of $ 112,000.

6.Income tax payable at the beginning of 2020 was paid early in 2020.

7.Payments of $ 73,000 were made to creditors for supplies previously purchased on credit.

8.One year’s interest at 9% was paid on the notes payable at July 1, 2020.

9. During 2020, Don Tallint, the principal shareholder, purchased a new car for his wife

    Debbie. The new car cost $ 45,000 and was paid for with cash from personal sources.

10.Property taxes were paid on the land and buildings in the amount of $ 17,000 with cash.

11.Dividends were declared and paid in cash in the amount of $ 7,200.

Information available for year end adjusting entries:

12.•Supplies inventory was counted on December 31, 2020 and it was determined the supplies inventory still on hand at yearend was $ 31,900.

13. •Annual depreciation on the buildings is $ 6,000.

14•Annual deprecation on the equipment is $ 5,500

15•Additional wages of $4,000 were earned but are unpaid and unrecorded at December 31, 2020.

16•Interest for six months at 9% per year on the notes payable is unpaid and unrecorded at December 31, 2020..

17•Income taxes of $ 16,500 were unpaid and unrecorded at December 31, 2020.

Q: please Record beginning 2020 beginning balances in T accounts. Prepare journal entries for transactions 1 to 11 above as required and record the journal entries in T accounts while adding any new T accounts that you need as you complete this task.

Marmidan Mold Shop Inc. designs and builds molds for the automotive and aircraft industries. The account balances in the company’s general ledger on January 1, 2020 (first day of the new annual fiscal year) were as follows (all account balances are in their normal position):

Cash                                                                    $     3,700

Accounts receivable                                                   5,900

Supplies inventory                                                    29,300

Land                                                                        168,500  

Buildings                                                                 116,500

Accumulated depreciation, buildings                       37,500   

Equipment                                                                 58,500

Accumulated depreciation, equipment                     18,000

Accounts payable                                                      25,200

Income tax payable                                                   16,600

Interest payable                                                           4,200

Wages payable (due in 2020)                                    15,700                                         

9% Notes payable ($10,000 due June 30, 2021,

     balance due June 30, 2022)                                  61,500

Common shares                                                       151,500

Retained earnings, Dec. 31, 2019                              52,200         

Transactions during 2020:

1.The company provided sales services to customers, on credit, for $ 210,300. In addition, the company produced cash sales to customers of $ 62,300.

2.Accounts receivable from customers of $ 15,600 remain to be collected at December 31, 2020.

3.Inventory of $ 62,900 was purchased on credit and debited to the supplies inventory account.

4.Minor parts were purchased with cash for $ 7,400 and debited to the supplies inventory account.

5.Wages payable at the beginning of 2020 were paid early in 2020. In addition, wages were earned by employees and paid during 2020 in the amount of $ 112,000.

6.Income tax payable at the beginning of 2020 was paid early in 2020.

7.Payments of $ 73,000 were made to creditors for supplies previously purchased on credit.

8.One year’s interest at 9% was paid on the notes payable at July 1, 2020.

9. During 2020, Don Tallint, the principal shareholder, purchased a new car for his wife

    Debbie. The new car cost $ 45,000 and was paid for with cash from personal sources.

10.Property taxes were paid on the land and buildings in the amount of $ 17,000 with cash.

11.Dividends were declared and paid in cash in the amount of $ 7,200.

Information available for year end adjusting entries:

12.•Supplies inventory was counted on December 31, 2020 and it was determined the supplies inventory still on hand at yearend was $ 31,900.

13. •Annual depreciation on the buildings is $ 6,000.

14•Annual deprecation on the equipment is $ 5,500

15•Additional wages of $4,000 were earned but are unpaid and unrecorded at December 31, 2020.

16•Interest for six months at 9% per year on the notes payable is unpaid and unrecorded at December 31, 2020.

17•Income taxes of $ 16,500 were unpaid and unrecorded at December 31, 2020.

Required:

Prepare a statement of retained earnings for Marmidan Mold Shop Inc. for the year ended December 31, 2020. (Please record  on the electronic worksheet)

Marmidan Mold Shop Inc. designs and builds molds for the automotive and aircraft industries. The account balances in the company’s general ledger on January 1, 2020 (first day of the new annual fiscal year) were as follows (all account balances are in their normal position):

Cash                                                                    $     3,700

Accounts receivable                                                   5,900

Supplies inventory                                                    29,300

Land                                                                        168,500  

Buildings                                                                 116,500

Accumulated depreciation, buildings                       37,500   

Equipment                                                                 58,500

Accumulated depreciation, equipment                     18,000

Accounts payable                                                      25,200

Income tax payable                                                   16,600

Interest payable                                                           4,200

Wages payable (due in 2020)                                    15,700                                         

9% Notes payable ($10,000 due June 30, 2021,

     balance due June 30, 2022)                                  61,500

Common shares                                                       151,500

Retained earnings, Dec. 31, 2019                              52,200         

Transactions during 2020:

1.The company provided sales services to customers, on credit, for $ 210,300. In addition, the company produced cash sales to customers of $ 62,300.

2.Accounts receivable from customers of $ 15,600 remain to be collected at December 31, 2020.

3.Inventory of $ 62,900 was purchased on credit and debited to the supplies inventory account.

4.Minor parts were purchased with cash for $ 7,400 and debited to the supplies inventory account.

5.Wages payable at the beginning of 2020 were paid early in 2020. In addition, wages were earned by employees and paid during 2020 in the amount of $ 112,000.

6.Income tax payable at the beginning of 2020 was paid early in 2020.

7.Payments of $ 73,000 were made to creditors for supplies previously purchased on credit.

8.One year’s interest at 9% was paid on the notes payable at July 1, 2020.

9. During 2020, Don Tallint, the principal shareholder, purchased a new car for his wife

    Debbie. The new car cost $ 45,000 and was paid for with cash from personal sources.

10.Property taxes were paid on the land and buildings in the amount of $ 17,000 with cash.

11.Dividends were declared and paid in caah in the amount of $ 7,200.

Information available for year end adjusting entries:

12.•Supplies inventory was counted on December 31, 2020 and it was determined the supplies inventory still on hand at yearend was $ 31,900.

13. •Annual depreciation on the buildings is $ 6,000.

14•Annual deprecation on the equipment is $ 5,500

15•Additional wages of $4,000 were earned but are unpaid and unrecorded at December 31, 2020.

16•Interest for six months at 9% per year on the notes payable is unpaid and unrecorded at December 31, 2020.

17•Income taxes of $ 16,500 were unpaid and unrecorded at December 31, 2020.

Required:

Prepare a single step income statement for Marmidan Mold Shop Inc. for the year ended December 31, 2020. (Please record  on the electronic worksheet)

Marmidan Mold Shop Inc. designs and builds molds for the automotive and aircraft industries. The account balances in the company’s general ledger on January 1, 2020 (first day of the new annual fiscal year) were as follows (all account balances are in their normal position):

Cash                                                                    $     3,700

Accounts receivable                                                   5,900

Supplies inventory                                                    29,300

Land                                                                        168,500  

Buildings                                                                 116,500

Accumulated depreciation, buildings                       37,500   

Equipment                                                                 58,500

Accumulated depreciation, equipment                     18,000

Accounts payable                                                      25,200

Income tax payable                                                   16,600

Interest payable                                                           4,200

Wages payable (due in 2020)                                    15,700                                         

9% Notes payable ($10,000 due June 30, 2021,

     balance due June 30, 2022)                                  61,500

Common shares                                                       151,500

Retained earnings, Dec. 31, 2019                              52,200         

Transactions during 2020:

1.The company provided sales services to customers, on credit, for $ 210,300. In addition, the company produced cash sales to customers of $ 62,300.

2.Accounts receivable from customers of $ 15,600 remains to be collected at December 31, 2020.

3.Inventory of $ 62,900 was purchased on credit and debited to the supplies inventory account.

4.Minor parts were purchased with cash for $ 7,400 and debited to the supplies inventory account.

5.Wages payable at the beginning of 2020 were paid early in 2020. In addition, wages were earned by employees and paid during 2020 in the amount of $ 112,000.

6.Income tax payable at the beginning of 2020 was paid early in 2020.

7.Payments of $ 73,000 were made to creditors for supplies previously purchased on credit.

8.One year’s interest at 9% was paid on the notes payable at July 1, 2020.

9. During 2020, Don Tallint, the principal shareholder, purchased a new car for his wife

    Debbie. The new car cost $ 45,000 and was paid for with cash from personal sources.

10.Property taxes were paid on the land and buildings in the amount of $ 17,000 with cash.

11.Dividends were declared and paid in cash in the amount of $ 7,200.

Information available for year end adjusting entries:

12.•Supplies inventory was counted on December 31, 2020 and it was determined the supplies inventory still on hand at yearend was $ 31,900.

13. •Annual depreciation on the buildings is $ 6,000.

14•Annual deprecation on the equipment is $ 5,500

15•Additional wages of $4,000 were earned but are unpaid and unrecorded at December 31, 2020.

16•Interest for six months at 9% per year on the notes payable is unpaid and unrecorded at December 31, 2020..

17•Income taxes of $ 16,500 were unpaid and unrecorded at December 31, 2020.

Q: please Record beginning 2020 beginning balances in T accounts. Prepare journal entries for transactions 1 to 11 above as required and record the journal entries in T accounts while adding any new T accounts that you need as you complete this task.