need the image download once it done. also please use spreadsheet excel and show each row line for the formula please.

The Mar KITANG Tools Shoe Show Window Help Homework Capital Budgeting and CAPM (1) Slide Show Review View Tell me C Rhest S De Homework #6: Capital Budgeting and CAPM 1. You are comparing the merits of two pieces of equipment with different life expectancies, as below. (A) (20 points) What are the net present values of A and B if they are run just once? r = 4% (B) (20)What are the net present values of A and B if they are run forever (le, replaced every 4 and 5 years respectively)? (C) (20) Which equipment would you prefer? Why? Year 5 Year 0 -$40 -$46 Year 1 $10 $11 Year 2 $12 $12 Year 3 $14 $15 Year 4 $16 $10 $12 Discount rate at 4% Equipment A (4-Yr Life) Equipment B (5-Yr Life) NPV of A = $? Equivalent Annual Cashflow NPV of B = $? Equivalent Annual Cashflow SA SA SA SA SB SB SB SB SB A SAW GV 4 MacBook Air D DD IN . 22 + ( > $ 96 & 7 .00 9 0 5 6 0 P P Q The MA 0:21 Format Arrange Tools Side Show Windo Help Home Cataludgeting and CAPM (1) Animations Slide Show Review View Time Share Convento Pictures Text Expected Rate of Return E(P) Market Portfolio 2. (40 points) You estimated the B's on 4 stock market sectors as follows: Sector A (B = -1.0) Sector B (B = 2.0) Sector CB -0.5) Sector D (B = 1.0) Please match the 4 sectors with the dots on the chart. Rs () Std Dev 2. C 1001 Aw tv MacBook Ar SON do DII 88 DD 28 re