Please list the equations in Excel to fill in the charts below. Thank you!

Bullard Company (BC) is considering expanding its range of industrial machinery products by manufacturing machine tables, saddles, machine bases, and other similar parts. Several combinations of new equipment and personnel could serve to fulfill this new function. Option 1 (M1): New machining center with three operators. Design 2 (M2): New machining center with an automatic pallet changer and two task-sharing operators. Each of these arrangements incurs different costs and revenues. The time taken to load and unload parts is reduced in the pallet-changer cases. Certainly, it cost more to acquire, install, and tool-fit pallet changer, but because the device is more efficient and versatile, it can generate larger annual revenues. Although saving on labor costs, task-sharing operators take longer to train and are more inefficient initially. As the operators become more experienced at their task and get used to collaborating with each other, it is expected that the annual benefits will increase by 13% per year over five years. Then, the revenues will be constant for five more years, completing the ten-year study period. BC has estimated the investment cost and additional revenues as in the following table. "Do nothing" is obviously an option, since BC will not undertake this expansion if none of the proposed methods is economically viable. If a method is chosen, BC expects to operate the machining center over the next ten years. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & 1 \\ \hline 1 & MARR & 12% & & & & & & & \\ \hline 2 & Life & 10 & years & & & & & & \\ \hline 3 & & M1 & M2 & & & & & & \\ \hline 4 & Investment: & & & & & & & & \\ \hline 5 & Machine tool purchase & 121,000 & 125,000 & & & & & & \\ \hline 6 & Automatic pallet changer & & 66,000 & & & & & & \\ \hline 7 & Installation & 30,000 & 42,000 & & & & & & \\ \hline 8 & Tooling expense & 58,000 & 65,000 & & & & & & \\ \hline 9 & Annual Benefits: Year 1 & & & & & & & & \\ \hline 10 & Additional revenues & 55,000 & 36,000 & & & & & & \\ \hline 11 & Direct labor savings & - & 15,300 & & & & & & \\ \hline 12 & Setup/changeover savings & - & 4,700 & & & & & & \\ \hline 13 & Years 2-10 revenues & Constant & Growth: 13%,5 years & & & & & & \\ \hline 14 & Annual maintenance cost & 3,500 & 5,000 & & & & & & \\ \hline 15 & Salvage value in year 10 & 25,000 & 40,000 & & & & & & \\ \hline 16 & & & & & & & & & \\ \hline 17 & & & & & & & & & \\ \hline 18 & Design 1 & & & & & Design 2 & & & \\ \hline 19 & Year & Inflows & Outflows & Net CF & & Year & Inflows & Outflows & Net CF \\ \hline 20 & 0 & 0 & 209,000 & $209,000.00 & & 0 & 0 & 298,000 & $298,000.000 \\ \hline 21 & 1 & & & & & 1 & & & \\ \hline 22 & 2 & & & & & 2 & & & \\ \hline 23 & 3 & & & & & 3 & & & \\ \hline 24 & 4 & & & & & 4 & & & \\ \hline 25 & 5 & & & & & 5 & & & \\ \hline 26 & 6 & & & & & 6 & & & \\ \hline 27 & 7 & & & & & 7 & & & \\ \hline 28 & 8 & & & & & 8 & & & \\ \hline 29 & 9 & & & & & 9 & & & \\ \hline 30 & 10 & & & & & 10 & & & \\ \hline 31 & & & & & & & & & \\ \hline 32 & Loan Amortization Schedule & & & & & & & & \\ \hline 33 & Year & Interest Paid & Principal Paid & Ending Balance & & & & & \\ \hline 34 & 1 & & & & & & & & \\ \hline 35 & 2 & & & & & & & & \\ \hline 36 & 3 & & & & & & & & \\ \hline 37 & 4 & & & & & & & & \\ \hline 38 & 5 & & & & & & & & \\ \hline 39 & 6 & & & & & & & & \\ \hline 40 & 7 & & & & & & & & \\ \hline 41 & 8 & & & & & & & & \\ \hline 42 & 9 & & & & & & & & \\ \hline 43 & 10 & & & & & & & & \\ \hline 44 & & & & & & & & & \\ \hline \end{tabular} Questions a) Compute the NPW and IRR for both options at MARR =12%. b) Based on the metrics computed in question a, which option would be selected? c) BC is considering financing 40% of the project's initial investment at an interest rate of 9% compounded monthly. If BC pays annual installments and the required repayment period is 10 years, determine the loan amortization schedule. Note: use the project selected in question a. Bullard Company (BC) is considering expanding its range of industrial machinery products by manufacturing machine tables, saddles, machine bases, and other similar parts. Several combinations of new equipment and personnel could serve to fulfill this new function. Option 1 (M1): New machining center with three operators. Design 2 (M2): New machining center with an automatic pallet changer and two task-sharing operators. Each of these arrangements incurs different costs and revenues. The time taken to load and unload parts is reduced in the pallet-changer cases. Certainly, it cost more to acquire, install, and tool-fit pallet changer, but because the device is more efficient and versatile, it can generate larger annual revenues. Although saving on labor costs, task-sharing operators take longer to train and are more inefficient initially. As the operators become more experienced at their task and get used to collaborating with each other, it is expected that the annual benefits will increase by 13% per year over five years. Then, the revenues will be constant for five more years, completing the ten-year study period. BC has estimated the investment cost and additional revenues as in the following table. "Do nothing" is obviously an option, since BC will not undertake this expansion if none of the proposed methods is economically viable. If a method is chosen, BC expects to operate the machining center over the next ten years. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & I \\ \hline 1 & MARR & 12% & & & & & & & \\ \hline 2 & Life & 10 & years & & & & & & \\ \hline 3 & & M1 & M2 & & & & & & \\ \hline 4 & Investment: & & & & & & & & \\ \hline 5 & Machine tool purchase & 121,000 & 125,000 & & & & & & \\ \hline 6 & Automatic pallet changer & & 66,000 & & & & & & \\ \hline 7 & Installation & 30,000 & 42,000 & & & & & & \\ \hline 8 & Tooling expense & 58,000 & 65,000 & & & & & & \\ \hline 9 & Annual Benefits: Year 1 & & & & & & & & \\ \hline 10 & Additional revenues & 55,000 & 36,000 & & & & & & \\ \hline 11 & Direct labor savings & - & 15,300 & & & & & & \\ \hline 12 & Setup/changeover savings & - & 4,700 & & & & & & \\ \hline 13 & Years 2-10 revenues & Constant & Growth: 13%,5 years & & & & & & \\ \hline 14 & Annual maintenance cost & 3,500 & 5,000 & & & & & & \\ \hline 15 & Salvage value in year 10 & 25,000 & 40,000 & & & & & & \\ \hline 16 & & & & & & & & & \\ \hline 17 & & & & & & & & & \\ \hline 18 & Design 1 & & & & & Design 2 & & & \\ \hline 19 & Year & Inflows & Outflows & Net CF & & Year & Inflows & Outflows & Net CF \\ \hline 20 & 0 & & & & & 0 & & & \\ \hline 21 & 1 & & & & & 1 & & & \\ \hline 22 & 2 & & & & & 2 & & & \\ \hline 23 & 3 & & & & & 3 & & & \\ \hline 24 & 4 & & & & & 4 & & & \\ \hline 25 & 5 & & & & & 5 & & & \\ \hline 26 & 6 & & & & & 6 & & & \\ \hline 27 & 7 & & & & & 7 & & & \\ \hline 28 & 8 & & & & & 8 & & & \\ \hline 29 & 9 & & & & & 9 & & & \\ \hline 30 & 10 & & & & & 10 & & & \\ \hline 31 & & & & & & & & & \\ \hline 32 & Loan Amortization Schedule & & & & & & & & \\ \hline 33 & Year & Interest Paid & Principal Paid & Ending Balance & & & & & \\ \hline 34 & 1 & & & & & & & & \\ \hline 35 & 2 & & & & & & & & \\ \hline 36 & 3 & & & & & & & & \\ \hline 37 & 4 & & & & & & & & \\ \hline 38 & 5 & & & & & & & & \\ \hline 39 & 6 & & & & & & & & \\ \hline 40 & 7 & & & & & & & & \\ \hline 41 & 8 & & & & & & & & \\ \hline 42 & 9 & & & & & & & & \\ \hline 43 & 10 & & & & & & & & \\ \hline 44 & & & & & & & & & \\ \hline \end{tabular} Questions a) Compute the NPW and IRR for both options at MARR =12%. b) Based on the metrics computed in question a, which option would be selected? c) BC is considering financing 40% of the project's initial investment at an interest rate of 9% compounded monthly. If BC pays annual installments and the required repayment period is 10 years, determine the loan amortization schedule. Note: use the project selected in question a