please answer these!!

$1$

$5.$ Prepare an income statement for the period ended January $31$ in the 'Income Statement' Tab.

$6.$ Prepare a bank reconciliation in the 'Bank Reconciliation' Tab.

$7.$ Prepare a classified balance sheet as of January $31$ in the 'Balance Sheet' Tab.

$8.$ Using the information from the requirements above, complete the 'Analysis' tab.

$90$

points

Requirement

General

General

Trial Balance

Income

Bank Journal Ledger Statement Reconciftation Balance Sheet Analysis

Use the January $31$ balance in Cash from General Ledger tab and the information $(j)$ to $(n)$ to prepare a bank reconciliation. PRS$\text{'}$s bank reported a January $31$ balance of $$5,510,$ while the comp$$ny$\text{'}$s book balance was $$4,910.$

Adjusted

$\backslash$table$[[$Pulse Recording Studio$],[$Bank Reconciliation$],[$At January $31],[$Updates to Bank Statement,Updates to Company's Books$],[$Ending balance per bank statement,$1,$$$,5,510,$Ending balance per Cash account,$$,4,910],[$Additions:$,,,,$Additions:,,$],[$Additen$,,,,,,],[,,,,,,],[,,,0,,,0],[,,,5,510,,,4,910],[$Deductions:$,,,,$Deductions:,,$],[-,,,,,,],[,,,,,,],[,,,0,,,0],[$Up$-$to$-$date cash balance,,$$,5,510,$Up$-$to$-$date cash balance,$$,4,910]]$

$1$

Requirement

General

General

Ledger

Trial Balance

Income

Statement

Beconciliation Balance Sheet

Analysis

Use the dropdowns to select the accounts properly included on the balance sheet. The unadjusted, or adjusted balances will appear for each account, based on your $$election$.$

$90$

points

Adjusted

$\backslash$table$[[$Pulse Recording Studio$],[$Balance Sheet$],[$At January $31],[,,],[.{?}^a,,],[-.,$$$,0],[,,0],[,,0],[,,0],[20,,,,0],[,,0],[,,0],[,,0],[$Equipment$,$ net,,$0],[,$$$,0],[$Liabilities and Stockholders' Equity$],[,,],[,$$$,0],[,,0],[,,0],[,,0],[,,0],[,,0],[,,0],[,,0]]$

Mc

$\backslash$table$[[$Requirement$,\backslash$table$[[$General$],[$Journal$]],\backslash$table$[[$General$],[$Ledger$]],$Trial Balance,$\backslash$table$[[$Income$],[$Statement$]],\backslash$table$[[$Bank$],[$Reconciliation$]],$Balance Sheet$]]$

eBook

General

Trial Balance

Income

Bank

Statement

Reconciliation

Balance Sheet

Analysis

Using the information from the requirements above, complete the 'Analysis' tab.

Analysis

Print

Calculate the current ratio at January $31.$

Note: Round your answer to $2$ decimal places.

Current Ratio $$

Indicate whether PRS has met its loan covenant that requires a minimum current ratio of $1\mathrm{.}2.$

$\backslash$table$[[,]]$

Calculate the net profit margin at January $31.$

Note: Round your answer to $2$ decimal places.

Net Profit Margin

$\%$

Indicate whether PRS has achieved its objective of $10$ percent.

$$