NEED EXCEL WORK for this. I am struggling to figure out how to build the excel formula for this. I understand the manual calculation.

Suppose your friend's employer will contribute to the account each year as part of the company's profit sharing plan. In addition, your friend expects a

distribution from a family trust several years from now. What amount must she deposit annually now to be able to make the desired withdrawals at

Employer's annual contribution:

Years until trust fund distribution:

Amount of trust fund distribution:

Value of employer's contribution at retirement:

Value of trust fund at retirement:

Amount to save each year now:

Today

Yr $30$

Today

Yr $30$

Yr $50$

Today

Yr $30$