P1. Note: Can use Excel for calculations, but must show procedure equations parameter values, factor value, etc. P1 (26 pt). The anticipated cash of a project has two phases "design and test" and "production". "Design and test" phase begins at the beginning of the project and ends at the end of year 2. "Production" phase begins at the beginning of year 3 and ends at the end of year 4. Disbursements and receipts are shown in the table below as: End of year Disbursements Receipts 0 2,000,000.00 0 2 100,000.00 200,000.00 3 0 3,000,000.00 4 20,000.00 2,000,000.00 1a.Draw the cash flow diagram (CFD). (2 pt) 1b.Using 10%, evaluate the whole project at the transition point as one lumpsum (end of year 2) (8 pt) 1c. What is your recommendation based on the transition point value. (2 pt.) PW (present worth ) of the