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

Q

You are interested in purchasing a $400,000 home. Interest rates are currently about 4.0% for 30...

Finance
Q

Two blocks connected by a string are pushed across a horizontalisurface by a force applied to...

Physics
Q

Elements Key performance indicator (KPI)

Mechanical Engineering
Q

Is the function represented by the following table linear or quadratic Choose the correct answer...

Basic Math
Q

13 Evaluate sin 5x cos 4x dx a c co cos x cos 9x C...

Calculus
Q

What is t x when t x ln In 2 3 2 2 Select the...

Calculus
Q

Can someone please help? Coronado Corporation acquires a coal mine at...

Accounting
Q

Demonstrate detailed knowledge by explaining 5 (out of 8) distinctions between Share and Debenture?

Accounting
Q

Greenville has provided the following information from its General Fund Revenues and Appropriations/Expenditure/Encumbrances subsidiary ledgers...

Accounting
Q

y1 This table shows the size of the financial investments (y1 and y2) of two...

Accounting
Q

The Trailer division of Baxter Bicycles makes bike trailers that attach to bicycles and can...

Accounting
Q

Post 30 transactions using the T format.. Use the 30 transactions from the Activity and...

Accounting