Determine the annual investment in an equally weighted portfolio (50 percent common stock, 50 percent bonds) required to accumulate the funds, assuming that the first payment is made at age. In excel...

Determine the annual investment in an equally weighted portfolio (50 percent common stock, 50 percent bonds) required to accumulate the funds, assuming that the first payment is made at age. In excel formula.

a. 30

b. 40

c. 50

Given information

Future Value 1,815,330.28

Interest .085

Age 30, number of years 35