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 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
In the following three dialogues, determine whether a contract is formed under UCC § 2-207.2. A: "I'll sell you my white 1974 Ford Torino for $358. This offer is limited ...
Jul 26 2021Predict the molecular structure and bond angles for each molecule or ion in Exercises 87 and 93.PART Ia. CCl4b. NCl3c. SeCl2d. IClPART IIa. NO2, NO3, N2O4 (N2O4 exists as...
Jul 19 2021Find the slope of the graph of the function at the given point. Use the derivative feature of a graphing utilityto confiirm your results? at
Jun 30 2021Write about Aggression Diversion and safety-valve theory mentioned Societies develop culturally acceptable ways of either reducing aggressive impulses. The areas of life ...
Feb 05 2020Suppose a perfectly competitive firm can maximize profit by hiring one more unit of labor, this extra unit of labor will make 6 more units of output. If it can sell each ...
Apr 26 2021What does the law of increasing costs imply as production shifts from one item to another?
Jun 05 2021Prepare the balance sheets of parent ltd and the consolidated balance sheet as at 1 January 20x7 after each transation, using for each qution the balance sheets of parent...
May 23 2020Think about It The table shows some values of the derivative of an unknown function Complete the table by finding the derivative of each transformation of if possible.
Jun 29 2021A mixture of 80 percent ethane and 20 percent methane on a mole basis is throttled from 10 MPa, 65°C, to 100 kPa and is fed to a combustion chamber where it undergoes com...
Jun 07 2020Refer to the information provided in Figure below to answer the question that follow. Cost and demand oondons ATU MC AM ME MB 15 13 Jong ada vo 6 Bushels of wheat Refer t...
Apr 05 2021