Question: Question 9: You are considering a project with an initial cash outlay and expected free cash flows at the end of each year for 5

Question 9:
You are considering a project with an initial cash outlay and expected free cash flows at the end of each year for 5 years, and the required rate of return for this project as stated below:
Length of Project 5 years
Expected Free Cash Flows at the end of each year 26 000
Initial Cash Outlay 115 000
Required Rate of Retrun 10,00%
a) What is the projects payback period? Would you accept/reject the project if the maximum acceptable payback period is 5 years?
b. What is the projects discounted payback period? Would you accept/reject the project if the maximum acceptable discounted payback period is 4 years?
c. What is the projects NPV? Would you accept/reject the project?
d. What is the projects PI? Would you accept/reject the project?
f. What is the projects IRR? Would you accept/reject the project?
f. What is the projects MIRR if the re-investment rate is 9 percent? Would you accept/reject the project?

Have anyone solved Similair Probelms in Excel and can go through the steps to solving this?

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!

Q:

Question 8: You are considering a project with an initial cash outlay and expected free cash flows at the end of each year for 5 years, and the required rate of return for this project as stated...

Q:

I need the full solution as quickly as possible . Note: Please delete your response by one day after you send it ( so my teacher wont be able yo catch me ) Thank you in advance INSTRUCTION FOR...

Q:

Question 3. The following common stocks are available for investment: COMMON STOCK (Ticker Symbol) BETA Nanyang Business Systems (NBS) 1.40 Yunnan Garden Supply, Inc. (YUWHO) 0.80 Bird Nest Soups...

Q:

Question 3. BETA The following common stocks are available for investment: COMMON STOCK (Ticker Symbol) Nanyang Business Systems (NBS) 1.40 Yunnan Garden Supply, Inc. (YUWHO) 0.80 Bird Nest Soups...

Q:

not in excel I need simple formula with all the process -24. (Calculating the payback period, NPV, PI, and IRR) Rayyan Industries is considering a project with an initial cash outlay of 120,000...

Q:

The market price is $850 for a year bond ($1000 par value) that pays 5.42% interest (2.71% semiannually). What is the bonds expected rate of return (yield to maturity, YTM) per year? Following above,...

Q:

Explanation in full detail Question 4. You are considering a project with an initial cash outlay of $200,000 and expected free cash flows of $100,000 at the end of each year for 3 years. The required...

Q:

You invested $ 1 0 0 , 0 0 0 in a 1 0 - year bond with a coupon rate of interest of 4 % . The market rate of interest is 2 % . Interest is paid semiannually. Compute the present value of the bond....

Q:

You are considering a project with an initial cash outlay of $71,000 and expected cash flows of $19,170 at the end of each year for six years. The discount rate for this project is 10.3 percent....

Q:

(Calculating the payback period, NPV, PI, and IRR) Rayyan Industries is considering a project with an initial cash outlay of 120,000 expected cash flows of 30,000 at the end of each year for seven...

Q:

1. In what sense is a program in a third-generation language machine independent? In what sense is it still machine dependent? 2. What is the difference between an assembler and a compiler? 3. We can...

Q:

So thats the simplified version of the decision tree based on what appear to be the critical issues, Nancy Milnor concluded. Calculating expected values, it looks as though we should introduce the...

Q:

In January 2020, the global currency market experienced unprecedented calm. The JP Morgan Global FX Volatility Index reached a historic low, reflecting subdued volatility across major currencies....

Q:

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

Q:

1 Is forgiving those who do harm an acceptable outcome for a conflict of this magnitude? Did the reaction of the Amish to their childrens killer and to his family effectively resolve the conflict, or...

Q:

3 The Amish forgive those involved in conflict with them because of their deeply held religious beliefs. Are there other reasons for forgiveness that can be useful in a conflict?

Q:

4 What is your reaction to the information on Amish forgiveness in light of what we learned about Amish shunning earlier in the chapter?