Solve the LP using Excel after finding the constraints$[10$ marks$]$ Information on a prospective investment for Wells Financial Services is given

below.

In each period, funds available for investment come from two sources: loan funds and income

from the previous period's investment. Expenses, or cash outflows, in each period must include

repayment of the previous period's loan plus $8\mathrm{.}5\%$ interest, and the current payroll payment. In

addition, to end the planning horizon, investment income from period $4($at $110\%$ of the

investment$)$ must be sufficient to cover the loan plus interest from period $4.$ The difference in

these two quantities represents net income, and is to be maximized.

Formulate a linear Programming model for this financial planning application.