Homework Help is Here – Start Your Trial Now!
Business
Finance
How do I complete this in Excel spreadsheet

How do I complete this in Excel spreadsheet

Cornerstones of Cost Management (Cornerstones Series)
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 10CE: Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects...
See similar textbooks
icon
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.
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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Present Value
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
International Financial Management
International Financial Management
Finance
ISBN:
9780357130698
Author:
Madura
Publisher:
Cengage
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS