Transcribed Image Text
*Excel formulas needed* A U.S.-based firm is considering a six-year project in Colombia. The following information is availableabout the project: Initial investment. The initial investment ofUSD 750,000 is used to purchase capital equipment. This equipmentwill be depreciated straight line to zero. At the end of six years,the remaining equipment will be sold for Colombian Peso (COP)25,000,000. Working capital. The investment in working capital isCOP 100,000,000. There are no changes in working capital until theend of the project when the full amount is recovered. Units, price,and costs. The firm will produce 2000 units of a product annually.The selling price is expected to be COP 599000 in the first year.This price is expected to increase at a rate of 4 percent annually.The direct expense per unit is expected to be COP 200000 in thefirst year. This is expected to increase at a rate of 5 percentannually. Indirect expenses are expected to be COP 50,000,000annually. Taxes and miscellaneous. Colombian taxes on income andcapital gains are 34 percent. There are no additional withholdingtaxes. All cash flows are repatriated when generated, and there areno additional U.S. taxes. The parity conditions are assumed to holdbetween Colombia and the United States. The relevant inflationindexes indicate a rate of 3 percent for the United States and 6percent for Colombia. Spot USDCOP equals 3300. Brady’s USDdenominated WACC is 12 percent.c. Use parity conditions to generate future spot rates.Calculate the project NPV in USD.EXCEL FORMULAS only please. It will be incorrect if not runthrough Excel.Thanks in advanced!