please answer correctly on excel and show the working formula on excel

The Case.- This case illustrates a new expansion project of an IT company {luv-Tech} where the company intend to invest to increase it sales and market share. Assume w-Tedi's research and development department has been applying its expertise in micro-processor technology to develop a small computer designed to control home appliances. Once programmed. the computer will automatically control the heating and air-conditioning systems, security system, hot water heater. and even small appliances such as coffeemaker. By increasing the home's energy efciency, the computer can cut costs enough to pay for itseif within a few years. Development has reached the stage where a decision must be made about whether to go forward with full-scale production. 1till-Tech believes that if the new project goes in operation, the annual sales would be 25,000 units if the units were priced at $2,500 each. so annual sales are estimated 562,500,000. W-Tech expects no growth in unit sales, and it believes that the unit price will rise by 3% each year. The engineering department has reported that the project will require additional manufacturing space, and WTech currently has an option to purchase an existing building, at a cost of $12,000,000, that would meet this need. The building would be bought and paid for on December 31, 2021. The building fall into ERA Common Asset Class 1 {4% ratej for ECA purposes. The necessary eduipment would be purchased and installed in late 2021, and it would be paid for on December 31. 2021. The equipment falls into ERA Class 43 {30% rate] for ECA calculation. The equipment would cost $6,800,000 and would require $200,000 for shipping and installation. CCA may be claimed on the purchase price of an asset plus any shipping and installation costs. The project's estimated economic life is 4 years. At the end of that time, the building is expected to have a resale value of $10,000,000. The equipment will have a salvage value of $1,300,000. The production department has estimated that variable manufacturing costs would be $1,800 per unit and that xed overhead costs would be $3,000,000 a year. They expect variable costs to rise by 296 per year and fixed costs to rise by 1% per year. WTech's tax rate is 3096. For capital budgeting purposes, the company's policy is to assume that operating cash flows occur at the end of each year. Assume that W- Tech must have an amount of net operating working capital [NOWC] on hand equal to 10% of the upcoming year's sales. Because the plant would begin operations on January 1, 2022, the first full year of operating cash flows would end on December 31. 2022. WTech is a large company who has multiple products; so, if the new project does not work out, it will not bankrupt the company. If the project is accepted, the company will be contractually obligated to operate it for its full 4-year life. Returns on this project would be positively correlated with returns on WTech's other projects and also with the stock market. Assume that you have been assigned to conduct the capital budgeting analysis. Assume that the project has the same risk as an average project and use the corporate weighted average cost of capital 12%. Using the above information answer the following questions. . Calculate for W-Tech's Capital Cost Allowance jCCA) for the years 2U22, 2023, 2C24 and 225 using the following schedule. Explain if you haye used a half-year ora full-year rule of CRA for CCA calculation. ll'ear Building Equipment *UCC = undepreciated capital cost 2. Calculate Project's operating income before tax {EBITJ over the Project's life. 3. Calculate Project's the operating cash flows over the Project's life. 4. Find Project's net cash flow over the project's life. What is project's initial costs? 5. Draw a timeline for this project showing all cash flows and the cost of capital. 6. What is your appraisal forthe proposed project? Answer this question based on Net Present Value (NW), Internal Rate of Return (IRRL Modified IRR [MIRRL and PI criteria. 2. Finally make a decision based on NW, IRR, MIRR and PI criteria whether you would propose w-Tech to accept or reject the new project. Explain why haye you made this decision? [Hint You should follow \"The Analysis of an Expansion Project" in pages 333-341 at your tektbook. Construct similar tables like Tables 11-4 Part 1, Part 2, Part 3. and Part 4.]