投行Excel财务建模学习资料

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

投行Excel财务建模学习资料（1） (90 Bytes, 需要: RMB 39 元)

2020-6-15 12:38:07 上传

需要: RMB 39 元  [购买]

配套资料和课程资料都在压缩包里
01 Accounting Fundamentals
    FrontPage.PNG
    BIWS-Excel-Shortcuts.pdf
    13LBO-Model-More-Advan.rar
    12-LBO-Model.rar
    11-Merger-Model-More-A.rar
    10-Merger-Model.rar
    09 More Advanced LBO Model.rar
    08 LBO Model.rar
    07 Merger Model.rar
    06 Valuation Summary.rar
    05 Discounted Cash Flow Analysis.rar
    04 Valuation Overview & Comparables.rar
    03 Equity Value, Enterprise Value & Multiples.rar
    02 Creating 3-Statement Projections.rar
    01 Accounting Fundamentals.rar
++++++++++++++
1
    01-Interview-Question-Model.xls
    01-BIWS-Accounting-Quick-Reference.pdf
    01-BIWS-Accounting-Interview-Reference.pdf
    01-AAPL-3-Statements.xls
    01-24-Linking-Statements.mp4
    01-24-Linking-Statements-Before.xls
    01-24-Linking-Statements-After.xls
    01-23-Cash-Flow-Statement.mp4
    01-23-Cash-Flow-Statement-Before.xls
    01-23-Cash-Flow-Statement-After.xls
    01-22-Balance-Sheet-Liabilities-SE.mp4
    01-22-Balance-Sheet-Liabilities-SE-Before.xls
    01-22-Balance-Sheet-Liabilities-SE-After.xls
    01-21-Balance-Sheet-Assets.mp4
    01-21-Balance-Sheet-Assets-Before.xls
    01-21-Balance-Sheet-Assets-After.xls
    01-20-Income-Statement.mp4
    01-20-Income-Statement-Before.xls
    01-20-Income-Statement-After.xls
    01-19-Making-iPhones-Part-2.mp4
    01-19-Making-iPhones-Part-2-Before.xls
    01-19-Making-iPhones-Part-2-After.xls
    01-18-Making-iPhones-Part-1.xls
    01-18-Making-iPhones-Part-1.mp4
    01-17-iPhone-Factories-Debt-Part-3.mp4
    01-17-iPhone-Factories-Debt-Part-3-Before.xls
    01-17-iPhone-Factories-Debt-Part-3-After.xls
    01-16-iPhone-Factories-Debt-Part-2.mp4
    01-16-iPhone-Factories-Debt-Part-2-Before.xls
    01-16-iPhone-Factories-Debt-Part-2-After.xls
    01-15-iPhone-Factories-Debt-Part-1.xls
    01-15-iPhone-Factories-Debt-Part-1.mp4
    01-14-Writing-Down-Debt.mp4
    01-14-Writing-Down-Debt-Before.xls
    01-14-Writing-Down-Debt-After.xls
    01-13-Goodwill-Impairment.xls
    01-13-Goodwill-Impairment.mp4
    01-12-Bailout.xls
    01-12-Bailout.mp4
    01-11-Raising-Paying-Off-Debt.xls
    01-11-Raising-Paying-Off-Debt.mp4
    01-10-Issue-Repurchase-Shares.xls
    01-10-Issue-Repurchase-Shares.mp4
    01-09-Dividends.xls
    01-09-Dividends.mp4
    01-08-Deferred-Income-Taxes.xls
    01-08-Deferred-Income-Taxes.mp4
    01-07-Deferred-Revenue.xls
    01-07-Deferred-Revenue.mp4
    01-06-Accrued-Expenses.xls
    01-06-Accrued-Expenses.mp4
    01-05-Inventory-LIFO-vs-FIFO.mp4
    01-05-Inventory-LIFO-vs-FIFO-Before.xls
    01-05-Inventory-LIFO-vs-FIFO-After.xls
    01-04-Inventory-Changes-Cash-Debt.xls
    01-04-Inventory-Changes-Cash-Debt.mp4
    01-03-Depreciation-Changes.xls
    01-03-Depreciation-Changes.mp4
    01-02-Walk-Through-Statements.mp4
    01-01-Interview-Model-Overview.mp4
