Question

In: Finance

Please Solve Handwritten out. NOT EXCEL, Thank You! #1 Suppose a project requires an initial cash...

Please Solve Handwritten out. NOT EXCEL, Thank You!

#1 Suppose a project requires an initial cash outflow of $34,900. The project will last for four years with the annual cash flows given below. The required rate of return is 12%.

Year Cash Flows
1 $12,500
2 $19,700
3 0
4 &10,400

A)Compute the net present value of the project. Should the firm invest in this project based on net present value? Why?

B)Compute the internal rate of return. Should the firm invest in this project based on internal rate of return? Why?

C)Use a graph to show why the firm’s decisions in (1) and (2) are consistent or inconsistent. Be specific.

D)Now suppose another project’s future annual cash flows are given below with an initial cash outflow $14,900.00). The required rate of return is 12%. Using a graph to explain why you cannot use IRR for capital budgeting in this case. (You do not need to compute anything here.)

Year Cash Flow
1 $12,500
2 $12,500
3 $12,500
4 $12,500
5 $12,500
6 $12,500
7 -$19,700
8 -$20,000
9 -$20,000
10 -$20,000

Solutions

Expert Solution


Related Solutions

*Solve without using Excel, write out the equations* Suppose a project requires an initial cash outflow...
*Solve without using Excel, write out the equations* Suppose a project requires an initial cash outflow of $34,900. The project will last for four years with the annual cash flows given below. The required rate of return is 12%. Year Cash Flow Cash Flows 1 12,500 2 19,700 3 0 4 10,400 A) Compute the net present value of the project. Should the firm invest in this project based on net present value? Why? B) Compute the internal rate of...
#1 Suppose a project requires an initial cash outflow of $34,900. The project will last for...
#1 Suppose a project requires an initial cash outflow of $34,900. The project will last for four years with the annual cash flows given below. The required rate of return is 12%. Year Cash Flows 1 $12,500 2 $19,700 3 0 4 &10,400 A)Compute the net present value of the project. Should the firm invest in this project based on net present value? Why? B)Compute the internal rate of return. Should the firm invest in this project based on internal...
Could this be answered within excel + handwritten notes and thoroughly explained. Please and thank you...
Could this be answered within excel + handwritten notes and thoroughly explained. Please and thank you INTRODUCTION TO LINEAR CORRELATION AND REGRESSION ANALYSIS. An economist with a major bank wants to learn, quantitatively, how much spending on luxury goods and services can be explained based on consumers’ perception about the current state of the economy and what do they expect in the near future (6 months ahead). Consumers, of all income and wealth classes, were surveyed. Every year, 1500 consumers...
NOTE: Please provide instructions on how to solve it in excel add screenshots Thank you Suppose...
NOTE: Please provide instructions on how to solve it in excel add screenshots Thank you Suppose a random sample of 137 households in Chicago was taken as part of a study on annual household spending for food at home. The sample data is below. For the sample data, compute the mean and the median and construct a box and whisker plot. (Use Excel to Descriptive statistics and copy paste the screenshot here). Are the data skewed or symmetric? Approximately what...
Solve in excel please, thank you It gives the data on the lifetime in hours of...
Solve in excel please, thank you It gives the data on the lifetime in hours of a sample of 100 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. a. Identify the null and the alternate hypotheses for this study. b. Can this lightbulb manufacturer claim at a significance level of 5% that its lightbulbs typically last more than 1000 hours?...
Suppose a project requires an initial cash outflow of $34,900. The project will last for four...
Suppose a project requires an initial cash outflow of $34,900. The project will last for four years with the annual cash flows given below. The required rate of return is 12%. (1) Compute the net present value of the project. Should the firm invest in this project based on net present value? Why? Year Cash Flows 1 $12,500 2 $19,700 3 0 4 $10,400 (2) Compute the internal rate of return. Should the firm invest in this project based on...
Suppose a project requires an initial cash outflow of $34,900. The project will last for four...
Suppose a project requires an initial cash outflow of $34,900. The project will last for four years with the annual cash flows given below. The required rate of return is 12%. Year Cash Flow 1 12,500 2 19,700 3 0 4 10,400 A) Compute the net present value of the project. Should the firm invest in this project based on net present value? Why? B) Compute the internal rate of return. Should the firm invest in this project based on...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 6) The time needed to complete a...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 6) The time needed to complete a final examination in a particular college course is normally distributed with a mean of 90 minutes and a standard deviation of 15 minutes. Answer the following questions. a. What is the probability of completing the exam in one hour or less? b. What is the probability that a student will complete the exam in more than 60 minutes but less than 105 minutes? c....
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN Given that z is a standard normal...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN Given that z is a standard normal random variable, find z for each situation. a. The area to the left of z is .9750. b. The area between 0 and z is .4750. c. The area to the left of z is .7291. d. The area to the right of z is .1314. e. The area to the left of z is .6700. f. The area to the right of z...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 5) The letter grades on the midterm...
***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 5) The letter grades on the midterm exam given in a large managerial statistics class are normally distributed with mean 75 and standard deviation 9. The instructor of this class wants to assign an A grade to the top 10% of the scores, a B grade to the next 10% of the scores, a C grade to the next 10% of the scores, a D grade to the next 10% of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT