Excel Online Structured Activity: Break-even Point

Schweser Satellites Inc. produces satellite earth stations that sell for $95,000 each. The firm's fixed costs, F, are $2 million, 50 earth stations are produced and sold each year, profits total $400,000; and the firm's assets (all equity financed) are $6 million. The firm estimates that it can change its production process, adding $4.5 million to investment and $540,000 to fixed operating costs. This change will (1) reduce variable costs per unit by $9,000 and (2) increase output by 21 units, but (3) the sales price on all units will have to be lowered to $90,000 to permit sales of the additional output. The firm has tax loss carry forwards that render its tax rate zero, its cost of equity is 16%, and it uses no debt.

Spreadsheet and question has been copied and uploaded to google docs and I am unable to upload files here.

https://drive.google.com/file/d/1dmaGybSvi7Ew4CYC01ndfnRZ1QVNyZns/view?usp=sharing