I PROVIDED HOW TO ANSWER, ALL THE STEPS THAT NEED TO FOLLOW. JUST PLEASE DO IT IN "EXCEL" WITH TABLES, SHOW CALCULATIONS AND FORMULAS YOU USED, PLEASE AND THANK YOU SO MUCH! :)

Lawrence Production Company is bidding a 10-year contract to provide the customer with 4,000 units of product per year. Their accounting department has estimated a labor and material costs of $30 per unit. An initial capital investment of $1,000,000 is required. The equipment belongs to CCA class 43 (rate 30%). Initial net working capital of $50,000 is also needed. The firm must pay factory lease expenses of $50,000 per year. Equipment maintenance expenses are projected to be $30,000 per year. Both lease expenses and maintenance expenses are payable at the end of the year. At the end of the contract, the capital equipment can be sold for $20,000. The firm has a tax rate of 40% and a required return rate of 15%.

DO: DETERMINE THE TAX BEFORE UNIT PRICE ofLawrence should bid for this contract. Round the unit price to the nearest dollar. Show all calculations and formulas using EXCEL.

!! I have the steps here on how to do it, I just don't know how to do it:

Step 1 - list out all the costs by year

Step 2 - calculate the total after-tax cost by year

Step 3 - include initial investment, salvage value, NWC, etc. cash flows

Step 3 - add up all the cash flows year by year

Step 4 - calculate the NPV of the cash flow of all years

Step 5 - use the PV CCA tax shield formula to calculate the tax shield amount using the photo attached for formula: