$1$ AC$211-$ This is your Midterm Comprehensive Assignment IMPORTANT: Please follow the instructions explicitly Enter only those fields that are highlighted in yellow. DC NOT alter any other fields as formulas will be affected

and this will impact your financial results and all

DO NOT ADD ANY FIELDS, ROWS OR COLUMNS TO THIS SPREADSHEET

INSTRUCTIONS:

STEP $1$: INPUTS $-$ Enter numbers in the yellow highlighted fields following the instructions.

$AP$ : Enter a number between $35,000$ and $45,000$

ADA: $3\%$ of the AR number is uncollectible

FA$1.$ Enter a number between $300,000$ and $$350,000$

$UL.$ Enter a number of years between $4$ and $8$

AP: As provided here

NP$.$ Enter a number between $70,000$ and $80,000$

BP: Enter a number between $50,000$ to $60,000$

$\backslash$table$[[$$$,40,000\mathrm{.}00,,],[***,1,200\mathrm{.}00,($calculate $3\%$ of your,chosen $A$ R number$]],[$$$,315,000\mathrm{.}00,,],[,6,,$