Answered step by step
Verified Expert Solution
Question
1 Approved Answer
12/01/18 Opened a corporate bank account at Chase Bank 12/01/18 Purchase of 10,000 shares of Platinum IT Services stock each by co-founders at a par
12/01/18 | Opened a corporate bank account at Chase Bank |
12/01/18 | Purchase of 10,000 shares of Platinum IT Services stock each by co-founders at a par value of $30 per share |
12/01/18 | Company borrowed $80,000 from Chase Bank at 5% annually for 3 years to finance further hiring's. All interest is accrued and payable starting date of when the loan was approved. |
12/01/18 | Licensed computer software from Supreme Computer Code for $10,000 for a period of 5 years, putting down $5,500 with the balance due on 01/18/18 Ck. #1008, Inv # 158 |
12/01/18 | Deposit all proceeds from the capital raise into the Chase checking bank account |
12/02/18 | Purchased two automobiles (vans) for $42,351 each to service customer calls (useful life is 5 years) Ch. #1002, Inv. #18009111 |
12/03/18 | Entered into a 10 year office lease (5,000 square feet) at $12 per square foot per year |
12/03/18 | Bought supplies on account from Office Depot, $1,185, Inv. #1425 |
12/04/18 | Paid $251,610 total in leasehold improvements to general contractor to upgrade the office space Ck. #1004, Inv. # 004 |
12/05/18 | Paid a deposit (one month's rent) and current month's rent Ck. #1003. |
12/06/18 | Received a bill from The LA Times for advertising during the month of December, $2,501, Inv. LAT #198 |
12/08/18 | Purchased furniture and fixtures for $100,000 (useful life is 5 years) Ck. #1001, Inv. # 1537 |
12/09/18 | Purchased for $161,050 office computers and equipment from BestBuy (useful life is 3 years) using corporate Chase Ink card. (All credit card balances are paid in full on the 28th of every month) |
12/10/18 | Bought an electric sign (useful life is 3 years) from Mega Light Signs, $5,500, putting $1,000 down, and placing the balance on account, Ck. #1004, Inv. 6712. |
12/11/18 | Provided IT services to Client #1 on account for $25,510 |
12/12/18 | Performed and billed Client #2 for repair services for $15,050. |
12/16/18 | Received and paid bill from the City of Los Angeles for license to do business for the year of 2018; $35, Ck. #1009, (Miscellaneous Expense). |
12/16/18 | Performed consultation services on account for Client #3, $32,100 |
12/19/18 | Performed installation services on account for Client #4, $105,000 |
12/20/18 | Took all employees out for a birthday celebration to Maestro's for $5,010, and paid bill by credit card |
12/22/18 | Paid the balance due to Supreme Computer Code Ck. #1009, Inv #168 |
12/25/18 | Paid salesperson's submitted travel reimbursement request for $100, Ck. #1012 |
12/28/18 | Received and paid the December 2018 electric bill, $500, Ck. #1011. |
12/29/18 | Company received a bill from auto mechanic for $600 due within 30 days, Inv# 019697 |
12/31/18 | Declared and paid a dividend of $5,000 to each of the owners |
12/31/18 | Owner's each purchased 1,000 additional shares/stock for $25 per share |
01/05/19 | Paid commissions to salesperson |
01/05/19 | Company paid current month's rent |
01/08/19 | Paid on account to The LA Times, $650, Ck. #1006, Inv. LAT #198 |
01/09/19 | Hired a new sales associate for $150,000 a year |
Please, need help with worksheet
Home Insert Draw Page Layout Formulas Da Revi View Share |-Comments v111 vA" General Bookman Old Style Wrap Text Paste $v%, Conditional Format Cell Insert Delete Format Sort & Find & Filter Select Marga & Center v Formatting as Table Styles F37 The following transactions oceurred for PLATINUM IT SERVICES during the month of December 2018 and January 2019: 1 3 | | 12/01/18 Opened corporate bank account at Chase Bank 2 4 | | 12/01/18 Purchase u{ 10,000 8lares urpletinum rr Service8 8tock euch by cu-rounders al par value of $30 per share 3 13/01/18 Company borrowed 80,000 trom Cha8c Bank at 5% annually for 3 year8 tonnanec further hiring s All interest i8 80 rued 8nd payable tarting date or when the loan was 8ppr ed. 5 6 4 12/01/ 18. Ileensed eam arter software from 8aprene. Camputer Code for $1G (XX) for period of years putting down sa,stla with the balance due n al 18 /18 Cl.10GH n # 1 58 75 12/011 Depast all praceeda from the capital raise into the Chase checking hank account | 6 | 12/02/1 a Purchased two automobiles vansl for $42.3S1 each to service customer calls (useful life is S years! Ch. #1002. Inv. 180091 1 1 0712/03/13 ntered into a 10 year office lease (5,000 square feet at S12 per square frot per year u | 8 12/03/18 Boughtsupplies account frucn Office Depot. S 1.185, Irv#1425 1 9 12/04/18 Pu 1251 610 total in k 88 hold uupruvetette to general contractor to upgrade the ure 8pace Ck.004, tuv 004 2 1013/05,18 Paid a deposit lonc month's rent) and arrent month's rent Ck, 1003 13 11 12 06/18 Received a bill from The LA Times for advertising during the month af December,2,501, Inv. Lar #198 14 | 12 | 12/08/18 Purchased furniture and fixtures for s 100,000 tuseful life is S years} Clc. 1001, Inv.1S37 5 13 12/09/1 a Purchased fr 161,050 nffice computers nd equipment from BestBuy useful life s 3 years usma corporate Chase Ink card. All credit card balances are paid in full on the 28th nf every monti 16 14 12/10/18 Bought an electric sign useful life is 3 years, from Mega L ght Sigus 5,500, putting S1,000 down, and placing the balance on account Ck #1004, Inv 6712. T | 15 | 12/11/18 Provided IT ervices to Client #1 UL1 wrount fur S25,5 10 16 12/1218 Perlormed ax billed Clicnt 2 for repair serviccs for 315,050 1 7 12 16/18 Received and paid bill from the City of 108 Angeles for license to do busines3 for the year of 2018;35, Ck 1009 (Miscellaneous Kxpensel. a | 18 | 12/16/18 Perfarmed conaultation services on con nt for Client #3.332,100 2 912/19/14 Perfarmed installatian serices an nccomt for Client t4, 105,000 22 20 12/20/18 Took all emplnyers out for a birthday celebration to Maestra's for 85,010, and paid bill by credit card 23 | 21 12/22/18 Paid the balance due to Supreme Computer Code CR. #1009, Inv #168 2 22 12/25 18 Psid salespersons submitted travel reiburseet request ur $100, Ck. 1012 85 23 1328,18 Reccived and paid the December 2018 clectric bill, 500, Ck, 1011. h | 24 | 12/29/ 18 Yinpary received bill from Auto nechanic for SfaCIC} due within 3C daya, nzu (19697 7 | 25 | 12/31/18 Declared and paid dividend of 5, DDD to each of the owners 26 12/311a Owners each purchased 1,0 additional shares stork for S25 per share 227 010519 Puid canmissions to salesperson 3 28 01/05/19 Couipry paid current nonthe rent 31 | 29 01/08/ 19 Paid un account lu The LA Times, $650. Ck. 41006, ltiv. LAT 198 230010919 Hircd a Dew salcs 88sociate for 8150,000 a ear Gerneral Jaurnals WarksheetMulti-Step Income Slatement Statement of RE Classified Balance Sheet Statement of CF Ratio Analyss+ Home Insert Draw Page Layout Formulas Data Review View ShareComments Bookman Old Style v 10 v K A. Wrap Text General 0 Conditional Format Cell Fcmatting as Table Stylas Insert Delete Format Sorl& Find & Merge & Center Snlect deas GENERAL JOURNAL Explanation or Memo Accurint Titles Ref Dr, Cr. 12/u/18a Cking Aunt To bonk purcha of malck Company borrowed 580.00 fror, Chase Rank at 5%. 3mmunTly fer 3 year: to firanoe further hiring: Checking Aocurt 8000000 Cimpany borrowed SHICAN, Iren Chase Hank al 5% anaually Ncble ler 3 years to lirano: hiring' n.nrn firra Terind cf 5 VrAT, Tlutting derwn $5. with the 1000000 Lioensed oumpater software Eem Supreme Computer Code fox 50,00 for a petod o5 yers puting dow 5,500 wath the balance due on U.18 1 Cs. MuS, Inv 15 Checking Aoccur Licensed campuler solLware Lem Supenx Computer Code k Acmunts Payab Lalana: due 111/18/18 ( 11128, Inv a 19 trchased t atumobiles ivans) Box $12,351 each to service customer als useful ife 15 5 years! Ch. #1002 bnv #13009111 81,20200 Cls king Auunt LEcught upplies on oocur.t froon Uffice Depot $1185, Lrv 1,185 ' Paid $251, tolal in kachold impoens logncral Checking Aoxunt 51,610.00 Paid a depitmth's reny and uents rent C Paid a depoeit jore onth's renti and current vonith's rent Ck 5,000.00 Cha king Auunt General Journals Worksheet Multi-Step Income Statement Statement of RE Classified Balance Sheet Statement of GFRatio Analysis+ Home Insert Draw Page Layout Formulas Data Review View Share -Comments Bookman Old Style10A A Conditional FrrmatCell nsert Delete Farmat Sart&ind -- Sv%, +ng48 l insert Delete harm at Merge & Center. Formatting as Table Styles Filter Select Account Titles Explanation or Meino Rel. C.f. Reived hi Iam A s fo advertisng. sl Inv 12/18AdwvrtiingF 51. Recrived a bl from Te LA Tnes x advertising. sUl, Inv Accxants Payabe 2 bU.u years) Ck #1C01. Inv #1537 00,000.0 Cash -CmkingAmunt jvats)Ch. #10111. Ins, a 1537 Purclliwa2 far $161.nsn 'ff."mFuars "ml equipmwmt fri"" 412/0918 Comuer and Offoe Equipment month) 181,050.00 Purhse for $161,050 officre oonpers and eqipment frum BestBuy useul Le is3 yearsl uKng orpurabe Chase Ink card. All crecat card balances are pud in full on the 2h of ery Accont Payabe Crecat Lards av, 6712 550mm Boaght an electric sigm frum Mega Light igns $5,5c0, pattirg $1,000 down, and plzcng the balrce cn accmtCk.1 Cash-Checking Aocurt Accvmt Payabe .00000 1.500.00 112/11/18 Receivable Service Rwven Trowided IT servioes bo Client unt fur $25,510 5,51000 551. Comnissians Hayable 552. G 12/12/18 Accoants Reccivable Pertermed and billkd Client 2 fox repair svics tor S.5,s0. Pectormed and billed Client 2 orepair sevies or 5.5,00. Performed and bille Client 42 for repir sevices for 515,0E0 Srvic Reven: 15,/060.00 Commissions Expense 1.505.00 1,55.00 Reccved and pad h bill o dy buainea lica, 3, k 35.NI 112/1Ml aneus Expens Recerved andnd the bill tor the ary basmess license, $35. Ck Transactions General Journals Worksheet Multi-Step Income Statement Statement of RE Classified Balance Sheel Staterment of CF Ratio Analysis + ShareComments Home Insert Draw Page Layout Formulas Data Review View Bookman Old Style 10 A* A Wrap Text Paste B 1 yv g. Av Merge & Center. $. % , 4: corditiona Tahia Stels Insert Delete Format Sort Find & Filter Seact deas GENERAL JOURNAL Date Account Titles Explanation or Memo Ref. Dr. 12/16/18 Kaocived and paad the ball fer the dty business oene 5, Lk Checking Aoocunt ,210.00 Lavable mo0 l'eriocred mstallaan serwoes on aooount for Client $1Udy 105,000.00 s Lavable Periocred installati ses on account for Chent 105,000.00 10.00 Took all eplcyees cut ix a biuthday ceebratien to Maestro's for 5MO, nd paic bill by credit card ayabie- Cred:t Carcs 5000 4,5.no Prid the balanoe due bo Supceme Cmpter Code Ck. v00 Checking Aoocun: Inv #108 50000 Paid salsrnsbmit travel imburau lar 0 2/23/18 Trael Fa Prid salespersonssubmibed travel eimbursement request for 100. C's, #1012 Checking Acoount 221litie Transaclions General Journals WarksheelMulli-Slep Income Slalermenl Stalenmernl of RE Classified Balarice Sheel a Slalement of CF Ralio Analysis + Home Insert Draw Page Layout Formulas Data Review View Share Comm Bookman Old Style v 10 v A. Wrap Text General Merge & Center v $v% , Conditional Forable Stells Paste gv-v I Insert Celete Format Sort & Filter. Find & Idea v Formatting as Table Sty es M68 GENDRAL TOURNAL Datc Account Titles Explanatian ar Memo Ref. Dr. Cr 12/28f18 Ualitics #101. Keceived and paid the Deoember 218 cecrx bll, $500, Ck #1011. 12:29 18 Reps Expese within 30 days Iv 019587 Cumpuny within 30 days rv 99 600.00 recvived bill frum auty rehai for $600 due ts Payable to0.00 12/31/18 Dividnds 5.000. on Owners ench purchased 1.000 additional sharessr $25 12131/18 Checking Aacunt per share Oers ench purchased 1.000 additional stares'stock fur 55 per share a Transactions General Journals workshoot Multi-Step Income Statement Statement of RE Classified Balance Shoot Statement of CF Ratio Analysis + Home Insert Draw Page Layout Formulas Data Review View ShareComments Wap Text | A" Bookman Old Style w 10 Mege & Center v | S.96 , Conditional Format Cell Formatting as Tabla Styles Insert De ete Format Sort&Find 8 FilterSelac deas Complete the worksheet below: PLATINUM IT SERVICES Adjusted Tial Halano Halance Shect Account Titles Dr Cr. Cast.-Checking Acont Moocuns Keceivable Deposits anur and FurniFixlur& Acotmulated Depre ahon-ul 2laed Deprecaton -FF&E 1Intangible Aet Seftware Lcense Aoccuns ayable 7 Notes Pavable 8missicns Payalbi Intst Payable 4Advertising Expense ! Miscellaneous Expense 7Kepairs bperse 5Itavel Lxpenses Meals and Lntaient Epenses n Expense Uilities Totals Inbre Fxe 7ppl.es F.spenw Depecintion Expense Background Chart of Accounts Fixed Assets List Instructions Transactions General Journals e Worksheet Multi-Step Income Statement Statement of RE CI + Home nsert Draw Page Layout Formulas Data Revie View Share Comments 82, Wrap Text Bookman Old Style10A A General Paste Conditional Format Cell Insert Delete Fornat Sort &Find & Ideas Formatting Table Styles Filter Select Complete the worksheot below PLATINUM IT SERVICES Adjusted Tial Halanc Kalance Sheet Adjustments Income Staten Account Titles Cr. Cr. Dr. Cy LJr. Dr. Cr. Service evenue 4 Adverlising Epense Trare Expenses Meas ard Entertunmen: Expenses Ucilities Total Interes Expense Income Sumamary Retained Earnings Totals Worksheet Multl-Step Income Background Chart of Accounts Fixed Assets List instructions Transactions eral Journals aStatement of REStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started