会计数据分析 Solutions-Manual Chapter-1-Labs-SM

Copyright©2019McGraw-HillEducation.Allrightsreserved.NoreproductionordistributionwithoutthepriorwrittenconsentofMcGraw-HillEducation.

CHAPTER1LABS–KEY

(Level1Header)Lab1-0Howtocompletelabsinthisbook

Instructorinformation:Thislabisverysimple,andexiststohelpstudentsfamiliarizethemselveswiththeformatoflabsandwithhowtotakeascreenshotandpasteitintoaWordDocument.Thiskeycontainsonlythescreenshotsthatwillbesimilartowhatastudentmaycomeupwithwhilecompletingthislab.

Part1:CreateanewWorddocumentonOneDrive

NoKey

Part2:Takeascreenshotofyourdocument

Keyscreenshot:

Part3:Addanotherscreenshotandsubmityourdocument

Keyscreenshot:

EndofLab

(Level1Header)Lab1-1DataAnalyticsinFinancialAccounting

Becauseeveryquestioninthislabisopen-ended,thereisnokeyprovided.

Examplesolution:

Part1:Has[CompanyX’s]grossmarginincreasedinthelastthreeyears?

Part2:

AppleInc.’sgrossmarginhasincreasedslightlyinthepastthreeyears.

CompanyName=EntitySectorIndustryClassificationPrimary

GrossMargin=GrossProfit

SalesRevenues=SalesRevenueNet

CostofGoodsSold=CostOfGoodsAndServicesSold

Year=DocumentPeriodEndDate

Part3:

ExampleSolutions

Part1:Questions

Part2:HypothesizedAnswer

Part2:

Tables/Fields/Tags

Otherdata:

