Purpose of Assignment The design of this assignment is to confess the students to behove well-acquainted delay and usage the size of Net Present Esteem (NPV), payback, and Weighted Average Cost of Capital (WACC) using Microsoft® Excel®. Assignment Steps Resources: Microsoft® Excel®, Capital Budgeting Decision Models Template Consider the subjoined problems using Microsoft® Excel®:Calculate the NPV for each scheme and individualize which scheme should be received. Scheme AProject BProject CProject DInital Outlay(105,000.000)(99,000.00)(110,000.00)(85,000.00)Instream year 153,000.0051,000.0025,000.0045,000.00Instream year 250,000.0047,000.0055,000.0050,000.00Instream year 348,000.0041,000.0015,000.0030,000.00Instream year 430,000.0052,000.0021,000.0062,000.00Instream year 535,000.0040,000.0035,000.0068,000.00Rate7%10%13%18%Your association is because three stubborn schemes. Given the subjoined money stream advice, consider the payback epoch for each. If your association requires a three-year payback anteriorly an boarding can be received, which scheme(s) would be received? Scheme DProject EProject FCost205,000.00179,000.00110,000.00Instream year 153,000.0051,000.0025,000.00Instream year 250,000.0087,000.0055,000.00Instream year 348,000.0041,000.0021,000.00Instream year 430,000.0052,000.009,000.00Instream year 524,000.0040,000.0035,000.00Using market esteem and magnitude esteem (separately), experience the adjusted WACC, using 30% tax trounce.ComponentBalance Sheet ValueMarket ValueCost of CapitalDebt5,000,000.006,850,000.008%Preferred Stock4,000,000.002,200,00.0010%Common Stock2,000,000.005,600,000.0013%Click the Assignment Files tab to acquiesce your assignment.