会计数据分析 Solutions_Manual Chapter_1_Labs_SM.docx

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[CompanyXs]currentratioincreasedoverthepastfouryears?

Targetscurrentratiohasincreasedslightlyoverthepastfiveyears

CompanyName=EntitySectorIndustryClassificationPrimary

CurrentAssets=AssetsCurrent

CurrentLiabilities=LiabilitiesCurrent

Year=DocumentPeriodEndDate

None

Whatwas[CompanyXs]rateofincrease/decreaseofgrossprofitthispastyear?

Targetsgrossprofitincreasedby3%thispastyear

CompanyName=EntitySectorIndustryClassificationPrimary

NetIncome=NetIncomeLoss

TotalAssets=Assets

Year=DocumentPeriodEndDate

None

Has[CompanyXs]debt-to-equityratiodecreasedoverthepastfouryears