Only the odds please and if so can you do in excel with formulas shown?
234 CHAPTER 1O d A project with an initial outlay of s5,000 results in a single free cash flow of $10,123 after (Payback) Determine each project's payback period years 13. aPof eaxh ar s000 resuls in a single free cash hlow of b. A project with an initial outlay of $10,.000 results in a single free cash flow of $8,000 after th c.A project with an initial outlay of $3,000 results in a single free cash flow of $1,333 after the end end of each year for 5 years of each year for 5 years A project with an initial outlay of $3,000 results in a single free cash flow of $1,235 after the end of each 2 years for 10 years 14. Internal Rate of Return) Calculate the project's internal rate of return. a. An initial cash outlow of S6,235 and a free cash flow of $7,125 in 5 years. An initial cash outflow of $6,235 and a free cash flow of $7,125 in 3 years initial cash outflow of $6235 and a free cash flow of $7,125 in 10 years c. An e. An initial cash outflow of $6,235 and a free cash flow of $1,125 at the end of the next 3 years, f. An initial cash outflow of $6.235 and a free cash flow of $1,125 at the end of the next 3 years, An initial cash outflow of $6,235 and a free cash flow of S1,125 at the end of the next 5 followed by $1,025 at the end of 5 years. followed by $1,025 at the end of 5 years. years An initial cash outflow of $6,235 followed by $1,025 at the end of 2 years and a free cash flow of $1,125 at the end of the next 3 years. (Net Present Value) Calculate the project's net present value. The cost of capital is 10%. a. An initial cash outflow of $6,235 and a free cash flow of $7,125 in 5 years. b. An initial cash outflow of $6,235 and a free cash flow of $7,125 in 3 years c. An initial cash outflow of $6,235 and a free cash flow of $7,125 in 10 years d. An initial cash outflow of $6,235 and a free cash flow of $1,125 at the end of the next 5 years e. An initial cash outflow of $6,235 and a free cash flow of $1,125 at the end of the next 3 years, 15. followed by $1,025 at the end of 5 years. f. An initial cash outflow of $6,235 and a free cash flow of $1,125 at the end of the next 3 years, followed by $1,025 at the end of 5 years. An initial cash outflow of $6,235 followed by $1,025 at the end of 2 years and a free cash flow of $1,125 at the end of the next 3 years g. 16. (Payback period, IRR, & NPV) You are considering a project with an initial cash outlay of $5.275 and expect to receive free cash flows $2,125 at the end of each year for the next 7 years. If the required rate of return is 10%, what is the firm's a. Payback period? b. NPV? C. IRR? d. Should this project be accepted? (use answers to parts b and c)
