Question: Please use excel to solve all problems and show all Formulas/Work. if you have any questions please comment and I will fix. Thank you. Georgia
Please use excel to solve all problems and show all Formulas/Work.
if you have any questions please comment and I will fix. Thank you.
Georgia Corporation is considering two mutually exclusive projects. Georgia Corporation's cost of capital is 10.50 percent. The cash flows for both projects are given in the table below: Year 0 1 | 2 | 3 | 4 | 5 | 6 | 7 Project A's -$330,000 $50,000 $90,000 $120.000 S110,000S180,000S140,000 $170,000 Cash Flows Project B's $150.00 | chat 15150,000 56,00|40,000 $80,00 S40,000|$140,00 90,000 500,00 a. (5 points) Use an Excel Data Table to construct a net present value profile graph for the two projects. b. (4 points) Use the =NPVO function in Excel to find the NPVs for the two projects. c. (4 points) Use the =IRRO function in Excel to find the IRRs for the two projects. d. (4 points) What are the discounted payback periods for the two projects? e. (4 points)Which project should be accepted? Explain. f. (4 points) What is the crossover rate
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
