Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 rejectStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started