5. In 2013, $9,000 is invested in a business project. Assume a discount rate of 10...

 

Transcribed Image Text:

5. In 2013, $9,000 is invested in a business project. Assume a discount rate of 10 percent per year. Assume all cash flows occur on Dec. 31 of the year listed. The profit stream from the project is as follows: Year 2014 2015 2016 2017 2018 2019 2020 Profit Stream $1,000 $1,000 $1,000 $2,000 $3,000 $4,000 $4,000 a) Draw the cash flow diagram. b) Determine the discounted payback period. (10% discount) c) Determine the Net Present Value for 2013. d) Instead of using a discount rate of 10%, determine the IRR for the project. (attach a copy of the EXCEL spreadsheet you used). 10 5. In 2013, $9,000 is invested in a business project. Assume a discount rate of 10 percent per year. Assume all cash flows occur on Dec. 31 of the year listed. The profit stream from the project is as follows: Year 2014 2015 2016 2017 2018 2019 2020 Profit Stream $1,000 $1,000 $1,000 $2,000 $3,000 $4,000 $4,000 a) Draw the cash flow diagram. b) Determine the discounted payback period. (10% discount) c) Determine the Net Present Value for 2013. d) Instead of using a discount rate of 10%, determine the IRR for the project. (attach a copy of the EXCEL spreadsheet you used). 10 5. In 2013, $9,000 is invested in a business project. Assume a discount rate of 10 percent per year. Assume all cash flows occur on Dec. 31 of the year listed. The profit stream from the project is as follows: Year 2014 2015 2016 2017 2018 2019 2020 Profit Stream $1,000 $1,000 $1,000 $2,000 $3,000 $4,000 $4,000 a) Draw the cash flow diagram. b) Determine the discounted payback period. (10% discount) c) Determine the Net Present Value for 2013. d) Instead of using a discount rate of 10%, determine the IRR for the project. (attach a copy of the EXCEL spreadsheet you used). 10 5. In 2013, $9,000 is invested in a business project. Assume a discount rate of 10 percent per year. Assume all cash flows occur on Dec. 31 of the year listed. The profit stream from the project is as follows: Year 2014 2015 2016 2017 2018 2019 2020 Profit Stream $1,000 $1,000 $1,000 $2,000 $3,000 $4,000 $4,000 a) Draw the cash flow diagram. b) Determine the discounted payback period. (10% discount) c) Determine the Net Present Value for 2013. d) Instead of using a discount rate of 10%, determine the IRR for the project. (attach a copy of the EXCEL spreadsheet you used). 10 5. In 2013, $9,000 is invested in a business project. Assume a discount rate of 10 percent per year. Assume all cash flows occur on Dec. 31 of the year listed. The profit stream from the project is as follows: Year 2014 2015 2016 2017 2018 2019 2020 Profit Stream $1,000 $1,000 $1,000 $2,000 $3,000 $4,000 $4,000 a) Draw the cash flow diagram. b) Determine the discounted payback period. (10% discount) c) Determine the Net Present Value for 2013. d) Instead of using a discount rate of 10%, determine the IRR for the project. (attach a copy of the EXCEL spreadsheet you used). 10 5. In 2013, $9,000 is invested in a business project. Assume a discount rate of 10 percent per year. Assume all cash flows occur on Dec. 31 of the year listed. The profit stream from the project is as follows: Year 2014 2015 2016 2017 2018 2019 2020 Profit Stream $1,000 $1,000 $1,000 $2,000 $3,000 $4,000 $4,000 a) Draw the cash flow diagram. b) Determine the discounted payback period. (10% discount) c) Determine the Net Present Value for 2013. d) Instead of using a discount rate of 10%, determine the IRR for the project. (attach a copy of the EXCEL spreadsheet you used). 10

Answer rating: 100% (QA)

a Cash Flow Diagram Year 0 1 2 3 4 5 6 7 Cash 9K 1K 1K 1K 2K 3K 4K 4K b ... View the full answer