+++++++++++++
2
    02-01-NOTES.txt
    1KB
    02-01-Overview.mp4
    14.5M
    02-01-Overview.xls
    46KB
    02-02-Income-Statement-Trends-After.xls
    47KB
    02-02-Income-Statement-Trends-Before.xls
    46KB
    02-02-Income-Statement-Trends.mp4
    18.2M
    02-03-Income-Statement-Projections-After.xls
    50KB
    02-03-Income-Statement-Projections-Before.xls
    47KB
    02-03-Income-Statement-Projections.mp4
    27.2M
    02-04-Balance-Sheet-Trends-After.xls
    50KB
    02-04-Balance-Sheet-Trends-Before.xls
    50KB
    02-04-Balance-Sheet-Trends.mp4
    21.9M
    02-05-Balance-Sheet-Projections-After.xls
    54KB
    02-05-Balance-Sheet-Projections-Before.xls
    50KB
    02-05-Balance-Sheet-Projections.mp4
    26.2M
    02-06-Cash-Flow-Statement-Projections-After.xls
    59KB
    02-06-Cash-Flow-Statement-Projections-Before.xls
    54KB
    02-06-Cash-Flow-Statement-Projections.mp4
    36.4M
    02-07-Linking-Statements-After.xls
    60KB
    02-07-Linking-Statements-Before.xls
    59KB
    02-07-Linking-Statements.mp4
    25.5M
    02-08-Amortization-After.xls
    60KB
    02-08-Amortization-Before.xls
    60KB
    02-08-Amortization.mp4
    15.5M
    02-09-Interest-After.xls
    61KB
    02-09-Interest-Before.xls
    60KB
    02-09-Interest.mp4
    21M
    02-10-Deferred-Taxes-After.xls
    64KB
    02-10-Deferred-Taxes-Before.xls
    63KB
    02-10-Deferred-Taxes.mp4
    21.2M
    02-11-Fix-BS-Problem-1-After.xls
    61KB
    02-11-Fix-BS-Problem-1-Before.xls
    61KB
    02-11-Fix-BS-Problem-1.mp4
    11.6M
    02-12-Fix-BS-Problem-2-After.xls
    66KB
    02-12-Fix-BS-Problem-2-Before.xls
    61KB
    02-12-Fix-BS-Problem-2.mp4
    17.4M
    02-13-Fix-BS-Problem-3-After.xls
    66KB
    02-13-Fix-BS-Problem-3-Before.xls
    62KB
    02-13-Fix-BS-Problem-3.mp4
    15.7M
    02-14-Fix-BS-Problem-4-After.xls
    66KB
    02-14-Fix-BS-Problem-4-Before.xls
    62KB
    02-14-Fix-BS-Problem-4.mp4
    24.1M
    02-15-Interview-Questions.mp4
    29.4M
    02-Apple-3-Statement-Projections.xls
    61KB
    02-BIWS-Balancing-Balance-Sheet.pdf
    174KB
    02-BIWS-Projections-Quick-Reference.pdf
    121KB
++++++++++++++++
3
    03-01-Equity-Market-Cap-After.xls
    66KB
    03-01-Equity-Market-Cap-Before.xls
    66KB
    03-01-Equity-Market-Cap.mp4
    16.1M
    03-02-Options-Overview.mp4
    9.1M
    03-02-Options-Overview.xls
    66KB
    03-03-Treasury-Stock-Method-After.xls
    66KB
    03-03-Treasury-Stock-Method-Before.xls
    66KB
    03-03-Treasury-Stock-Method.mp4
    18M
    03-04-TSM-Exercise-1-After.xls
    67KB
    03-04-TSM-Exercise-1-Before.xls
    66KB
    03-04-TSM-Exercise-1.mp4
    9.6M
    03-05-Convertibles.mp4
    15M
    03-05-Convertibles.xls
    67KB
    03-06-EV-vs-Equity-Value.mp4
    10.5M
    03-06-EV-vs-Equity-Value.xls
    67KB
    03-07-Calculating-EV-After.xls
    67KB
    03-07-Calculating-EV-Before.xls
    66KB
    03-07-Calculating-EV.mp4
    20.6M
    03-08-EV-Advanced-Additions.mp4
    23.8M
    03-08-EV-Advanced-Additions.xls
    68KB
    03-09-Key-Metrics-After.xls
    68KB
    03-09-Key-Metrics-Before.xls
    67KB
    03-09-Key-Metrics.mp4
    28.5M
    03-09-NOTES.txt
    3KB
    03-10-Valuation-Multiples-After.xls
    69KB
    03-10-Valuation-Multiples-Before.xls
    68KB
    03-10-Valuation-Multiples.mp4
    29.7M
    03-11-EV-vs-Equity-Value-Multiples.mp4
    18.6M
    03-11-EV-vs-Equity-Value-Multiples.xls
    70KB
    03-12-Interview-Questions.mp4
    23.3M
    03-Apple-Enterprise-Value.xls
    69KB
    03-BIWS-Equity-Value-Enterprise-Value.pdf
    296KB
    03-BIWS-Valuation-Metrics-Multiples.pdf
    135KB
