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

  Calculate roi before investing in a new product

What unique challenges would a health care organization face when attempting to compute a true ROI?

  Accrual accounting role in statements

Discuss and explain some of the characteristics of income statement, balance sheet & cash flow statement. From perspective of story told by every statement?

  Make the liquidators final statement of account

X Ltd. went into liquidation. Its assets realized Rs.1,75,000, excluding the amount realized by sale of securities held by the secured creditors.

  What is the value of midwest pine to kc deck

From a financial manager's perspective, WHY would this merger have been a value creating proposition? In other words, why are the two firms worth more together than apart?

  Arguments and evidence from behavioural finance

What is wrong with the arguments and evidence from behavioural finance that there might be active strategies that consistently beat the market over the very long term and what is so convincing about the arguments and evidence from modern finance a..

  Discuss the results of the sensitivity analysis

Discuss the results of the sensitivity analysis and the implications of changes in revenue.

  Risk free rate and market risk premium

What is the minimum line of credit that CBM will need - what do you think of CBM's cash position during the budget period? Do you see any concerns for the company in this regard?

  How does a learning curve differ from an experience curve

Explain to Arty what is meant by a learning curve and explain the learning curves role in cost estimation.

  What is the irr on project

The project net working capital is equal to 10% of the next year's revenue. The tax-rate is 35%. What are the project's net cash flows for years 0-3? What is the IRR on this project?

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Construct a price weighted index

Three (3) stocks have share values of $12, $75, and $30 with total market rates of $400 million, $350 million & $150 million respectively.

  Investment in fixed assets or borrow funds

Analysis on whether to go for investment in Fixed Assets or borrow funds - what conclusion can you draw from it

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