Please provide answer with steps of calculation. Preferably not in excel format 
1HB.5 Zulu Inc. is considering a proposal to mantuactare high-send profein bas used ne fock seppiernerits ty body buldors. The project requires use of an exisling whreshoune, wivich the firm acruated buro yeats ago for $1.55 mallion and which it currently rents cut for 5165,000 . Fental rates are roat expiected to thange going forward. In addition to using the waretwouse, the project requires an upfiont investrment into machines and offer equiprnert of $1,600,000. This invostment can be fully depreciated straight-lane over the next 10 years for tax purposes. However, Zulu Inc. expects to terminate the project at the end of 5 years and to sell the machirves and equipment for $1,010,000. Finally, the project requires an initial investment into net working capital (NWC) equal to 9% of predicted first-year sales. Subsequently, net working capital is 9% of the predicted sales over the following year. Sales of protein bars are expected to be $4,100,000 in the first year and to stay constant for five years. Total manufacturing costs and operating expenses (excluding depreciation) are 85% of sales, and profits are taxed at 2196. Assume (1) the warehouse can be rented out again for $165,000 after 5 years and (2) the NWC is fully recovered at book value after 5 years. What are the incremental free cash flows of the project? If the cost of capital is 11.5%. what is the NPV of the project? Assume a neutral rate of reinvestment for this project and calculate the MiRR. The initial investment, i.e.: the fre the nearest whole number) The free cash flow in year 2 is eq The free cash flow in year 5 is eq The NPV of the project is equal: $ The MIRR of the project is equal: (round to the nearest whole number) % (round 1 digit after decimal point) Assume Zulu Inc. is acquired by Canadian fund which reports in Canadian dollars (CAD). The fund worries about xchange rate risk and is going to hedge this investment. Suppose that the spot exchange rate is SD/CAD=1.2100 (i.e.. how much CAD is per 1.00 USD). slected benchmark bond yields are as follows: Assume Zulu Inc. is acquired by Canadian fund which reports in Canadian dollars (CAD). The furvd worries about exchange rate risk and is going to hedge this investment. Suppose that the spot exchange rate is USD /CAD=1.2100 (i.e.: how much CAD is per 1.00 USD). Selected benchmark bond yields are as follows: To find an estimate of the four-year yield, calculate the average of the three- and five-year yields. Based on these yields, what forward exchange rates are consistent with no arbitrage? Calculate forward exchange rates USD/CAD as the interest rate parity model works. Next, calculate the NPV and the IRR of this investment in Canadian dollars. Assume the same cost of the capital. Forward exchange rate USD/CAD in year 1 is equal: CAD per 1.00 USD (round 4 digits after decimal point) Forward exchange rate USD/CAD in year 5 is equal: CAD per 1.00 USD (round 4 digits after decimal point) The NPV of the project (in Canadian dollars) is equal: CAD (round to the nearest whole number) The IRR of the project (in Canadian dollars) is equal: % (round 1 digit after decimal point) 1HB.5 Zulu Inc. is considering a proposal to mantuactare high-send profein bas used ne fock seppiernerits ty body buldors. The project requires use of an exisling whreshoune, wivich the firm acruated buro yeats ago for $1.55 mallion and which it currently rents cut for 5165,000 . Fental rates are roat expiected to thange going forward. In addition to using the waretwouse, the project requires an upfiont investrment into machines and offer equiprnert of $1,600,000. This invostment can be fully depreciated straight-lane over the next 10 years for tax purposes. However, Zulu Inc. expects to terminate the project at the end of 5 years and to sell the machirves and equipment for $1,010,000. Finally, the project requires an initial investment into net working capital (NWC) equal to 9% of predicted first-year sales. Subsequently, net working capital is 9% of the predicted sales over the following year. Sales of protein bars are expected to be $4,100,000 in the first year and to stay constant for five years. Total manufacturing costs and operating expenses (excluding depreciation) are 85% of sales, and profits are taxed at 2196. Assume (1) the warehouse can be rented out again for $165,000 after 5 years and (2) the NWC is fully recovered at book value after 5 years. What are the incremental free cash flows of the project? If the cost of capital is 11.5%. what is the NPV of the project? Assume a neutral rate of reinvestment for this project and calculate the MiRR. The initial investment, i.e.: the fre the nearest whole number) The free cash flow in year 2 is eq The free cash flow in year 5 is eq The NPV of the project is equal: $ The MIRR of the project is equal: (round to the nearest whole number) % (round 1 digit after decimal point) Assume Zulu Inc. is acquired by Canadian fund which reports in Canadian dollars (CAD). The fund worries about xchange rate risk and is going to hedge this investment. Suppose that the spot exchange rate is SD/CAD=1.2100 (i.e.. how much CAD is per 1.00 USD). slected benchmark bond yields are as follows: Assume Zulu Inc. is acquired by Canadian fund which reports in Canadian dollars (CAD). The furvd worries about exchange rate risk and is going to hedge this investment. Suppose that the spot exchange rate is USD /CAD=1.2100 (i.e.: how much CAD is per 1.00 USD). Selected benchmark bond yields are as follows: To find an estimate of the four-year yield, calculate the average of the three- and five-year yields. Based on these yields, what forward exchange rates are consistent with no arbitrage? Calculate forward exchange rates USD/CAD as the interest rate parity model works. Next, calculate the NPV and the IRR of this investment in Canadian dollars. Assume the same cost of the capital. Forward exchange rate USD/CAD in year 1 is equal: CAD per 1.00 USD (round 4 digits after decimal point) Forward exchange rate USD/CAD in year 5 is equal: CAD per 1.00 USD (round 4 digits after decimal point) The NPV of the project (in Canadian dollars) is equal: CAD (round to the nearest whole number) The IRR of the project (in Canadian dollars) is equal: % (round 1 digit after decimal point)