++++++++++++++++++++
3
    04-01-Overview.mp4
    10.9M
    04-01-Valuation-Overview.xls
    115KB
    04-02-Selecting-Public-Comps-After.xls
    19KB
    04-02-Selecting-Public-Comps-Before.xls
    36KB
    04-02-Selecting-Public-Comps.mp4
    21.8M
    04-03-Public-Comps-Finding-Data-EV-Calc-After.xls
    29KB
    04-03-Public-Comps-Finding-Data-EV-Calc-Before.xls
    28KB
    04-03-Public-Comps-Finding-Data-EV-Calc.mp4
    33.6M
    04-04-HPQ-CS-11.24.2009.pdf
    302KB
    04-04-Public-Comps-Finding-Data-IS-Calc-After.xls
    29KB
    04-04-Public-Comps-Finding-Data-IS-Calc-Before.xls
    29KB
    04-04-Public-Comps-Finding-Data-IS-Calc.mp4
    19M
    04-05-Public-Comps-Operating-Data-After.xls
    121KB
    04-05-Public-Comps-Operating-Data-Before.xls
    117KB
    04-05-Public-Comps-Operating-Data.mp4
    26.2M
    04-06-Public-Comps-Valuation-Multiples-After.xls
    127KB
    04-06-Public-Comps-Valuation-Multiples-Before.xls
    122KB
    04-06-Public-Comps-Valuation-Multiples.mp4
    19M
    04-07-Largest-Tech-M&A-Update.pdf
    929KB
    04-07-Largest-Technology-Deals-After.xls
    20KB
    04-07-Largest-Technology-Deals-Before.xls
    22KB
    04-07-PwC-US-technology-MA-insights-2009.pdf
    1.2M
    04-07-PwC-US-technology-MA-insights-2010.pdf
    1.7M
    04-07-Selecting-Transaction-Comps.mp4
    17.4M
    04-07-Tech-M&A-Review-2008.pdf
    129KB
    04-07-Tech-M&A-Review-2009.pdf
    228KB
    04-08-Transaction-Comps-Multiples-After.xls
    131KB
    04-08-Transaction-Comps-Multiples-Before.xls
    129KB
    04-08-Transaction-Comps-Multiples.mp4
    19.1M
    04-Apple-Public-Comps-Transaction-Comps.xls
    131KB
    04-BIWS-Public-Comps-Precedent-Transactions.pdf
    276KB
+++++++++++
4
    04-01-Overview.mp4
    10.9M
    04-01-Valuation-Overview.xls
    115KB
    04-02-Selecting-Public-Comps-After.xls
    19KB
    04-02-Selecting-Public-Comps-Before.xls
    36KB
    04-02-Selecting-Public-Comps.mp4
    21.8M
    04-03-Public-Comps-Finding-Data-EV-Calc-After.xls
    29KB
    04-03-Public-Comps-Finding-Data-EV-Calc-Before.xls
    28KB
    04-03-Public-Comps-Finding-Data-EV-Calc.mp4
    33.6M
    04-04-HPQ-CS-11.24.2009.pdf
    302KB
    04-04-Public-Comps-Finding-Data-IS-Calc-After.xls
    29KB
    04-04-Public-Comps-Finding-Data-IS-Calc-Before.xls
    29KB
    04-04-Public-Comps-Finding-Data-IS-Calc.mp4
    19M
    04-05-Public-Comps-Operating-Data-After.xls
    121KB
    04-05-Public-Comps-Operating-Data-Before.xls
    117KB
    04-05-Public-Comps-Operating-Data.mp4
    26.2M
    04-06-Public-Comps-Valuation-Multiples-After.xls
    127KB
    04-06-Public-Comps-Valuation-Multiples-Before.xls
    122KB
    04-06-Public-Comps-Valuation-Multiples.mp4
    19M
    04-07-Largest-Tech-M&A-Update.pdf
    929KB
    04-07-Largest-Technology-Deals-After.xls
    20KB
    04-07-Largest-Technology-Deals-Before.xls
    22KB
    04-07-PwC-US-technology-MA-insights-2009.pdf
    1.2M
    04-07-PwC-US-technology-MA-insights-2010.pdf
    1.7M
    04-07-Selecting-Transaction-Comps.mp4
    17.4M
    04-07-Tech-M&A-Review-2008.pdf
    129KB
    04-07-Tech-M&A-Review-2009.pdf
    228KB
    04-08-Transaction-Comps-Multiples-After.xls
    131KB
    04-08-Transaction-Comps-Multiples-Before.xls
    129KB
    04-08-Transaction-Comps-Multiples.mp4
    19.1M
    04-Apple-Public-Comps-Transaction-Comps.xls
    131KB
    04-BIWS-Public-Comps-Precedent-Transactions.pdf
    276KB
