Briefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it. 4.1 Cash flows Provide an Excel spreadsheet screenshot that shows how you arrive at the net cash flows for each period in your planning horizon and describe its highlights. 4.2 NPV Analysis Provide a screenshot of your Excel NPV analysis here, and describe its highlights. 4.3 Rate of Return Provide a screenshot of your IRR and accounting rate of return calculations here, and explain the highlights. 4.4 Payback Period Provide a screenshot of your Excel calculation of the payback period for this venture. Project with uneven cash flows
Year	Metric	0	1	2	3	4	5
ARR accounting rate of return
Enter total annual sales years 1 to 5 from for your course project company's Week 2 Five Year Sales Forecast			100,000	120,000	144,000	230,400	414,720
Calculate net operating cash flows years 1 to 5 (assume = 35% sales).	35.0%
Enter straight line annual depreciation years 1 to 5 = (initial investment - salvage value)/5. See cells C20 and H21. Enter the amount of the annual depreciation expense as a positive $ amount.