Question: I need this in excel, please Business Processing Consultants (BPC), Inc. is interested in replacing its fully depreciated in-house computer capability with a five-year contract

I need this in excel, please

Business Processing Consultants (BPC), Inc. is interested in replacing its fully depreciated in-house computer capability with a five-year contract to use computer support from Amazon World Services. To do so the company must pay a charge of $600,000 at the end of the first year and a subsequent annual fee for usage. Business Processing believes this improved capability will increase sales for the next five years. Their forecast projects net extra revenue each year (after subtracting Amazons annual fee) to be as follows. End of First year +100,000 End of Second year +120,000 End of Third year +130,000 End of Fourth year + 205,000 End of Fifth year + 225,000 Determine the present value of this investment using an 7% discount rate.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Excel only 7. Business Processing Consultants (BPC), Inc. is interested in replacing its fully depreciated in-house computer capability with a five-year contract to use computer support from Amazon...

thank you in advance ! 3. Business Processing Consultants (BPC), Inc. is interested in replacing its fully depreciated in-house computer capability with a five-year contract to use computer support...

1. You plan on retiring in 30 years and believe it is time to start making annual contributions to a retirement account. (a) How much will you have in your retirement account if you deposit $2600...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

GRADUATE CERTIFICATE IN PROJECT MANAGEMENT PROJ5010: PROJECT PROCUREMENT AND STRATEGIC SOURCING. CASE STUDIES CONTENTS 1. Proj5010: The World Bank RFP Case Study covers 1. Assignment 1: Marks = 5 2....

2. What should Martin have done earlier in the project timeline to prevent delays? ( detailed answer) Chris, what do you mean, we can't deploy the system on time? It's a month before the end of the...

1. How much longer will the project take? (Detailed Answer) Chris, what do you mean, we can't deploy the system on time? It's a month before the end of the project and now you're telling me that we...

Please help me to find ProActive action in this Case study as a project manager. Singapore TradeNet: A Tale of One City As the sun rose over the island of Borneo, the container ship Kobayashi Maru,...

IV-1 Systems Investments The Clarion School for Boys, Inc.Milwaukee Division: Making Information John Young, Controller of the Clarion School for Boys, Inc.Milwaukee Division, hung up the telephone...

Because it's so difficult to estimate the cost of providing defined-benefit pensions to employees, it would make more sense, and result in more accurate financial statements, to simply expense...

Mrs Teng, the sole proprietor of a food catering business, submits her profit and loss account for the year ended 31 December 2020 as follows: Sales Less: Cost of sales Remunerations Van running...

The O'Hara Group is owed $ 1 , 0 7 0 , 0 0 0 by Hilton Enterprises under an 1 0 % note with three years remaining to maturity. The prior year of interest was unpaid. O'Hara agrees to restructure the...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...