Cramer Industries has acknowledged various funding options that will become accessible over the next three years and would love you to guage these duties. They’ve requested that you simply simply use the NPV and IRR methods to seek out out if these unbiased duties are acceptable. Each of these investments will occur one yr apart and the cash flows will start one yr after the funding is made.Desk-1:ProjectCash Flows/Yr(in lots of)Measurement of ProjectCost and Date when Value is incurredA $ 2,300.005 years $ 12,00zero.00 @t=1B $ three,00zero.005 years $ 17,00zero.00 @t=2C $ 2,800.005 years $ 13,00zero.00 @t=3D $ 2,100.005 years $ 15,00zero.00 @t=4Cramer at current has 2,00zero,00zero shares glorious and pays a dividend of $2 per share.With a extreme diploma of certainty, Cramer has projected their earnings for the next four years as follows, which includes the annual cash flows from the investments chosen above:Desk-2:YearIncome After Taxes1 $6,00zero.002 $eight,00zero.003 $5,00zero.004 $7,00zero.00Questions:What is the NPV for each enterprise on the time the funding might be made? Make clear your findings.What is the IRR for each enterprise on the time the funding might be made? Make clear your findingsWhich investments have to be chosen? Justify your conclusions.What’s going to the dividends per share and the outside financing required, if the current dividend per share is maintained? Justify your conclusions.What’s going to the dividends per share and the outside financing required, if the dividend per share payout ratio of 50% is maintained? Make clear your options.If the dividend protection is taken under consideration a residual selection, what could be the dividends per share and exterior financing requirement in yearly? Make clear your options.Beneath which protection will exterior financing be minimized? Justify your conclusions.Present your analysis of the assigned points in Excel format. Enter non-numerical responses within the equivalent worksheet using textboxes.