This paper circulates around the core theme of You are offered an asset that costs $3000 and has cash flows of $500 every six month (end of period) together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
You are offered an asset that costs $3000 and has cash flows of $500 every six month (end of period) 1 answer below » You are offered an asset that costs $3000 and has cash flows of $500 every six month (end of period) of the next 10 years. a. If your cost of capital is 8.2 percent, should you purchase it? b. What is the IRR of the asset? c. What is the NPV of the asset? (Setup cash flows in Excel spreadsheets and use following Excel Financial functions, IRR and NPV to derive your answers.) Work for this problem must be shown through application of excel PMT and PV formulas (please see attached spreadsheet) SINGLE CASH FLOW Present Value Attachments: Q..docx Q.-Attachment….xls Sep 21 2015 11:55 AM