Excel Crash Course Exam from Wall Street Prep – Wall Street Prep Questions And Answers Updated 2024
Instructions: nQuestions n1-4 nuse nthe nfinancial nmodel non ntab nQ1-4 nin nthe nExam nWorkbook. nComplete nthe nmodel nby nfilling nin nthe nblank ncells nbefore nanswering nthe nquestion nbelow. nAnswers nshould nbe nrounded nto nthe nnearest nwhole nnumber, ncomma nseparating n000s, nNOT nwritten nin ncurrency nformat. nSo nif nthe nanswer nis n$5,505,210.50, nyou nwould ninput n5,505,210.
1. What nis nforecast nRevenue nin n2017? n13,642,021
2. What nis nforecast nNet nIncome nin n2016? n925,777
3. If nDepreciation&Amortization nas na n% nof nCapital nExpenditures nis nchanged nto n30%, nwhat nis nNet nIncome nin n2017? n1,123,438
4. What nis nthe nEBITDA n% nMargin nin n2018? n17.1%
Instructions: nQuestions n5-19 nuse nthe ndata ntable non ntab nQ5-19 nin nthe nExam nWorkbook. nWe nstrongly nrecommend nyou nanalyze nthis ndata nwith nthe naid nof na npivot ntable. nYou nmay nalso nbenefit nfrom nadding nsome nextra ncalculation ncolumns nto nthe ndataset.
Answers nfor nnumerical ndata nshould nbe nrounded nto nthe nnearest n1 ndecimal, ncomma nseparating n000s, nNOT nwritten nin ncurrency nformat. nSo nif nthe nanswer nis n$10,500.658, nyou nwould ninput n10,500.7.
Over nthe nentire nanalysis nperiod, nwhich nsales nrep nsold nthe nhighest
