Purchase Solution

present worth analysis

Not what you're looking for?

Ask Custom Question

(a) Determine which of the following independent projects should be selected for investment if $325,000 is available and the MARR is 10% per year. Use the PW method to evaluate mutually exclusive bundles to make the selection.
(b) If the five projects are mutually exclusive alternatives, perform the present worth analysis and select the best alternative.

Project Initial Investment Net Cash Flow, $Year Life Years
A -100,000 50,000 8
B -125,000 24,000 8
C -120,000 75,000 8
D -220,000 39,000 8
E -200,000 82,000 8

Need to show excel formula

Purchase this Solution
Solution Summary

A present worth analysis is performed.

Purchase this Solution
Free BrainMass Quizzes
Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

View More Free Quizzes
Related BrainMass Solutions

  • sensitivity analysis

    In order to conduct the sensitivity analysis on 60%, 65%, and 70%, change the value in all of these boxes and observe the change in present worth in box C26.

  • present worth analysis

    At an interest rate of 12% per year, which method should be used on the basis of a present worth analysis. Need to show Excel problem. Please see attached file for answers. A present worth analysis is depicted.

  • Depreciation, Investment Appraisal

    Solve the problem by: Present Worth Analysis Annual Cash Flow Analysis Rate of Retun Analyis Future Worth Analyis Benefit-Cost ratio analyis See attached file Answers to two questions: 1) Depreciation calculation using straight line ,

  • lottery winner

    Option B is worth Present value = future value/(1 + discount rate)^time = 1750000/(1+0.05)^5 = 1,371,170.79.

  • Cost Estimation: IRR and Future Worth

    A future worth that was > 0 and a present worth that was < 0. What should Lucy say to Jack? a. If it is an investment analysis, the cash flow in Year 0 or the initial investment would be set as the present worth.

  • Conducting Cash Flow Analysis

    The solution helps in computing cash flow analysis.

  • What is the time value of money?

    How do net present value (NPV) and future value (FV) impact the concept of time value of money? Time value of money is the concept that the money we have today is worth more than it will be worth tomorrow.

  • Present Worth Analysis of Two Different Designs

    66491 Present Worth Analysis of two different designs for a safety closure, which will be in use indefinitely. Using a present worth analysis, which design is better?

  • MACRS

    Using the present worth criterion in a 5-year analysis (development year plus 4 revenue years), determine if it is financially justified to proceed with this project. See the attached file.

View More Related Solutions