Reference no: EM131268645
Capital Budgeting
First Republic Bancorp is considering the acquisition of a new data processing and management and information system. The system, including computer hardware and software, will cost 1 million. Delivery and installation of the system is expected to add $100,000 to this cost. To put this new system in place, the bank expects to have to make an investment of $50,000 in net working capital immediately and an additional net working capital investment of $25,000 at the end of year 1. The system has an expected economic life of 10 years. It will be depreciated as a 7-year asset under MACRS rules. Actual salvage value at the end of 10 years is expected to be $100,000, and the bank plans to sell the system for its salvage value at that time.
The new data processing system will save the bank the $190,000 fee per year that it currently pays to a computer time-sharing company. Operating, maintenance, and insurance costs for the system are estimated total $50,000 during the first year. These costs are expected to increase at a rate of 7% per year over the 10-year period.
First Republic plans to sell excess computer time to a number of local firms. The demand function for this service during year 1 is estimated to be Q = 20,000 - 200P
Where Q = number of units of computer time sold, and P = price per unit of computer time sold.
Based on an analysis of the local market for computer time, the bank feels that it can charge $14 per unit of computer time. Although the bank does not anticipate changing this charge over the 10 year period, it expects the quantity demanded to decline by 5 percent per year after year 1. It is expected that these outside sales of computer time will cost the bank an additional $40,000 per year in computer operating costs (including the salary of a computer services representative to handle the new customers). These additional operating costs are expected to increase at a rate of 7 percent annually over the next 10-year period.
The bank has a marginal ordinary tax rate of 34 percent. This rate is expected to remain in effect over the life of the project. First Republic uses an after-tax cost of capital of 15 percent to evaluate projects of this risk. This cost of capital was computed based upon the current after-tax cost of equity and debt funds in the bank's capital structure.
Based on the information contained in the case, use the NPV approach to determine if First Republic should acquire the new data processing system.
Answer must be in Excel format. Please use attached "Ch10 ICP Student Go By" spreadsheet. All cells must be completed.
Attachment:- ch10_icp_student_go-by-1.xlsx
|
Use graphical approximation methods
: Use graphical approximation methods to determine how long it will take for her total investment in the two accounts to grow to $20,000.
|
|
Would you collect information using a sample or a population
: For the following questions, would you collect information using a sample or a population? Why? Verage has taught nearly 1,500 students in the course over the past 5 years.
|
|
Antitrust division of the justice department be concerned
: From 1979 to 1987 Kellogg introduced over 30 brands of cereal. Should the Antitrust Division of the Justice Department be concerned? Additionally, five other companies introduced a total of 51 new brands of cereal over the same period. Does this fact..
|
|
Empowerment must be provided to the quality teams
: In seminars on TQM, employees were told that empowerment must be provided to the quality teams. The process of empowerment worked reasonably well on the TQM teams, but struggled on project teams. Should the project team be empowered to set goals or s..
|
|
Determine first republic should acquire processing system
: Based on the information contained in the case, use the NPV approach to determine if First Republic should acquire the new data processing system.
|
|
Determine the signal power from the receiving antenna
: A radio communication system transmits at a power level of 0.1 W at 1 GHz. The transmitting and receiving antennas are parabolic, each having a diameter of 1 m. The receiver is located 30 km from the transmitter.
|
|
Graph the amount in the account as a function
: If $6,000 is invested at 10% compounded continuously, graph the amount in the account as a function of time for a period of 8 years.
|
|
Substitution and income effects of a price change
: Distinguish between the substitution and income effects of a price change. If a good's price increases, does each effect have a positive or a negative impact on the quantity demanded?
|
|
Determine the received power level at the output
: The earth station uses a 10-m parabolic antenna with an efficiency of 0.6. The frequency band is at f = 1 GHz. Determine the received power level at the output of the receiver antenna.
|