Excel Crash Course Exam from Wall
ii! ii! ii! ii ! ii! ii ! ii!
Street Prep - Wall Street Prep Questions And
ii! ii ! ii! ii! ii! ii ! ii! ii! ii !
Answers Updated 2025 ii! ii! ii!
ii!
ii!
ii!
, Instructions:po Questionspo 1-
4po usepo thepo financialpo modelpo onpo tabpo Q1-
4po inpothepoExampoWorkbook.poCompletepothepo modelpobypofillingpoinpothe
poblankpocellspo before poansweringpothepoquestionpo below. poAnswers posho
uldpobeporoundedpotopo theponearestpowholeponumber, pocommaposeparatin
gpo000s,poNOTpowrittenpo inpocurrencypoformat.poSopo ifpothepoanswerpoispo$
5,505,210.50,poyoupowouldpoinputpo5,505,210.
1. WhatpoispoforecastpoRevenuepoinpo2017?po13,642,021 ii!
2. WhatpoispoforecastpoNetpoIncomepoinpo2016?po925,777 ii!
3. IfpoDepreciation&Amortizationpoaspoapo%poofpoCapitalpoExpendit
urespoispochangedpotopo30%,powhatpoispoNetpoIncomepoinpo2017
ii!
?po1,123,438
ii! ii!
4. WhatpoispothepoEBITDApo%poMarginpoinpo2018?po17.1% ii!
ii!
Instructions:poQuestionspo5-
19pousepothepodatapotablepoonpotabpoQ519poinpothepoExampoWorkbook.poWe
postronglypo recommendpoyoupo a
nalyzepothispodatapowithpothepoaidpoofpoapopivotpotable.poYoupomayp
ii!
o alsopobenefitpofrompoaddingposome poextrapocalculationpocolumnspo
ii!
topothepodataset.
ii! ii!
Answerspoforponumericalpodataposhouldpobeporoundedpotopotheponear
estpo1podecimal,pocommaposeparatingpo000s,poNOTpowrittenpoinpocu
ii!
rrencypoformat.poSopoifpothepoanswerpoispo$10,500.658,poyoupowoul
ii!
dpoinputpo10,500.7.
ii! ii!
5. Overpothepoentirepoanalysispoperiod,powhichposalesporepposoldpothep
ohighestpocumulative poquantity poofpoaposinglepoitem?
ii! ii!
RobpoStewart ii!
6. Inpothepolastpoquestionpoyoupodeterminedpotheposalespopersonpowhopos
old pothe
ii! ii!
, highestpocumulativepoquantitypoofpoaposinglepoitem.poWhatpoispothepoite
mpo codepoofpothatpoitem?
ii! ii!
16 ii!
7. Overpothepoentirepoanalysispoperiod,powhatpoispotheposecondpohighest
posellingpoitempocode pobypoquantity?
ii! ii!
39 ii!
ii!
8. Overpothepoentirepoanalysispoperiod,powhatpoispothepohighestposellingpoit
empocodepobypoquantity?
ii! ii!
16 ii!
ii!
ii!
9. Onlypoconsideringpopostalpocodespo93372,po93403poandpo93434,po
whichpopostalpocodepohadpothepohighestpototalpoprofitpoduringpothepom
ii!
onthpoofpoMarch?po93372
ii! ii!
ii!
10. Inp o thepolastpoquestionpoyoupodeterminedpothepopostalpocodepot
ii! ii!
ii! hatpohadpothepohighestpototalpoprofitpoduringpothepomonthpoofpoMarch.
ii! poWhat powaspothe poprofit?po13691.4 ii!
ii!
11. DuringpothepomonthpoofpoApril,powhichpopostalpocodepoboughtpothep
omo stpoofpoitempo13 poby poquantity?
ii! ii!
93558 ii!
ii!
12. Inpothepolastpoquestion,poyoupodeterminedpothepopostalpocodepothat
po b
ii! oughtpothepomostpoofpoitempo13pobypoquantitypoforpothepomonthpoofpoApr
ii! il.poWhatpowaspothatpoquantity? ii!
24 ii!
ii!
13. WhatpoispothepototalpoofpoAmypoAdam’sposalespooverpothepoanalysis
ii! poperiod?po492,153.8 ii!
ii!
ii! ii! ii! ii ! ii! ii ! ii!
Street Prep - Wall Street Prep Questions And
ii! ii ! ii! ii! ii! ii ! ii! ii! ii !
Answers Updated 2025 ii! ii! ii!
ii!
ii!
ii!
, Instructions:po Questionspo 1-
4po usepo thepo financialpo modelpo onpo tabpo Q1-
4po inpothepoExampoWorkbook.poCompletepothepo modelpobypofillingpoinpothe
poblankpocellspo before poansweringpothepoquestionpo below. poAnswers posho
uldpobeporoundedpotopo theponearestpowholeponumber, pocommaposeparatin
gpo000s,poNOTpowrittenpo inpocurrencypoformat.poSopo ifpothepoanswerpoispo$
5,505,210.50,poyoupowouldpoinputpo5,505,210.
1. WhatpoispoforecastpoRevenuepoinpo2017?po13,642,021 ii!
2. WhatpoispoforecastpoNetpoIncomepoinpo2016?po925,777 ii!
3. IfpoDepreciation&Amortizationpoaspoapo%poofpoCapitalpoExpendit
urespoispochangedpotopo30%,powhatpoispoNetpoIncomepoinpo2017
ii!
?po1,123,438
ii! ii!
4. WhatpoispothepoEBITDApo%poMarginpoinpo2018?po17.1% ii!
ii!
Instructions:poQuestionspo5-
19pousepothepodatapotablepoonpotabpoQ519poinpothepoExampoWorkbook.poWe
postronglypo recommendpoyoupo a
nalyzepothispodatapowithpothepoaidpoofpoapopivotpotable.poYoupomayp
ii!
o alsopobenefitpofrompoaddingposome poextrapocalculationpocolumnspo
ii!
topothepodataset.
ii! ii!
Answerspoforponumericalpodataposhouldpobeporoundedpotopotheponear
estpo1podecimal,pocommaposeparatingpo000s,poNOTpowrittenpoinpocu
ii!
rrencypoformat.poSopoifpothepoanswerpoispo$10,500.658,poyoupowoul
ii!
dpoinputpo10,500.7.
ii! ii!
5. Overpothepoentirepoanalysispoperiod,powhichposalesporepposoldpothep
ohighestpocumulative poquantity poofpoaposinglepoitem?
ii! ii!
RobpoStewart ii!
6. Inpothepolastpoquestionpoyoupodeterminedpotheposalespopersonpowhopos
old pothe
ii! ii!
, highestpocumulativepoquantitypoofpoaposinglepoitem.poWhatpoispothepoite
mpo codepoofpothatpoitem?
ii! ii!
16 ii!
7. Overpothepoentirepoanalysispoperiod,powhatpoispotheposecondpohighest
posellingpoitempocode pobypoquantity?
ii! ii!
39 ii!
ii!
8. Overpothepoentirepoanalysispoperiod,powhatpoispothepohighestposellingpoit
empocodepobypoquantity?
ii! ii!
16 ii!
ii!
ii!
9. Onlypoconsideringpopostalpocodespo93372,po93403poandpo93434,po
whichpopostalpocodepohadpothepohighestpototalpoprofitpoduringpothepom
ii!
onthpoofpoMarch?po93372
ii! ii!
ii!
10. Inp o thepolastpoquestionpoyoupodeterminedpothepopostalpocodepot
ii! ii!
ii! hatpohadpothepohighestpototalpoprofitpoduringpothepomonthpoofpoMarch.
ii! poWhat powaspothe poprofit?po13691.4 ii!
ii!
11. DuringpothepomonthpoofpoApril,powhichpopostalpocodepoboughtpothep
omo stpoofpoitempo13 poby poquantity?
ii! ii!
93558 ii!
ii!
12. Inpothepolastpoquestion,poyoupodeterminedpothepopostalpocodepothat
po b
ii! oughtpothepomostpoofpoitempo13pobypoquantitypoforpothepomonthpoofpoApr
ii! il.poWhatpowaspothatpoquantity? ii!
24 ii!
ii!
13. WhatpoispothepototalpoofpoAmypoAdam’sposalespooverpothepoanalysis
ii! poperiod?po492,153.8 ii!
ii!
