Cost benefit at the local level often uses a simple tool

Reference no: EM13380872

Cost benefit at the local level often uses a simple tool for calculating potential benefits of a project. It is the simple payback time. That is if a project costs $100,000 to do but will save $25,000 per year, then the simple payback time is 4 years (100,000/25,000). This is not the method Anderson describes in the text, which employs a method to calculate the time value of money: discounting. I have added a PowerPoint to the content area entitled Cost-Benefit Analysis, which reviews this tool again, but the last slide has a project to assess whether or not to proceed. The project is buying new garbage trucks for $400,000 with the estimated annual savings of $90,000; the trucks would last 4 years and would be sold for $100,000. A simple payback analysis would show a payback of 4.4 years (400,000/90,000); however, the residual value of $100,000 was not included; adding that in gives a payback of 3.33 years (400,000-100,000/90,000). Would you make the decision to do this project? Of course, there is a flaw in the simple payback: it does not account for the time value of money. A dollar today is worth more than a dollar 4 years from now.

Also in the Content area is a spreadsheet entitled Discountinggarbage trucks. This spreadsheet has computed the net present value of this proposal using a 7% discount rate; note that it is negative (-$18,861). (Negative numbers are often shown in parentheses in Excel.) With a negative number, you would not recommend doing this project. Since the spreadsheet is set up for you, I would like you to play around with the discount rate until you get the smallest possible positive number next to Net Present Value.

Tell me what this number is. Then explain

1) who might want to use a higher discount rate (you should see a negative number) and

2) who might use a lower number than the one you found ( a positive result), and why. That's it.

For those of you who are new to Excel (I hope you use it, since it is the primary budget and finance tool used at all levels of government), you simply type over the number in the cell next to the one labeled Discount Rate to change the rest of the spreadsheet, particularly the net present value number.

Note: to do this more correctly, you would also have to include an inflation factor in the formula; we will not do so for this exercise.

Reference no: EM13380872

Questions Cloud

Part aassume that you are a financial analyst working : part aassume that you are a financial analyst working for muscat investment l.l.c. evaluate the financial

He one supposed to be done is project 1 reexamining the : he one supposed to be done is project 1 reexamining the stylized facts.a. nbspwhat you already know from the

Research market data on bondsresearch the current within : research market data on bondsresearch the current within the last two months market data on bonds from atampt dell and

In 2007 maureen carter a retired 64-year-old divorced her : in 2007 maureen carter a retired 64-year-old divorced her husband of 42 years. as part of the property settlement the

Cost benefit at the local level often uses a simple tool : cost benefit at the local level often uses a simple tool for calculating potential benefits of a project. it is the

Individual assignmnet corporate financeten years ago in : individual assignmnet corporate financeten years ago in 2003 george reeby founded a small mail-shy-order company

What cash flows are relevant to the value of stockwhy the : what cash flows are relevant to the value of stock?why the fed was initially established?suppose a firms stock has a

Research online trading sites and drips as outlined below : research online trading sites and drips as outlined below and summarize your findings. make sure to include a summary

Question 1what we know-balance sheet as of dec 31st 2012 : question 1what we know-balance sheet as of dec 31st 2012 shown in millions cash3.5accounts

User Account

All Pages