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

Medical Sciences
1.2K views

Chronic kidney disease is a gradual loss of kidney function. In this assignment, you will explore...

Biology
1.2K views

1. Research one of the invasive species from the list below (or any other invasive species). Zebra...

Finance
1.2K views

Phil and Carol eloped (at 59 and 46) to New Mexico and then told the kids...

Physics
1.2K views

point charge +Q at origin and two infinite ground planes at z= +- d. used method...

Biology
1.2K views

Read the following excerpt from "Federalist Paper 10" by James Madison, and answer the questionthat...

Basic Math
1.2K views

Consider the picture and identify the center and radius Center 5 0 5 5 4...

Basic Math
1.2K views

The projected year end assets in a collection of trust funds in trillions of dollars...

Calculus
1.2K views

4 Partition the given interval into the indicated number of subintervals 1 4 6

Accounting
1.2K views

Holz Disc Golf Course was opened on March 1 by Colada...

Accounting
1.2K views

Required information Exercise 5-4A (Algo) Effect of inventory cost...

Accounting
1.2K views

Management wants to improve profits and gathered the following data: The company is divided into...

Accounting
1.2K views

For the year ended December 31, 2018, Norstar Industries reported net income of $960,000. At...