Q$1-$

From the following information given below, assuming that sales are collected in cash within $45\mathrm{.}00$ days, the beginning cash balance is $750\mathrm{.}00$ and Annual Sales Forecasts is $365,000\mathrm{.}00.$ Calculate the following:

i$)-$ Average Sales per Day

ii$)-$ Average Cash Balance

iii$)-$ Beginning Cash Balance

iv$)-$ Ending Cash Balance

Use the following formulas:

$\backslash$table$[[\backslash$table$[[$Average Cash$],[$Balance$]],=,$Annual Sales Forecast,$\{$fe$79$e$027$e$-20$e$5-485$d$-$bb$56-0$dd$05$a$39$e$320\}$

$\backslash$table$[[$Days$\text{'}$ Sales in$],[$Cash$]]]]$

$\backslash$table$[[\backslash$table$[[$Ending Cash$],[$Balance$]],\{$f$2$fa$7$d$262-76$ff$-4086-$aeb$4-0$e$254$dc$73$cdb$\}$

$\backslash$table$[[$Average Cash$],[$Balance$]],\backslash$times $,2\mathrm{.}00,-$

$\backslash$table$[[$Beginning$],[$Cash Balance$]]]]$

Answer:

$\backslash$table$[[\backslash$table$[[$Annual Sales$],[$Forecasts$]],\backslash$table$[[$Average$],[$Sales per$],[$Day$]],\backslash$table$[[$Days$\text{'}],[$Sales in$],[$Cash$]],\backslash$table$[[$Average$],[$Cash Balance$]],\backslash$table$[[$Beginning$],[$Cash$],[$Balance$]],\backslash$table$[[$Ending$],[$Cash$],[$Balance$]]],[365,000\mathrm{.}00,,45\mathrm{.}00,,,],[365,000\mathrm{.}00,,45\mathrm{.}00,,,],[365,000\mathrm{.}00,,45\mathrm{.}00,,,],[365,000\mathrm{.}00,,45\mathrm{.}00,,,],[365,000\mathrm{.}00,,45\mathrm{.}00,,,]]$