+++++++++++++++++++++
5
    05-01-Overview-Assumptions.mp4
    8.3M
    05-01-Overview-Assumptions.xls
    134KB
    05-02-Projecting-Cash-Flows-After.xls
    136KB
    05-02-Projecting-Cash-Flows-Before.xls
    134KB
    05-02-Projecting-Cash-Flows.mp4
    26.1M
    05-03-Discounting-Cash-Flows-After.xls
    136KB
    05-03-Discounting-Cash-Flows-Before.xls
    136KB
    05-03-Discounting-Cash-Flows.mp4
    8.5M
    05-04-Mid-Year-Discount-After.xls
    137KB
    05-04-Mid-Year-Discount-Before.xls
    136KB
    05-04-Mid-Year-Discount.mp4
    7.2M
    05-05-Terminal-Value-Multiples-After.xls
    137KB
    05-05-Terminal-Value-Multiples-Before.xls
    137KB
    05-05-Terminal-Value-Multiples.mp4
    11.3M
    05-06-Terminal-Value-Gordon-Growth-After.xls
    137KB
    05-06-Terminal-Value-Gordon-Growth-Before.xls
    137KB
    05-06-Terminal-Value-Gordon-Growth.mp4
    12.9M
    05-07-Share-Price-Sensitivity-Tables-After.xls
    141KB
    05-07-Share-Price-Sensitivity-Tables-Before.xls
    137KB
    05-07-Share-Price-Sensitivity-Tables.mp4
    21.7M
    05-08-Walk-Through.mp4
    6.2M
    05-08-Walk-Through.xls
    141KB
    05-09-Interview-Questions.mp4
    28.8M
    05-09-Interview-Questions.xls
    141KB
    05-10-WACC-Overview-Assumptions-After.xls
    142KB
    05-10-WACC-Overview-Assumptions-Before.xls
    141KB
    05-10-WACC-Overview-Assumptions.mp4
    18.2M
    05-11-Unlevered-Beta-After.xls
    143KB
    05-11-Unlevered-Beta-Before.xls
    143KB
    05-11-Unlevered-Beta.mp4
    24.2M
    05-12-Calculating-Our-Beta-After.xls
    143KB
    05-12-Calculating-Our-Beta-Before.xls
    143KB
    05-12-Calculating-Our-Beta.mp4
    12.4M
    05-13-Cost-of-Equity-WACC-After.xls
    144KB
    05-13-Cost-of-Equity-WACC-Before.xls
    143KB
    05-13-Cost-of-Equity-WACC.mp4
    10.1M
    05-14-Interview-Questions.mp4
    24.1M
    05-14-Interview-Questions.xls
    144KB
    05-Apple-DCF.xls
    144KB
    05-BIWS-DCF-Quick-Reference.pdf
    269KB
+++++++++++++++
    06-01-Linking-Methodologies-After.xls
    140KB
    06-01-Linking-Methodologies-Before.xls
    136KB
    06-01-Linking-Methodologies.mp4
    40.5M
    06-02-Football-Field-After.xls
    154KB
    06-02-Football-Field-Before.xls
    151KB
    06-02-Football-Field.mp4
    19.4M
    06-03-Interview-Questions.mp4
    33M
    06-03-Interview-Questions.xls
    154KB
    06-Apple-Complete-Valuation.xls
    154KB
    Bonus
+++++++++++++
    07-01-Merger-Model-Overview.xls
    181KB
    07-01-Overview.mp4
    14.4M
    07-02-Transaction-Assumptions-After.xls
    181KB
    07-02-Transaction-Assumptions-Before.xls
    181KB
    07-02-Transaction-Assumptions.mp4
    18.7M
    07-03-Buyer-Seller-IS-After.xls
    184KB
    07-03-Buyer-Seller-IS-Before.xls
    182KB
    07-03-Buyer-Seller-IS.mp4
    26.3M
    07-03-RIMM-Caris-Research-03.09.2010.pdf
    327KB
    07-04-Combining-IS-After.xls
    185KB
    07-04-Combining-IS-Before.xls
    184KB
    07-04-Combining-IS.mp4
    19.3M
    07-05-Accretion-Dilution-After.xls
    186KB
    07-05-Accretion-Dilution-Before.xls
内容太多，下列省略
…………
等等

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏5 回帖

关键词：EXCEL 学习资料 财务建模 xcel exce