Economic Feasibility Summary Worksheet: Page 4This is a featured page

As part of the Economic Feasibility Summary Worksheet design, you must discount the recurring benefits and costs to their present values. Although several ways exist to determine the present value of the benefits, you decide to multiply the recurring benefit (or cost) by a present value factor. Since each year requires a different present value factor, the worksheet must compute the present value factor for each year. You decide to use the formula provided below to determine each year's present value factor. (In following formula, "i" refers to the discount rate, and "n" refers to the year. The worksheet shown in Figure 1 assumes that the project's useful life in five years.) To determine the present value of a benefit or cost for a particular year, you multply the recurring value of the benefit or cost for that year by the present value factor for that year. The net present value of all benefits (or costs) is a summation of the benefits (or costs) up to and including the current year. The overall net present value is the difference between the net present value of all benefits and the net present value of all costs. The cash flow section provides a summary of the cash flows on a yearly basis, as well as a summation of the overall cash flows.

PVF=1/(1+i)^n

Piedmont Trailer Manufacturing Company
Custom Order Tracking Project
(Current Date)
Discount Rate 14







Year

0 1 2 3 4 5 Totals
Benefits






Recurring value of benefits $0.00 $295,000.00 $295,000.00 $295,000.00 $295,000.00 $295,000.00
Present Value Factor 1.0000 .877193 .769468 .674972 .592080 .519369
Present value of benefits $0.00 $258,771.93 $226,992.92 $199,116.60 $174,663.68 $153,213.76
Net Present Value of all benefits $0.00 $258,771.93 $485,764.85 $684,881.45 $859,545.13 $1,012,758.89 $1,012,758.89








Costs






One time costs $256,657.00





Recurring cost $0.00 $202,000.00 $202,000.00 $202,000.00 $202,000.00 $202,000.00
Present Value Factor 1.0000 .877193 .769468 .674972 .592080 .519369
Present value of the recurring cost $0.00 $177,193.00 $155,432.00 $136,344.00 $119,600.00 $104,912.00
Net Present Value of all cost $256,657.00 $433,849.98 $589,282.42 $725,626.67 $845,226.89 $950,139.36 $950,139.36








Overall Net Present Value





$62,619.53








Cash Flow Analysis






Yearly NPV Cash flow ($256,657.00) $81,578.95 $71,560.48 $62,772.35 $55,063.47 $48,301.29
Overall NPV Cash Flow ($256,657.00) ($175,078.05) ($103,517.57) ($40,745.22) $14,318.24 $62,619.53


No user avatar
yvonnejazzey
Latest page update: made by yvonnejazzey , Jan 24 2008, 3:48 AM EST (about this update About This Update yvonnejazzey Moved from: Case Background: Page 1 - yvonnejazzey

No content added or deleted.

- complete history)
Keyword tags: 4 case2 page 4
More Info: links to this page
Started By Thread Subject Replies Last Post
yvonnejazzey encoded by yvonn, amlyn & co. 0 Jan 24 2008, 3:51 AM EST by yvonnejazzey
Thread started: Jan 24 2008, 3:51 AM EST  Watch
this is to recognized who contributed this information for the case
Do you find this valuable?    
Keyword tags: case2 page 4
Showing 1 of 1 threads for this page

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)