2. Company B:

Excel sheet assignment: Excel sheet assignment: : Review Cash flow statement as in attachment.

Instructions: Need NVP, IRR, NVP Vs IRR in excel sheet

1. Use a required rate of return (hurdle rate) of 8% for the discounting of the future cash flows.

2. An Excel spreadsheet that analyzes the proposals from two vendors using the net present value (NPV) discounted cash flow model. Use Excel's =NPV( ) -costs function to determine which proposal is more financially acceptable. The final part of your assignment will include your justification of why your group's analysis using the NPV method suggests selecting one proposal over the other.

3. Use a required rate of return (hurdle rate) of 8% for the discounting of the future cash flows.