Question
In: Finance
As a financial advisor at RedHat International (RHI), you have been asked to evaluate two capital...
As a financial advisor at RedHat International (RHI), you have been asked to evaluate two capital investment alternatives submitted by the shipping department. Before beginning your analysis, you note that company policy has set the minimum desired rate of return at 18% for all proposed projects. You also learn that the corporate tax rate is 26%.
The proposed capital project calls for the shipping department to fully automate a warehouse using one of two different advanced robotics systems. System A will incur development costs of $2,500,000. System B will a cost $4,000,000 to develop. Both systems will be capitalized and amortized using a CCA rate of 30%. In addition, the firm believes that Net Working Capital will rise by $50,000 at time zero and then by an additional $10,000 at the end of each year for each year that the new system is operating (except at the end of the final year of the project). This applies to both alternatives. However, all of the increase in Net Working Capital will be recovered at the end of the project.
The Shipping Department intends to hire an outside consultant at a cost of $10,000 to help it choose which of the two alternatives would be most effective. If neither alternative is financially attractive, the consultant will be expected to point this out to the company. The amount paid to the consultant will be expensed at the time it is incurred.
To recover a portion of the development cost, the shipping department intends to charge the manufacturing department for the use of computer time at the rate of $150 per hour for 50 hours per year for each year of the project. This amount will remain the same under either alternative. RHI owns all of its computer equipment, which has significant spare capacity. The company plans to maintain this spare capacity into the future. However, it is company policy not to rent spare computer capacity to outside users due to security concerns.
If the new automated robotics system is put into use, the pre-tax cost savings each year are estimated as follows:
|
Year |
System A |
System B |
|
1 |
$1,500,000 |
$2,000,000 |
|
2 |
$1,200,000 |
$1,750,000 |
|
3 |
$1,000,000 |
$1,500,000 |
|
4 |
$ 950,000 |
$1,250,000 |
|
5 |
$ 900,000 |
$1,100,000 |
Figure 1
As the capital budgeting analyst, you are required to draft a comprehensive memo, addressed to: The Manager, Shipping Department.
-
How should you handle the $150 per hour charge for computer time charged by the shipping department to the production department? Why? Be specific.
-
How should you handle the $10,000 payment to the Consultant? Why? Be specific.
Solutions
Expert Solution
A Memo on the selection of Fully Operating warehousing Project.
To,
The Manager,
Shipping Department ,
Dear Sir,
Based on the financial and operational information provided , a comprehensive Capital Investment evaluation process has been done for both the alternate Option of System A and System B B.
As per the NPV analysis , we can reach to the conclusion that System A may be selected for the development of the Automated Warehouse as it has a higher NPV of $568,709 (against $333,328 of system B) and the initial investment is also lower.
Two specific considerations have been made in this analysis;
1. The $150 per hour charge for computer time has been ignored in this evaluation. There is no new incremental cost for computer capacity generation. The existing capacity will be continued to use and there is spare capacity as well. As there is no additional cost to be incurred , the proposed charge for computer time in not relevant for evaluation.
2. The otside consultant cost of $10,000 has also been excluded for evaluation process. This is a sunk cost and the peformance of any of the two projects not affected by this cost. This is not a relevant cost for evaluation.
Please refer to the detailed evaluation done to reach to the above conclusion in favor of System A..
Any input on this will be highly appreciated.
Best Regards,
XYZ
Attachment : NPV Analysis
| CCA Calculation for both the systems @30% | ||||
| Year | WDV System A | CCA Deduction System A | WDV System B | CCA Deduction System B |
| Year 1 | $ 2,500,000 | $ 750,000 | $ 4,000,000 | $ 1,200,000 |
| Year 2 | $ 1,750,000 | $ 525,000 | $ 2,800,000 | $ 840,000 |
| Year 3 | $ 1,225,000 | $ 367,500 | $ 1,960,000 | $ 588,000 |
| Year 4 | $ 857,500 | $ 257,250 | $ 1,372,000 | $ 411,600 |
| Year 5 | $ 600,250 | $ 600,250 | $ 960,400 |
$ 960,40 |
| Calculation of NPV of System A | |||||||
| Details | Year0 | Year1 | Year2 | Year3 | Year4 | Year5 | |
| Initial Investment | |||||||
| Development cost | $ (2,500,000) | ||||||
| Investment in Additional WC | $ (50,000) | $ (10,000) | $ (10,000) | $ (10,000) | $ (10,000) | ||
| a | Total Initial Investment | $ (2,550,000) | $ (10,000) | $ (10,000) | $ (10,000) | $ (10,000) | |
| Pre Tax cost savings | $ 1,500,000 | $ 1,200,000 | $ 1,000,000 | $ 950,000 | $ 900,000 | ||
| Less CCA Deduction | $ 750,000 | $ 525,000 | $ 367,500 | $ 257,250 | $ 600,250 | ||
| EBT | $ 750,000 | $ 675,000 | $ 632,500 | $ 692,750 | $ 299,750 | ||
| Tax @26% | $ 195,000 | $ 175,500 | $ 164,450 | $ 180,115 | $ 77,935 | ||
| Post Tax Income | $ 555,000 | $ 499,500 | $ 468,050 | $ 512,635 | $ 221,815 | ||
| Add back CCA deduction | $ 750,000 | $ 525,000 | $ 367,500 | $ 257,250 | $ 600,250 | ||
| b | Cash flow from Operations | $ 1,305,000 | $ 1,024,500 | $ 835,550 | $ 769,885 | $ 822,065 | |
| Terminal Cash flow | |||||||
| Return of Working capital | $ 90,000 | ||||||
| c | Total Terminal Cash flow | $ 90,000 |
| d | Total Relevant Cash flow=a+b+c | $ (2,550,000) | $ 1,295,000 | $ 1,014,500 | $ 825,550 | $ 759,885 | $ 912,065 |
| e | Discount factor @18%=1/1.18^n | 1 | 0.847 | 0.718 | 0.609 | 0.516 | 0.437 |
| f | PV of Cash flows =d*e= | $ (2,550,000) | $ 1,096,865 | $ 728,411 | $ 502,760 | $ 392,101 | $ 398,572 |
| g | NPV =Sum of PV of cash flows = | $ 568,709 | |||||
| PI = | 0.23 |
| Calculation of NPV of System A | |||||||
| Details | Year0 | Year1 | Year2 | Year3 | Year4 | Year5 | |
| Initial Investment | |||||||
| Development cost | $ (4,000,000) | ||||||
| Investment in Additional WC | $ (50,000) | $ (10,000) | $ (10,000) | $ (10,000) | $ (10,000) | ||
| a | Total Initial Investment | $ (4,050,000) | $ (10,000) | $ (10,000) | $ (10,000) | $ (10,000) | |
| Pre Tax cost savings | $ 2,000,000 | $ 1,750,000 | $ 1,500,000 | $ 1,250,000 | $ 1,100,000 | ||
| Less CCA Deduction | $ 1,200,000 | $ 840,000 | $ 588,000 | $ 411,600 | $ 960,400 | ||
| EBT |
$&nbs
 jeff jeffy answered 2 years agoRelated SolutionsAs a financial advisor at RedHat International (RHI), you have been asked to evaluate two capital...As a financial advisor at RedHat International (RHI),
