*PLEASE do in excel!!* Raph Inc. needs someone to supply it with 750,000 planks of wood per year to support its manufacturing needs over the next five years, and your company has decided to bid on the contract. It will cost your firm $3,000,000 to install the equipment necessary to start production. The equipment will be depreciated using the straight-line method to 0 over the project's life. The salvage value of the equipment is expected to be 0. Your fixed costs will be $1,500,000 annually, and your variable production costs are $12.5 per plank. You also need an initial investment in net working capital of $2,000,000, which will be recovered at the end of the project. The firm has a tax rate of 21%, and the required rate of return is 10%.

1a. Calculate the initial cash outflow. (Enter a negative value and Round to 2 decimals)

1b. Calculate the bid price. (Round to 3 decimals)

1c. Based on the bid price, calculate the OCF for year 1. (Round to 2 decimals)