The Internal Rate of Return function (IRR(values, [guess]). ) is a calculation of the interest paid with an initial investment (-) and subsequent periodic returns (+). A relative has approached you with an opportunity to invest in his new invention. Let's call this a base investment and it has an IRR of 11% (see below). The relative offers 6 yearly payments (20000, 30000,....,15000) for an initial loan of 100000. Additionally, the relative also offers 3 other investment options. You decide to build a table that calculates the IRR for the other investments. These investments are all a variation of the base. For example, Investment 2 asks for 25% more from you initially (-125000) and increases the 6 payments by 25%; thus, Return yr1 is +25000 Return yr2 is 37500, etc.

Write three formulas with absolute and relative addressing that reference the cell values in green and can be easily copied to build the table. The partially completed table is shown below. Build the table with the northwest corner in Cell A1. VERY IMPORTANT THAT I GET THE FORMULAS.

Increase in PMT relative to base = 25% 35% 20%

Increase in RTN relative to base = 25% 30% 20%

	Base	Investment 2	Investment 3	Investment 4
IRR	10.99%
PMT	-100000
Return Yr 1	20000
Return Yr 2	30000
Return Yr 3	25000
Return Yr 4	25000
Return Yr 5	25000
Return Yr 6	15000