Exam (elaborations)
Trading Comps Modeling Wall StreetPrep – update veryfied questions with correct answers guaranteed pass.
Institution
Wall Street Prep
Trading Comps Modeling Wall StreetPrep – update veryfied questions with correct answers guaranteed pass.Trading Comps Modeling Wall StreetPrep – update veryfied questions with correct answers guaranteed pass.Trading Comps Modeling Wall StreetPrep – update veryfied questions with correct ans...
[Show more]
Uploaded on
November 20, 2024
Number of pages
9
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
Institution
Wall Street Prep
Course
Wall Street Prep
$11.99
100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached
Trading Comps Modeling Wall StreetPrep – update
Q&A
•
Whatbvisbvgenerallybvnotbvconsideredbvtobvbebvabvpre-taxbvnon-
recurringbv(unusualbvorbvinfrequent)bvitem?bv-bvExtraordinarybvgains/losses
whatbvisbvfalsebvaboutbvdepreciationbvandbvamortizationbv-
bvD&Abvmaybvbebvclassifiedbvwithinbvinterestbvexpense
CompanybvX'sbvcurrentbvassetsbvincreasedbvbybv$40bvmillionbvfrombv2007-
2008bvwhilebvthebvcompaniesbvcurrentbvliabilitiesbvincreasedbvbybv$25bvmillionbvoverbvthebv
samebvperiod.bvthebvcashbvimpactbvofbvthebvchangebvinbvworkingbvcapitalbvwasbv-
bvabvdecreasebvofbv15bvmillion
thebvfinalbvcomponentbvofbvanbvearningsbvprojectionbvmodelbvisbvcalculatingbvinterestbvexp
ense.bvthebvcalculationbvmaybvcreatebvabvcircularbvreferencebvbecausebv-
bvinterestbvexpensebvaffectsbvnetbvincome,bvwhichbvaffectsbvFCF,bvwhichbvaffectsbvthebvam
ountbvofbvdebtbvabvcompanybvpaysbvdown,bvwhich,bvinbvturnbvaffectsbvthebvinterestbvexpens
e,bvhencebvthebvcircularbvreference
abv10-qbvfinancialbvfilingbvhasbvallbvofbvthebvfollowingbvcharacteristicsbvexceptbv-
bvissuedbvfourbvtimesbvabvyear.
DepreciationbvExpensebvfoundbvinbvthebvSG&Abvlinebvofbvthebvincomebvstatementbvforbvabv
manufacturingbvfirmbvwouldbvmostbvlikelybvbebvattributablebvtobvwhichbvofbvthebvfollowingbv-
bvcomputersbvusedbvbybvthebvaccountingbvdepartment
Ifbvabvcompanybvhasbvprojectedbvrevenuesbvofbv$10bvbillion,bvabvgrossbvprofitbvmarginbvofbv6
5%,bvandbvprojectedbvSG&Abvexpensesbvofbv$2billion,bvwhatbvisbvthebvcompany'sbvoperati
ngbv(EBIT)bvmargin?bv-bv45%
Abvcompanybvhasbvthebvfollowingbvinformation,bv1.bv2014bvrevenuesbvofbv$5bvbillion,2013bv
Accountsbvreceivablebvofbv$400bvmillion,bv2014bvaccountsbvreceivablebvofbv$600bvmillion,bv
whatbvarebvthebvdaysbvsalesbvoutstandingbv-bv36.5
Abvcompanybvhasbvthebvfollowingbvinformation:
•bv2014bvRevenuesbvofbv$8bvbillion
•bv2014bvCOGSbvofbv$5bvbillion
•bv2013bvAccountsbvreceivablebvofbv$400bvmillion
•bv2014bvAccountsbvreceivablebvofbv$600bvmillion
•bv2013bvInventoriesbvofbv$1bvbillion
•bv2014bvInventoriesbvofbv$800bvmillion
•bv2013bvAccountsbvpayablebvofbv$250bvmillion
•bv2014bvAccountsbvpayablebvofbv$300bvmillion
Whatbvarebvthebvinventorybvdaysbvforbvthebvcompany?bv-bv65.7bvdays
, Trading Comps Modeling Wall StreetPrep – update
Q&A
•
Whichbvofbvthebvfollowingbvisbvtruebv-
bvCocabvCola'sbvbrandbvnamebvisbvnotbvreflectedbvasbvanbvintangiblebvassetbvonbvitsbvbalanc
ebvsheet
Abvcompanybvhasbvthebvfollowingbvinformation:
•bv2014bvsharebvrepurchasebvplanbvofbv$4bvbillion
•bvAveragebvsharebvpricebvofbv$60bvforbvthebvyearbv2013
•bvExpectedbvEPSbvgrowthbvforbv2014bvofbv10%
Whatbvshouldbvthebvnumberbvofbvsharesbvrepurchasedbvbybvthebvcompanybvbebvinbvyourbvfi
nancialbvmodel?bv-bv60.6bvmillion
non-controllingbvinterestbv-
bvisbvanbvexpensebvonbvthebvincomebvstatementbvandbvequitybvobvthebvbalancebvsheet
Abvcompanybvhasbvthebvfollowingbvinformation:
•bv2013bvretainedbvearningsbvbalancebvofbv$12bvbillion
•bvNetbvincomebvofbv$3.5bvbillionbvinbv2014
•bvCapexbvofbv$200bvmillionbvinbv2014
•bvPreferredbvdividendsbvofbv$100bvmillionbvinbv2014
•bvCommonbvdividendsbvofbv$400bvmillionbvinbv2014
Whatbvisbvthebvretainedbvearningsbvbalancebvatbvthebvendbvofbv2014?bv-bv15bvbillion
inbvorderbvtobvfindbvoutbvhowbvmuchbvcashbvisbvavailablebvtobvpaybvdownbvshortbvtermbvdebt,b
vsuchbvasbvrevolvingbvcreditbvline,bvyoubvmustbvtakebv-bvbeginningbvcashbvbalancebv+bvpre-
debtbvcashbvflowsbv-bvmin.bvcashbvbalancebv-
bvrequiredbvprincipalbvpaymentsbvofbvLTbvandbvotherbvdebt
tobvcalculatebvinterestbvexpensebvinbvthebvfuture,bvyoubvshouldbvdobvwhichbvofbvthebvfollowin
gbv-
bvapplybvabvweightedbvaveragebvinterestbvratebvtimesbvthebvaveragebvdebtbvbalancebvoverbvt
hebvcoursebvofbvthebvyear
enterprisebv(transaction)bvvaluebvrepresentsbvthe:bv-
bvvaluebvofbvallbvcapitalbvinvestedbvinbvabvbusiness
Abvdebtbvholderbvwouldbvbebvprimarilybvconcernedbvwithbvwhichbvofbvthebvfollowingbvmultipl
es?
I.bvEnterprisebv(Transaction)bvValuebv/bvEBITDA
II.bvPrice/Earnings
III.bvEnterprisebv(Transaction)bvValuebv/bvSalesbv-bv1bvandbv3bvonly
OnbvJanuarybv1,bv2014,bvsharesbvofbvCompanybvXbvtradebvatbv$6.50bvperbvshare,bvwithbv40
0bvmillionbvsharesbvoutstanding.bvThebvcompanybvhasbvnetbvdebtbvofbv$300bvmillion.bvAfterb
vbuildingbvanbvearningsbvmodelbvforbvCompanybvX,bvyoubvhavebvprojectedbvfreebvcashbvflow
bvforbveachbvyearbvthroughbv2020bvasbvfollows: