please complete the 2 charts: cash flow over projects #1' life; and capital budgeting calculations product #1.

NOTE: Cells shaded in YELLOW are the cells you must provide the calculations. NOTE: Cells shaded in RED are the cells that will automatically calculate. CASH FLOWS OVER PROJECT #1's LIFE = Target Rate of Return = WACC = 22.243% Auto Transferred from your WACC worksheet Net Cash Flows each year 2 Year Number 0 1 3 4 2. YEAR 2021 2022 2023 2024 2025 CAPITAL PRODUCT #1 -$6,185,800 $1,876,800 $2,165,100 $2,923,000 $3,741,400 -$6,185,800 Cumulative cash flows (See Problem 5-1) $0 $0 $0 $0 + Discounted cash flows (See Problems 5-3 (Part a) & 5-4 (Part b)) -$6,185,800 $0 $0 $0 $0 Cumulative discounted cash flows (See blems 5-3 (Part a) & 5-4 (Part b)) -$6,185,800 $0 $0 $0 $0 3 18 8 CAPITAL BUDGETING CALCULATIONS PRODUCT #1 19 CALCULATE ANALYSIS: ACCEPTABLE or UNACCEPTABLE? 20 Net Present Value (NPV) (See Problems 5-11 (Part c) & 5-12 (Part b)) $0 21 Internal Rate of Return (IRR) (See Problems 5-5 & 5-6) 0.00% 22 Profitability Index (PI) (See Problem 5-8) 0.000 23 Modified Internal Rate of Return (MIRR) (using the COMBINATION APPROACH) 24 (See Problem 5-20) 0.00% Reir bot Payback Period (PP) (See Problem 5-1) 0.00 25 Discounted Payback period (DPP) (See Problems 5-3 (Part a) & 5-4 (Part b)) 0.00 26