An asset with a 5‐year MACRS* life will be purchased for $10,500. It will produce net annual benefits (i.e., revenues) o...
An asset with a 5‐year MACRS* life will be purchased for $10,500. It will produce net annual
benefits (i.e., revenues) of $2000/year for 6 years, after which time it will have a net salvage value of zero
and will be retired. The company’s total tax rate is 34% and they use an ieff (MARR) of 11%. Use these to
construct a table in Excel showing the annual discounted after tax cash flows (CF). Please calculate discrete
and cumulative CF for each year requested.
Homework Answers
| Year | Initial cost | Revenue after tax | Tax shield-Depreciation | Net CF | Cumulative CF | Discounted CF | Cumulative DCF |
| 0 | -10500 | -10500 | -10500 | -10500.00 | -10500 | ||
| 1 | 1320 | 714.00 | 2034.00 | -8466.00 | 1832.43 | -8667.57 | |
| 2 | 1320 | 1142.40 | 2462.40 | -6003.60 | 1998.54 | -6669.03 | |
| 3 | 1320 | 685.44 | 2005.44 | -3998.16 | 1466.36 | -5202.67 | |
| 4 | 1320 | 411.26 | 1731.26 | -2266.90 | 1140.44 | -4062.23 | |
| 5 | 1320 | 411.26 | 1731.26 | -535.63 | 1027.42 | -3034.81 | |
| 6 | 1320 | 205.63 | 1525.63 | 990.00 | 815.67 | -2219.14 |
Note:Assuming the net benefits are before tax.
Workings
Add Answer to:
An asset with a 5‐year MACRS* life will be purchased for $10,500. It will produce net annual benefits (i.e., revenues) o...
Compute by hand (without EXEL!) 10.9 An asset in the five-year MACRS property class costs $150,000...
Compute by hand (without EXEL!)
10.9 An asset in the five-year MACRS property class costs $150,000 and has a zero estimated salvage value after six years of use. The asset will generate annual revenues of $320,000 and will require $80,000 in annual labor and $50,000 in annual material expenses. There are no other revenues and expenses. Assume a tax rate of 40%. a. Compute the after-tax cash flows over the project life. b. Compute the NPW at MARR = 12%....
Etonic Inc. is considering an investment of $365,000 in an asset with an economic life of...
Etonic Inc. is considering an investment of $365,000 in an asset with an economic life of five years. The firm estimates that the nominal annual cash revenues and expenses at the end of the first year will be $245,000 and $70,000 respectively. Both revenues and expenses will grow thereafter at the annual rate of 3 percent. Etonic will use the straight-line method to depreciate its asset to zero over five years. The salvage value of the asset is estimated to...
A given project requires the acquisition of a capital assets purchased outright in year o totaling...
A given project requires the acquisition of a capital assets purchased outright in year o totaling $100 Million. The company expects sales revenues to increase by $50 Million in year one and maintain that level through year 4. Cost of revenue will be $12 Million per year, and fixed expenses will be $5 Million per year. The asset should be depreciated as 5-year MACRS asset, and it will be sold at the end of year 4 for $25 Million (Hint:...
Beyer Company is considering the purchase of an asset for $400,000. It is expected to produce the following net...
Beyer Company is considering the purchase of an asset for $400,000. It is expected to produce the following net cash flows. The cash flows occur evenly within each year Year 1 $80,000 Year 3 $70,e0e Year 2 Year 4 Year 5 Total $445,000 $200,000 Net cash flows $80,000 $15,e00 Compute the payback period for this investment. (Cumulative net cash outflows must be entered with a minus sign. Round your Payback Period answer to 2 decimal place.) Cumulative Net Cash Inflow...
The Tasha Corporation needs a new pipe-boring machine that can be purchased for $10,000. The machine will...
The Tasha Corporation needs a new pipe-boring machine that can be purchased for $10,000. The machine will be depreciated using MACRS with a 5-year class. Tasha will use the machine for 5 years and then sell it with an anticipated salvage value of $2000. A maintenance contract will be purchased at a cost of $500 per year with payments made in advance. Tasha can obtain a bank loan with an interest rate of 7.5% and the company’s tax rate is 34%. (EXCEL...
Able purchased a machine for $150,000 on March 1, 2017. The asset has a 5 year life and a $30,000 salvage value. Th...
Able purchased a machine for $150,000 on March 1, 2017. The asset has a 5 year life and a $30,000 salvage value. The half year assumption will be used for financial and tax depreciation. Financial reporting will use straight-line depreciation, DDBX (double declining with a switch to straight) will be used for tax purposes. Calculate depreciation for 2017 and 2018 in the space provided below: 2020 2018 2017 Straight line DDBX Assume that income prior to considering tax and depreciation...
please help with question #12.24 without using excel. net present worth of this investment. Contributedby value,...
please help with question #12.24 without using
excel.
net present worth of this investment. Contributedby value, and Assume unit 444 CHAPTER 12: INCOME TAXES FOR CORPORATIONS Mukasa Ssemakula, Wayne State University (b) Explain why the rate of return obtained in part (a) is different from the rate of return obtained in Problem 12-20. 12-25 A firm has invested $400.000 in car- ment. They will depreciate the r-washing equip equipment by 6% (a) Comput (b) Comput MACRS G MACRS, assuming a...
A firm can purchase a centrifugal separator (5-year MACRS property) for $21,000. The estimated salvage value...
A firm can
purchase a centrifugal separator (5-year
MACRS property) for
$21,000.
The estimated
salvage value is
$2,500
after a useful
life of six years. Operating and maintenance
(O&M)
costs for the first year are expected to be
$2,100.
These
O&M
costs are projected to increase by
$500
per year each
year thereafter. The income tax rate is
25%
and the MARR
is
11%
after taxes.
What must the uniform annual benefits be for the purchase of the
centrifugal separator...
Objective This activity has the purpose of helping students use the Microsoft Excel software to compute...
Objective This activity has the purpose of helping students use the Microsoft Excel software to compute the after tax cash flow and perform a sensitivity analysis. (Objective 3) Student Instructions Read example 7-15 to be used to compute the after tax present worth. Retrieved from textbook example 7-15 Computing After Tax Present Worth of and Asset (Sullivan W., Wicks E., and Patrick C.), page 341 Certain new machinery when placed in service is estimated to cost $180,000. It is expected...
A company is considering the purchase of a capital asset for $110,000. Installation charges needed to...
A
company is considering the purchase of a capital asset for
$110,000.
Installation
charges needed to make the asset serviceable will total
$25,000.
The
asset will be depreciated over six years using the
straight-line method and an estimated
salvage value
(SV6)
of
$24,000.
The
asset will be kept in service for six years, after which it
will be sold for
$34,000.
During
its useful life, it is estimated
that the asset will produce annual revenues of
$25,000.
Operating
and maintenance...
Compute by hand (without EXEL!)
10.9 An asset in the five-year MACRS property class costs $150,000 and has a zero estimated salvage value after six years of use. The asset will generate annual revenues of $320,000 and will require $80,000 in annual labor and $50,000 in annual material expenses. There are no other revenues and expenses. Assume a tax rate of 40%. a. Compute the after-tax cash flows over the project life. b. Compute the NPW at MARR = 12%....
A given project requires the acquisition of a capital assets purchased outright in year o totaling $100 Million. The company expects sales revenues to increase by $50 Million in year one and maintain that level through year 4. Cost of revenue will be $12 Million per year, and fixed expenses will be $5 Million per year. The asset should be depreciated as 5-year MACRS asset, and it will be sold at the end of year 4 for $25 Million (Hint:...
Beyer Company is considering the purchase of an asset for $400,000. It is expected to produce the following net cash flows. The cash flows occur evenly within each year Year 1 $80,000 Year 3 $70,e0e Year 2 Year 4 Year 5 Total $445,000 $200,000 Net cash flows $80,000 $15,e00 Compute the payback period for this investment. (Cumulative net cash outflows must be entered with a minus sign. Round your Payback Period answer to 2 decimal place.) Cumulative Net Cash Inflow...
Able purchased a machine for $150,000 on March 1, 2017. The asset has a 5 year life and a $30,000 salvage value. The half year assumption will be used for financial and tax depreciation. Financial reporting will use straight-line depreciation, DDBX (double declining with a switch to straight) will be used for tax purposes. Calculate depreciation for 2017 and 2018 in the space provided below: 2020 2018 2017 Straight line DDBX Assume that income prior to considering tax and depreciation...
please help with question #12.24 without using
excel.
net present worth of this investment. Contributedby value, and Assume unit 444 CHAPTER 12: INCOME TAXES FOR CORPORATIONS Mukasa Ssemakula, Wayne State University (b) Explain why the rate of return obtained in part (a) is different from the rate of return obtained in Problem 12-20. 12-25 A firm has invested $400.000 in car- ment. They will depreciate the r-washing equip equipment by 6% (a) Comput (b) Comput MACRS G MACRS, assuming a...
A firm can
purchase a centrifugal separator (5-year
MACRS property) for
$21,000.
The estimated
salvage value is
$2,500
after a useful
life of six years. Operating and maintenance
(O&M)
costs for the first year are expected to be
$2,100.
These
O&M
costs are projected to increase by
$500
per year each
year thereafter. The income tax rate is
25%
and the MARR
is
11%
after taxes.
What must the uniform annual benefits be for the purchase of the
centrifugal separator...
Objective This activity has the purpose of helping students use the Microsoft Excel software to compute the after tax cash flow and perform a sensitivity analysis. (Objective 3) Student Instructions Read example 7-15 to be used to compute the after tax present worth. Retrieved from textbook example 7-15 Computing After Tax Present Worth of and Asset (Sullivan W., Wicks E., and Patrick C.), page 341 Certain new machinery when placed in service is estimated to cost $180,000. It is expected...
A
company is considering the purchase of a capital asset for
$110,000.
Installation
charges needed to make the asset serviceable will total
$25,000.
The
asset will be depreciated over six years using the
straight-line method and an estimated
salvage value
(SV6)
of
$24,000.
The
asset will be kept in service for six years, after which it
will be sold for
$34,000.
During
its useful life, it is estimated
that the asset will produce annual revenues of
$25,000.
Operating
and maintenance...
Most questions answered within 3 hours.
-
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 13 minutes ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 15 minutes ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 20 minutes ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 24 minutes ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 34 minutes ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 42 minutes ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 40 minutes ago -
Write MARIE assembly language programs that do the following:
Write a program that inputs an integer...
asked 44 minutes ago -
Explain an understanding of services and protocols.
Explain the job of DNS.
Explain the three email...
asked 1 hour ago -
(As soon as possible) Balance each of the following equations
according to the half-reaction method:
H2O2(aq)...
asked 1 hour ago -
A thin rod with a mass of 3.5kg and a length L=1.5 m is oriented
horizontally....
asked 1 hour ago -
Inheritance pattern in BRCA 1
Describe the inheritance pattern of BRCA 1 Is it recessive or...
asked 1 hour ago