Suppose that a Frankford town homeowner is considering a project to plant several trees in her...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose that a Frankford town homeowner is considering a project to plant several trees in her front and back yards. Planting the trees would involve an upfront (year 0) expense of $1,000. Starting in year 1, the homeowner would incur an additional expense of $100 per year to maintain the trees (trimming, monitoring health, etc.). The trees would provide several benefits directly to the homeowner, including shade (lowering cooling costs in the summer) and improving the scenery. The monetary value of these benefits to the homeowner is $150 per year, starting in year 1. The trees would also henefit to the residents of the neighborhood and beyond. The trees would reduce air pollution, reduce ambient noise levels in the neighborhood, reduce stormwater runoff, and improve the aesthetics of the area, among other possible benefits. The monetary value of these external benefits is $100 per year, starting in year 1. Scenarios Scenario A (Baseline)-For your baseline BCA, assume that the trees will last 20 years after planting (t.e, through year 20). Assume that the project should be evaluated with a 5% discount rate. For this scenario, consider only the benefits and costs to the homeowner. Scenario B (External benefits)-For this scenario, use the same assumptions as the Baseline scenario, except that you include the external benefits of the trees (to other residents of the neighborhood and beyond), as well as the benefits to the homeowner, in the analysis. Scenario C (Longer life) - For this scenario, use the same assumptions as the Baseline scenario, except that you assume that trees will last 30 years (Le, through year 30) after planting Scenario D (Low discount rate)-For this scenario, use the same assumptions as the Baseline scenario. except that you use a 2% discount rate in the analysis. Scenario E (High discount rate) - For this scenario, use the same assumptions as the Baseline scenario, except that you use a 10% discount rate in the analysis Scenario F (Low costs)-For this scenario, use the same assumptions as the Baseline scenario, except that the annual expense for maintaining the trees is only $50, rather than $100 Questions Set up a spreadsheet to conduct a benefit-cost analysis (BCA) of this situation. (The sample lines below provide some guidance for setting up your spreadsheet.) For each scenario, use your spreadsheet to find the following values. You may want to write your answers in table provided. I ● ● Total benefits (undiscounted) - Find the sum of all benefits considered for that scenario over the life of the project. Do not discount future benefits. Total costs (undiscounted) - Find the sum of all costs over the life of the project. Do not discount future costs. • Net present value (NPV) - Find the net present value of the project (i.e., the sum of the discounted net benefits over the life of the project). • Implement? - Based on the net present value of the project, does benefit-cost analysis suggest that the project should be implemented (yes or no)? The following are the first few lines from a spreadsheet based on this problem (scenario A). You can use them for guidance in structuring your spreadsheet and making sure that your formulas are correct (at least for the first couple of lines). Year Benefits 0 1 2 3 0 150 150 Etc. Costs Net Benefits Discount 1000 100 100 Etc. -1000 50 50 Etc. 5% 5% 5% Etc. Present Value -1000 47.62 45.35 Etc. Suppose that a Frankford town homeowner is considering a project to plant several trees in her front and back yards. Planting the trees would involve an upfront (year 0) expense of $1,000. Starting in year 1, the homeowner would incur an additional expense of $100 per year to maintain the trees (trimming, monitoring health, etc.). The trees would provide several benefits directly to the homeowner, including shade (lowering cooling costs in the summer) and improving the scenery. The monetary value of these benefits to the homeowner is $150 per year, starting in year 1. The trees would also henefit to the residents of the neighborhood and beyond. The trees would reduce air pollution, reduce ambient noise levels in the neighborhood, reduce stormwater runoff, and improve the aesthetics of the area, among other possible benefits. The monetary value of these external benefits is $100 per year, starting in year 1. Scenarios Scenario A (Baseline)-For your baseline BCA, assume that the trees will last 20 years after planting (t.e, through year 20). Assume that the project should be evaluated with a 5% discount rate. For this scenario, consider only the benefits and costs to the homeowner. Scenario B (External benefits)-For this scenario, use the same assumptions as the Baseline scenario, except that you include the external benefits of the trees (to other residents of the neighborhood and beyond), as well as the benefits to the homeowner, in the analysis. Scenario C (Longer life) - For this scenario, use the same assumptions as the Baseline scenario, except that you assume that trees will last 30 years (Le, through year 30) after planting Scenario D (Low discount rate)-For this scenario, use the same assumptions as the Baseline scenario. except that you use a 2% discount rate in the analysis. Scenario E (High discount rate) - For this scenario, use the same assumptions as the Baseline scenario, except that you use a 10% discount rate in the analysis Scenario F (Low costs)-For this scenario, use the same assumptions as the Baseline scenario, except that the annual expense for maintaining the trees is only $50, rather than $100 Questions Set up a spreadsheet to conduct a benefit-cost analysis (BCA) of this situation. (The sample lines below provide some guidance for setting up your spreadsheet.) For each scenario, use your spreadsheet to find the following values. You may want to write your answers in table provided. I ● ● Total benefits (undiscounted) - Find the sum of all benefits considered for that scenario over the life of the project. Do not discount future benefits. Total costs (undiscounted) - Find the sum of all costs over the life of the project. Do not discount future costs. • Net present value (NPV) - Find the net present value of the project (i.e., the sum of the discounted net benefits over the life of the project). • Implement? - Based on the net present value of the project, does benefit-cost analysis suggest that the project should be implemented (yes or no)? The following are the first few lines from a spreadsheet based on this problem (scenario A). You can use them for guidance in structuring your spreadsheet and making sure that your formulas are correct (at least for the first couple of lines). Year Benefits 0 1 2 3 0 150 150 Etc. Costs Net Benefits Discount 1000 100 100 Etc. -1000 50 50 Etc. 5% 5% 5% Etc. Present Value -1000 47.62 45.35 Etc.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Molecular weight data for some polymer are tabulated here. Compute the following: (a) The number-average molecular weight (b) The weight-average molecular weight. (c) If it is known that this...
-
Refer to the financial statement information in P 14-60 for Clarksville Corporation. Required: For the years 2010, 2011, and 2012, compute the following ratios: 1. Return on sales 2. Asset turnover...
-
Show that the number of complex multiplications of the FFT algorithm for generic \(N\) is given by Equation (3.176). M(N) = N(N1 + 2 + + N-1+ N-1). (3.176)
-
As shown in Fig. 5-7p, a positive lens with focal length \(f\) is placed in contact with a pinhole screen in a Young's experiment. The lens and pinhole plane are at distance \(z_{1}\) from the source...
-
Pendergrass Company hires an accounting intern who says that intangible assets should always be amortized over their legal lives. Is the intern correct? Explain.
-
Gold coast organics has a total assets turnover of 2.5 and a net profit margin of 3.5 percent.the total debt ratio for the firm is 50 percent.calculate the gold coast organics return On equity.
-
Patterson, Inc. has provided detals of Its actual cost data for the month. The Controller has asked you to compute the basic variances and the impact of those variances on unit costs. Use the...
-
Discuss the factors that contribute to the downfall of Roman imperial administration. What part did the Roman military, the influx of barbarian peoples, and the reforms of Constantine play in this...
-
Direct labor cost $10,500 Purchases of raw materials 16,500 Factory supervisor salary 2,250 Office Supplies used 675 Factory Insurance 1,350 Commissions paid Commissions paid 2,500 Advertising 1,800...
-
The temperature coefficient of resistivity of a material is 0.0040 (C o ) -1 . By how much T does the temperature of a wire made from this material have to change, in order that the resistance of the...
-
What is the problems with selecting a jury pool that reflects our racially diverse populations? What are two ways to improve jury selection to ensure that a criminal defendant has a jury that can be...
-
What is the difference between evaluative and facilitative mediation? What approach would you take if were a mediator? Which approach would you prefer a mediator take if you were an advocate...
-
Tonic Inc. is a manufacturing company. Last year, the company generated $75 million in EBIT. The company also had $50 million in capital expenditures and reported $20 million in depreciation and...
-
Suppose current spot rates (yields to maturity on zero-coupon bonds) are as below: r0,1 = 4%, r0,2 = 4.25%, r0,3 = 5%, and r0,4 = 5.20%. Here r0,t is the yield-to-maturity on the t-year zero coupon...
-
Explain the operation of the dividends received deduction.
-
In its 2011 financial report, Sound Unlimited reported the following items: 1. A credit balance of $200,000 in allowance for doubtful accounts. 2. A debit balance of $7,500,000 in accounts...
-
Norsums Department Store sells gift certificates that are redeemable in merchandise. During 2011, Norsums sold gift certificates for $88,000. Merchandise with the total price of $52,000 was redeemed...
-
Kyocera is a Japanese telecommunications company that publishes IFRS-based financial statements. On its March 31, 2009, statement of cash flows in the operating section it reported a provisions for...
-
What is the value of Queens Park PLCs preferred stock when the dividend rate is 10 percent on a $100 par value? The appropriate discount rate for a stock of this risk level is 16 percent.
-
Midwest Energy Group has issued preferred stocks ($10 par value) that pay 8 percent dividend annually. If the required rate of return is 15 percent, what is the value of the stock?
-
Calculate the value of Swatchs preferred stock that pays a dividend of $8 per share if your required rate of return is 14 percent.
Study smarter with the SolutionInn App