Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / Task A Given the following table with financial data on three projects create MS Exeel

Task A Given the following table with financial data on three projects create MS Exeel

Task A. Given the following table with financial data on three projects, create MS Exeel models to compute each of the following selection criteria for each project 1) NPV (discounting factor is 10% PVF Year 10.91. Year 2 0.83, Year 3-0.75, Year 4-068 Yer 5-62 2) IRR (cost of capital is 10%) 3) PI (cost of captal is 10% 4) Discounted Payback period (maximum 3 years) B. Based on your Excel computation results in (A) above, determine whether cach projest independently is feasible/acceptable or not, according to cach of the 4 criteria above Each project must be accepted/rejected on the basis of each criterion considered separately Eg. cach project will have FOUR accept/reject decisions C. If only ONE of the three projects should be selected, which project would you recommend, and why? D. Explain why there are differences and discrepancies in the recommendations of the four selection criteria E. Based on your answer to part (D) above, which of the above four criteria appear(s) more reliable and credible in the present scenario? Explain your reasoning Note: You can read any Finance book in the library or search the Internet for more information about the advantages and limitations of these selection models. Facts: The following table provides data about three projects scheduled to be completed in five years. The cash flows are in thousands of Dirhams and occur at the end of each year Year 3 Year 4 Year 5 Year 2 Total Projects: Cost/Benefits Year 1 1,500 Costs 200 300 400 500 100 Project 1,700 Benefits 200 200 400 900 0 1,500 Costs Project 2Benefits 100 300 400 300 400 1,700 200 200 500 300 500 1,500 Costs 300 300 300 300 300 Project 3 1,700 Benefits 300 500 300 200 400

Jan 31 2020 View more View Less

Answer (UnSolved)

question Get Solution

Related Questions