Has[CompanyX's]currentratioincreasedoverthepastfouryears?

Target'scurrentratiohasincreasedslightlyoverthepastfiveyears

CompanyName=EntitySectorIndustryClassificationPrimary

CurrentAssets=AssetsCurrent

CurrentLiabilities=LiabilitiesCurrent

Year=DocumentPeriodEndDate

None

Whatwas[CompanyX's]rateofincrease/decreaseofgrossprofitthispastyear?

Target'sgrossprofitincreasedby3%thispastyear

CompanyName=EntitySectorIndustryClassificationPrimary

NetIncome=NetIncomeLoss

TotalAssets=Assets

Year=DocumentPeriodEndDate

None

Has[CompanyX's]debt-to-equityratiodecreasedoverthepastfouryears?

Target'sdebt-to-equityratiohasincreasedoverthepast5years

CompanyName=EntitySectorIndustryClassificationPrimary

TotalLiabilities=Liabilities

Stockholder'sEquity=StockholdersEquity

Year=DocumentPeriodEndDate

None

Whiletheselabsshouldremainopen-endedinthetextbook,wecanguidestudentsabitinConnect:

PossibleConnectExercises:

Part1(Given):HowhasAppleInc.’sgrossmarginchangedinthepastthreeyears?

Part2:

Selectanappropriatehypothesizedanswertothequestionabovefromthelist:

[Correct]AppleInc.’sgrossmarginincreasedby3%inthepastthreeyears.

AppleInc.’srevenuesdeclinedinthepastthreeyears.

AppleInc.’snetincomeasapercentageofsalesremainedconstantinthepastthreeyears.

AppleInc.’snewproducthashadapositiveimpactonsales.

(Ifpossible,aninterestingConnectactivitywouldbetoshowtheoriginalquestionwithdrop-downlistsandhavestudentsselectthevariables)

e.g.Howhas[AppleInc.’s|CompanyName][grossmargin|(Sales–CostofGoodsSold)/Sales][changed|Y2/Y1]inthepastthree[years|Year]?

Distracters:

CompanyName

SalesRevenue

CostofGoodsSold

Sales-CostofGoodsSold

(Sales-CostofGoodsSold)/Sales

Year

Industry

Y2/Y1

%

MatchdataelementsfromthepreviousquestiontoXBRLtagsthatwouldprovidedatatoanswerthequestionfromPart1.Ifthedataelementrequiresacalculation,choose“Expression”

CompanyName=EntitySectorIndustryClassificationPrimary

GrossMargin=Expression

SalesRevenues=SalesRevenueNet

CostofGoodsSold=CostOfGoodsAndServicesSold

Change=Expression

Year=DocumentPeriodEndDate

Distracters:

Expression

GrossProfit

EntitySectorIndustryClassificationPrimary

SalesRevenueNet

CostOfGoodsAndServicesSold

DocumentPeriodEndDate

ProfitLoss

Part3:(CurrentlyaliveGoogleSheet.WecouldpossiblysimulateinConnectasaspreadsheetwithAppledata.Inthiscase,astudentwouldenteratagfromthepreviousstepandinthebackgroundaVLOOKUPcouldreturnthedatavalue.Thoughts?)

(Level1Header)Lab1-2DataAnalyticsinManagerialAccounting

Becauseeveryquestioninthislabisopen-ended,thereisnokeyprovided.

Examplesolution:

Part1:

2.Wheredoesthecustomerlive?

3.Hypothesis:riskycustomerslikelyliveincoastaltowns.

4.City,state,zipcode

Part2:

Zip_code,addr_state

ExampleSolutions

Part1:Questions

Part2:HypothesizedAnswer

Part2:

Tables/Fields/Tags

Otherdata:

Doesthecustomerhavemanycreditaccounts?

Riskycustomerslikelyhavemanycreditaccounts

1.customer’smembernumber(member_id)

2.Thenumberofcreditaccountsacustomerhas(total_acc)

3.Thecustomer’stotalavailablecredit(revol_bal)

Howlongistheemploymenttimeofthecustomer?

Peoplewithshortemploymenttimearepotentialriskycustomers

1.customer’smembernumber(member_id)

2.Thelengthoftheemploymenttime(emp_length)

3.thetotaltimeoffull-timeworkexperience

Totalemploymentlength

Howlongwillthecustomerpaybacktheloan?

Riskycustomersarelikelytohavelongertimeforpayment.

1.customer’smembernumber(member_id)

2.Thetimelengthcustomerspromisedtopaybacktheloan

Loanterm

Whiletheselabsshouldremainopen-endedinthetextbook,wecanguidestudentsabitinConnect:

PossibleConnectExercises:

Part1(Given):Docustomerswithlatepaymentsliveinthesameareas?

Part2:

Selectanappropriatehypothesizedanswertothequestionabovefromthelist:

[Correct]Customerswithlatepaymentsareevenlygeographicallydistributed.

Customerswithlatepaymentshavehighcreditutilization.

Customersinsomestateshavemorepaymentplansthanothers.

Someareashavecustomerswithalongeremploymenthistory.

(Ifpossible,aninterestingConnectactivitywouldbetoshowtheoriginalquestionwithdrop-downlistsandhavestudentsselectthevariables)

e.g.Do[customers|Name]with[latepayments|Numberoflatepayments]liveinthesame[areas|State]?

Distracters:

Name

State

Numberoflatepayments

Employmentlength

Debt-to-incomeratio

Paymentplan

Creditutilization

Applicationtype

Loandate

MatchdataelementsfromthepreviousquestiontoavailablefieldsprovidedbyLendingClubthatwouldprovidedatatoanswerthequestionfromPart1.Ifthedataelementrequiresacalculation,choose“Expression”

NameorID=member_id

Numberoflatepayments=delinq_2y

State=addr_state

Distracters:

member_id

delinq_2y

addr_state

dti

revol_util

purpose

emp_length

open_acc

(Level1Header)Lab1-3DataAnalyticsinAuditing

Becauseeveryquestioninthislabisopen-ended,thereisnokeyprovided.

Examplesolution:

Part1:

Areanyshippingmanagersapprovingshipmentsmorethantwodaysaftertheyarereceived?

Hypothesis:Only1or2shippingmanagersareapprovingshipmentsmorethantwodaysaftertheyarereceived.

ApproverID,orderdate,approvaldate

Part2:

Shipments_Made_YYYYMMDD_YYYYMMDDtableandApproved_By,Entered_Date,andApproved_Datefields

ExampleSolutions

Part1:Questions

Part2:HypothesizedAnswer

Part2:

Tables/Fields/Tags

Otherdata:

Howlongwillittakefromreceivingsalesorderstoshipmentsmade?

Goodinternalcontrolshouldtake1-3daysfromreceivingsalesorderstoshipmentsmade

1.Salesordersdate

2.Shipmentsdate

3.Salesordersid

4.Shipmentsid

Sales_Orders_YYYYMMDD_YYYYMMDD

Sales_Order_ID

Sales_Order_Date

Shipments_Made_YYYYMMDD_YYYYMMDD

Shipment_ID

Shipment_Date

None

Whatisthepercentageoferrorstototalshipments?

Goodinternalcontrolshouldhaveerrorpercentageunder1%

1.thetotalnumberoferrorsconcerningshipmentsforaquarter

2.thetotalnumberofshipmentsforaquarter

3.Theshipmentid

Shipments_Made_YYYYMMDD_YYYYMMDD

Shipment_ID

Shipment_Period

None

Howlongwillittakefromsendingsalesinvoicetoopeningaccountsreceivable

Goodinternalcontrolshouldfinishtheprocesswithinoneday

1.thedateofsendingsalesinvoice

2.invoiceid

3.thedateofopeningaccountsreceivable

4.thecustomermembershipid

5.thetransactiondate

6.thebalanceamount

Invoices_Generated_YYYYMMDD_YYYYMMDD

Invoice_ID

Invoice_Date

Open_Accounts_Receivable_YYYYMMDD

Customer_Account_ID

Transaction_Date

Balance_Amount

None

Whiletheselabsshouldremainopen-endedinthetextbook,wecanguidestudentsabitinConnect:

PossibleConnectExercises:

Part1(Given):Areanyshippingmanagersapprovingshipmentsmorethantwodaysaftertheordersarereceived?

Part2:

Selectanappropriatehypothesizedanswertothequestionabovefromthelist:

[Correct]Customerswithlatepaymentsareevenlygeographicallydistributed.

Customerswithlatepaymentshavehighcreditutilization.

Customersinsomestateshavemorepaymentplansthanothers.

Someareashavecustomerswithalongeremploymenth