Please, I need help to fill out these tables.

PHULUL HUN SCHEDULE Year: 0 6 THE IMPACT OF PRODUCTION SCHEDULING ON CASHFLOW ANALYSIS INITIAL CAPITAL INVESTMENT ($): 80,000,000+(1+team#) x 100,000 FIXED COST/year, $: 7,000,000+(1+team#) x 10,000 VARIABLE COST/tonne, $: 80 REVENUE/tonne, $ 150 OREBODY SIZE (tonnes): 6,000,000 Discount rate, real $, %: 10% real (constant $) Inflation Rate, %: 6% constant for all years Taxation rate, %: 39% Depreciation of capital cost on a straight line basis, assuming an individual project basis for taxation CASHFLOW ANALYSIS #1 PRODUCTION RATE (tonne/yr) 1000000 1000000 1000000 1000000 1000000 1000000 1 2 3 4 5 Revenue, $: Fixed costs, $: Variable costs, $: Net operating income, $: CCA, S: Consider inflation in your cash flow analyses #1 & #2, Taxable revenue, $: applicable to costs only. Annual revenues are not Taxes, $: affected by inflation After-tax profit, $: Cash flow(current), $: All $ are Canadian Cash flow constant), S: Cumulative cash flow, $: NPV, $: Operating clelays resulting n: IRR, %: 70% increase of fixed costs in years 5,6,7,8 CASHFLOW ANALYSIS #2 50% reduction in production after the 4th year PRODUCTION RATE (tonne/yr) 1,000000 1,0000001,0000001,000000 500,000 500,000 500,000 500,000 Year: 1 2 3 5 6 7 8 Revenue, S: Fixed costs, $: Variable costs, $: Net operating income, $: CCA, S: Taxable revenue, $: Taxes, S: After-tax profit, $: Cashflow(current), $: Cashflow(constant) Cumulative cash flow, $: NPV, $: IRR, % EXPECT DELAYS 0 4 DELAYED PHULUL HUN SCHEDULE Year: 0 6 THE IMPACT OF PRODUCTION SCHEDULING ON CASHFLOW ANALYSIS INITIAL CAPITAL INVESTMENT ($): 80,000,000+(1+team#) x 100,000 FIXED COST/year, $: 7,000,000+(1+team#) x 10,000 VARIABLE COST/tonne, $: 80 REVENUE/tonne, $ 150 OREBODY SIZE (tonnes): 6,000,000 Discount rate, real $, %: 10% real (constant $) Inflation Rate, %: 6% constant for all years Taxation rate, %: 39% Depreciation of capital cost on a straight line basis, assuming an individual project basis for taxation CASHFLOW ANALYSIS #1 PRODUCTION RATE (tonne/yr) 1000000 1000000 1000000 1000000 1000000 1000000 1 2 3 4 5 Revenue, $: Fixed costs, $: Variable costs, $: Net operating income, $: CCA, S: Consider inflation in your cash flow analyses #1 & #2, Taxable revenue, $: applicable to costs only. Annual revenues are not Taxes, $: affected by inflation After-tax profit, $: Cash flow(current), $: All $ are Canadian Cash flow constant), S: Cumulative cash flow, $: NPV, $: Operating clelays resulting n: IRR, %: 70% increase of fixed costs in years 5,6,7,8 CASHFLOW ANALYSIS #2 50% reduction in production after the 4th year PRODUCTION RATE (tonne/yr) 1,000000 1,0000001,0000001,000000 500,000 500,000 500,000 500,000 Year: 1 2 3 5 6 7 8 Revenue, S: Fixed costs, $: Variable costs, $: Net operating income, $: CCA, S: Taxable revenue, $: Taxes, S: After-tax profit, $: Cashflow(current), $: Cashflow(constant) Cumulative cash flow, $: NPV, $: IRR, % EXPECT DELAYS 0 4 DELAYED