Using a computer-based spreadsheet, create a cash flow statement to capture the anticipated cash flow in the case study below. Ensure that the spreadsheet created includes separate columns for each month and that the figures presented are entered appropriately. Assuming that no other external or internal income is available, develop a financing scenario that will cover cash flow requirements and also optimize the amount of income by the close of the transaction. A Canadian company, Canuck Pure Water Inc., has obtained a contract from Agua Pura S.A. of Chile to install a new bottling line in its old plant in Santiago. Canuck is to supply the equipment, the engineering, the technical and administrative staff, and the computer equipment and software. It will employ local labourers in Chile for the plant construction. The value of this sales contract between Agua Pura S.A. of Chile and Canuck Pure Water Inc. is USD 1 million. To execute the contract, Canuck is subcontracting to a supplier in Boston, Massachusetts, for the provision of the machinery, equipment and computer hardware and software that will be needed. These items will be purchased from the supplier in Boston for USD 600,000 and produced/assembled over a three month timeframe. All the equipment purchased from the firm in Boston will be shipped from New York to Santiago, Chile, by maritime cargo. This will reduce delays and costs. Canuck will assume all charges for freight, loading, unloading, packing and maritime insurance. All project-related salaries as well as the travel and expenses of the staff and workers involved in the project will be paid in U.S. dollars. The following facts and additional figures related to this contract are available: The sales contract with Agua Pura S.A. stipulates that an advance of 10 percent to cover start-up costs will be paid when the contract is signed. The sales contract with Agua Pura S.A. and the equipment contract with the Boston supplier were both signed and confirmed at the beginning of March, with the project to be completed by the end August If the overall work schedule is complied with, Agua Pura S.A. will pay USD 300,000 on May 1, USD 500,000 on August 30, and USD 100,000 ninety days after the completion date. The equipment contract with the Boston supplier calls for a down payment of 25 percent when the order is confirmed at the beginning of March, 60 percent on April 1, and the remaining portion on May 31 when the equipment is ready for shipment. Additional figures (in USD): Canuck Pure Water Inc. has a bank account balance of $100,000 at the end of February (i.e. before the project begins). The freight costs to ship the equipment from Boston to Santiago DDP total $25,000, which is payable on loadingestimated to be in first week of June. Packing costs are $2,000; these are payable in May. Loading and unloading will cost $1,000; these charges will be paid in May. Shipping insurance: 1.5 percent of the $600,000 contract (half payable in March, the other half in April). The bank fees for setting up a line of credit for the firm will be $5,000 (payable in the month when the loan agreement with the bank is signed). Interest on any funds used will be 12 percent per annum (or simply 1 percent per month, calculated monthly on the line of credit balance at month endpayable in the following month). Project-related salary expenses total $30,000 per month, payable monthly in March, April, May, June, July and August. Travel and expenses are $40,000, which is payable in May, in advance of the travel.