50.1K

Verified Solution

Link Copied!

Record all transactions for your new moving company $1.$ Record your initial investment of $$100,0002.$ Record the energy bills $($January$,$ February, and March$)3.$ Record all moving jobs that are listed on your calendar $($January$,$ February, and March$).$ You will record the sale, the contractor expense, and supplies expense for each job. $4.$ Record the two separate truck purchases and calculate depreciation for January, February, and March $5.$ Record the leasing agreement Any trucks purchased will be depreciated over $12$ years with no residual value. Depreciation is calculated at the end of each month. $$ You have a $5$ year loan on all the vehicles you purchase and the payment is due the $1$st of every month. $$ You pay your movers $($you consider them contractors$)$ at $$20$ per man hour for each moving job. They are paid at the end of each week. You do not owe payroll taxes on their wages. $$ You expense the cost of supplies $($boxes$,$ tape, paper$)$ for each job. The supply cost is listed for each job on the moving calendar. $$ You pay your bills on the due date, not when received. $$ You take full payment from the customers on the day of the move. $1$ Record your initial investment $1/2/2018$ Cash $$100,000$ Common Stock $$100,0002$ Record the energy bills $1/31/2018$ Utility expenses $$665\mathrm{.}72$ Utility payable $$665\mathrm{.}722/15/2018$ Utility Payable $$665\mathrm{.}72$ Cash $$665\mathrm{.}722/28/2018$ Utility expenses $$845\mathrm{.}79$ Utility payable $$845\mathrm{.}793/15/2018$ Utility Payable $$845\mathrm{.}79$ Cash $$845\mathrm{.}793/31/2018$ Utility expenses $$795\mathrm{.}63$ Utility payable $$795\mathrm{.}634/15/2018$ Utility Payable $$795\mathrm{.}63$ Cash $$795\mathrm{.}633$ Record all moving jobs that are listed on your calendar $1/4/2018$ Cash $$1,500$ Sale $$1,5001/4/2018$ Contractor expense $(12$ x $$20)$ $$240$ Contractor expense payable $$2401/4/2018$ Supplies expenses $$200$ Cash $$2001/6/2018$ Cash $$300$ Sale $$3001/6/2018$ Contractor expense $(2$ x $$20)$ $$40$ Contractor expense payable $$401/6/2018$ Supplies expenses $$50$ Cash $$501/6/2018$ Contractor expense payable $$280$ Cash $$2801/9/2018$ Cash $$2,200$ Sale $$2,2001/9/2018$ Contractor expense $(15$ x $$20)$ $$300$ Contractor expense payable $$3001/9/2018$ Supplies expenses $$500$ Cash $$5001/12/2018$ Cash $$400$ Sale $$4001/12/2018$ Contractor expense $(2\mathrm{.}5$ x $$20)$ $$50$ Contractor expense payable $$501/12/2018$ Supplies expenses $$50$ Cash $$501/13/2018$ Contractor expense payable $$350$ Cash $$3501/28/2018$ Cash $$350$ Sale $$3501/28/2018$ Contractor expense $(1\mathrm{.}5$ x $$20)$ $$30$ Contractor expense payable $$301/28/2018$ Supplies expenses $$50$ Cash $$502/1/2018$ Cash $$1,500$ Sale $$1,5002/1/2018$ Contractor expense $(12$ x $$20)$ $$240$ Contractor expense payable $$2402/1/2018$ Supplies expenses $$300$ Cash $$3002/3/2018$ Contractor expense payable $$270$ Cash $$2702/4/2018$ Cash $$650$ Sale $$6502/4/2018$ Contractor expense $(5$ x $$20)$ $$100$ Contractor expense payable $$1002/4/2018$ Supplies expenses $$50$ Cash $$502/10/2018$ Contractor expense payable $$100$ Cash $$1002/16/2018$ Cash $$5,000$ Sale $$5,0002/16/2018$ Contractor expense $(23$ x $$20)$ $$460$ Contractor expense payable $$4602/16/2018$ Supplies expenses $$1,000$ Cash $$1,0002/20/2018$ Cash $$500$ Sale $$5002/20/2018$ Contractor expense $(3$ x $$20)$ $$60$ Contractor expense payable $$602/20/2018$ Supplies expenses $$50$ Cash $$502/24/2018$ Contractor expense payable $$520$ Cash $$5203/10/2018$ Cash $$2,000$ Sale $$2,0003/10/2018$ Contractor expense $(18$ x $$20)$ $$360$ Cash $$3603/10/2018$ Supplies expenses $$300$ Cash $$3003/14/2018$ Cash $$300$ Sale $$3003/14/2018$ Contractor expense $(1\mathrm{.}5$ x $$20)$ $$30$ Contractor expense payable $$303/14/2018$ Supplies expenses $$50$ Cash $$503/17/2018$ Contractor expense payable $$30$ Cash $$303/29/2018$ Cash $$1,500$ Sale $$1,5003/29/2018$ Contractor expense $(12$ x $$20)$ $$240$ Contractor expense payable $$2403/29/2018$ Supplies expenses $$300$ Cash $$3003/31/2018$ Contractor expense payable $$240$ Cash $$2404$ Record the two separate truck purchases and calculated depreciation for Jan, feb and March $1/12/2018$ Moving trucks $$103,480$ Long term Loan $$103,4803/23/2018$ Moving Trucks $$48,325$ Long term loan $$48,3251/31/2018$ Depreciation expense $$718\mathrm{.}61$ Accumulated Depreciation $$718\mathrm{.}61($Full month depreciation is charged$)2/28/2016$ Depreciation expense $$718\mathrm{.}61$ Accumulated Depreciation $$718\mathrm{.}613/31/2018$ Depreciation expense $$718\mathrm{.}61$ Accumulated Depreciation $$718\mathrm{.}61$ Depreciation is not charged on second purchase as it put to use in last week of March $2/1/2018$ Long term loan $$1,724\mathrm{.}67$ Cash $$1,724\mathrm{.}67($Loan installment paid$)3/1/2018$ Long term loan $$1,724\mathrm{.}67$ Cash $$1,724\mathrm{.}675$ Record the leasing agreement $1/1/2018$ Refundable Deposit $$5,000$ Cash $$5,0001/1/2018$ Rent expense $$1,000$ Cash $$1,0002/1/2018$ Rent expense $$1,000$ Cash $$1,0003/1/2018$ Rent expense $$1,000$ Cash $$1,000$

Need an income statement that includes income,sales,total income, gross profit, expenses, depreciation expense, job supplies, rent and lease, salaries and wages, utilities, total expenses, net operating income and net income. Need it in excel

Answer & Explanation Solved by verified expert

See Answer