Please put the calculations/ formulas on a separate ss aswell, thank you!

Complete on an EXCEL spreadsheet and submit to HUSKYCT. 1. The Loviscek Co. is considering the purchase of a new machine. Financial projections for the investment are provided below. 1 2 0 150,000 Year Cost of New Machine Revenues Variable Costs Fixed Costs Depreciation Net Working Capital 200,000 100,000 50,000 25,000 25,000 250,000 115,000 50,000 25,000 30,000 20,000 After Year 2 cash flows will grow at a constant rate of 3% forever. The company discounts all cash flows at 10% and has a marginal tax rate of 20%. What is the Net Present Value of the project? Complete on an EXCEL spreadsheet and submit to HUSKYCT. 1. The Loviscek Co. is considering the purchase of a new machine. Financial projections for the investment are provided below. 1 2 0 150,000 Year Cost of New Machine Revenues Variable Costs Fixed Costs Depreciation Net Working Capital 200,000 100,000 50,000 25,000 25,000 250,000 115,000 50,000 25,000 30,000 20,000 After Year 2 cash flows will grow at a constant rate of 3% forever. The company discounts all cash flows at 10% and has a marginal tax rate of 20%. What is the Net Present Value of the project