If you were to calculate in excel: Not knowing how much you need to invest but wanting to make $75000 a year on the interest made from the initial investment compounded annually at 1% for 30 years with a payout for 15 years at $75000. How much would you need to invest initially?