Can you please help me in parts a and b? Thank you

- x Acrobat Pro DC Ow Help project fall 2020.pdf x Subscribe 1 /2 149% 1. Discounted Cash Flow (DCF) analysis (weight: 40% = 10%+10%+10%+10%) For each of the two production schedules calculate and show: (a) The after tax cash flows in constant $ (create bar charts with the cumulative cash flows); (b) The payback period - based on after tax cash flows (show your calculation); (c) The NPV and the IRR of the two investment alternatives using the Excel formulae; (d) Describe & discuss the impact of operating delays using your DCF analysis. 0 -2004 Ta con 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 - x Acrobat Pro DC Ow Help project fall 2020.pdf x Subscribe 1 /2 149% 1. Discounted Cash Flow (DCF) analysis (weight: 40% = 10%+10%+10%+10%) For each of the two production schedules calculate and show: (a) The after tax cash flows in constant $ (create bar charts with the cumulative cash flows); (b) The payback period - based on after tax cash flows (show your calculation); (c) The NPV and the IRR of the two investment alternatives using the Excel formulae; (d) Describe & discuss the impact of operating delays using your DCF analysis. 0 -2004 Ta con 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