make in excel

This comprabansivo problam is a continaztion of Comprohensive Problam $1.$ Miller Dalivery

Servics has complatad closing entrias and the accounting cycle for $2016.$ The business is now

rasiy to racord January $2017$ transactions.

Jan. $3$ Collected $$1,000$ cash from customer on account.

$5$ Purchased office supplies on account, $$600.$

$12$ Perfarmed delivery services for a customer and rocesved $$2,000$ cash.

$15$ Paid emplayee salary including the amount owed on December $31,32,500.$

$18$ Pefarnod delivery services on acccumt, $5950.$

$20$ Paid $$200$ an account.

$24$ Purchased fuel for the truck, paying $$250$ cash.

$27$ Completed the nemaining work due for Unearned Pevenue

$28$ Paid affice rent, $$1,600,$ for the manth of Januars

$30$ Collocted $$3,200$ in sdvance for delivery service to be performed later.

$31$ Cash dividends of $$2,000$ were paid to stockhaiders.

Requirements

Racord eveh Jurery trawaction in the journal Explanations are not requirsd.

Post the trassactions in the T$-$accounts. Don't forget to ase the Decembar $31,2016,$ anding

balmos as aypropriate.

Propars an unvijusted trial belawes as of Jastary $31,2017.$

Propare a workshest $2$ of Jaunary $31,2017.($optional$)$

Jourualize the adjusting entres using the following adjatment dats and also by recisaing

the journzl entriss propared in Requiramast $1.$ Post adjusting astries to the T$-$accounts.

Adjastament data:

a$.$ Office Suppliss on kaud, $$120.$

b$.$ Accraed Sarvies Rarases, $$1,200.$

c$.$ Accroed Salarias Expense, $$1,000.$

d$.$ Prepaid Insurance for the month hes expired.

e$.$ Deprociztion was racorded on the truek for the mouth.

Propars an adjasted trizl balance zs of January $31,2017.$

Propars Miller Delivery Sarvica's income statsment and statemant of ratained earings for

the monta asdsd Junury $31,2017,$ asd the clasified balance sheet on that data. On the

income statement, list expenses in decrasing order by amoun:$-$ that is$,$ the largest expanse

first, the smallest axyanse last.

Calculate the following ratios as of Jazary $31,2017,$ for Millar Dalivery Sarvice: retum on

assets, debt ratio, asd currant ratio.