IP6ANSW(1)
pdf
keyboard_arrow_up
School
Quinnipiac University *
*We aren’t endorsed by this school
Course
360
Subject
Finance
Date
Jan 9, 2024
Type
Pages
7
Uploaded by BailiffDanger13040
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)
Related Documents
Related Questions
Required information
Nuclear safety devices installed several years ago have been depreciated from a first
cost of $200,000 to zero using the Modified Accelerated Cost Recovery System
(MACRS). The devices can be sold on the used equipment market for an estimated
$15,000, or they can be retained in service for 5 more years with a $9000 upgrade now
and an operating expenses (OE) of $6000 per year. The upgrade investment will be
depreciated over 3 years with no salvage value. The challenger is a replacement with
newer technology at a first cost of $40,000, n = 5 years, and S= 0. The new units will
have operating expenses of $7000 per year.
Use a 5-year study period, an effective tax rate of 41%, an after-tax minimum acceptable rate of return
(MARR) of 18% per year, and an assumption of classical straight line depreciation (no half-year convention)
to perform an after-tax AW-based replacement study.
The annual worth of the defender is determined to be $|
The annual worth of the challenger…
arrow_forward
7. Cisco Systems is purchasing a new bar code scanning device for its service center in
San Francisco. The table that follows lists the relevant cost items for this purchase. The
operating expenses for the new system are $10,000 per year, and the useful life of the
system is expected to be five years. The SV for depreciation purposes is equal to 25% of
the hardware cost.
Cost
$160,000
$15,000
$15,000
Cost Item
Hardware
Training
Installation
a. What is the BV of the device at the end of year three if the SL depreciation method is
used?
b. Suppose that after depreciating the device for two years with the SL method, the firm
decides to switch to the double declining balance depreciation method for the remainder
of the device's life (the remaining three years). What is the device's BV at the end of four
years?
arrow_forward
Problem 3: A machine currently in use was originally purchased 2 years ago for $40,000. The machine is
being depreciated under MACRS using a 5-year recovery period; it has 3 years of usable life remaining.
The current machine can be sold today to net $42,000 after removal and cleanup costs. A new machine,
using a 3-year MACRS recovery period, can be purchased at a price of $140,000. It requires $10,000 to
install and has a 3-year usable life. If the new machine is acquired, the investment in accounts receivable
will be expected to rise by $10,000, the inventory investment will increase by $25,000, and accounts
payable will increase by $15,000. Earnings before depreciation, interest, and taxes are expected to be
$70,000 for each of the next 3 years with the old machine and to be $120,000 in the first year and
$130,000 in the second and third years with the new machine. At the end of 3 years, the market value of
the old machine will equal zero, but the new machine could be sold to net…
arrow_forward
Problem 3: A machine currently in use was originally purchased 2 years ago for $40,000. The
machine is being depreciated under MACRS using a 5-year recovery period; it has 3
years of usable life remaining. The current machine can be sold today to net
$42,000 after removal and cleanup costs. A new machine, using a 3-year MACRS
recovery period, can be purchased at a price of $140,000. It requires $10,000 to
install and has a 3-year usable life. If the new machine is acquired, the investment
in accounts receivable will be expected to rise by $10,000, the inventory investment
will increase by $25,000, and accounts payable will increase by $15,000. Earnings
before depreciation, interest, and taxes are expected to be $70,000 for each of the
next 3 years with the old machine and to be $120,000 in the first year and $130,000
in the second and third years with the new machine. At the end of 3 years, the
market value of the old machine will equal zero, but the new machine could be sold
to net…
arrow_forward
need excel solution.
arrow_forward
Problem 2: Irvin Enterprises is considering the purchase of a new piece of equipment to replace
the current equipment. The new equipment costs $75,000 and requires $5,000 in
installation costs. It will be depreciated under MACRS using a 5-year recovery
period. The old piece of equipment was purchased 4 years ago for an installed cost
of $50,000; it was being depreciated under MACRS using a 5-year recovery period.
The old equipment can be sold today for $55,000 net of any removal or cleanup
costs. As a result of the proposed replacement, the firm's investment in net working
capital is expected to increase by $15,000. The firm pays taxes at a rate of 40%.
Percentage by recovery year
Recovery year
3 ycars
5 years
7 ycars
10 years
33%
20%
14%
10%
45
32
25
18
3.
15
19
18
14
4.
12
12
12
12
6.
7.
10
11
Totals
100%
100%
100%
100%
a. Calculate the book value of the old piece of equipment.
b. Determine the taxes, if any, attributable to the sale of the old equipment.
c. Find the initial…
arrow_forward
HI!
I would need help with the question 3 of the attached project
Thank you for your time
arrow_forward
Complete solution
6. The Green Spaces project involves purchasing equipment worth $300,000. Assuming a flat rate depreciation of 10% per year, calculate the book value of the equipment after 4 years (define a recurrence relation to answer this question).
7. If the Residential Infrastructure budget is used to purchase specialized machinery costing $800,000 with a unit cost depreciation of $20,000 per year, determine the book value after 3 years (define a recurrence relation to answer this question).
The city expects the population in the Residential Infrastructure area to grow exponentially at a rate of 2% per year.
a. Calculate the projected population after 10 years if the current population is 50,000 (define a recurrence relation to answer this question).
b. Draw a graph illustrating the population growth over 10 years.
arrow_forward
ASAP please
arrow_forward
onsider the following financial informationabout a retooling project at a computer manufacturing company:• The project costs $2.5 million and has a five-yearservice life.• The retooling project can be classified as sevenyear property under the MACRS rule.• At the end of the fifth year, any assets held for theproject will be sold. The expected salvage valuewill be about 10% of the initial project cost.• The firm will finance 40% of the project moneyfrom an outside financial institution at an interestrate of 10%. The firm is required to repay the loanwith five equal annual payments.• The firm’s incremental (marginal) tax rate on theinvestment is 35%.• The firm’s MARR is 18%.With the preceding financial information,(a) Determine the after-tax cash flows.(b) Compute the annual equivalent worth for thisproject.
arrow_forward
Initial investment-Basic calculation Cushing Corporation is considering the purchase of a new grading machine to replace
the existing one. The existing machine was purchased 3 years ago at an installed cost of $19,500; it was being depreciated
under MACRS using a 5-year recovery period. (See table E for the applicable depreciation percentages.) The existing
machine is expected to have a usable life of at least 5 more years. The new machine costs $34,700 and requires $4,800 in
installation costs; it will be depreciated using a 5-year recovery period under MACRS. The existing machine can currently be
sold for $24,600 without incurring any removal or cleanup costs. The firm is subject to a 40% tax rate. Calculate the initial
investment associated with the proposed purchase of a new grading machine.
The initial investment will be $. (Round to the nearest dollar.)
Data Table
(Click on the icon located on the top-right corner of the data table below in order to copy its contents into a…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT

Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning


Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Related Questions
- Required information Nuclear safety devices installed several years ago have been depreciated from a first cost of $200,000 to zero using the Modified Accelerated Cost Recovery System (MACRS). The devices can be sold on the used equipment market for an estimated $15,000, or they can be retained in service for 5 more years with a $9000 upgrade now and an operating expenses (OE) of $6000 per year. The upgrade investment will be depreciated over 3 years with no salvage value. The challenger is a replacement with newer technology at a first cost of $40,000, n = 5 years, and S= 0. The new units will have operating expenses of $7000 per year. Use a 5-year study period, an effective tax rate of 41%, an after-tax minimum acceptable rate of return (MARR) of 18% per year, and an assumption of classical straight line depreciation (no half-year convention) to perform an after-tax AW-based replacement study. The annual worth of the defender is determined to be $| The annual worth of the challenger…arrow_forward7. Cisco Systems is purchasing a new bar code scanning device for its service center in San Francisco. The table that follows lists the relevant cost items for this purchase. The operating expenses for the new system are $10,000 per year, and the useful life of the system is expected to be five years. The SV for depreciation purposes is equal to 25% of the hardware cost. Cost $160,000 $15,000 $15,000 Cost Item Hardware Training Installation a. What is the BV of the device at the end of year three if the SL depreciation method is used? b. Suppose that after depreciating the device for two years with the SL method, the firm decides to switch to the double declining balance depreciation method for the remainder of the device's life (the remaining three years). What is the device's BV at the end of four years?arrow_forwardProblem 3: A machine currently in use was originally purchased 2 years ago for $40,000. The machine is being depreciated under MACRS using a 5-year recovery period; it has 3 years of usable life remaining. The current machine can be sold today to net $42,000 after removal and cleanup costs. A new machine, using a 3-year MACRS recovery period, can be purchased at a price of $140,000. It requires $10,000 to install and has a 3-year usable life. If the new machine is acquired, the investment in accounts receivable will be expected to rise by $10,000, the inventory investment will increase by $25,000, and accounts payable will increase by $15,000. Earnings before depreciation, interest, and taxes are expected to be $70,000 for each of the next 3 years with the old machine and to be $120,000 in the first year and $130,000 in the second and third years with the new machine. At the end of 3 years, the market value of the old machine will equal zero, but the new machine could be sold to net…arrow_forward
- Problem 3: A machine currently in use was originally purchased 2 years ago for $40,000. The machine is being depreciated under MACRS using a 5-year recovery period; it has 3 years of usable life remaining. The current machine can be sold today to net $42,000 after removal and cleanup costs. A new machine, using a 3-year MACRS recovery period, can be purchased at a price of $140,000. It requires $10,000 to install and has a 3-year usable life. If the new machine is acquired, the investment in accounts receivable will be expected to rise by $10,000, the inventory investment will increase by $25,000, and accounts payable will increase by $15,000. Earnings before depreciation, interest, and taxes are expected to be $70,000 for each of the next 3 years with the old machine and to be $120,000 in the first year and $130,000 in the second and third years with the new machine. At the end of 3 years, the market value of the old machine will equal zero, but the new machine could be sold to net…arrow_forwardneed excel solution.arrow_forwardProblem 2: Irvin Enterprises is considering the purchase of a new piece of equipment to replace the current equipment. The new equipment costs $75,000 and requires $5,000 in installation costs. It will be depreciated under MACRS using a 5-year recovery period. The old piece of equipment was purchased 4 years ago for an installed cost of $50,000; it was being depreciated under MACRS using a 5-year recovery period. The old equipment can be sold today for $55,000 net of any removal or cleanup costs. As a result of the proposed replacement, the firm's investment in net working capital is expected to increase by $15,000. The firm pays taxes at a rate of 40%. Percentage by recovery year Recovery year 3 ycars 5 years 7 ycars 10 years 33% 20% 14% 10% 45 32 25 18 3. 15 19 18 14 4. 12 12 12 12 6. 7. 10 11 Totals 100% 100% 100% 100% a. Calculate the book value of the old piece of equipment. b. Determine the taxes, if any, attributable to the sale of the old equipment. c. Find the initial…arrow_forward
- HI! I would need help with the question 3 of the attached project Thank you for your timearrow_forwardComplete solution 6. The Green Spaces project involves purchasing equipment worth $300,000. Assuming a flat rate depreciation of 10% per year, calculate the book value of the equipment after 4 years (define a recurrence relation to answer this question). 7. If the Residential Infrastructure budget is used to purchase specialized machinery costing $800,000 with a unit cost depreciation of $20,000 per year, determine the book value after 3 years (define a recurrence relation to answer this question). The city expects the population in the Residential Infrastructure area to grow exponentially at a rate of 2% per year. a. Calculate the projected population after 10 years if the current population is 50,000 (define a recurrence relation to answer this question). b. Draw a graph illustrating the population growth over 10 years.arrow_forwardASAP pleasearrow_forward
- onsider the following financial informationabout a retooling project at a computer manufacturing company:• The project costs $2.5 million and has a five-yearservice life.• The retooling project can be classified as sevenyear property under the MACRS rule.• At the end of the fifth year, any assets held for theproject will be sold. The expected salvage valuewill be about 10% of the initial project cost.• The firm will finance 40% of the project moneyfrom an outside financial institution at an interestrate of 10%. The firm is required to repay the loanwith five equal annual payments.• The firm’s incremental (marginal) tax rate on theinvestment is 35%.• The firm’s MARR is 18%.With the preceding financial information,(a) Determine the after-tax cash flows.(b) Compute the annual equivalent worth for thisproject.arrow_forwardInitial investment-Basic calculation Cushing Corporation is considering the purchase of a new grading machine to replace the existing one. The existing machine was purchased 3 years ago at an installed cost of $19,500; it was being depreciated under MACRS using a 5-year recovery period. (See table E for the applicable depreciation percentages.) The existing machine is expected to have a usable life of at least 5 more years. The new machine costs $34,700 and requires $4,800 in installation costs; it will be depreciated using a 5-year recovery period under MACRS. The existing machine can currently be sold for $24,600 without incurring any removal or cleanup costs. The firm is subject to a 40% tax rate. Calculate the initial investment associated with the proposed purchase of a new grading machine. The initial investment will be $. (Round to the nearest dollar.) Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT

Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning


Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning