Please use the description above to fill out the excel table below. Please include calculations or excel formulas for your answers. Thank you :)

- Sales are $150,000 year. Labor, materials, rent, and marketing costs are $130,000/ year. Sales and costs arrive at year end. - You spend $30,000 today on furniture and cooking equipment, depreciated evenly and fully over 4 years. - You spend $5,000 today for a kitchen full of flour and frosting (inventory). Years 1-3 will grow this by $1,000 each year (so inventory will be $6,000 at the end of year 1 , for example). - You will shut down in 4 years. You will use up inventory during year 4 so that the day you close, you will have no flour or frosting left. In other words, inventory at end of year 4 is zero. - At shut down, you can sell your furniture/equipment for $3,000. - The tax rate is 20% and the required return is 15%. What is the NPV of this store? \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{1}{|l|}{0} & 1 & 2 & \multicolumn{1}{|c|}{3} \\ \hline Investment & & & \\ \hline Saless & & & \\ \hline Operating Costs & & & \\ \hline Depreclation & & & \\ \hline NWC & & & \\ \hline Change in NWC & & & \\ \hline & & & \\ \hline EBIT & & & \\ \hline EBIT(1-Tax) & & \\ \hline FCF & & \\ \hline Discounted FCF & & \\ \hline & & \\ \hline Discounted Rate & & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline NPV & PV \\ \hline IRR & \\ \hline PV & \\ PMT & \\ \hline nperratefV & FV \\ \hline & FV for annuity \\ & Nper(N of Periods) \\ & Rate(discount rate, req) \\ & Pmt(payment, annuity) \end{tabular}