you have been asked to evaluate two capital investment alternatives
submitted by the shipping department. Before beginning your
analysis, you note that company policy has set the minimum desired
rate of return at 18% for all proposed projects. You also learn
that the corporate tax rate is 26%.
The proposed capital project calls for the shipping
department to fully automate a warehouse using one of two different
advanced robotics systems. System A...
As a financial advisor at Minor International (MI), you have been asked to evaluate two capital...As a financial advisor at Minor International (MI), you have
been asked to evaluate two capital investment alternatives
submitted by the production department. Before beginning your
analysis, you note that company policy has set the required rate of
return for all new projects at 20% per year. You also learn that
the corporate tax rate is 24%.
The proposed capital project calls for the IT Department to
develop new computer software to facilitate partial automation of a
production plant. Alternative...
As a financial analyst for ABC Co. you have been asked to evaluate two capital investment...As a financial analyst for ABC Co. you have been asked to
evaluate two capital investment opportunities submitted by the
production department of the firm. Before beginning your analysis,
you note that the company has set the cost of capital at 10 percent
for all proposed projects. ABC Co. pays corporate taxes at the rate
of 30 percent.
The proposed capital project calls for developing new computer
software to facilitate partial automation of production in the
Company’s plant. Alternative A...
As a financial analyst at Delhi Systems you have been asked to evaluate two capital alternatives...As a financial analyst at Delhi Systems you have been asked to
evaluate two capital alternatives submitted by the production
department of the firm. Before beginning you analysis. As a small
business, Delhi pays corporate taxes at the rate of 35%. The
proposed capital project calls for developing new computer software
to facilitate partial automation of production in Delhi’s plant.
Alternative A has initial software development costs estimated at
$185,000, while Alternative B would cost $330,000. Software
development costs would...
You have been hired as a financial advisor to Raheel Abbas. He has received two offers...You have been hired as a financial advisor to Raheel Abbas. He
has received two offers for playing professional basketball and
wants to select the best offer, based on considerations of money
only. Offer A is a Rs.10m (offer for Rs.2m a year for 5 years).
Offer B is a Rs.11m (offer of Rs.1m a year for four years and Rs.7m
in year 5).
Required: Calculate the present value of each contract by assuming
a range of interest rate (8%...
You have been asked to analyze the financial statements of the Dayton Corporation for the two...You have been asked to analyze the financial statements of the
Dayton Corporation for the two years ending 2015 and 2016.
Dayton Corporation
Financial Data
2015
2016
Net Sales
$47,715
$40,363
Cost Sales
$27,842
$21,485
SG & A expenses
$8,090
$7,708
Depreciation expense
$628
$555
Interest expense
$754
$792
Tax expense
$3,120
$3,002
Cash & equivalents
$2,144
$2,536
Receivables
$5,215
$5,017
Inventory
$3,579
$3,021
Other current assets
$2,022
$2,777
Plant & equipment
$18,956
$16,707
Accumulated depreciation
$5,853
$5,225
Intangible assets...
You have been tasked to evaluate the financial health and working capital policy of Yoyo Co....You have been tasked to evaluate the financial health and
working capital policy of Yoyo Co.
The extracts of the balance sheet as at 31 December 2019 and income
statement for the year ended are as follows:
Balance sheet
$'000
Income Statement
$'000
Current assets
Sales
20,000
Inventory
2,500
Cost of Sales
15,000
Accounts receivables
4,250
Cash
4,000
Current liabilities
Accounts payables
2,750
Short-term bank loan
2,500
Companies which are similar to Yoyo Co have the following average
metrics for...
You have been asked to evaluate two machines. The benefits from ownership are identical. Machine A...You have been asked to evaluate two machines. The benefits from
ownership are identical. Machine A costs $300 to buy and install,
lasts for 5 years, and costs $160 per year to operate. Machine B
costs $500, lasts for 7 years, and costs $120 per year to operate.
Both machines have zero salvage value. Assuming that this is a
one-time acquisition, which machine do you recommend if the cost of
capital is 15%?
A.
Machine A, the PV is $163...
You have been hired as Financial advisor by Texas Corporation and the first task that is...You have been hired as Financial advisor by Texas Corporation
and the first task that is assigned to you is to help the company
determine its optimal capital structure.
a) What factors will help you in determining the optimal
structure for Texas Corporation.
b) From the financial statements of the company you have
discovered that company has a very high operating leverage. How is
it effecting the firm's profitability?
c) The company is in a higher tax bracket defined by...
You have the following financial statements for two building companies and have been asked to compare...You have the following financial statements for two building
companies and have been asked to compare them:
Income statements for the year to 31st December
2019
Potts Ltd
Tony Ltd
£`000
£`000
Sales
3500
3880
Cost of Sales
(900)
(1000)
Gross Profit
2600
2880
Operating expenses
(560)
(790)
Operating Profit
2040
2090
Interest Payable
(57)
(76)
Profit Before Taxation
1983
2014
Taxation
(80)
(68)
Profit After Taxation
1903
1946
Dividends
(35)
(42)
Retained Profits
1868
1904
Statements of financial position...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|