PPP项目财务测算模型(公路)表格文件下载.xls
- 文档编号:13287600
- 上传时间:2022-10-09
- 格式:XLS
- 页数:307
- 大小:4.28MB
PPP项目财务测算模型(公路)表格文件下载.xls
《PPP项目财务测算模型(公路)表格文件下载.xls》由会员分享,可在线阅读,更多相关《PPP项目财务测算模型(公路)表格文件下载.xls(307页珍藏版)》请在冰豆网上搜索。
PleaseensurethatExcelsMacrosareenabledbeforeusingthemodel.ViabilityanalysismodelforPPPprojectsRoadssectorGovernmentofIndiaMinistryofFinanceDepartmentofEconomicAffairsDevelopercontactsDevelopedby:
@#@EconomicConsultingAssociatesinfoeca-Withassistancefrom:
@#@CRISILInfrastructureAdvisoryGoto:
@#@UserGuideVersioninformationVersionv5.2Date27June2011UserGuideColourcodesandbuttonsThedatainputsforthemodelaresetintwoways:
@#@usingthespinnerbuttonsor,wherethereisnospinner,enteringthenumbersdirectly.SpinnerbuttontochangevariableinLARGEstepsSpinnerbuttontochangevariableinSMALLstepsThemodelusesacolour-codetoindicatewheredatashouldbeenteredbytheuser:
@#@Cellvalue=PPPvariables,USERDEFINED.Enterdatainthebluecells,orusethespinnerstochangethecellvalue.Theseareaspectsoftheprojectwhichcanbevariedtotestviability.Cellvalue=PPPparameters,USERDEFINED.Theseareaspectsoftheprojectoreconomywhichtheusermaychangebutwhichwould,ingeneral,notbethesubjectofwhat-if?
@#@testing.Theusershouldchangetheseinfrequently.Cellvalue=Calculationcell.NOTUSERDEFINED.Cellvalue=Resultscell.Thesecellsshowresultsforimportantpartsofthemodel.Ahyperlinktotherelevantworksheet.BriefdescriptionofthemodelThismodelistohelpaProjectOfficerevaluatethefinancialviabilityofaPPPprojectintheroadssector.Viabilityistestedfromtheperspectiveofaprivatepartner(ie,looksataftertaxreturnscomparedtoexpectedafter-taxROEforacommercialdeveloper).TheProjectOfficershouldalsohaveasenseofthelevelofgovernmentsupportorotherprojectcharacteristics(eg.Tolllevels)thatareacceptabletothepublicsector.Themodeldoesnottestwhethertheprojectiseconomicallyjustifiedoroffersvalue-for-money(VFM)comparedtothepublicsectoralternative.Themodelismeanttoberelativelysimple.AmoredetailedmodelwillbecreatedaspartoftheFeasibilityStudy.Themodelcontainssixmainsheetsinthefollowingsequence:
@#@Set-upandinformationinputsheets:
@#@1.Set-up:
@#@HeretheuserentersbackgroundassumptionssuchastypeofPPP,theprojectlifeandmacroeconomicinformation.2.Demand:
@#@Theinitialdemandandforecastgrowthratesareenteredhere.3.CapEx:
@#@TheCapitalExpenditureisenteredonthissheet(forCapExprojectsonly-thesheetishiddenfornon-CapExprojects)Set-upCapExRevenueOpExCoverViabilityAnalysisUserGuideDemandWorksheetname4.OpEx:
@#@Theoperatingexpenditurerelatedtotheprojectisenteredonthissheet5.Revenue:
@#@Heretheusercansetsourcesandlevelsofrevenuefortheproject.Revenuecanbefromtollstousers,orfromgovernmentpaymentstotheconcessionaire.6.ViabilityAnalysis:
@#@Thisprovidesanoverallsummaryoftheprojectsfinancialviabilityfromaprivateinvestorsperspective.GraphsshowingprojectcashflowsandkeyfinancialratiosareprovidedaswellaskeysummaryvaluessuchastheNPVandIRR.Financialstatementsandcalculationsheetsarealsoprovidedforinformationpurposes.TheExportsheetallowsoutputsfromtheFinancialViabilitymodeltobeusedintheVFMIndicatortool.UsetheExportresultsbuttononSet-upsheettocreateanexportfile.Theuserisencouragedtotrywhat-if?
@#@analysisofprojectviability.Theusershouldenterafirstestimateoftheprojectparametersinsteps1-5andthentestviabilitybyrefiningkeyparameters(suchastiming,chargesandpayments,andfinancingmix)inordertoseeifviabilityisachievable.Thiscanbedonebymakingchangestotheprojectset-up,inparticularbyusingtheViabilityAnalysissheetandontheRevenuesheet.Theusercannavigatebetweenthesheetsusingthebuttonsatthetop.Note:
@#@ExcelMacrosmustbeenabledforthemodeltofunctionfully.TheseshouldbeenabledwhenthefileisopenedorusingExcelssecuritysettings.ThemodelcandisplaythenewRupeesymbol.Todisplayit,youmusthavetherupiforidianrontinstalledonyourcomputer.Ifitisnotinstalled,therupeesymbolwillappearasanR.TheCapExsheetishiddenforOpEx-onlyprojects.Allcashflowsareassumedtooccurattheendofeachfiscalyear,exceptwherenoted.Themodelallowsforperiodsmeasuredinhalf-years(forexample,ifconstructionwasexpectedtotake2.5years).Datesmightthenbeexpressedasmiddle-pointsofayear:
@#@eg,2013.5isthemiddleoftheyear2013.CashFlowIncomeStatmentBalanceSheetResultsExportThedatainputsforthemodelaresetintwoways:
@#@usingthespinnerbuttonsor,wherethereisnospinner,enteringthenumbersdirectly.SpinnerbuttontochangevariableinLARGEstepsSpinnerbuttontochangevariableinSMALLsteps=PPPvariables,USERDEFINED.Enterdatainthebluecells,orusethespinnerstochangethecellvalue.=PPPparameters,USERDEFINED.Theseareaspectsoftheprojectoreconomywhichtheusermaychangebutwhichwould,ingeneral,notbethesubjectofwhat-if?
@#@testing.Theusershouldchangetheseinfre
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- PPP 项目 财务 测算 模型 公路