Corporate Finance 4 - Excel, business and finance homework help

User Generated

neas911

Business Finance

Description

See Attached

Time Deadline - 2 hours

Unformatted Attachment Preview

You need to complete this problem in a spreadsheet and show all your work. 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 is 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?
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

a)

project revenues
1500000
1575000
1653750
1736438
1823259
8288447 Revenue Total
operatin...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags