You work for a consulting firm hired to analyze whether a firm should invest in its new product. The project's life has been estimated to be 15 years. Each unit can be manufactured for $30, and the estimated price it can be sold is $75. If the project is approved, the firm will need to hire 100 employees for $700,000 annually during the project's life. The firm will also need to rent the space for the new facility for $5,000,000 per year. The equipment necessary for production can be purchased for $40,000,000. Considering the decay and loss of equipment efficiency over the years, the firm will need to buy a second and smaller piece of equipment in year 10 for $20,000,000. While the original piece of equipment will be worthless on a market basis at the end of the project, the second piece will be able to be sold for $4,000,000. Following Tax code regulations, each piece must be depreciated following a schedule highlighted in the depreciation table below. To obtain the amount necessary for the initial investment, the firm will need to borrow money at a rate of 3% per year. To estimate the number of units that the firm will sell, you have access to historical data on a similar product. Based on your experience with this type of project, you have determined that you need to adjust the estimates obtained from historical data by increasing them by 10% during the first 8 years and then decreasing them by 15% during the last 7 years. It is known that the number of units can be properly explained by the median household income and number of households in the target market. Before production can start, the new facility must be constructed, and personnel must be trained. This implies that production in year 1 will be 0 . Subsequently, the requirement for net working capital will also start in year 2 and will occur with the timing of cash flows for the year. The investment in net working capital will be $1,000,000. The services being provided by your consulting firm cost $5,000,000 and will be paid over the next 5 years in equal $1,000,000 installments. Assuming a corporate tax rate of 21% and a required return of 12% a) Estimate the Cash flows of the project. (30 points) b) What is the payback and discounted payback? Interpret the results. (10 points) c) What is the profitability index? Interpret the result. (5 points) d) What is the IRR of the project? Interpret the result. (5 points) \begin{tabular}{|r|r|r|r|} \hline Year & Unit sales & Household income & Number of Households \\ \hline 2000 & 105,114 & 46,311 & 1,776,445 \\ \hline 2001 & 110,469 & 48,117 & 1,808,886 \\ \hline 2002 & 116,012 & 47,460 & 1,877,239 \\ \hline 2003 & 121,762 & 48,694 & 1,937,855 \\ \hline 2004 & 128,014 & 49,339 & 1,985,161 \\ \hline 2005 & 134,266 & 49,338 & 2,049,927 \\ \hline 2006 & 140,907 & 50,117 & 2,101,286 \\ \hline 2007 & 147,438 & 50,305 & 2,181,673 \\ \hline 2008 & 154,713 & 51,672 & 2,221,864 \\ \hline 2009 & 162,567 & 50,953 & 2,306,984 \\ \hline 2010 & 170,763 & 52,288 & 2,354,657 \\ \hline 2011 & 179,172 & 51,874 & 2,414,842 \\ \hline 2012 & 188,087 & 51,945 & 2,538,289 \\ \hline 2013 & 197,538 & 54,646 & 2,623,605 \\ \hline 2014 & 207,208 & 55,644 & 2,730,159 \\ \hline 2015 & 217,086 & 57,511 & 2,726,575 \\ \hline 2016 & 227,988 & 54,472 & 2,798,905 \\ \hline 2017 & 239,220 & 54,678 & 2,886,781 \\ \hline 2018 & 251,226 & 55,368 & 2,962,421 \\ \hline 2019 & 264,071 & 55,438 & 3,028,215 \\ \hline 2020 & 277,358 & 55,111 & 3,121,664 \\ \hline 2021 & 291,384 & 55,726 & 3,205,542 \\ \hline 2022 & 306,029 & 55,920 & 3,236,912 \\ \hline 2023 & 321,397 & 54,206 & 3,236,912 \\ \hline & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|} Year & \multicolumn{2}{|l|}{Depreciationpercentage} \\ \hline 1 & 14.29% \\ \hline 2 & 24.49% \\ \hline 3 & 17.49% \\ \hline 4 & 12.49% \\ \hline 5 & 8.93% \\ \hline 6 & 8.92% \\ \hline 7 & 8.93% \\ \hline 8 & 4.46% \\ \hline \end{tabular} You work for a consulting firm hired to analyze whether a firm should invest in its new product. The project's life has been estimated to be 15 years. Each unit can be manufactured for $30, and the estimated price it can be sold is $75. If the project is approved, the firm will need to hire 100 employees for $700,000 annually during the project's life. The firm will also need to rent the space for the new facility for $5,000,000 per year. The equipment necessary for production can be purchased for $40,000,000. Considering the decay and loss of equipment efficiency over the years, the firm will need to buy a second and smaller piece of equipment in year 10 for $20,000,000. While the original piece of equipment will be worthless on a market basis at the end of the project, the second piece will be able to be sold for $4,000,000. Following Tax code regulations, each piece must be depreciated following a schedule highlighted in the depreciation table below. To obtain the amount necessary for the initial investment, the firm will need to borrow money at a rate of 3% per year. To estimate the number of units that the firm will sell, you have access to historical data on a similar product. Based on your experience with this type of project, you have determined that you need to adjust the estimates obtained from historical data by increasing them by 10% during the first 8 years and then decreasing them by 15% during the last 7 years. It is known that the number of units can be properly explained by the median household income and number of households in the target market. Before production can start, the new facility must be constructed, and personnel must be trained. This implies that production in year 1 will be 0 . Subsequently, the requirement for net working capital will also start in year 2 and will occur with the timing of cash flows for the year. The investment in net working capital will be $1,000,000. The services being provided by your consulting firm cost $5,000,000 and will be paid over the next 5 years in equal $1,000,000 installments. Assuming a corporate tax rate of 21% and a required return of 12% a) Estimate the Cash flows of the project. (30 points) b) What is the payback and discounted payback? Interpret the results. (10 points) c) What is the profitability index? Interpret the result. (5 points) d) What is the IRR of the project? Interpret the result. (5 points) \begin{tabular}{|r|r|r|r|} \hline Year & Unit sales & Household income & Number of Households \\ \hline 2000 & 105,114 & 46,311 & 1,776,445 \\ \hline 2001 & 110,469 & 48,117 & 1,808,886 \\ \hline 2002 & 116,012 & 47,460 & 1,877,239 \\ \hline 2003 & 121,762 & 48,694 & 1,937,855 \\ \hline 2004 & 128,014 & 49,339 & 1,985,161 \\ \hline 2005 & 134,266 & 49,338 & 2,049,927 \\ \hline 2006 & 140,907 & 50,117 & 2,101,286 \\ \hline 2007 & 147,438 & 50,305 & 2,181,673 \\ \hline 2008 & 154,713 & 51,672 & 2,221,864 \\ \hline 2009 & 162,567 & 50,953 & 2,306,984 \\ \hline 2010 & 170,763 & 52,288 & 2,354,657 \\ \hline 2011 & 179,172 & 51,874 & 2,414,842 \\ \hline 2012 & 188,087 & 51,945 & 2,538,289 \\ \hline 2013 & 197,538 & 54,646 & 2,623,605 \\ \hline 2014 & 207,208 & 55,644 & 2,730,159 \\ \hline 2015 & 217,086 & 57,511 & 2,726,575 \\ \hline 2016 & 227,988 & 54,472 & 2,798,905 \\ \hline 2017 & 239,220 & 54,678 & 2,886,781 \\ \hline 2018 & 251,226 & 55,368 & 2,962,421 \\ \hline 2019 & 264,071 & 55,438 & 3,028,215 \\ \hline 2020 & 277,358 & 55,111 & 3,121,664 \\ \hline 2021 & 291,384 & 55,726 & 3,205,542 \\ \hline 2022 & 306,029 & 55,920 & 3,236,912 \\ \hline 2023 & 321,397 & 54,206 & 3,236,912 \\ \hline & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|} Year & \multicolumn{2}{|l|}{Depreciationpercentage} \\ \hline 1 & 14.29% \\ \hline 2 & 24.49% \\ \hline 3 & 17.49% \\ \hline 4 & 12.49% \\ \hline 5 & 8.93% \\ \hline 6 & 8.92% \\ \hline 7 & 8.93% \\ \hline 8 & 4.46% \\ \hline \end{tabular}