HelloThere are 4 questions I need answered the main thing I need is the spreadsheet set up with the accompanying average demand senario and sensitivity analysis. I will do the written report with the with the analysis.2) What is the projects cost of
HelloThere are 4 questions I need answered the main thing I need is the spreadsheet set up with the accompanying average demand senario and sensitivity analysis. I will do the written report with the with the analysis.2) What is the projects cost of equity? What is the appropriate discount factor touse for evaluating the refrigerator project?4) Forecast the projects cash flows for the next twenty years. What assumptions didyou use?5) Use the appropriate capital budgeting techniques to evaluate the project.6) Use the average demand scenario to evaluate the sensitivity of the projects NPVwith respect to sale price of the refrigerator and the cost of the compressor.I saw these same questions already asked earlier so i am hoping someone has already done the ground work.The requirements of information i need for the spreadsheet are attached. thank you pursemaven