Reference no: EM131435925
Assignment
Please read the brief and instructions thoroughly.
You are an external capital budgeting advisor to a highly successful manufacturing firm. You have recently received a proposal for equipment replacement that will presumably lead to more capacity and less cost. The replacement details are given below.
Old Equipment
|
New Equipment
|
Current book value
|
$ 400,000
|
|
|
Current market value
|
$ 600,000
|
Acquisition cost
|
$ 1,000,000
|
Remaining life (yrs.)
|
10
|
Life (yrs.)
|
10
|
Annual sales
|
$ 300,000
|
Annual sales
|
$ 450,000
|
Cash operating expenses
|
$ 120,000
|
Cash operating expenses
|
$ 150,000
|
Annual depreciation
|
$ 40,000
|
Annual depreciation
|
$ 100,000
|
Accounting salvage value
|
$ 0
|
Accounting salvage value
|
$ 0
|
Expected salvage value
|
$ 100,000
|
Expected salvage value
|
$ 200,000
|
If the new equipment replaces the old equipment, an additional investment of $80,000 in net working capital will be required. The tax rate is 30% and the required rate of return is 10%.
As you work through the NPV and IRR analysis provided by the company, you discover the following errors:
• The initial outlay correctly accounts for incremental investment in new fixed capital and net working capital but after-tax cash proceeds from the sale of old fixed capital are not adjusted.
• Annual operating cashflows are not adjusted for tax and depreciation is not added back.
• Terminal-year after-tax non-operating cashflows do not recapture investment in net working capital. Also, incremental capital gains on salvage value are not taxed.
You realise that you need to do the entire project feasibility report from scratch. You set out to do the following:
(a) Calculate the initial outlay, year on year after-tax operating cash flows, and terminal-year after-tax non-operating cashflow for the old and new equipment.
(b) Present these cash flows in a tabular format indicating the relevant year in which these cash flows fall. You believe the usage of a spreadsheet will be very helpful for this exercise.
(c) Find out the NPV, IRR, and Profitability Index for the replacement proposal.
(d) Conduct a sensitivity analysis of NPV to the required rate of return falling between the range of 10% to 16% pa (with increments of 1%).
(e) Tabulate your results. This step is required because there are some uncertainties at the top management level regarding the appropriate required rate of return to be used due to substantial decrease in risk-free rate over the years.
(f) Following the AIB assignment format, prepare an advisory report for the management that includes:
• a theoretical background to the three investment decision criteria you have used for analyses
• a comparison among these methodologies
• a note on why these criteria are superior to accounting rate of return and payback period used by some firms
• an analysis of the problem at hand and specific recommendations on the proposal, which integrates all the calculations and tabulations made in (a) to (d) above.
What is the annualized return
: A mutual fund was held by an investor for 575 days and earned a cumulative return of 23.74%. What is the annualized return?
|
Discuss either the pro or con of full financial disclosure
: In this discussion post you are to discuss either the pro or con of full financial disclosure. To prepare for your original post, find a business article related to some aspect of disclosure of accounting statements.
|
What method of inventory accounting does farmer brothers use
: How much did the company pay to stockholders in dividends in fiscal year 2015? What might impact the company's ability to pay dividends in future years? What methods of inventory accounting does Farmer Brothers use
|
Give an example of a man made rock
: What is the difference between natural and made made rocks, which work better in the long run and give an example of a man made rock.
|
Conduct a analysis of npv to the required rate of return
: Conduct a sensitivity analysis of NPV to the required rate of return falling between the range of 10% to 16% pa (with increments of 1%).
|
Rope of negligible mass
: A 1.83-kg bucket is tied to a rope of negligible mass. The rope is wrapped around a pole that is mounted horizontally on frictionless bearings. The cylindrical pole has a diameter of 0.484 m and a mass of 4.91 kg.
|
Motor deliver if the turntable
: An LP turntable must spin at 3.520 rad/s to play a record. How much torque must the motor deliver if the turntable is to reach its final angular speed in 1.900 revolutions, starting from rest?
|
Research a recent article on auditing acquisitions
: Research a recent article on auditing acquisitions, payments, property plant and equipment (fixed assets), notes payable, or owner's equity. Apply what you learn to your future or current job.
|
Find the kinetic energy ka of particle
: Using the formula for kinetic energy of a moving particle K=1/2 mv2, find the kinetic energy Ka of particle a. Using the formula for kinetic energy of a moving particleK=12mv2, find the kinetic energy Kb of particle b.Express your answer in terms o..
|