Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Management Expert

A project under consideration is expected to have an 5-7 year projected life (equal probabilities for 5, 6, and 7 years). The initial investment for the project is estimated to be normally distributed with a mean of $20,000 and a standard deviation of $500. The salvage value at the end of the project life is estimated at 10% of the initial investment. The annual revenue estimates are more certain and estimated at $3,000 for each year of the project life. The MARR is 12%. Using Excel, simulate 100 iterations to determine the expected value and standard deviation of the present worth. Clearly identify both in your Excel spreadsheet. Is the expected present worth of this project positive or negative, and would you recommend investing in this project ? Identify your answer in your Excel spreadsheet. create a histogram of your simulation results to illustrate the resulting distribution.

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92370782

Have any Question?


Related Questions in Financial Management

Assignment for pogo managing government finances -the

Assignment for POGO Managing Government Finances - The assignment questions are drawn from topics that may ask you to integrate the topics covered across the entire course - or certainly link different topics together in ...

Assignmentyou may need to make assumptions for some of the

Assignment You may need to make assumptions for some of the problems. You will not lose points as long as you state these assumptions, and your constraints are logical -according to your assumptions. YOUR MODELS MUST BE ...

Assignmentdescribe a work task a hobby or another activity

Assignment Describe a work task, a hobby, or another activity that you regularly do, and sequentially list the various actionsyou take in orderto complete this activity. Consider thecomplexity of your list and the amount ...

Scenario 1you know from government legislation that the

Scenario 1) You know from government legislation that the legal tax rate on your property is 2.4% and the city's assessed value of your property is $155,000. However, your property is currently on the market for only $60 ...

1 comparative advantagethe following chart represents the

1. Comparative Advantage The following chart represents the production capabilities of the US and Japan:.   Output per worker- day   Country Food Clothing US 2 1 Japan 3 9 a) Which country has an absolute advantage in fo ...

Using the framework discussed in the background readings

Using the framework discussed in the background readings, critically analyze General Mills' strategic choices at the Corporate level (remember that "corporate" level is the very highest level of the organization, with lo ...

Company overviewintroductory paragraph summarize the

Company Overview Introductory paragraph. Summarize the section in 1 - 2 paragraphs including the history, current market, and the overall image of the organization. History Current Market Include a brief 2 - 3 paragraph ...

You have owned and operated a successful brick-and-mortar

You have owned and operated a successful brick-and-mortar business for several years. Due to increased competition from other retailers, you have decided to expand your operations to sell your products via the Internet. ...

Part aweek 1in order to properly implement a strategic plan

Part A Week 1: In order to properly implement a strategic plan, organizations use structure, various control systems (budgets, variance analysis, policies and procedures, company rules), and culture. Let us revisit Gener ...

Assignmentnow that you have gained an understanding of red

Assignment Now that you have gained an understanding of Red Carpet, Leroy has asked you to join in on a preliminary meeting with the VP of HR and other members of the organization to discuss change. The meeting was very ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As