Calculate the Payback Period, Internal Rate of Return, Net Present Value, and Modified IRR and Discounted PBP for both of the two mutually exclusive projects listed below. Both projects are new projects. Use Excel to complete this problem. You must use formulas where appropriate. Answers are values only in Excel.

Lemon Juice Project A: Project will take $260,000 expenditure to start today; generate cash inflows for the next 4 years of $30,000, 100,000, $150,000 and $50,000 with a WACC=10%. Lemon Juice Project B: Project will take $300,000 expenditure to start today; generate cash inflows for the next 4 years of $95,000 per year with a WACC=10%.