CVA考试相关:关注CVA公众号和官网公布信息为准。有问题随时咨询CVA课程顾问-李老师,电话:17769955044,微信同号。

excel财务建模——筹资决策分析模型

财务建模 cva 210℃ 0评论

excel财务建模——筹资决策分析模型

筹资决策分析模型的建立方法:

筹资决策分析系统界面:

[转载]excel财务建模——筹资决策分析模型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财务建模——筹资决策分析模型

喜欢 (0)or分享 (0)


培训咨询:李老师,电话:17769955044,微信同号。

发表我的评论
取消评论
表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 本页网址
(4)个小伙伴在吐槽
  1. 很好的一个学习网站
    cva2019-06-25 21:39 回复
  2. I was more than happy to discover this site. I want to to thank you for your time just for this wonderful read!! I definitely appreciated every part of it and I have you saved as a favorite to look at new stuff in your blog.
    QQPokerRaja2019-04-09 11:50 回复
  3. I will right away grab your rss as I can not find your email subscription hyperlink or e-newsletter service. Do you've any? Please permit me realize so that I may just subscribe. Thanks.
    Domino992019-04-09 08:35 回复
  4. I appreciate, result in I found just what I was looking for. You've ended my 4 day long hunt! God Bless you man. Have a nice day. Bye
    DOminoQQ2019-04-09 02:17 回复