Please choose the correct ending to complete the given sentence: Computers and Electronics: [header] How to calculate an irr in excel [title] Launch microsoft excel. [title] Create a new workbook and save it with a descriptive name. [title] Determine the projects or investments you will be analyzing and the future period to use.

Ending1: [title] Perform the addition and subtraction of funds from the assets you will be analyzing. [title] Upon completion of the analysis, type and enter-and then enter the future period. Ending2: [title] Use the rectangle tool from the excel workbook to format numbers so they will line up neatly. [title] Press power and eject to format excel. Ending3: [substeps] For instance, assume that you have been asked to calculate an irr for 3 projects over a period of 5 years. [title] Prepare your spreadsheet by creating the column labels. Ending4: [step] Calculate the length of the work you will be working out. A similar work needs to be considered five years from the start time date in order to calculate an irr.

Answer format: ending1/ending2/ending3/ending4