Question

An investment in the Mezzogiorno will receive a subsidized loan of $12 million from the Italian government. The loan bears an interest rate of 7% in contrast to a market rate of 10%. The loan principal must be paid back in 8 years. What is the present value of the interest subsidy?

Answer 1

$1.92 million

Step-by-step explanation:

The value of the subsidy per year = $12,000,000 x 3% = $360,000

Now we have to find the present value of the cash flows using an excel spreadsheet and the net present value function =NPV(discount rate,series of cash flows)

discount rate = 10% (market rate)

cash flows = 8 cash flows of 360,000 each

=NPV(10%,360000,360000,360000,360000,360000,360000,360000,360000) = $1,920,573 ≈ $1.92 million