You must use Excel for this problem. Six Bridges Electronics Corporation (SBE) is considering expanding its production capacity by purchasing a new machine, the IMAGE-EX 10000. If purchased today, the machine will not be operational until a year from now, and its installation will disrupt current production.: a. SBE just completed a $250,000 feasibility study to analyze the decision to buy the IMAGE-EX 1000, resulting in the estimates detailed below. b. The IMAGE-EX 1000 will cost $4.15 million. The purchase price must be paid today. c. Installation costs for the IMAGE-EX 1000 are estimated to be $550,000, will be paid upon completion of its installation, and included in its depreciable cost. d. The IMAGE-EX 1000 will be placed and operated in a fully depreciated building SBE already owns. The building had cost $3.5 million, and has a current market value of $1.75 million. SBE has a 4-year agreement to lease the building to Imagine Corporation for $225,000 per year, but can cancel the lease agreement by paying a fee of $500,000 today. SBE planned to sell the building at the end of the 4-year lease term. Note: The current market price of something is its "present value!" e. Once in operation, the IMAGE-EX 1000's expanded capacity is expected to generate $15.5 million per year in additional sales in each of it 5 years of operation. f. The disruption caused by the IMAGE-EX 1000's installation will decrease sales by $4.25 million this year. g. As with SBE's existing process, the cost of goods sold for the products produced by the IMAGE-EX 1000 is expected to be 50% of their sales price. h. The IMAGE-EX 1000's increased production will require SBE to maintain increased raw materials and finished goods inventory on hand of $1.8 million once production begins. i. The IMAGE-EX 1000 is 5-year MACRS property, and SBE will begin depreciating it once it is operational. The depreciation rates for 5-year MACRS property are as follows: j. When operating, the IMAGE-EX 1000 will require additional sales and administrative personnel at a cost of $2.25 million per year. k. When production begins a year from now, SBE expects receivables from the new sales to be 20% of revenues and payables related to inventories to be 12% of cost of goods sold. 1. SBE expects to salvage the IMAGE-EX 1000 for $1,250,000 at the end of the project. m. SBE's corporate tax rate is 22.0%, and its cost of capital for this project is 12.5%. 5 uired: A. What are the periodic net cash flows related to each of the items above? B. What is the IMAGE-EX 1000 project's net present value? C. What is the MAGE-EX 1000 project's breakeven net present value annual sales revenue? D. What is the MAGE-EX 1000 project's breakeven net present value annual cost of goods sold percentage