PLEASE USE EXCEL AND SHOW FORMULAS\

PLEASE USE EXCEL AND SHOW FORMULAS

PLEASE USE EXCEL AND SHOW FORMULAS

PLEASE USE EXCEL AND SHOW FORMULAS

PROBLEM 2: Given the following data, estimate the after tax cash flows for the Project for each year including year 'O'. Calculate the NPV for the project Michigan Solar Panel Manufacturing Company Cost of Equipment $10,000,000 Installation Charge $800,000 Life in Years 3 Use Straight Line Depreciation Price / Unit $145 Annual Sales 150,000 Units Variable Cos/ Unit $45 Annual Fixed Costs $1,000,000 Salvage Value $900,000 WACC = 10.5% Tax Rate = 20%