Question: PLEASE SHOW CALCULATIONS IN EXCEL - SHOW FORMULAS USED Implementing an e-commerce website has a projected net economic benefit of $ 40,000/year during the next

PLEASE SHOW CALCULATIONS IN EXCEL - SHOW FORMULAS USED

Implementing an e-commerce website has a projected net economic benefit of $ 40,000/year during the next five years. The recurring costs of this project are $ 10,000/year, and the initial cost of implementing the website is $ 50,000. Assuming that 10 percent is the estimated discount rate, do the following:

A. Calculate the net present value of these costs and benefits

B. Calculate the overall return on investment

C. Perform a break-even analysis and estimate when the actual break-even occurs

D. Generate a graphical representation in the case that the project breaks even

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 Accounting Questions!

Instructions You must upload two files. An Excel file with your calculations and a Word File with the summary of your answers. Please use image captures to show the summary within the Word document....

An Excel file with your calculations and a Word File with the summary of your answers. Please use screen shots to show the summary within the Word document. Problem 1 Implementing an e-commerce...

Please answer parts 1-4 Problem 1 Implementing an e-commerce website has a projected net economic benefit of $ 40,000/year during the next five years. The recurring costs of this project are $...

Attached is the assignment requirement and 2 previous assignments as example 1- the assignment should be zero plagiarism and similarity (no copy ans paste is accepted) 2- should be completed in the...

The excel homework assignment below has five tabs that cover five different topics: Net Present Value Analysis, Capital Budgeting and Cost of Capital, Working Capital, Management, Financial Ratio...

I need Help for this project!!! (Attached herewith the format of the project and sample project to get an idea) Business plan project This project is designed as you who plan to open (or acquire)...

Strategic Plan Introduction The strategic plan is established by analyzing alternative solutions through tools and matrices designed to develop a strategic direction. The stacked EFE/IFE matrix is...

BLC Inc. is a medium-sized manufacturing company based in the UK. The company operates mainly in the London area and is based in Peterborough. At a recent board meeting, the company decided to expand...

Hello, I need some assistance with this project. I have everything completed except the third and fourth question (located in the instruction project document. 3.)You are a security analyst...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

John owns all the shares of Blue Corporation. John wishes to sell the corporation and agrees to pay an outside agency $80,000 to determine the fair value of the corporation and to assist him in...

1. A company shows the following unit costs for its product: Direct materials ....$40 Direct labor ......30 Variable overhead ...2 Fixed overhead ....5 The company started the year with 8,000 units...

Sunk costs A . are costs that flims sink into marketing. B . are costs that hare nlresty lewh paid and carnot be recapt red in any signficant way. C . ace important for optimal decision making. D ....

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

3. Design a checklist for carrying out a safety inspection in the workplace. Use your checklist to actually carry out an inspection of a designated area either at work or in your college. Write a...

explain the terms used for companies which operate on an international basis such as international, multinational and global enterprise

5. Imagine that you are a consultant employed to select a job evaluation scheme for an organisation that employs 500 employees in a large range of clerical jobs. Write a report to the human resource...