IP6ANSW(1)

pdf

School

Quinnipiac University *

*We aren’t endorsed by this school

Course

360

Subject

Finance

Date

Jan 9, 2024

Type

pdf

Pages

7

Uploaded by BailiffDanger13040

Report
Part 1: Replacement Decision Company BBB purchased a computerized measuring device two years ago for $80,000. It falls into the 5-year category for MACRS depreciation. The equipment can currently be sold for $28,400. A new piece of equipment will cost $210,000, and falls into the same 5-year MACRS category for depreciation. The new equipment is expected to provide the following stream of added cost savings for the next 6 years. Tax rate is 34%, and the cost of capital is 15%. Should the replacement be undertaken? Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Cost Savings $66,000 $56,000 $50,000 $45,000 $40,000 $30,000 5-Year MACRS Depreciation Rates 20.00% 32.00% 19.20% 11.50% 11.50% 5.80% REPLACEMENT DECISION INFORMATION (1) Purchasing Price of Old Machine $80,000 (2) Purchasing Price of New Machine $210,000 (3) Sales Price of Old Machine $28,400 (4) Tax Rate 34% (5) WACC 15% ANNUAL DEPRECIATIONS Year -2 Year -1 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 (6) 5-Year MACRS Depreciation Rates 20.00% 32.00% 19.20% 11.50% 11.50% 5.80% (7) New Machine Depreciation $42,000 $67,200 $40,320 $24,150 $24,150 $12,180 (8) Old Machine Depreciation $16,000 $25,600 (9) Incremental Depreciation: (7)-(8) $42,000 $67,200 $40,320 $24,150 $24,150 $12,180
Book-Value of Old Machine on Sale (10) Purchasing Price of Old Machine: (1) $80,000 (13) Sales Price: from (3) $28,400 $41,600 (14) Tax Loss on Sale: (13)-(12) ($10,000) (12) Book-Value of Old Machine $38,400 $3,400 (16) Net Cost of New Machine: (2)-(3)-(15) $178,200 Total Benefits Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 $66,000 $56,000 $50,000 $45,000 $40,000 $30,000 $43,560 $36,960 $33,000 $29,700 $26,400 $19,800 (19) Incremental Depreciation: (9) $42,000 $67,200 $40,320 $24,150 $24,150 $12,180 (20) Tax Shield Benefit from Depreciation: (19)×Tax Rate $14,280 $22,848 $13,709 $8,211 $8,211 $4,141 (21) Total Benefits: (18)+(20) $57,840 $59,808 $46,709 $37,911 $34,611 $23,941 DECISION with NPV Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 ($178,200) $57,840 $59,808 $46,709 $37,911 $34,611 $23,941 Cost of Capital 15% NPV ($2,735.15) DECISION Reject (18) After Tax Cost Savings Benefit: (17)×(1-Tax Rate) Tax Benefit/Loss (11) Total Depreciation of Old Machine to date (15) Tax Benefit: (14) × Tax R (17) Cost Savings Benefit from New Machine: (3)
1. Annual coupon PMTs Bonds Annual Yield Years To Maturity Annual Coupon Rate Far Value Issue Proceeds AAA 7.00% 10 5.00% $100,000 ??? (4) BBB 3.00% 10 0.00% ??? (3) $1,556,853 CCC 6.50% ??? (2) 4.00% $1,000,000 $845,500 DDD ??? (1) 15 6.00% $100,000 $117,822 EEE 8.00% 10 ??? (5) $1,000 $865.80 Settlement Maturity ABC 0.80% 20 2.00% $500,000 ??? (6) 1/1/2001 12/31/2019 Answer: (1): 4.36% (2): 8.16 (3): $2,092,280.25 (4): $85,952.84 (5): 6.00% (6): $605,354.67 2. Semi-annual coupon PMTs YTM TTM (semiannual) Annual Coupon Rate Par Price FFF 7.00% 20 5.00% $500,000 ??? (9) GGG 8.00% ??? (7) 6.00% $500,000 $438,631 HHH ??? (6) 12 5.00% $1,000,000 $955,000 LLL 3.00% 10 ??? (8) $1,000 $1,095.00 Settlement Maturity NNN 6.00% 20 5.00% $1,000,000 ??? (10) 1/1/2001 12/31/2019 Answer: (6): 5.90% (7): 17.22 (8): 5.06% (9): $428,937.98 (10) $927,994.69
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. Analyzing and Reporting Financial Statement Effects of Premium Bond Transactions Assume that on January 1, Xfinity issues $1,000,000 of 5-year, 8% coupon bonds payable, yielding an effective annual interest rate of 6%. Coupon interest are payable semiannually on June 30 and December 31. A) Compute the issue price, bond discount, and the periodic coupon interest. Issue Price = $1,085,302.03 Discount Amount = $85,302.03 Annual Coupon PMT = $40,000.00 B) Prepare an amortization table for the bonds for the five years. Interest Expende Coupon Interest Premium Amortization Premium Balance Bond Payable, Net 0 $85,302.03 $1,085,302.03 1 $32,559.06 $40,000.00 $7,440.94 $77,861.09 $1,077,861.09 2 $32,335.83 $40,000.00 $7,664.17 $70,196.92 $1,070,196.92 3 $32,105.91 $40,000.00 $7,894.09 $62,302.83 $1,062,302.83 4 $31,869.08 $40,000.00 $8,130.92 $54,171.91 $1,054,171.91 5 $31,625.16 $40,000.00 $8,374.84 $45,797.07 $1,045,797.07 6 $31,373.91 $40,000.00 $8,626.09 $37,170.98 $1,037,170.98 7 $31,115.13 $40,000.00 $8,884.87 $28,286.11 $1,028,286.11 8 $30,848.58 $40,000.00 $9,151.42 $19,134.70 $1,019,134.70 9 $30,574.04 $40,000.00 $9,425.96 $9,708.74 $1,009,708.74 10 $30,291.26 $40,000.00 $9,708.74 ($0.00) $1,000,000.00 Total $314,697.97 $400,000.00 $85,302.03
C) Complete Xfinity’s financial statement effects template a. on bond issuance. LTD $1,085,302.03 Cash $1,085,302.03 Bonds payable, face $1,000,000.00 Add bond premium $85,302.03 Bonds payable, net $1,085,302.03 b. on Jun. 30 of the 1 st year. Interest expense in I/S $32,559.06 Retained earnings in B/S ($32,559.06) Bond Payable in B/S ($7,440.94) Cash in B/S ($40,000.00) c. semiannual interest payment and premium amortization on Dec. 31 of the 1 st year. Interest expense in I/S $32,335.83 Retained earnings in B/S ($32,335.83) Bond Payable in B/S ($7,664.17) Cash in B/S ($40,000.00)
1. Analyzing and Reporting Financial Statement Effects of Discount Bond Transactions Assume that on January 1, Xfinity issues $1,000,000 of 5-year, 8% coupon bonds payable, yielding an effective annual interest rate of 10%. Coupon interest are payable semiannually on June 30 and December 31. A) Compute the issue price, bond discount, and the periodic coupon interest. Issue Price = $922,782.65 Discount Amount = $77,217.35 Annual Coupon PMT = $40,000.00 B) Prepare an amortization table for the bonds for the five years. Interest Expende Coupon Interest Premium Amortization Premium Balance Bond Payable, Net 0 $77,217.35 $922,782.65 1 $46,139.13 $40,000.00 $6,139.13 $71,078.22 $928,921.78 2 $46,446.09 $40,000.00 $6,446.09 $64,632.13 $935,367.87 3 $46,768.39 $40,000.00 $6,768.39 $57,863.73 $942,136.27 4 $47,106.81 $40,000.00 $7,106.81 $50,756.92 $949,243.08 5 $47,462.15 $40,000.00 $7,462.15 $43,294.77 $956,705.23 6 $47,835.26 $40,000.00 $7,835.26 $35,459.51 $964,540.49 7 $48,227.02 $40,000.00 $8,227.02 $27,232.48 $972,767.52 8 $48,638.38 $40,000.00 $8,638.38 $18,594.10 $981,405.90 9 $49,070.29 $40,000.00 $9,070.29 $9,523.81 $990,476.19 10 $49,523.81 $40,000.00 $9,523.81 $0.00 $1,000,000.00 Total $477,217.35 $400,000.00 $77,217.35
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
C) Complete Xfinity’s financial statement effects template a. on bond issuance. LTD $922,782.65 Cash $922,782.65 Bonds payable, face $500,000.00 Add bond premium $77,217.35 Bonds payable, net $422,782.65 b. on Jun. 30 of the 1 st year. Interest expense in I/S $46,139.13 Retained earnings in B/S ($46,139.13) Bond Payable in B/S $6,139.13 Cash in B/S ($40,000.00) c. semiannual interest payment and premium amortization on Dec. 31 of the 1 st year. Interest expense in I/S $46,446.09 Retained earnings in B/S ($46,446.09) Bond Payable in B/S $6,446.09 Cash in B/S ($40,000.00)