Your team has submitted the following estimated financial projections to VTEPS, Inc. for your BRG Project for a $3$ year project, evaluated on a quarterly basis:

Development costs are $$100,\frac{000}{?}$ quarter for year $1$

Ramp$-$Up costs are $$40,000/$quarter for $Y_{1}Q4$ and $Y_{2}Q1$

Production costs are $$35,000/$quarter for $Y_2$ through $Y3$

Marketing costs are $$20,\frac{000}{?}$ quarter for $Y2$ and $Y3$

Product support costs are $$5,000/$quarter for $Y_1$ and $$20,000/$quarter for $Y_2$

Material costs are $$15,000/$quarter for $Y2$ and $Y3$

Sales Revenue is expected to be $$200,000/$quarter for $Y2$ and $$350,\frac{000}{?}$ quarter for $Y3$

The VTEPS, Inc. has an annual MARR $=20\%.$

Using Excel determine the following:

The Project PW$,$ AW$,$ FW$,$ IRR, and Payback Period.

If development costs increase to $$275,000/$quarter for year $1$ and all other variables remain the same, determine the project PW$,$ AW$,$ FW$,$ IRR, and Payback Period.

Referring to the original data, if marketing costs double and all other variables remain the same, determine the project PW$,$ AW$,$ FW$,$ IRR, and Payback Period.

Referring to the original data, if both sales revenue is only $$150,\frac{000}{?}$ quarter for year $2$ and $$300,000/$quarter for year $3,$ marketing costs increase $50\%,$ and all other variables remain the same, determine the project PW$,$ AW$,$ FW$,$ IRR, and Payback Period.