Please help me with those questions about finance

 
 
 

 

Below is a table where cash flows for two mutually exclusive projects may be shown. I have entered a series of cash flows for Project 1. TABLE 1 Time 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 CHECK SUM of cash flows Project 1 $(200,000) $20,000 $30,000 $30,000 $30,000 $90,000 $100,000 SUM: $300,000 For years 1 to 6 1 REQUIREMENTS and CORRECTION GRID-next page Project 2 $(200,000) 80,000 Getting started: You must complete the series of cash flows for Project 2, and you will then have two mutually exclusive projects to compare. The cash flows for years 1 to 4 for Project 2 must total up to a sum of $250,000. TABLE 1, duly completed, should be submitted as part of your project. Refer to course 4 for the following: 1) example of how to prepare a table with NPVs for both projects at various discount rates (including one IRR per project). 2) example of a line graph (example can be improved upon). SUM: $250,000 For years 1 to 4 L 111