Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you show work and possibly use the formulas to solve instead of excell please A local municipality is considering investing $ 290,000 to upgrade

can you show work and possibly use the formulas to solve instead of excell please
image text in transcribed
image text in transcribed
image text in transcribed
A local municipality is considering investing $ 290,000 to upgrade a park. Based on similar investments made by similar cities, it is anticipated the investment will result in annual costs and annual benefits over a 15-year period as shown in the cash flow profile given below in thousands of dollars. Notice, an intermediate investment of $ 180,000 is anticipated in the 6th year of the investment. Based ona MARR of 3%, use benefit-cost ratio analysis to determine whether the investment should be made. (All values in thousand dollars) End-of Year Costs Benefits Net Cash Flow 0 $ 290 -$ 290 1 $ 90 $ 135 $45 2 $ 90 $ 145 $55 3 S 90 $ 155 $65 $ 90 $ 165 $75 5 S 90 $ 175 $85 6 $ 270 $ 185 -$85 7 $ 90 $ 175 $85 8 $ 90 $ 165 $75 9 $ 90 $ 155 $65 10 $ 90 $ 145 $55 11 $ 90 $ 135 $ 45 $ 12 $ 125 $ 35 90 13 $ 90 $ 115 $25 $ 14 $ 105 $ 15 Question 1 of 3 > - /25 E 90 155 10 $ 145 $ 55 90 11 $ 90 $ 135 $45 12 $ 125 $35 90 13 $ 90 $ 115 $ 25 14 $ 90 $ 105 $ 15 15 $ 90 $95 $5 Click here to access the TVM Factor Table calculator B/C

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions