Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
How do I complete this in Excel spreadsheet
![Integrative Case Problem
Capital Budgeting
First Republic Bancorp is considering the acquisition of a new data processing and
management 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 to total $50,000 during the first year. These costs are
expected to increase at a rate of 7 percent 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 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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2c95636c-8e05-4daa-a236-f0ad81c4ad39%2F5d69bdbf-85af-4dfe-9dae-385c9fd33492%2Fcnm9xg_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Integrative Case Problem
Capital Budgeting
First Republic Bancorp is considering the acquisition of a new data processing and
management 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 to total $50,000 during the first year. These costs are
expected to increase at a rate of 7 percent 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 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.
![](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2c95636c-8e05-4daa-a236-f0ad81c4ad39%2F5d69bdbf-85af-4dfe-9dae-385c9fd33492%2Fcw5uhbj.jpeg&w=3840&q=75)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education