














































Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
2025 DCF MODELING LATEST EXAM WITH COMPLETE ACTUAL TEST QUESTIONS AND CORRECT DETAILED ANSWERS (CORRECT VERIFIED SOLUTIONS) NEWEST UPDATED VERSION 2025
Typology: Exams
1 / 54
This page cannot be seen from the preview
Don't miss anything!
1 - p(T/F)pOncepappropertypassetptypepispselectedpitpcannotpbepchangedp- pCorrectpAnswer- False.pInpthepDCFpversionpyoupcantpbutpinpenterprisepthepassetptypepCANpbepch angedpafterpitspcreated 1 - p(T/F)pThepanalysispbeginpdatepdefaultsptopthepcurrentpmonthpandpyearp- pCorrectpAnswer-True.pandp 100 pyearspisptheplongestpanalysispperiod 1 - Whichpsectionpinpthepnavigationppanepallowspusersptopupdatepapvarietypofpdi fferentpsettingsprangingpfrompmanagingpusersptopdatapimportpvalidationprulesp topreportpsettings?p-pCorrectpAnswer-controlppanel 1 - Whichpofpthepportfoliopapplicationptabspispbestpdescribedpbypthepfollowingpst atement?pThispapplicationpallowspusersptopcreatepandpviewpanalyticalpchartspa ndpgraphspbasedponpapcombinationpofppropertiespfrompthepportfoliop- pCorrectpAnswer-analysis 2 - Whatpispthepextensionpofpappropertypassetpfilepinparguspenterprise?p-
pCorrectpAnswer-.avux
B.pWhatpwillpbepthepactualpexpenseponpthepcashpflowpforpinsurance?p- pCorrectpAnswer-A.p80,
B.p80, 2 - pTopreplicatepapvaluepinpapspecificpmonthpofpeachpyearpduringpthepprojectpforpa pspecificpexpense,pyoupmustpclickpwhichpbuttonpinpthepAmount1pvariespwindo w?p-pCorrectpAnswer-copypcolumnptopend 3 - pWhatpispthepMarketprentpinp2025?prelevantpin fopfrompbookp(pgp47): marketprentpinp 2022 pisp 15 marketpinflationpratepisp5%pinp 2023 pandp2024,pthenpitpisp3%pinp2025,p 2026 pan dp 2027 p-pCorrectpAnswer-17. 3 - pWhatpispthepcpipinflationpratepinp 2024 preleva ntpinfopfrompbookp(pgp47): marketprentpinp 2022 pisp 15 cpipinflationpratepispshownpacrosspthepboardpasp0%p-pCorrectpAnswer-0.00% 3 - pWhenpcalculatingpapmarketpleasingpprofilepwithpthepuponpexpirationpsetptopren ew,penterprisep - pCorrectpAnswer-assumespap100%prenewal
p(T/F)pWhenpyouphavepaponeptimepincrease,porpanpincreasepthatphappenspatpdif ferentpincrementsporptimes,putilizepthepfixedpstepspunitpcolumnp- pCorrectpAnswer-False 4 - pWhenpenteringpanpavailablepdateppriorptopthepstartpdatepwithinptheprentproll,parg uspenterprisepwillpassume:p-pCorrectpAnswer- thepspacepispavailable,pbutpvacantpuntilpthepstartpdate 4 - pThepanalysispstartpdatepispjanuaryp2022.pAptenantspleasepstartpdatepispMarchp 2 022.pIfpwepwantptopshowptheplostpabsorption/pturnoverprentpforpthisptenant,pwhatp wouldpbepenteredpinpthepfollowingpfields? A.pAvailablepdatepfield: B.pStartpdatepfield:p-pCorrectpAnswer-A.pJanp 2022 B.pMarchp 2022 4 - p(T/F)pTheplostpabsorption/pTurnoverprentpbeingpreportedpforpthepmonthsppriorpto papleasepstartpwillpappearponpthepindividualptenantpcashpflow/pLPVpreportp- pCorrectpAnswer-False
pcalcppercentageprentpinfop fromptxtppgp88:ptenantpsiz e:p2,450pSF
work: (pgrp+pabsorptionp&pturnover)ppvacancypratep- pabsorptionpandpturnoverp(9600000p+p230000)pp5%p-p230,
pCalculateptheputilitiespexpense,pusingpthepfollowingpassumptionspproper typsize=p35,000pSF utilitiespexpense=p0.15/sf/yearp-->p35%pfixed occupancy=p80%p-pCorrectpAnswer- (expensesppfixed%)p+p(expensesppvariablep%ppoccupancyp%) ((35,000pp.15)pp.35)p+p((35,000pp.15)pp.65pp.80) 4,567. 5 - pAssumepthatpapproperty'spcampexpensepisp$30,000pperpyearpandp60%pfixedpt hepoccupancypofptheppropertypisp70%.pWhatpvaluepshouldpbepenteredpinpthepa mount1pfieldpinpthepoperatingptab?p-pCorrectpAnswer-30, 5 - pAssumepthatpapproperty'spcampexpensepisp$30,000pperpyearpandp60%pfixed.pth epoccupancypofptheppropertypisp70%.pWhatpispthepoperatingpexpensepamountpth atpwillpappearponpthepcashpflowpreport?p-pCorrectpAnswer- p(expenseppfixed%)p+p(expenseppvariablep%ppoccupancyp%) (30,000pp.60)p+p(30,000pp.40pp.70) =26,
appearponpthepcashpflowpreport?p-pCorrectpAnswer- (expenseppfixed%)p+p(expenseppvariablep%ppoccupancyp%) (30,000pp.60)p+p(30,000pp.40pp.70) =26, 5 - pWhatpwillptenantpAppaypinpreimbursementspinp 2017 pifptheyphavepap 2016 pbasepye arpstoppandpallpopexparepincludedpexceptptheprealpestateptaxes? info: tenantpApsize=p20,000ppro pertypsize=p25, totalpopexp2016=p404, resptaxesp2016=p80, totalpopexp2017=p466, resptaxesp2017=p82,400p-pCorrectpAnswer-((2017ptotalpopex-presptaxes)p- p(2016ptotalpopexp-presptaxes))pp(tenantpsize/ppropertypsize) (466109-82400)p-p(404703-80000)pp(20,000/25,000) =47,204. 5 - pWhatpwillptenantpAppaypinpreimbursementspinp 2018 pifpthepreimbursementpmeth odpispnetpandpallpoperatingpexpensesparepincludedpinptheprecovery? info: 2018 ptotalpopex=p482,710ptenan
pThepgrosspsaleppricepispcalculatedpbyptakingpthepNOIptopcapitalizepandpdividing pitpbypthep ,pwhenpusingpcappNOIp(12pmonthspafterpsale)p- pCorrectpAnswer-capprate 7 - p(T/F)papuserpcanpchangepthepholdplengthpforptheppropertypresalepbypselectingpeit herpholdpyearsporpapfixedpdatep-pCorrectpAnswer-true 7 - pCalculatepthepresalepvaluepofpthepbuildingpusingpthepfollowingpassumptio ns resalepmethod=pcapitalizepNOIp capprate=p6.5% NOI=p784, sellingpcosts=p3%padjustedpgrossp-pCorrectpAnswer-(NOI/pcapprate)p- p((NOI/pcapprate)ppsellingpcostp%) (784,567/6.5%)p-p((784,567/6.5%)pp3%) $11,708, 7 - pparameterspforpthepdiscountpratepchangepintervalponpthepIRRpmatricpreportpcan pbepchangedpinpthep tab?p-pCorrectpAnswer-assumptions 7 - pWithinpthepinvestmentsptab,pthep
tabpispusedptopcalculatepdebtp notespoutsidepofpthepAEpsystemp-pCorrectpAnswer-otherpdebt
10 - pactualspandpbudgetpinformationpcanpbepviewedponpa:p-pCorrectpAnswer- pallpofpthepabove!
WhichpispapbenefitptoputilizingpapChartpofpAccounts? A) EasierptoptrackpRevenues/Expenses B) StandardizespportfoliopforpnamespofpallpExpenses/Revenues C) Helpspwithpaccountingpsystempintegration. D) AllpofpthepAbovep-pCorrectpAnswer-D)pAllpofpthepAbove InpARGUSpEnterprise,pyoupcanponlypassignponepChartpofpAccountsptopapPortfoli o. A) True B) Falsep-pCorrectpAnswer-A)pTrue ThepDiscardpChangespoptionpwillpdiscardponlyptheplastpchangepyouphavepmadep toptheppropertyprecord. A) True B) Falsep-pCorrectpAnswer-B)pFalse Onlypuserspwithpappropriateppermissionspcanpaccesspallpofpthepfeaturespinpthep ControlpPanel.