Please examine the provided cash flow table

Year Cash Flow

$0-11$R

$1-1\mathrm{.}5$R

$265000$

$34\mathrm{.}2$R

$43\mathrm{.}5$R

$5-1\mathrm{.}9$R

$6-23000$

$74\mathrm{.}1$R

$861023$

$91\mathrm{.}6$R

$10-2500$

$11$ R

Use the goal seek function. Answer these questions.

$5$a$.$ What is the value of R at $5\mathrm{.}6\%$ interest to make all of the cash flow transactions balance out?

$5$b$.$ HOW do we know when all of the cash flows, in and out have been balanced?

$5$c$.$ If R is $$27,000$ what is the NEW interest rate we will need?