hem smat for were she al need rour help to evaluane these projects: CAPITAL PROJECT 1 - Global Marufacturing is consibering exounding is production of very suocessful model LD1100 Banic Desk. Lamp. CAPITAL PROUECT 2 - Global Marufacturing's LED lofting ditsicn has propoed manufacturing and seling a new line of LED Cimmakie Desk Lamp. lamps. CANTAL PRovECT 4 - Clobal Marufacturng is comiseng probaing the components of its LED Cesk Lanp and sell al a dighty higher price. discourted papback perot, ret present valis (NPV), rternal rate of rebum (FFr), and the profitabilify index (PI). she knes that the CFo liked all proiects te parback within i rears. Ansther consiraint that she mut deal sib is that the CEO and fie Board of Directors are folowing the Bustainable. Gowth approdach which does not alow the frm to issie new common stook or alow the firm to exceed is current deta which is shom on your CASF STUDV DATA SHFET. Capital Budgeting Calculations You will find the Cash Flow estimates for each of the four projects and the Target Rate of Return for 2023 devaloped by the Finance Deparimert on the CAFIAL BUDesise worksheet. Usa this informatian to complete the folowing cakulations. For Captal Projects 1,2,3, and 4 do the following: 1) CALCULATE: Cumulative Cash Flows (Do nos, indude the dolir sign (\$). Nognt ve amounts mast be 2) CALCULATE: Discounted Cash Flows (Do not include te colar sign (5). Nhogtive amouns must be inakated by a minus sizn to be corsidered correct. Round your arswer to the nearest whole do lar. (e g, 3,215)] 3) CALCULATE: Cumulative Discounted Cash Flows (Do not instude the dolar bign (\$). Negstise dolar. [e.g, 3,216i). 4) CALCULATE: Not Present Value (NPV) (Do not induce tho dol br sign (5). Necative amsunts mast be evaluate esch project busod on your findings and determine if each propest is siner ACCEPTABLE or NOT ACCFPTAPLF based on NPV accoptance crilerion. 5) CALCULATE: Internal Rate of Return (IRR) (Do not include the parcene sign (S). Round your anewer 152 decimal places. (e g., 32 15) eveluate aech project basad en your findings and determise if each propest is effer ACCEPTABLE NOT ACCEPTABLE based on IRR acceptanoe criberion. 6) CALCULATE: Modified Internal Rate of Return (MIRR) using the combination approsch only. evaluate esch project bassd on your findings and determine if each propect is sifer ACCEPTABLE or NOT ACCEPTABLE based on MIRR acosptance citterion. eveusts eoch proiect bssod on your findings and dotermive if eash pro,est is sifer ACCEPTABLE or NOT ACCEPTABLE based on Pl accoptaroe criarion. coour in 4 years miler 0.00 for NO PAYBACXK) ACCEPTABLE or NOT ACCEPTABLE tased on Paytseck Period acceptence criterion. (Fiemember, for the Diseounted Payback Peried ewaliale aach projoct based on your findings and dotermine if each project is elther ACCEPTABLE or NOT ACCEPTAELE based on Disosurted Payback Poriod soceptance criturion. CAPITAL BUDGETING ANALYSIS Recap of Each Project's Net Cash Flows and Net Present Value (NPV) From Your Calculations \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Yoar Number } & \multicolumn{5}{|c|}{ Cash Flows At End of Year } & \\ \hline & 0 & 1 & 2 & 3 & 4 & \\ \hline YEAR & 2022 & 2023 & 2024 & 2025 & 2026 & NPV \\ \hline CAPITAL PROJECT \#1 & $1,461,200 & $421,100 & $484,300 & $650,300 & $819,500 & $0 \\ \hline CAPITAL PROJECT \#2 & $1,263,900 & $244,900 & $328,300 & $435,900 & $513,500 & $0 \\ \hline CAPITAL PROJECT \#3 & $1,581,500 & $489,300 & $496,700 & $451,100 & $1,123,100 & $0 \\ \hline CAPITAL PROJECT \#4 & $1,593,800 & $416,900 & $455,500 & $695,100 & $1,106,400 & $0 \\ \hline \end{tabular} Capital Budgeting Analysis decifo which combirst on of these four IMDCPCNICCNT projects ses soceptablo for Globsi Mansfacturing. Inc. based on the MPV criverion: Which ove of fores protect cort bins Which QNE of trese Manulacturing? orporate value to increase? Part 1): Identify all project combinations that are ACCEPTABLE for Global Manufacturing based on the NPV acceptance criterion. (You may not need all the spaces provided.) \begin{tabular}{|c|c|c|c|c|c|c|} \hline & \multicolumn{5}{|c|}{ Cumulative Project Cash Flows At End of Year } & \multirow[b]{2}{*}{\begin{tabular}{c} NET \\ PRESENT \\ VALUE (NPV) \\ \end{tabular}} \\ \hline & Project Cost 2022 & 2023 & 2024 & 2025 & 2026 & \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Part 2): Since Global's management has imposes a Capital Budget Constraint (called Capital Rationing) you must now select those project combinations from Part (1) that DO NOT cost more than the Capital Budget Constraint shown below. (You may not need all the spaces provided.) \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[t]{2}{*}{ Capital Budget Constrai } & \multicolumn{2}{|c|}{$3,964,900.00} & & & & \\ \hline & \multicolumn{5}{|c|}{ Cumulative Project Cash Flows At End of Year } & \\ \hline & \begin{tabular}{c} Project Cost 2022 \\ Cannot Exceed \\ $3,964,900 \\ \end{tabular} & 2023 & 2024 & 2025 & 2026 & \begin{tabular}{c} NET PRESENT \\ VALUE (NPV) \end{tabular} \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Part 3): Which ONE of these AFFORDABLE project combinations identified in Part (2) above will MAXIMIZE the corporate value of Global Manufacturing? \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{\begin{tabular}{l} SINGLE AFFORDABLE PROJECT COMBINATION \\ THAT WILL MAXIMIZE CORPORATE VALUE \end{tabular}} & \multicolumn{5}{|c|}{ Cumulative Project Cash Flews At End of Year } & \multirow[b]{2}{*}{\begin{tabular}{c} NET \\ PRESENT \\ VALUE (NPV) \\ \end{tabular}} \\ \hline & \begin{tabular}{c} Project Cost 2022 \\ Cannot Exceed \\ $3,964,900 \\ \end{tabular} & 2023 & 2024 & 2025 & 2026 & \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Part 4): If this maximizing project combination selected Part (3) were implemented how much could the firm expect its corporate value to increase? Expected Increase in Corporate Value ($)= hem smat for were she al need rour help to evaluane these projects: CAPITAL PROJECT 1 - Global Marufacturing is consibering exounding is production of very suocessful model LD1100 Banic Desk. Lamp. CAPITAL PROUECT 2 - Global Marufacturing's LED lofting ditsicn has propoed manufacturing and seling a new line of LED Cimmakie Desk Lamp. lamps. CANTAL PRovECT 4 - Clobal Marufacturng is comiseng probaing the components of its LED Cesk Lanp and sell al a dighty higher price. discourted papback perot, ret present valis (NPV), rternal rate of rebum (FFr), and the profitabilify index (PI). she knes that the CFo liked all proiects te parback within i rears. Ansther consiraint that she mut deal sib is that the CEO and fie Board of Directors are folowing the Bustainable. Gowth approdach which does not alow the frm to issie new common stook or alow the firm to exceed is current deta which is shom on your CASF STUDV DATA SHFET. Capital Budgeting Calculations You will find the Cash Flow estimates for each of the four projects and the Target Rate of Return for 2023 devaloped by the Finance Deparimert on the CAFIAL BUDesise worksheet. Usa this informatian to complete the folowing cakulations. For Captal Projects 1,2,3, and 4 do the following: 1) CALCULATE: Cumulative Cash Flows (Do nos, indude the dolir sign (\$). Nognt ve amounts mast be 2) CALCULATE: Discounted Cash Flows (Do not include te colar sign (5). Nhogtive amouns must be inakated by a minus sizn to be corsidered correct. Round your arswer to the nearest whole do lar. (e g, 3,215)] 3) CALCULATE: Cumulative Discounted Cash Flows (Do not instude the dolar bign (\$). Negstise dolar. [e.g, 3,216i). 4) CALCULATE: Not Present Value (NPV) (Do not induce tho dol br sign (5). Necative amsunts mast be evaluate esch project busod on your findings and determine if each propest is siner ACCEPTABLE or NOT ACCFPTAPLF based on NPV accoptance crilerion. 5) CALCULATE: Internal Rate of Return (IRR) (Do not include the parcene sign (S). Round your anewer 152 decimal places. (e g., 32 15) eveluate aech project basad en your findings and determise if each propest is effer ACCEPTABLE NOT ACCEPTABLE based on IRR acceptanoe criberion. 6) CALCULATE: Modified Internal Rate of Return (MIRR) using the combination approsch only. evaluate esch project bassd on your findings and determine if each propect is sifer ACCEPTABLE or NOT ACCEPTABLE based on MIRR acosptance citterion. eveusts eoch proiect bssod on your findings and dotermive if eash pro,est is sifer ACCEPTABLE or NOT ACCEPTABLE based on Pl accoptaroe criarion. coour in 4 years miler 0.00 for NO PAYBACXK) ACCEPTABLE or NOT ACCEPTABLE tased on Paytseck Period acceptence criterion. (Fiemember, for the Diseounted Payback Peried ewaliale aach projoct based on your findings and dotermine if each project is elther ACCEPTABLE or NOT ACCEPTAELE based on Disosurted Payback Poriod soceptance criturion. CAPITAL BUDGETING ANALYSIS Recap of Each Project's Net Cash Flows and Net Present Value (NPV) From Your Calculations \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Yoar Number } & \multicolumn{5}{|c|}{ Cash Flows At End of Year } & \\ \hline & 0 & 1 & 2 & 3 & 4 & \\ \hline YEAR & 2022 & 2023 & 2024 & 2025 & 2026 & NPV \\ \hline CAPITAL PROJECT \#1 & $1,461,200 & $421,100 & $484,300 & $650,300 & $819,500 & $0 \\ \hline CAPITAL PROJECT \#2 & $1,263,900 & $244,900 & $328,300 & $435,900 & $513,500 & $0 \\ \hline CAPITAL PROJECT \#3 & $1,581,500 & $489,300 & $496,700 & $451,100 & $1,123,100 & $0 \\ \hline CAPITAL PROJECT \#4 & $1,593,800 & $416,900 & $455,500 & $695,100 & $1,106,400 & $0 \\ \hline \end{tabular} Capital Budgeting Analysis decifo which combirst on of these four IMDCPCNICCNT projects ses soceptablo for Globsi Mansfacturing. Inc. based on the MPV criverion: Which ove of fores protect cort bins Which QNE of trese Manulacturing? orporate value to increase? Part 1): Identify all project combinations that are ACCEPTABLE for Global Manufacturing based on the NPV acceptance criterion. (You may not need all the spaces provided.) \begin{tabular}{|c|c|c|c|c|c|c|} \hline & \multicolumn{5}{|c|}{ Cumulative Project Cash Flows At End of Year } & \multirow[b]{2}{*}{\begin{tabular}{c} NET \\ PRESENT \\ VALUE (NPV) \\ \end{tabular}} \\ \hline & Project Cost 2022 & 2023 & 2024 & 2025 & 2026 & \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Part 2): Since Global's management has imposes a Capital Budget Constraint (called Capital Rationing) you must now select those project combinations from Part (1) that DO NOT cost more than the Capital Budget Constraint shown below. (You may not need all the spaces provided.) \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[t]{2}{*}{ Capital Budget Constrai } & \multicolumn{2}{|c|}{$3,964,900.00} & & & & \\ \hline & \multicolumn{5}{|c|}{ Cumulative Project Cash Flows At End of Year } & \\ \hline & \begin{tabular}{c} Project Cost 2022 \\ Cannot Exceed \\ $3,964,900 \\ \end{tabular} & 2023 & 2024 & 2025 & 2026 & \begin{tabular}{c} NET PRESENT \\ VALUE (NPV) \end{tabular} \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Part 3): Which ONE of these AFFORDABLE project combinations identified in Part (2) above will MAXIMIZE the corporate value of Global Manufacturing? \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{\begin{tabular}{l} SINGLE AFFORDABLE PROJECT COMBINATION \\ THAT WILL MAXIMIZE CORPORATE VALUE \end{tabular}} & \multicolumn{5}{|c|}{ Cumulative Project Cash Flews At End of Year } & \multirow[b]{2}{*}{\begin{tabular}{c} NET \\ PRESENT \\ VALUE (NPV) \\ \end{tabular}} \\ \hline & \begin{tabular}{c} Project Cost 2022 \\ Cannot Exceed \\ $3,964,900 \\ \end{tabular} & 2023 & 2024 & 2025 & 2026 & \\ \hline & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Part 4): If this maximizing project combination selected Part (3) were implemented how much could the firm expect its corporate value to increase? Expected Increase in Corporate Value ($)=