You will submit through Canvas the answers to the questions below. You need to utilize Excel...

 

Transcribed Image Text:

You will submit through Canvas the answers to the questions below. You need to utilize Excel to work out the problems and turn in the solutions in your Excel spreadsheet. Solve each question in a separate sheet in Excel and label the sheet accordingly. Also, copy and paste the question into the Spreadsheet similar to the class example. Lastly, make sure and color code any solutions and provide a key for your color-coding scheme (right now you will probably only have two colors but moving forward we will add to that). Single Cash Flow Present Value-Solve the following problem in three equivalent ways: Calculate present value using a time-line, Calculate present value using a formula, Calculate present value using Excel's built-in PV function. Your solution should look similar to the Spreadsheet below (your solution should follow the example provided in the Week 1 video): Question 1: A single cash flow of $2,543.28 will be received in 4 periods. For this cash flow, the appropriate discount rate / period is 5.3%. What is the present value of this single cash flow (see example below for correct output)? You will submit through Canvas the answers to the questions below. You need to utilize Excel to work out the problems and turn in the solutions in your Excel spreadsheet. Solve each question in a separate sheet in Excel and label the sheet accordingly. Also, copy and paste the question into the Spreadsheet similar to the class example. Lastly, make sure and color code any solutions and provide a key for your color-coding scheme (right now you will probably only have two colors but moving forward we will add to that). Single Cash Flow Present Value-Solve the following problem in three equivalent ways: Calculate present value using a time-line, Calculate present value using a formula, Calculate present value using Excel's built-in PV function. Your solution should look similar to the Spreadsheet below (your solution should follow the example provided in the Week 1 video): Question 1: A single cash flow of $2,543.28 will be received in 4 periods. For this cash flow, the appropriate discount rate / period is 5.3%. What is the present value of this single cash flow (see example below for correct output)?