Need to make a pro forma cash flow

You have been asked to evaluate the financial viability of a mining project. Here is the relevant information about the investment plan for the project: There is an Excel sheet with a template on Blackboard. Investment Plan Year o 2 4 Site Preparation Materials, imported, net of tax 400 Tariffs at 15% 60 Sales tax at 5% 20 Skilled labor 350 Ec 421: Public Finance Assignment 4 hours) Page 1 of 2 Unskilled labor 250 Equipment Imported, net of tax 600 Tariffs at 15% 90 Sales tax at 5% 30 Land 100 = Total Investment Expenditure 1,700 Financing Government equity (including grant of land) 850 Government: short-term loan 350 Foreign loan, guaranteed by foreign government 700 Here is the operating plan for the mine, which will only work for three years. Operating Plan Year o Sales 2,000 2,800 Purchases Material inputs Local 240 Sales tax at 5% Imported 600 Tariffs at 15% 90 205 Sales tax at 5% 30 35 Skilled labor Unskilled labor 50 50 Other: depreciation 500 425 Working capital (end of period) Accounts receivable 500 900 Accounts payable 350 Cash on hand 30 45 3 2,800 200 240 10 12 12 700 700 105 35 100 50 375 100 200 400 o oo 100 800 140 40 o 20 0 Use the parameter tables above to create a pro forma cash flow. [A spreadsheet file with these numbers may be You have been asked to evaluate the financial viability of a mining project. Here is the relevant information about the investment plan for the project: There is an Excel sheet with a template on Blackboard. Investment Plan Year o 2 4 Site Preparation Materials, imported, net of tax 400 Tariffs at 15% 60 Sales tax at 5% 20 Skilled labor 350 Ec 421: Public Finance Assignment 4 hours) Page 1 of 2 Unskilled labor 250 Equipment Imported, net of tax 600 Tariffs at 15% 90 Sales tax at 5% 30 Land 100 = Total Investment Expenditure 1,700 Financing Government equity (including grant of land) 850 Government: short-term loan 350 Foreign loan, guaranteed by foreign government 700 Here is the operating plan for the mine, which will only work for three years. Operating Plan Year o Sales 2,000 2,800 Purchases Material inputs Local 240 Sales tax at 5% Imported 600 Tariffs at 15% 90 205 Sales tax at 5% 30 35 Skilled labor Unskilled labor 50 50 Other: depreciation 500 425 Working capital (end of period) Accounts receivable 500 900 Accounts payable 350 Cash on hand 30 45 3 2,800 200 240 10 12 12 700 700 105 35 100 50 375 100 200 400 o oo 100 800 140 40 o 20 0 Use the parameter tables above to create a pro forma cash flow. [A spreadsheet file with these numbers may be