珍贵A-General Framework Chinese.xls

Chart Data Gr_Cover Gr_Debt Gr_Cash Economics WorkCap Depn Capex Op Costs Prodn Financials Assumptions Cover Avail Capacity Capn Case Comm Constn F_Scenario FClose Final Rampup Repay RMat sl_depn Spot Units Construction Cost S Curve 建设期S曲线 月Month p.a. No over Quarters at of capacity of CPI Yes Yes/No % p.a. % Total Revenue LLCR Calc Month Cum % Raw Normalised to 0.5 total (over months) using parabola formula y=ax^2+b a= b= $M First Last Prorata Debt Service PLCR Calc @ TOTALS Other Operating Costs Tax (1, 2 or 3) Gr_Cash Return to Equity Gr_Debt Gr_Cover Debt Outstanding (days past end Avail Pd) Calculation Rows (Not Printed) TO BE COMPLETED BY USER Avail =Assumptions!$C$26 Capacity =Assumptions!$C$42 Capn =Assumptions!$C$96 Case =Assumptions!$C$4 Comm =Assumptions!$C$45 Constn =Assumptions!$C$44 F_Scenario =Assumptions!$F$22 FClose =Assumptions!$C$25 Final =Assumptions!$C$29 Print_Area =Assumptions!$A$5:$M$105 Print_Titles =Assumptions!$1:$4 Rampup =Assumptions!$C$46 Repay =Assumptions!$C$27 RMat =Assumptions!$J$45 Spot =Assumptions!$C$39 Names 通用项目模型 假设条件 计算机模型Computer Model 目录Contents 菜单页Sheet 首页Cover 假设Assumptions 财务Financials 生产Prodn 经营成本Op Costs 折旧Depn 流动资金Working Cap 经济Economics 现金图Gr_Cash 债务图Gr_Debt 还债保障图Gr_Cover 数据图表Chart Data 注释Notes PTB 美元/吨US$/t 资金来源和应用 股本金Equity Funds 债务资金Debt Funds 资本投资Capital Expenditure 建设期发生利息 库存Inventory 提款总额 实际年限 资金报表按多少天计算Funds statement goes to 股本金是按照下列哪个顺序投入到项目中的Equity Paid In: 先期投入 按比例投入 最后投入 直接成本Direct Costs 产品销售 产品销售价格 数字Numbers 始于From 成本Cost 利息税前利润EBIT 利息Interest 按照贴现率 原材料库存 成品库存 资本成本 来源/(使用) Calculation Rows (Not Printed) 每年计算,公历年度Annual Calculations (calendar year) 净现金流Net Cash Flow 新股本New Equity 股本现金流Equity Cash Flow 偿还债务保障比例Debt Coverage Ratios 季度提款计算Quarterly Drawdown Calculations 股本金Available Equity Funds 股本金先出Equity First 使用股本金Equity Funds Used 债务融资比例Proportion Debt Financed 按比例Prorata 后出股本金Equity Last 债务金额Debt Available 利用的债务Debt Used 偿还债务保障比率Debt Coverage Ratios 可用于偿还债务现金Cash Available for Debt Service 偿还债务Debt Se