Chapter 4_Coca-Cola & Kimball International_Completed

xlsx

School

University of Utah *

*We aren’t endorsed by this school

Course

ADVANCED

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

23

Uploaded by MajorRatPerson986

Report
In determining the purchase price for its interest in Kimball International, Coca-Cola made the following Kimball International's pretax financial income for each of the 7 years prior to the acquisition was: For the year ended December 31, 2013 For the year ended December 31, 2014 For the year ended December 31, 2015 For the year ended December 31, 2016 For the year ended December 31, 2017 For the year ended December 31, 2018 For the year ended December 31, 2019 Loss from discontinued operations for the year ended December 31, 2018 Extraordinary loss for the year ended December 31, 2019 At the time of the acquisition, the normal rate of return on net assets for Kimball International's industry Balance Sheet Account Cash Marketable securities Accounts receivable Inventory Prepaid expenses Land Buildings, net Equipment, net Patent, net DTA - NOL Carryforward Goodwill Total assets Accounts payable On January 1, 2020, Coca-Cola acquired 100% of Kimball International by exchanging shares (on a ta Kimball International. On the date of acquisition, Coca-Cola’s common stock was trading at $45 per sha $37,000 of costs in connection with the acquisition. included in the pretax earnings of Kimball International following the acquisition (NOTE: a reduction to d Annual (reduction)/increase in depreciation expense on buildings Annual (reduction)/increase of depreciation expense on equipment rate of return (e.g., the return on net assets that Coca-Cola requires when making any investment decis liabilities as of the date of acquisition resulted in fair values shown to the right of each respective asset
Interest payable Bonds payable Discount/premium on bonds Total liabilities Common stock, $1 par value APIC Retained earnings Total liabilities and shareholders' equity In addition to the foregoing, the following facts or events are also relevant to the acquisition of Kimball NOL Carryforward Tax rate DTA - NOL Carryforward Proceeds Book value Gain Cash Land Gain on sale of marketable securities Proceeds Book value Gain Kimball International and Coca-Cola depreciate all fixed assets on a straight-line basis equipment have 15 year EUL and no salvage value). Except in the case of leased assets, the salv value of leased equipment is determined by applying the rules that govern accounting for capital le acquired are shown above. The inventory shown above, if any, was sold equally over the time period(s) Kimball International had a net operating loss carryforward of $136,000 that can be utilized by Coca-Co had been recorded by Kimball International for this loss carryforward. The loss was, or will be, utilized e Marketable securities with a January 1, 2020 book value of $87,549 and fair value of $81,541, respec reported on the books of Kimball International Company in the current year. Land with a January 1, 2020 book value of $139,468 and fair value of $165,826, respectively, was sold books of Kimball International in the previous year.
Cash Land Gain on sale of land See "Bonds Payable" worksheet. As of December 31, 2022, Coca-Cola and Kimball International have the following trial balances, respec Cash Marketable securities Accounts receivable Inventory Prepaid expenses Investment in Kimball International Land Buildings, net Equipment, net Patent, net DTA - NOL Carryforward Goodwill Accounts payable Interest payable Bonds payable Discount/premium on bonds Common stock, $1 par value APIC Retained earnings Dividends declared Sales revenue Cost of goods sold Operating expenses Selling & administrative expenses Depreciation expense - buildings and equipment Interest expense (Gain)/loss - marketable securities, fixed assets, and constructive redemptions Income tax expense Equity in earnings of Kimball International On January 1, 2017, Kimball International issued a $140,000 face-value, 7%, 16-year bond. Interest is of issuance, the market rate on similar bonds was 4%. Kimball International uses the effective-interes January 1, 2020, the annual market rate of interest on bonds of similar term and quality was 5%.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Coca-Cola has a calendar year-end, a corporate tax rate of 43%, and uses the FULL-EQUITY METHOD to Step 1 Current–Year Amortization of B2FV Adjustment NCI's % ownership in Kimball International Equity in Earnings of Kimball International Step 2 Original cost of investment Retained earnings of Kimball International as of 1/1 of current year Retained earnings of Kimball International as of date of acquisition Net in Kimball International's RE since acquisition 𝝙 Brown's % ownership Prior-years' B2FV amortization Brown's % ownership Coca-Cola's % of prior-year B2FV amortization Balance in Investment in Kimball International on 1/1/2022 Equity in Earnings of Kimball International Current-year dividends of Kimball International Brown's % ownership Balance in Investment in Kimball International on 12/31/2022 Consolidation Worksheet Entries: Elimination Entry 1 Common stock, $1 par value APIC Retained earnings Investment in Kimball International Eliminate Coca-Cola's % of Kimball International's beginning SE. Elimination Entry 2 Marketable securities Kimball International's current-year Partial-Equity NI Kimball International's current-year Full-Equity NI NCI in Full-Equity NI of Kimball International
Inventory Land Buildings, net Equipment, net Patent, net DTA - NOL Carryforward Goodwill Discount/premium on bonds Investment in Kimball International B2FV Adjustment. Elimination Entry 3 Inventory Land Buildings, net Equipment, net Patent, net DTA - NOL Carryforward Discount/premium on bonds Investment in Kimball International Accumulated Amortization of B2FV Adjustment. Elimination Entry 4 Marketable securities Buildings, net Equipment, net Patent, net DTA - NOL Carryforward Discount/premium on bonds (Gain)/loss - marketable securities, fixed assets, and constructive redemptions Depreciation expense - buildings and equipment Operating expenses Income tax expense Interest expense Current–Year Amortization of B2FV Adjustment. Elimination Entry 5 Equity in earnings of Kimball International Investment in Kimball International Eliminate Coca-Cola’s % share of Kimball International's Full-Equity income. Elimination Entry 6 Investment in Kimball International Dividends declared Eliminate Coca-Cola’s % share of Kimball International's dividend.
g computations and assumptions: $ 68,000 26,000 28,000 60,000 18,000 15,000 44,000 $ (989) 5,336 78,000 52,000 y was 10%. Kimball International Company Book Value Fair Value $ 36,872 $ 36,872 $ - 87,549 81,541 (6,008) 36,232 36,232 124,986 119,174 1 (5,812) 14,279 14,279 389,468 465,826 76,358 109,235 90,453 19 (18,782) 314,816 341,495 5 26,679 34,377 33,964 10 (413) - 58,480 3 58,480 19,973 - (19,973) $ 1,167,787 $ 68,317 $ 68,317 axable basis) of its $1 par value common stock for shares of are on the New York Stock Exchange. Coca-Cola also incurred depreciation expense increases pretax earnings): sion). t/liability. Remaining Life (Yrs) B2FV Adjustment
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
4,900 4,900 140,000 140,000 42,254 26,531 13 15,723 $ 255,471 $ 239,748 $ 126,252 84,262 150,993 677,061 $ 1,167,787 International: 136,000 43% 58,480 Subsidiary Consolidated 106,003 106,003 87,549 81,541 18,454 24,462 Subsidiary Consolidated 106,003 106,003 - (87,549) (81,541) 6,008 (18,454) (24,462) (6,008) - - - Subsidiary Consolidated 215,574 215,574 139,468 165,826 76,106 49,748 (buildings have 30 year EUL and no salvage value; vage value of fixed and intangible assets is zero. The salvage eases. The remaining useful life of the assets and liabilities ) noted above. ola in future taxable years. Prior to the acquisition, no asset equally over 3 years. ctively, were sold in 2022. This resulted in a gain of $18,454 B2FV Amortization in 2020. This resulted in a gain of $76,106 reported on the
Subsidiary Consolidated 215,574 215,574 - (139,468) (165,826) (26,358) (76,106) (49,748) 26,358 - - - ctively: Coca-Cola Kimball International ELIM 1 $ 319,555 $ 551,193 $ 870,748 129,172 188,640 317,812 106,329 108,456 214,785 159,698 139,368 299,066 22,554 8,477 31,031 1,535,439 - 1,535,439 (1,081,316) 441,820 250,000 691,820 857,326 109,235 966,561 742,065 327,348 1,069,413 26,257 27,502 53,759 - - - - 19,973 19,973 (91,441) (57,521) (148,962) - - - - (140,000) (140,000) - (34,338) (34,338) (309,971) (84,262) (394,233) 84,262 (2,219,745) (150,993) (2,370,738) 150,993 (859,448) (846,061) (1,705,509) 846,061 35,654 18,209 53,863 (1,661,576) (1,002,372) (2,663,948) 460,778 252,063 712,841 218,908 101,749 320,657 128,833 50,486 179,319 203,117 68,712 271,829 - 7,056 7,056 - (18,454) (18,454) 171,013 105,534 276,547 (416,338) - (416,338) B2FV Amortization paid on June 30 and December 31 of each year. At the time st method to amortize discount or premium on the bond. On Combined (BV)
- (0) (0) - o account for its investment in Kimball International. (435,226) 18,888 (416,338) 0% - (416,338) 1,038,568 846,061 677,061 169,000 100% 169,000 70,258 100% (70,258) 1,137,311 416,338 18,209 100% (18,209) 1,535,439 2022 84,262 150,993 846,061 (1,081,316) - (6,008)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
(5,812) 76,358 (18,782) 26,679 (413) 58,480 (19,973) 15,723 (126,252) - 5,812 (26,358) 1,977 (10,672) 83 (38,987) (2,113) 70,258 - 6,008 989 (5,336) 41 (19,493) (1,097) (6,008) 4,347 (41) 19,493 1,097 416,338 (416,338) 18,209 (18,209)
7 7 $ - $ - $ - (6,008) (5,812) 26,358 (989) (989) (989) 5,336 5,336 5,336 (41) (41) (41) 19,493 19,493 19,493 Amortization of B2FV Adjustment (2020) Amortization of B2FV Adjustment (2021) Amortization of B2FV Adjustment (2022)
1,043 1,070 1,097 $ 45,388 $ 24,869 $ 18,888
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ELIM 2 ELIM 3 ELIM 4 ELIM 5 (6,008) 6,008 (5,812) 5,812 (126,252) 70,258 (416,338) 76,358 (26,358) (18,782) 1,977 989 26,679 (10,672) (5,336) (413) 83 41 58,480 (38,987) (19,493) (19,973) 15,723 (2,113) (1,097) (41) 4,347 1,097 (6,008) 19,493 416,338
- - 0 -
$ 68,000 26,000 28,000 60,000 18,000 15,000 44,000 6,920 (37,351) 78,000 52,000 358,569 7 51,224 1,038,568 FV of NA 103,857 10% (52,633) Deficit in earnings (219,127) Gain on bargain purchase 1,038,568 FV of NA 819,441 Purchase price
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ELIM 6 Total 870,748 317,812 214,785 299,066 31,031 18,209 - 741,820 950,745 1,080,085 53,470 - - (148,962) - (140,000) (21,825) (309,971) (2,219,745) (859,448) (859,448) (18,209) 35,654 35,654 (2,663,948) (2,663,948) 712,841 712,841 320,616 320,616 179,319 179,319 276,177 276,177 8,153 8,153 (24,462) (24,462) 296,040 296,040 - Consolidated Income Statement Consolidated Retained Earnings
- 0 Consolidated Net Income (895,264) (895,264) Consolidated Retained Earnings (1,719,058)
870,748 317,812 214,785 299,066 31,031 - 741,820 950,745 1,080,085 53,470 - - (148,962) - (140,000) (21,825) (309,971) (2,219,745) Consolidated Balance Sheet
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
(1,719,058) -
Input Factors Bond issuance/purchase date Original life of bond (years) Bond maturity date Face Value N (as of bond issuance date) Stated rate Market rate (when bonds were originally issued/purchased) Market rate (when Coca-Cola acquires Kimball International) Interest pmts/year Type (begin/end) Parent Subsidiary Parent's % ownership of Subsidiary Date of Acquisition Beginning of Current-Year End of Current-Year Journal Entries Cash Bond premium Bond payable To record issuance of bonds – NiSource's books Interest Expense Bond premium Cash To record interest expense – 2020
January 1, 2017 16 January 1, 2033 140,000 32 7% 4% 5% 2 - Su Coca-Cola Kimball International 1/1/2017 1/1/2020 100% N 32 26 January 1, 2020 I 2.00% 2.00% January 1, 2022 PV 189,284 182,254 December 31, 2022 PMT (4,900) (4,900) FV (140,000) (140,000) Type - - Bond premium/discount (49,284) (42,254) Amortization Interest Expense B2FV Amortization 189,284 (49,284) (140,000) Subsidiary's Books 7,056 8,153 1,097 2,744 1,647 (1,097) (9,800) (9,800) - On January 1, 2017, Kimball and December 31 of each ye uses the effective-interest m rate of interest on bonds of s Bond Issuance Date Date of Acquisition Consolidated Books Current-Year Amortization
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ubsidiary's Books 1/1/2021 1/1/2022 12/31/2022 24 22 20 N 2.00% 2.00% 2.00% I 179,719 177,082 174,338 PV (4,900) (4,900) (4,900) PMT (140,000) (140,000) (140,000) FV - - - Type (39,719) (37,082) (34,338) (2,535) (2,637) (2,744) 7,265 7,163 7,056 International issued a $140,000 face-value, 7%, 16- ear. At the time of issuance, the market rate on simi method to amortize discount or premium on the bond similar term and quality was 5%. Beginning of Current-Year End of Current-Year
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Consolidated Books 1/1/2020 1/1/2021 1/1/2022 12/31/2022 26 24 22 20 2.50% 2.50% 2.50% 2.50% 166,531 165,039 163,472 161,825 (4,900) (4,900) (4,900) (4,900) (140,000) (140,000) (140,000) (140,000) - - - - (26,531) (25,039) (23,472) (21,825) (1,492) (1,567) (1,647) 8,308 8,233 8,153 1,043 1,070 1,097 -year bond. Interest is paid on June 30 ilar bonds was 4%. Kimball International d. On January 1, 2020, the annual market Date of Acquisition Beginning of Current-Year End of Current- Year
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help