Question: Your team is evaluating two mutually exclusive projects. The initial cost of each investment is $50,000. The probability of the cash flows is shown below.

Your team is evaluating two mutually exclusive projects. The initial cost of each investment is $50,000. The probability of the cash flows is shown below. If the project will have a 5 year life and the appropriate cost of capital is 9% calculate the following:

Probability	CF(A)	CF(B)
10%	(34,000)	(13,500)
25%	(8,500)	2,125
30%	17,000	19,000
25%	42,500	31,875
10%	68,000	46,750

please show how to get theses in excel with forumlas shown as well

Expected value

NPV

Standard deviation

IRR

MIRR

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

SHOW WORK on EXCEL and EXPLAIN ANSWERS on all problems. You are thinking of buying a miniature golf course to operate. It is expected to generate cash flows of $45,000 per year in years one through...

I need help with these finance questions and see attachment below for the documents Finance questions Provide work on excel sheet and give explanations where necessary. You are thinking of buying a...

Hi, I need help with my finance homework.Thisis kind of a short notice as we have been given asmall windowto complete. It is due today. Please see attached and let me know if you can help. Please...

1. You are thinking of buying a miniature golf course to operate. It is expected to generate cash flows of $45,000 per year in years one through three and $55,000 per year in years four through...

Your team is evaluating two mutually exclusive projects. The initial cost of each investment is $ 5 0 , 0 0 0 . The probability of the annual cash flows is shown below ( note these cash flows and...

2) Your team is evaluating two mutually exclusive projects. The initial cost of each investment is $50,000. The probability of the cash flows is shown below. If the project will have a 5 year life...

The Mulligan company, a manufacturer of electrical parts, is evaluating several proposals for the upcoming capital budget year and you were asked to perform the analysis and submit a report with your...

From the following transactions for Andrew Co., journalize, record, post, and prepare a schedule of accounts receivable when appropriate. The accounts receivable subsidiary ledger and partial general...

GoldStar Inc. acquired all assets and assumed all liabilities of Silver Company at a cash purchase price of $784,000. The carrying value of the assets acquired was $1,040,000 and the carrying value...

To protect your credit card privacy, which of the following should you do ? a . Cancel all credit card accounts. b . Review your credit bureau report at least once a year. c . Write your driver's...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

4. Think of a topic that you find excruciatingly dull (for example, balancing your checkbook, studying for a required course you dont like, or taking a summer or part-time job doing something utterly...

2. Informative speeches are everywherein your classroom, on the news, and in your community. Watch an informative speech (or read a transcript, available at the Web sites of many government agencies...

5. Imagine a process you do every day, such as driving a car. Think about how you would explain the process to someone whos never done it or even seen it done before. Consider different ways you...