b$)$ Create an Excel formula to calculate Quick Ratio. $(1$ mark$)$

Quick Ratio $=\frac{\text{T}\text{o}\text{t}\text{a}\text{l}\text{A}\text{c}\text{c}\text{o}\text{u}\text{n}\text{t}\text{s}\text{r}\text{e}\text{c}\text{e}\text{i}\text{v}\text{a}\text{b}\text{l}\text{e}+\text{C}\text{a}\text{s}\text{h}+\text{O}\text{t}\text{h}\text{e}\text{r}\text{C}\text{u}\text{r}\text{r}\text{e}\text{n}\text{t}\text{A}\text{s}\text{s}\text{e}\text{t}\text{s}}{\text{T}\text{o}\text{t}\text{a}\text{l}\text{C}\text{u}\text{r}\text{r}\text{e}\text{n}\text{t}\text{L}\text{i}\text{a}\text{b}\text{i}\text{l}\text{i}\text{t}\text{i}\text{e}\text{s}}$

c$)$ Create an Excel formula to calculate WACC. $(3$ marks$)$

WACC$=\frac{D}{V}**Rd**(1-Tc)+\frac{E}{V}**Re$