Question
In: Finance
A company is considering the purchase of a major piece of equipment for its manufacturing plant....
A company is considering the purchase of a major piece of equipment for its manufacturing plant. The project would cost $22m in initial investment and would result in cost savings, before tax, of $3.25m per year for five years. The equipment could be sold for $4.5m at the end of the five years. The equipment would also result in an increase in NWC of $500,000, which will be recovered at the end of the project. The company’s CCA rate is 25% and the corporate tax rate is 34%. The company’s target capital structure is 70% equities and 30% debt. The cost of equity is 12% while the cost of debt before tax is 5%. The WACC is 9.39%. Step 1: Initial cost - $22m + $50,000 = 22,050,000 -22,050,000 Step 2: Cost savings = 3.25m(1-.34) = $2.145m + 8,259,500 PV of cost savings = + 4,494,158 N=5, i=9.39, PMT=2.145 PV = 8.2595 + 2,905,000 Step 3; Calc PVCCATs Using formula = 4.494.158 NPV = -6,391,342 Step 4: Calc PV of terminal CFs 4.5m + 50,000 = 4,550,000 PV = N=5, FV=4.55, i=9.39 Do not proceed. Calc PV=2.905m How did they get these numbers?
Solutions
Expert Solution
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
JUST WRITTEN IN EXCEL, NO EXCEL FUNCTION IS USED
PVIFA AND PV IF FORMULAS SHOWN
PLEASE MAKE IT CLEAR AS TO WORKING CAPITAL = 500000 OR 50000
SUM SAYS 500000
jeff jeffy answered 1 year agoRelated Solutions
A company is considering the purchase of a major piece of equipment for its manufacturing plant....
A company is considering the purchase of a major piece of
equipment for its manufacturing plant. The project would cost $22m
in initial investment and would result in cost savings, before tax,
of $3.25m per year for five years.
The equipment could be sold for $4.5m at the end of the five
years. The equipment would also result in an increase in NWC of
$500,000, which will be recovered at the end of the project.
The company’s CCA rate is...
A piece of equipment used in a manufacturing plant that costs 220,000 to purchase has the...
A piece of equipment used in a manufacturing plant that costs
220,000 to purchase has the economic data shown in the table below
including the market value if the equipment was sold at the end of
the period of use. Apply an interest rate of 9.0% to answer the
questions that follow the data.
Period
1
2
3
4
5
Operating Cost
45,000
56,000
70,000
85,000
98,000
Market Value
160,000
125,000
105,000
45,000
15,000
a. What is the period cost...
Bernie Ltd is considering the purchase of a new equipment for its manufacturing plant and has...
Bernie Ltd is considering the purchase of a new equipment for
its manufacturing plant and has asked you to work out an
appropriate discount rate to use when evaluating the project.
information about burnie’s current capital structure is as
follows:
Source of capital. Book value. Market value
debts. $1,500,000. $1,600,000
ordinary share capital. $1,800,000. $3,000,000
total. $3,300,000. $3,600,000
to finance the purchase, Bernie can sell 10 year-bonds paying
annual coupon interest at a rate of 6%. The bond can be...
An Engineering company is considering purchasing a piece of plant equipment and wishes to compare its...
An Engineering company is considering purchasing a piece of
plant equipment and wishes to compare its replacement strategies
for purchase and maintenance over a period of time. The machine’s
initial cost is $170,000 with immediate payment required. Running
Costs including maintenance are $12,000 in year 1, $17,000 in year
2, $24,000 in year 3 and $33,000 in year 4. Payments are required
at the end of each year. Interest rates are 4% p.a. The equipment
will have a salvage value...
An Engineering company is considering purchasing a piece of plant equipment and wishes to compare its...
An Engineering company is considering purchasing a piece of
plant equipment and wishes to compare its replacement strategies
for purchase and maintenance over a period of time. The machine’s
initial cost is $160,000 with immediate payment required. Running
Costs including maintenance are $11,000 in year 1, $16,000 in year
2, $23,000 in year 3 and $32,000 in year 4. Payments are required
at the end of each year. Interest rates are 4% p.a. The equipment
will have a salvage value...
A company is considering the purchase of a piece of equipment that would cost $380,000 and...
A company is considering the purchase of a piece of equipment
that would cost $380,000 and would last for 8 years. At the end of
8 years, the equipment would have a salvage value of $97,500. The
equipment would provide annual cost savings of $85,000. The company
requires a minimum pretax return of 12% on all investment projects.
(Ignore income taxes.)
Required:
Provide your Excel input and the final net present value amount
you calculated. (If a variable is not...
6) Company is considering the purchase of a piece of equipment in '12. The projected cost...
6)
Company is considering the
purchase of a piece of equipment in '12.
The projected cost of the equipment is
50,000
The equipment will be depreciated via the MACRS - 5
year life
This equipment is expected to generate the
following economics:
Revenue for first year will be
45,700
Revenue will increase by
1.0%
per year thereafter
Expenses for first year will be
29,700
Expenses will decrease by
1.0%
per year thereafter
Company's Capital Structure is as follows:...
Harriman Manufacturing Company is evaluating the purchase of a new piece of equipment. The quoted price...
Harriman Manufacturing Company is evaluating the
purchase of a new piece of equipment. The quoted price is $50,000,
and it would cost Harriman another $ 10,000 for related capital
costs such as transportation and equipment modification for special
use. The total investment would fall into MACRS three year class
with depreciation rates being applied to the full capitalized costs
not excluding salvage at 33%, 45%, 15% and 7% in years 1-4,
respectively. Harriman expects that the equipment would be sold...
Harriman Manufacturing Company is evaluating the purchase of a new piece of equipment. The quoted price...
Harriman Manufacturing Company is evaluating the purchase of a
new piece of equipment. The quoted price is $50,000, and it would
cost Harriman another $ 10,000 for related capital costs such as
transportation and equipment modification for special use. The
total investment would fall into MACRS three year class with
depreciation rates being applied to the full capitalized costs not
excluding salvage at 33%, 45%, 15% and 7% in years 1-4,
respectively. Harriman expects that the equipment would be sold...
ben is considering the purchase of new piece of equipment. the cost savings from the equipment...
ben is considering the purchase of new piece of equipment. the
cost savings from the equipment would result in an annual increase
in net income of $200000. the equipment will have an initial cost
of $1200000 and have an 8 year life. the salvage value of the
equipment is estimated to be $200000. the hurdle rate is 10%. what
is accounting rate of return? b) what is the payback period? c)
what is the net present value? d) what would...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- (2) Cite an example on how organizations like Google, Facebook, Youtube etc collect data for image...
- The legal landscape is perpetually changing. Psychologists must remain abreast of these changes to avoid potentially...
- We are evaluating a project that costs $1.68 million, has a six-year life, and has no...
- In C++ Having call-by-reference allows one to use storeback parameters, i.e., parameters whose values are transmitted...
- You must evaluate a proposal to buy a new milling machine. The base price is $175,000,...
- “Triangle Guessing” game in Python The program accepts the lengths of three (3) sides of a...
- THIS PROGRAM HAS TO BE WRITTEN IN C Single function to perform the parity computation on...
ADVERTISEMENT