- 0000 T-Mobile Wi-Fi 4:57 PM 4796 instructure-uploads.s3.amazonaws.com have been hirod as an accountant for NFT Consuting Inc. This business was crealed when some friends decided to make use of their newly minted college degrees and po inte business together. The busines was created on November 1, 2017 The company will have a fiscal ycar end of October 3 The initial formation ransactions and early parchases for NFT Consaing Inc resued in the belances are included in the fist 2 columas of the Wiorkshect e the workshoot tab) Nvember, the first month of operations, the follewing transactions occurred I-Nov Paid $7.300 for 12 months rent on office space -Nov Parchasedtice funitare for 58.950 Nov Parchased $11,354 of additional office supplies on account lomo" ed 20,000 from he bank fr operating cash The now has a 3% interest rate .smple moreso and 8-Now is to be paid back in 4 1S-Nov Reveived $10,800 fhom Fortuna Ing. for work to be performed over the next 12 months 21-Nov Performed services for various customers for $13,200 cash and another SI100nt 25-Nov Paid $8,650 or parchases of supplics previsuly made on account -Nov Paid salaries to employees totaling $5,200 for 0-Nov Collectod $12.300 as payment for amounts 0-Nov Dividnds of $3,000 were declared and weck adjastments are needed 0-Nov One month of the prepaid rent has been used up 30-Nov Supplies on hand are 58.150 3 0-Nov One moeth of interest has crued on the note payable foe the banik loan 30-Nov One moeth of the services foe the Fortuna Inc. bas been performed( 30-Nov Salaries of $5.200 are paid every Friday (foe a 5 day woek week). Novemmber 30, 2017 was a Thurnday Additional work foe customers of $9,580 has been performod during the last wock of November but yet billed 0-Nov Deprocistion esxpetse foe the computer equipment is $140 and for the office furniture i $120 SUGGESTED STEPS FOR COMPLETION OF THE PROJECT oumal entrics to recoed the November transactions given Please refer to the Wokshect tab for Nocount Tales you may need id the November journal entry information to the Worksheet in the November columns You can de this in one of 2 ways-(1) Post the journall entries to ledger accounts using T-accounts to represent accounts and them use those sotals to pest to the worksheet or (2) use escel to add all entrics for account into the comect colamn in the worksheet (ie add all cash debits fhom the journal into the cash debit column for November entries). There is a tab to usc for T Accounts if you wa but they are NOT sequired Prepare an unadjusted trial balance as of November 30, 2017. Tis will be part of the Werkshect you project to oblain full credi Po the adjusting entries to the Adjusting entries colmns os the uorksheet 3 ppare There is a tab in this file that you will use for this. Excel forulas must be used theouphout the 4 Prepare adjusting entries for the month of Nowesber given the information Prepare an adjusted trial halance as of November 30, 2017. This will be part of the Woreksheet you There is a ab in this file that you will use for this Prepare financial statcments for the moath ending November 30, 2017.(Income Statement, Stunicment o Retained Eamings, Classified Balance Sheet.Formanting is impertat and will be gradell so be sare yo dollar signs and underlines as appeopriale Also be surc you have headings and proper colum sas for all statemets. There is a tab Sor these staiements.Heading are PARTIALLY compiletied Sor the 3 sanements Prepare elosing es for the end of the pariod Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab and the Financial Sanements from the Financial Statements tab to the Financial Statements tab Highlight the entie woksheet/inancial statements area sespecively and peess the 'etfl" key and thekey. This will cause the formulas wed to display instead of the mumbers Save your file with the formulas displayod REQUIRED TO BE SUBMITTED Ybmit your escel file which mest inclede Joursal estris trial balasces, the worksheet, the financial statemvats, and the armulars tabs te the ceerect asigaments link on the class Canvas site by 5 pm Saturday February 3. Your file must be aamed- "Your name first and last) Prejeet I". Failure to ame your file vectly wlrelin 2 peint deduction Each student mest subsit a ORIGINAL eie hat is their own werk. While studeuts are enceuraged te week together, each student mast process and format hs/her own sct of escel - 0000 T-Mobile Wi-Fi 4:57 PM 4796 instructure-uploads.s3.amazonaws.com have been hirod as an accountant for NFT Consuting Inc. This business was crealed when some friends decided to make use of their newly minted college degrees and po inte business together. The busines was created on November 1, 2017 The company will have a fiscal ycar end of October 3 The initial formation ransactions and early parchases for NFT Consaing Inc resued in the belances are included in the fist 2 columas of the Wiorkshect e the workshoot tab) Nvember, the first month of operations, the follewing transactions occurred I-Nov Paid $7.300 for 12 months rent on office space -Nov Parchasedtice funitare for 58.950 Nov Parchased $11,354 of additional office supplies on account lomo" ed 20,000 from he bank fr operating cash The now has a 3% interest rate .smple moreso and 8-Now is to be paid back in 4 1S-Nov Reveived $10,800 fhom Fortuna Ing. for work to be performed over the next 12 months 21-Nov Performed services for various customers for $13,200 cash and another SI100nt 25-Nov Paid $8,650 or parchases of supplics previsuly made on account -Nov Paid salaries to employees totaling $5,200 for 0-Nov Collectod $12.300 as payment for amounts 0-Nov Dividnds of $3,000 were declared and weck adjastments are needed 0-Nov One month of the prepaid rent has been used up 30-Nov Supplies on hand are 58.150 3 0-Nov One moeth of interest has crued on the note payable foe the banik loan 30-Nov One moeth of the services foe the Fortuna Inc. bas been performed( 30-Nov Salaries of $5.200 are paid every Friday (foe a 5 day woek week). Novemmber 30, 2017 was a Thurnday Additional work foe customers of $9,580 has been performod during the last wock of November but yet billed 0-Nov Deprocistion esxpetse foe the computer equipment is $140 and for the office furniture i $120 SUGGESTED STEPS FOR COMPLETION OF THE PROJECT oumal entrics to recoed the November transactions given Please refer to the Wokshect tab for Nocount Tales you may need id the November journal entry information to the Worksheet in the November columns You can de this in one of 2 ways-(1) Post the journall entries to ledger accounts using T-accounts to represent accounts and them use those sotals to pest to the worksheet or (2) use escel to add all entrics for account into the comect colamn in the worksheet (ie add all cash debits fhom the journal into the cash debit column for November entries). There is a tab to usc for T Accounts if you wa but they are NOT sequired Prepare an unadjusted trial balance as of November 30, 2017. Tis will be part of the Werkshect you project to oblain full credi Po the adjusting entries to the Adjusting entries colmns os the uorksheet 3 ppare There is a tab in this file that you will use for this. Excel forulas must be used theouphout the 4 Prepare adjusting entries for the month of Nowesber given the information Prepare an adjusted trial halance as of November 30, 2017. This will be part of the Woreksheet you There is a ab in this file that you will use for this Prepare financial statcments for the moath ending November 30, 2017.(Income Statement, Stunicment o Retained Eamings, Classified Balance Sheet.Formanting is impertat and will be gradell so be sare yo dollar signs and underlines as appeopriale Also be surc you have headings and proper colum sas for all statemets. There is a tab Sor these staiements.Heading are PARTIALLY compiletied Sor the 3 sanements Prepare elosing es for the end of the pariod Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab and the Financial Sanements from the Financial Statements tab to the Financial Statements tab Highlight the entie woksheet/inancial statements area sespecively and peess the 'etfl" key and thekey. This will cause the formulas wed to display instead of the mumbers Save your file with the formulas displayod REQUIRED TO BE SUBMITTED Ybmit your escel file which mest inclede Joursal estris trial balasces, the worksheet, the financial statemvats, and the armulars tabs te the ceerect asigaments link on the class Canvas site by 5 pm Saturday February 3. Your file must be aamed- "Your name first and last) Prejeet I". Failure to ame your file vectly wlrelin 2 peint deduction Each student mest subsit a ORIGINAL eie hat is their own werk. While studeuts are enceuraged te week together, each student mast process and format hs/her own sct of escel