can you show work and possibly use the formulas to solve instead of excell please...
50.1K
Verified Solution
Link Copied!
Question
Accounting
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 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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
