Предлагаю работу корпоративные финансы

[SHAREWOOD]

The task should be submitted as single MS Excel file. Answer to each question should be easily identifiable. Answers should be found with MS Excel formulas or functions like solver or histogram. If you used MS Excel functions, please, make a note in the file specifying which function for which variable you used, otherwise answers as a plain number will not be counted. Consider the following assumptions for a capital budgeting project. The firm is located in Russia and plans to sell its products to India: Fixed capital investment is 20,000,000 Rub; no investment in net working capital is required. The project has an expected five-year life (Year 0 + 5 years of operations). The fixed capital is depreciated straight-line to zero over a five-year life. Unit sales in Year 1 are normally distributed with a mean of 2,000 and a standard deviation of 200. Unit sales growth after Year 1 is normally distributed with a mean of 4 percent and standard deviation of 6 percent. Assume the same sales growth rate for Years 2–5. The sales price is 3500 Indian Rupee per unit, normally distributed with a standard deviation of 250 Rupee per unit. The same price holds for all five years. Estimate the distribution of exchange rate using historical data for 2001-2020 from Russian Central Bank web-site cbr.ru/eng/currency_base/... . To find the mean exchange rate in 2021 you can extrapolate average historical growth rate or use exchange rate forecast for 2021 of trustworthy external sources. Describe the method you applied to find the mean exchange rate in 2021 and include the link to external data sources if you used them. Cash operating expenses as a percentage of total revenue in Rubles are normally distributed with a mean and standard deviation of 30 percent and 3 percent, respectively. The annual discount rate is 12 percent and the tax rate is 20 percent. Solve the following exercises using MS Excel. 1. Draw the financial model of the project assuming the investments w...

Откликнуться на задание: