Please answer the question in a spreadsheet, word document, or scanned image that shows your work. (Just like the capital budgeting problem on the midterm). Be sure to address all three parts clearly. Peter is the CEO of an agriculture products retailer. He is considering the purchase of a new software system to help with his new online retail venture. The software will cost $650,000, and will be depreciated straight-line over five years (to zero). Peter does not think the software will be viable after 4 years, however, because the developer will no longer support the product. Even worse, he thinks he will need to pay a programmer $10,000 at the end of year 4 to get rid of the software at that time. The software will have several effects if it is installed. First, it will reduce overhead expense by $20,000 per year due to savings in hardware needs. Second, it will reduce labor expenses for custom programming by $100,000 per year. Lastly, due to its sophisticated inventory management system, it will allow Peter to permanently reduce inventory by $200,000 when he buys the software. The company has a target debt/equity ratio of 0.3 which they plan to maintain after adoption of the new software. Its current equity beta is 1.1. Peter plans on paying for the project out of cash raised from a new bank loan with an 7% interest rate (its marginal pre-tax cost of debt). Assume that the risk-free rate is 4%, the market risk premium is 7%, and all firms face a marginal tax rate of 30%.

1. What are the cash flows for the project for each year?
2. What discount rate should the firm use for the project?
3. Should Peter accept the project? Why or why not?

Answer rating: 100% (QA)

Here is the analysis of the software project in a spreadsheet format Spreadsheet Imagehttpsiimgurcom... View the full answer