Proforma Financial Statement Worksheet

Calculate the NPV, IRR, and discounted payback period for the electric cars and solar generator projects. Use the nominal approach. Using Excel’s Data Table feature, determine the change in NPV for each project if the actual RRR was 5.0% lower or 5.0% higher than the rate specified rate in intervals of 1.0%. Which project(s) should Magnum pursue? ................
................