I have only 30%, can you solve this question in excel I need same solution like it is solved I dont know how they solve PW OF BENEFITS.

5.) Consider three alternatives below based on benefit-cost ratio analysis. Each has a 5-year useful life. The MARR is 10%. You must select one project. State below why one is preferred State below also the incremental B- C ratios to 3 decimals (like 1.134 or 0.945) used to explain your answer . When stating each incremental B-C ratio, you must identify which alternatives are being compared to each other. Alternatives Alpha Beta Gamma Cost $660 $510 $210 Uniform Annual Benefit $185.3 $138.7 $58.3 Answer: Choose Alpha, AB/C of Beta-Gamma = 1.016, AB/C of Alpha-Beta = 1.178 Reasoning/Work: Alternatives Alpha Beta Gamma Beta-Gamma Alpha - Beta ($660) ($510) ($210) ($300) ($150) Uniform Annual Benefit $185.30 $138.70 $58.30 $80 $47 PW of Benefit ($702.43) ($525.78) ($221.00) ($304.78) ($176.65) Ratio B/C 1.0642921 1.030945 1.05239461 1.015930854 1.17767109 Decision B/C>1 B/C>1 B/C>1 reject Gamma select Alpha All three individually have B/C> 1. So first increment Beta-Gamma, but since B/C>1, reject lower initial cost Gamma. Then increment Alpha - Beta, and since B/C>1, select higher cost Alpha. Cost 5.) Consider three alternatives below based on benefit-cost ratio analysis. Each has a 5-year useful life. The MARR is 10%. You must select one project. State below why one is preferred State below also the incremental B- C ratios to 3 decimals (like 1.134 or 0.945) used to explain your answer . When stating each incremental B-C ratio, you must identify which alternatives are being compared to each other. Alternatives Alpha Beta Gamma Cost $660 $510 $210 Uniform Annual Benefit $185.3 $138.7 $58.3 Answer: Choose Alpha, AB/C of Beta-Gamma = 1.016, AB/C of Alpha-Beta = 1.178 Reasoning/Work: Alternatives Alpha Beta Gamma Beta-Gamma Alpha - Beta ($660) ($510) ($210) ($300) ($150) Uniform Annual Benefit $185.30 $138.70 $58.30 $80 $47 PW of Benefit ($702.43) ($525.78) ($221.00) ($304.78) ($176.65) Ratio B/C 1.0642921 1.030945 1.05239461 1.015930854 1.17767109 Decision B/C>1 B/C>1 B/C>1 reject Gamma select Alpha All three individually have B/C> 1. So first increment Beta-Gamma, but since B/C>1, reject lower initial cost Gamma. Then increment Alpha - Beta, and since B/C>1, select higher cost Alpha. Cost