User Account

All Pages

Develop a spreadsheet to perform a cost benefit analysis

Assignment Help Corporate Finance
Reference no: EM13205514

MC's CIO has determined that the up front costs of developing their new Web site will be $54,000. The site will take 6 months to become operational.Once operating, the monthly cost for running the site is $5,000 (this includes hosting fees, data entry, marketing, fulfillment, and a Web master).The company expects the site to result in $6,500 per month in additional after tax revenue.

The cost for the ERP project is $100,000 the first year and $50,000 in years 2 and 3.After year 3 the annual cost of maintaining and upgrading the system will be $40,000.The company expects to begin reaping the benefits of the project in year 2 when it will save $50,000.Beginning in year 3 and continuing into the future the annual projected savings is $90,000.

a. Develop a spreadsheet to perform a cost benefit analysis to determine how much the company will make or lose over the next five years for each project.What is the company's annual return on investment for each project?Based solely on this analysis which project would you recommend?

b. Determine the net present value (NPV) for each project (use a discount rate of 10%). What is the company's annual return on investment?Based solely on this analysis which project would you recommend?How would your analysis change if the discount rate increased to 13%?How would you revise your recommendation?

Reference no: EM13205514

Questions Cloud

What are the number of hits for each player : Two minor league baseball players got a total of 358 hits. Washington had 20 more hits than Sanchez. What are the number of hits for each player?
What federal funds rate should the fed now set : The federal funds rate is currently 3%. The equilibrium real federal funds rate is 3%, and the weights on the output gap and inflation gap are 0.5 each. The inflation target is 1%. Suppose that a year has gone by, output is now just 1% above poten..
Use lagrange multipliers to find the given extremum : Use Lagrange multipliers to find the given extremum. In each case assume that x and y are positive.
What money growth rate should the fed aim : Suppose that the Fed's inflation target is 2%, potential output growth is 3.5%, and velocity is a function of how much the interest rate differs from 5%: %^V= 0.5 X (i-5). Suppose that a model of the economy suggests that the real interest rate.
Develop a spreadsheet to perform a cost benefit analysis : Develop a spreadsheet to perform a cost benefit analysis to determine how much the company will make or lose over the next five years for each project and what is the company's annual return on investment for each project
Does have excess reserves or is short of reserves : Statistics for the economy as a whole are D= $2,000 billion, R= $200 billion, C/D= 0.2=ratio of currency to transactions deposits, N/D= 2.0= ratio of nontransactions deposits to transactions deposits, MMF/D = 1.6 = ratio of retail money-market mut..
By how much will the area of the square be increased : A square support unit in a television is made with a side measuring 10 centimeters. A new model being designed for the upcoming year will have a larger square with a side measuring 10.3 centimeters. By how much will the area of the square be incre..
What are the values given a required annual rate : Would it preferable to receive daily payments rather than quarterly or semi-annually and what are the following values given a required annual rate of 5%?
Compute the volume of the solid generated by revolving : Compute the volume of the solid generated by revolving the triangular region bounded by the lines

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd