Marriott's environmental commitments are aiming to further reduce energy and water consumption by 20%. To meet...

Transcribed Image Text:

Marriott's environmental commitments are aiming to further reduce energy and water consumption by 20%. To meet the goals, Marriott Marquis initiated a long-term project to reduce waste by 20%. (We here refer that maximum conversion rate, Ymax. is 20%) Considerations for cost analysis 1. Annual cost of waste for Marriott Marquis (per hotel): The following table is to illustrate Marriott Marquis's average monthly weights for recycling, trash, compost for recent years. All weights are marked in tons. Recycling and trash amounts are measured in 35-yard compactors. It costs $150 to haul a 35-yard compactor plus $59 per tonnage. Compost amount is measured based on a 35-gal container. 22.5 containers are required for tonnage. It costs $6.66 per a recycled container with delivery costs of $59 per tonnage. The 35-yard compactor can be shared for recycling and trash. (Assume that recycling and trash & compost treatment process is implemented once a month.) Table: Marriott Marquis' weights for recycle, trash, and compost. Month Recycle Trash Compost Total July - 95.52 95.52 August 86.5 86.5 Sept 2.89 84.93 87.82 Oct 9.33 110.57 119.9 Nov 17.47 74.41 91.88 Dec 5.38 59.93 65.31 Jan 17.82 70.69 - 88.51 Feb 9.85 85.21 95.06 March 19.83 96.82 6.35 123 April 11.89 87.33 19.31 118.53 May 26.11 91.61 6.85 124.57 June 17.53 85.93 16.05 119.51 Total 138.1 1029.45 48.56 1216.11 2. Expected Cash Flows: Let's denote total annual cost savings (recycling, trash and compost) for Marriott Marquis as Cs, discount rate as r and maximum conversion rate is Ymax (Gamma Max). Suppose annual conversion rate, y (Gamma), is increasing linearly each year over 10 years. That is, y = 0.1ymax in the first year, 0.2Ymax in the second year,, Ymax in the last (10th) year. The expected cash flow (CF) is C, x (Ymax x 0.1) in the first year, C, x (Ymax x 0.2) in the second year,, Cs x (Ymax x 1) in the last (10th) year. 3. Discount rate: You need to calculate your own WACC. 4. Typical project length: Many of Marriott's hotels have a form of committees or independent CSR work groups. Each work group has launched and is currently working on relevant projects as part of enhancing business sustainability with typical project lasting about 10 years. 5. Net Present Value (NPV) and Internal Rate of Return (IRR): NPV determine the sum of the present values of cash inflow and outflows over the period of project. NPV calculate an estimate of the profitability of a project or investment. The formula can be written as i. NPV-Co+ C1 C2 + (1+r) + + (1+r) T = -Co += (1+r) ii. IRR finds r such as - Co+= (1-0 where Co is initial cost (investment), C is cash flow, r is discount rate, and 7' is time. The NPV method is a direct measure of the dollar contribution to the investors, while the IRR method provides the return on the original money invested. NPV and IRR method can give a conflicting ranking of projects when IRR method is compared to NPV for mutually exclusive projects. Also multiple IRR problem can be an issue when cash flows during the project lifetime are negative. 2 Question for Project Your boss now asked you to prepare for a report for board meeting in a week. Your report will be distributed to board members whose average age is slightly over 60 years old. Thus, you need to consider the efficiency and visibility when you write your report'. Your report is expected to include answers for the following questions that the board members want to know: Report Q1-1) What is the annual cost of waste for Marriott Marquis in recent years? Q1-2) Suppose there is no initial investment (cost), I=0 (without any running cost). What is the maximum allowed annual investment, I, for this project to have positive NPV? Q1-3) Suppose there is initial investment (cost), Io, of $35,000 required. What is the maximum allowed annual investment, I, for this project to have positive NPV? Q2) Provide the financial analysis for answers that you have derived in Question 1. Q3) Provide your final opinion (S1 paragraph length) as a project manager. Marriott's environmental commitments are aiming to further reduce energy and water consumption by 20%. To meet the goals, Marriott Marquis initiated a long-term project to reduce waste by 20%. (We here refer that maximum conversion rate, Ymax. is 20%) Considerations for cost analysis 1. Annual cost of waste for Marriott Marquis (per hotel): The following table is to illustrate Marriott Marquis's average monthly weights for recycling, trash, compost for recent years. All weights are marked in tons. Recycling and trash amounts are measured in 35-yard compactors. It costs $150 to haul a 35-yard compactor plus $59 per tonnage. Compost amount is measured based on a 35-gal container. 22.5 containers are required for tonnage. It costs $6.66 per a recycled container with delivery costs of $59 per tonnage. The 35-yard compactor can be shared for recycling and trash. (Assume that recycling and trash & compost treatment process is implemented once a month.) Table: Marriott Marquis' weights for recycle, trash, and compost. Month Recycle Trash Compost Total July - 95.52 95.52 August 86.5 86.5 Sept 2.89 84.93 87.82 Oct 9.33 110.57 119.9 Nov 17.47 74.41 91.88 Dec 5.38 59.93 65.31 Jan 17.82 70.69 - 88.51 Feb 9.85 85.21 95.06 March 19.83 96.82 6.35 123 April 11.89 87.33 19.31 118.53 May 26.11 91.61 6.85 124.57 June 17.53 85.93 16.05 119.51 Total 138.1 1029.45 48.56 1216.11 2. Expected Cash Flows: Let's denote total annual cost savings (recycling, trash and compost) for Marriott Marquis as Cs, discount rate as r and maximum conversion rate is Ymax (Gamma Max). Suppose annual conversion rate, y (Gamma), is increasing linearly each year over 10 years. That is, y = 0.1ymax in the first year, 0.2Ymax in the second year,, Ymax in the last (10th) year. The expected cash flow (CF) is C, x (Ymax x 0.1) in the first year, C, x (Ymax x 0.2) in the second year,, Cs x (Ymax x 1) in the last (10th) year. 3. Discount rate: You need to calculate your own WACC. 4. Typical project length: Many of Marriott's hotels have a form of committees or independent CSR work groups. Each work group has launched and is currently working on relevant projects as part of enhancing business sustainability with typical project lasting about 10 years. 5. Net Present Value (NPV) and Internal Rate of Return (IRR): NPV determine the sum of the present values of cash inflow and outflows over the period of project. NPV calculate an estimate of the profitability of a project or investment. The formula can be written as i. NPV-Co+ C1 C2 + (1+r) + + (1+r) T = -Co += (1+r) ii. IRR finds r such as - Co+= (1-0 where Co is initial cost (investment), C is cash flow, r is discount rate, and 7' is time. The NPV method is a direct measure of the dollar contribution to the investors, while the IRR method provides the return on the original money invested. NPV and IRR method can give a conflicting ranking of projects when IRR method is compared to NPV for mutually exclusive projects. Also multiple IRR problem can be an issue when cash flows during the project lifetime are negative. 2 Question for Project Your boss now asked you to prepare for a report for board meeting in a week. Your report will be distributed to board members whose average age is slightly over 60 years old. Thus, you need to consider the efficiency and visibility when you write your report'. Your report is expected to include answers for the following questions that the board members want to know: Report Q1-1) What is the annual cost of waste for Marriott Marquis in recent years? Q1-2) Suppose there is no initial investment (cost), I=0 (without any running cost). What is the maximum allowed annual investment, I, for this project to have positive NPV? Q1-3) Suppose there is initial investment (cost), Io, of $35,000 required. What is the maximum allowed annual investment, I, for this project to have positive NPV? Q2) Provide the financial analysis for answers that you have derived in Question 1. Q3) Provide your final opinion (S1 paragraph length) as a project manager.