excel财务建模——筹资决策分析模型
筹资决策分析模型的建立方法:
筹资决策分析系统界面:
以上共有五个命令按钮
他们的宏代码分别为:
借款分析按钮:
Sub loan()
loan Macro
Sheets(“借款”).Select
ActiveWindow.SmallScroll Down:=-2
ActiveWindow.SmallScroll ToRight:=-2
Range(“A1”).Select
End Sub
双变量分析按钮:
Sub double_analysis()
Sheets(“双变量分析”).Select
ActiveWindow.SmallScroll Down:=-2
ActiveWindow.SmallScroll ToRight:=-2
Range(“A1”).Select
End Sub
对比分析按钮:
Sub compare()
compare Macro
张 记录的宏 2000-11-14
Sheets(“筹资界面”).Select
ActiveWindow.NewWindow
Windows.Arrange ArrangeStyle:=xlTiled
ActiveWindow.ScrollWorkbookTabs Sheets:=1
Sheets(“借款”).Select
ActiveWindow.SmallScroll ToRight:=2
ActiveWindow.SmallScroll Down:=2
ActiveWindow.SmallScroll ToRight:=2
ActiveWindow.ScrollColumn = 3
ActiveWindow.SmallScroll ToRight:=2
Range(“I19”).Select
Windows(“1.XLS:1”).Activate
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
Sheets(“租赁”).Select
ActiveWindow.SmallScroll ToRight:=2
Range(“E22”).Select
End Sub
租赁分析按钮:
Sub rent()
Sheets(“租赁”).Select
ActiveWindow.SmallScroll Down:=-2
ActiveWindow.SmallScroll ToRight:=-2
Range(“A1”).Select
End Sub
结束按钮:
Sub closem()
ActiveWorkbook.Close
End Sub
转载请注明:CVA注册估值分析师 » excel财务建模——筹资决策分析模型