What should be the formula on cell B$5?$

a$.=\frac{1-B4**B3**B1-B2}{B}3$

b$.=(1-B4)**\frac{B4**B1-B2}{B}4$

c$.=(1-B4)**\frac{B3**B1+B2}{B}3$

d$.=(1-B4{)}^{**}\frac{B3**B1-B2}{B}3$

e$.=(1-B3)**\frac{B3**B1-B2}{B}4$ What should be the formula on cell B$5?$

a$.=\frac{B\frac{4}{C}4-1}{B\frac{3}{C}3-1}$

b$.=\frac{B\frac{4}{C}4-1}{B\frac{2}{C}2-1}$

c$.=\frac{B\frac{3}{C}3-1}{B\frac{2}{C}2-1}$

d$.=\frac{C\frac{4}{B}4-1}{C\frac{2}{C}B-1}$

e$.=\frac{B\frac{4}{C}4+1}{B\frac{2}{C}2+1}$ Twenty years ago, you invested $$5,000$ at a rate of $7\%$ compounded annually. Fifteen years

ago you added an additional $$3,000$ to that investment because the rate had increased to $10\%$

compounded quarterly. What is the result of cell B$9?$ Remember that the basic syntax of the FV

function is: rate,nper,pmt$,$pv$,$type$)$

a$.$ $$35,986\mathrm{.}34$

b$.$ $$44,054\mathrm{.}03$

c$.$ $$47,543\mathrm{.}86$

d$.$ $$52,986\mathrm{.}54$

e$.$ $$54,975\mathrm{.}87$You have been approved a credit to buy a TV with maximum payment of $$100$ a month for

$4$ years. The interest rate is $9$ percent. What should be the formula on cell B$4$ to find the

maximum price of a TV you can afford to purchase using the credit approved?

a$.=PV(B\frac{3}{12},B1**12,-B2,0)$

b$.=PV(B3**12,B1**12,-B2,0)$

c$.=PV(B\frac{3}{12},B\frac{1}{12},-B2,0)$

d$.=PV(B3**12,B\frac{1}{12},-B2,0)$

e$.=PV(B3,B1,-B2,0)$What should be the formula on cell B$6?$

a$.=B5**\frac{B1-B2}{B}3$

b$.=B5**B1-B\frac{2}{B}4$

c$.=B5**\frac{B1-B2}{B}4$

d$.=B5**\frac{B2-B3}{B}4$

e$.=B5**\frac{B1-B3}{B}4$