Dùng Excel trong phân tích tài chính

Thảo luận trong 'Phân tích báo cáo tài chính' bắt đầu bởi Simon, 27/7/06.

Trạng thái chủ đề:
Không mở trả lời sau này.
  1. Simon

    Simon Guest

    Mình có quyển phân tích tài chính bằng excel muốn chia sẻ cùng các bạn. Các bạn download về xem nhé.

    Download

    Cheers;)
     
                   
  2. vongphuc

    vongphuc New Member Hội viên mới

    Cảm ơn Simon, bạn có file mẫu kèm theo sách ko share cho mình với?
     
  3. haivan

    haivan New Member Hội viên mới

    các bạn có bài mẫu nào không chứ đuă phần mền lên mà không có thực hành và hướng dẩn cụ thể thì coi như chưa tốt lắm!
    thank nếu có bài mẫu!
     
  4. canhnh

    canhnh New Member Hội viên mới

    Tập hợp các mô hình phân tích tài chính trong Excel

    Gửi tặng các bạn Saganors yêu thích các mô hình tài chính trong bảng tính Microsoft Excel. Tất cả mô hình đều miễn phí và có nguồn gốc từ địa chỉ này .

    1. Top Five Capital Budgeting Analysis (xls) - Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc. - Adamodar Damodaran
    2. Rating Calculation (xls) - Estimates a rating and cost of debt based on the coverage of debt by an organization - Adamodar Damodaran
    3. LBO Valuation (xls) - Analyzes the value of equity in a leverage buyout (LBO) - Adamodar Damodaran
    4. Synergy (xls) - Estimates the value of synergy in a merger and acquisition - Adamodar Damodaran
    5. Valuation Models (xls) - Rough calculation for choosing the correct valuation model - Adamodar Damodaran
    6. Risk Premium (xls) - Calculates the implied risk premium in a market. (uses macro's) - Adamodar Damodaran
    7. FCFE Valuation 1 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates - Adamodar Damodaran
    8. FCFE Valuation 2 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth - Adamodar Damodaran
    9. FCFE Valuation 3 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with three stages of growth, high growth initially, decline in growth, and then stable growth - Adamodar Damodaran
    10. FCFF Valuation 1 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates - Adamodar Damodaran
    11. FCFF Valuation 2 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth - Adamodar Damodaran
    12. Time Value (xls) - Introduction to time value concepts, such as present value, internal rate of return, etc.
    13. Lease or Buy a Car (xls) - Basic spreadsheet for deciding to buy or lease a car.
    14. Top Five NPV & IRR (xls) - Explains Internal Rate of Return, compares projects, etc.
    15. Real Rates (xls) - Demonstrates inflation and real rates of return.

     
    ntngocgiao1703 thích bài này.
  5. canhnh

    canhnh New Member Hội viên mới

    16. Template (xls) - Template spreadsheet for project evaluation & capital budgeting.
    17. Top Five Free Cash Flow (xls) - Cash flow worksheets - subsidized and unsubsidized.
    18. Capital Structure (xls) - Spreadsheet for calculating optimal capital structures using different percents of debt.
    19. WACC (xls) - Calculation of Weighted Average Cost of Capital using beta's for equity.
    20. Statements (xls) - Generate a set of financial statements using two input sheets - operational data and financial data.
    21. Bond Valuation (zip) - Calculates the value or price of a 25 year bond with semi-annual interest payments.
    22. Buyout (zip) - Analyzes the effects of combining two companies.
    23. Cash Flow Valuation (zip) - Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.
    24. Financial Projections (zip) - Spreadsheet model for generating projected financials along with valuation based on WACC.
    25. Leverage (zip) - Shows the effects on Net Income from using debt (leverage).
    [​IMG]
     
  6. canhnh

    canhnh New Member Hội viên mới

    26. Ratio Calculator (zip) - Calculates a standard set of ratios based on input of financial data.
    27. Stock Value (zip) - Calculates expected return on stock and value based on no growth, growth, and variable growth.
    28. CFROI (xls) - Simplified Cash Flow Return on Investment Model.
    29. Financial Charting (zip) - Add on tool for Excel 97, consists of 6 files.
    30. Risk Analysis (exe) - Analysis and simulation add on for excel, self extracting exe file.
    31. Black Scholes Option Pricing (zip) - Excel add on for the pricing of options.
    32. Cash Flow Matrix - Basic cash flow model.
    33. Business Financial Analysis Template for start-up businesses from Small Business Technology Center
    34. Forex (zip) - Foreign market exchange simulation for Excel
    35. Hamlin (zip) - Financial function add-on's for Excel
    36. Tanly (zip) - Suite of technical analysis models for Excel
    37. Financial History Pivot Table - Microsoft Financials
    38. Income Statement What If Analysis
    39. Breakeven Analysis (zip) - Pricing and breakeven analysis for optimal pricing - Biz Pep.
    40. SLG Ratio Master (exe) - Excel workbook for creating 25 key performance ratios.
    41. DCF - Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management by Robert C. Higgins - Analysis for Financial Management
    42. History - Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management by Robert C. Higgins - Analysis for Financial Management
    43. Proforma - Menu driven Excel program (must enable macros) for Pro-forma Financial Statements from the book Analysis for Financial Management by Robert C. Higgins - Analysis for Financial Management
    44. Business Valuation Model (zip) - Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet. Bizpep
    45. LBO Model - Excel model for leveraged buy-outs
     
  7. canhnh

    canhnh New Member Hội viên mới

    46. Comparable Companies - Excel valuation model comparing companies
    47. Combination Model - Excel valuation model for combining companies
    48. Top Five Balanced Scorecard - Set of templates for building a balanced scorecard.
    49. Cash Model - Template for calculating projected financials from CFO Connection
    50. Techniques of Financial Analysis - Workbook of 11 templates (breakeven, valuation, forecasting, etc.) from ModernSoft
    51. Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios from Agilicor
    52. Risk Analysis IT - Template for assessing risk of Information Technology - Audit Net
    53. Risk Analysis DW - Template for assessing risk of Data Warehousing - Audit Net
    54. Top Five Excel Workbook 1-2 - Set of worksheets for evaluating financial performance and forecasting - Supplemental Material for Short Course 1 and 2 on this website.
    55. Rule Maker Essentials - Excel Template for scoring a company by entering financial data - The Motley Fool
    56. Rule Maker Ranker - Excel Template for scoring a company by entering comparable data - The Motley Fool
    57. IPO Timeline - Excel program for Initial Public Offerings (must enable macros)
    58. Assessment Templates - Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.
    59. Cash Gap in Days - Spreadsheet for calculating number of days required for short-term financing.
    60. Cash Flow Template - Simple cash flow model with explanations of each cash flow component - Arkansas Small Business Development Center.
     
  8. canhnh

    canhnh New Member Hội viên mới

    61. Six Solver Workbook (zip) - Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.).
    62. Free Cash Flow Valuation - Basic Spreadsheet Valuation Model
    63. Finance Examples - Seven examples in Business Finance - Solver
    64. Capital Budgeting Workbook - Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.
    65. Present Value Tables (rtf) - Set of present value tables written in rich text format, compatible with most word processors. Includes examples of how to use present value tables.
    66. Investment Valuation Model (zip) - Valuation model of companies (must enable macros) - Excel Business Tools
    67. Cash Flow Sensitivity (xlt) - Sensitivity analysis spreadsheet - Small Business Store
    68. What If Analysis - Set of templates for sensitivity analysis using financial inputs.
    69. Risk Return Optimization - Optimal project selection (must enable macro's) - Metin Kilic
    70. CI - Basics #1 - Basic spreadsheet illustrating competitive analysis - Business Tools Templates.
    71. CI - Basics #2 - Basic spreadsheet illustrating competitive analysis - Business Tools Templates.
    72. External Assessment - Assessment questions for organizational assessment (must enable macros).
    73. Internal Assessment - Assessment questions for organizational assessment (must enable macros).
    74. Formal Scorecard - Formal Balanced Scorecard Spreadsheet Model (3.65 MB / must enable macros) - Madison Area Quality Improvement Network.
    75. Project Plan - Project Scheduling Template currently setup for a Balanced Scorecard Project.
     
  9. canhnh

    canhnh New Member Hội viên mới

    76. Gantt Chart - Gantt chart for project management with work plan - Jim Chapman's Web Site
    77. E O Q Model - Simple Inventory Models for calculating Economic Order Quantity.
    [​IMG]

    78. Inventory Simulation Control Model - Formal model for simulating inventory shortages, delivery times, costs, backorders, and optimal inventory levels - John McClain
    79. Financial Projections Model - A comprehensive financial model for forecasting a complete set of financials with breakeven and valuation tabs developed by Frank Moyes and Stephen Lawrence at Leeds School of Business.
    80. Option Trading Workbook - Educational toolkit for using Excel for Options - Option Trading Tips
    81. Financial Model - A nice clean financial model driven by different calculators (such as Company, Market, Subscribers, etc.) developed by Bill Snow.
    82. Forecasting Model - Step by step financial model for forecasting financials created by Sam Gui
    83. Economic Evaluation - Step by step workbook for evaluating the economics of a system investment - Automated Concepts

     
  10. mrbang

    mrbang New Member Hội viên mới

    Choáng quá, chẳng hiểu gì cả. Sao bạn giỏi vậy, truyền nghề cho tui chút đi. Nếu bạn có thời gian giải thích từng công cụ một thì mình cám ơn lắm. Sorry nha vì mình hơi bị dốt tài chính nhưng rất muốn tìm hiểu. :001_wub:
     
  11. deal

    deal New Member Hội viên mới

    Cảm ơn bạn nhé!:thumbup1:
     
  12. phamthiquyen

    phamthiquyen New Member Hội viên mới

    Oa oa

    :ohmy: anhnh! bạn cho tất cả những người không biết như mình lên mây xanh hết rùi. Đọc xong chẳng hiểu gì cả. Giải thích và chỉ dần giùm tui đi
    Thanksss
     
  13. Simon

    Simon Guest

    Bạn nói thế thì chắc mất mấy năm mới giải thích hết. Phần nào bạn quan tâm mà thấy chưa rõ thì cùng nêu ra và thảo luận nhé.

    :laugh:
     
  14. letran

    letran New Member Hội viên mới

    Chao cac ban, cac ban gui cac file rat hay, nhung hau het la van ban tieng anh. Neu duoc cac ban co the gui cac file tieng viet duoc k? Thnks you rat nhieu. Ah tien the co ai chi cho minh cach danh tieng viet dc hay k? Minh la thanh vien moi ma li..... Hi Hi cam on nhieu nhe!
     
  15. doiconxanh

    doiconxanh New Member Hội viên mới

    Tuyệt vời!

    Đúng là những công cụ mình cần để phân tích, cảm ơn các bạn nhé!
     
  16. cayman

    cayman Banned Thành viên BQT Hội viên mới

    bạn sử dụng vietkey hoặc Unikey,chọn font Unicode để gõ được tiếng Việt. Thân !
     
  17. gemvn

    gemvn New Member Hội viên mới

    em đang cần mẫu về phân tích điểm hòa vốn, download mục breakeven analysis ở trên về xem thì thích quá, nhưng sao chỉ cho dùng thử có 7 ngày à, anh chị nào có bản free thì cho em với. cám ơn nhìu nhìu.
     
  18. ngoc_ha735

    ngoc_ha735 New Member Hội viên mới

    chào bạn

    mình cũng rất khâm phục bạn đó.Bạn cho mình bí quyết với vì mình cũng là dân kế toán nhưng mình học dốt lắm
    mong bạn giúp mình hiểu cặn kẽ hơn vấn đề này
    Cảm ơn bạn nhiều
     
  19. thu170279

    thu170279 New Member Hội viên mới

    Ðề: Dùng Excel trong phân tích tài chính

    Cho mình hỏi với: Quyển phân tích tài chính bằng excel có viết bằng tiếng việt không?
    Mình đã dowload nhưng toàn tiếng Anh mình không hiểu.
    Cảm ơn bạn
     
    quan thủy thích bài này.
  20. hien48

    hien48 New Member Hội viên mới

    Ðề: Dùng Excel trong phân tích tài chính

    ui trời, nhiều thiệt, thanks bạn. Mình đang rất cần những thứ này.
     
Trạng thái chủ đề:
Không mở trả lời sau này.

Chia sẻ trang này

XenForo Add-ons by Brivium ™ © 2012-2013 Brivium LLC.