Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. can you show work and possibly use the formulas to

can you show work and possibly use the formulas to solve instead of excell please...

50.1K

Verified Solution

Question

Accounting

can you show work and possibly use the formulas to solve instead of excell please
image
image
image
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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students