Please help with excel details. You need to complete this problem in a spreadshe
ID: 2732701 • Letter: P
Question
Please help with excel details.
You need to complete this problem in a spreadsheet and show all your work. Create an excel file that shows your calculations. Clearly indicate your final answer(s). Name the file with the following convention: Lastname-Problem .xlsx. For instance, Roark-Problem 4.xlsx Your firm is considering a 5 year project. The projected revenues are $1,500,000 in year 1 and then they are expected to grow by 5% per year for years 2-5. Operating expenses are 65% of revenues and depreciation is straight-line. The tax rate is 35% and the project requires an upfront investment in equipment of $1,000,000. The project requires $40,000 in working capital (assume the investment in working capital s made up front at time period 0) which will be recouped at the end of year 5 a) Prepare a spreadsheet that shows the cash flows for each year. Clearly show your work and use formulas and cell references wherever possible. b) What is the IRR of the project? c) What is the NPV of the project if the discount rate is 9.5%? d) What is your recommendation for the project accept or reject?Explanation / Answer
Working:
(a) Spreadsheet prepared andattached (b) IRR of theproject is 32% (c) NPV of the project at 9.5% discount rate is $ 704082 (d) Due to Positive NPV, project could be accepted