本文考量於Excel介面下設計一「壽險公司現金流量模型」，透過保險財管、精算理論的採用與大量隨機模擬亂數的應用，欲建構一結合理論基礎與實務運用的動態財務分析系統雛形。 模型中，資產面的模擬項目共有七項：1.債券與放款：採用CIR或Vesicek兩利率模型供選擇進行利率期間結構生成，以模擬出各到期期限的債券及放款價格。2.股票：以資本資產訂價模型(CAPM)來模擬各類股股票價格的變動與股票投資報酬。3.不動產：使用幾何布朗運動模擬不動產價值與租金收入。4.國外投資：利用幾何布朗運動模擬匯率的變動。5.現金及銀行存款。6.應收款項，考量壞帳情況下，逐年比率攤回殘餘金額。7.其他資產。 負債面採用定期險、終身生死合險與遞延年金險模擬壽險公司業務經營的現金流量情況。藉由資產與負債的整合，可模擬出公司未來十年內各年度的損益情況，讓使用者了解於承受總體經濟各項不確定風險下，壽險公司資產面、負債面與業主權益的現金流量情況。 文末引用個案範例，進行實務操作的說明，示範如何應用本模型來進行最適資產配置決策與敏感度分析，以證明本系統的合理可行性。最後，並對此系統提出檢討與展望，期待後續研究可加入程式語言的應用而建構出一完備的動態財務分析系統。 / The main purpose of this study is to construct a dynamic cash flow testing for the life insurance company by using Excel. Through the adoption of financial and actuarial theories and the application of stochastic method, we want to provide a rudiment analysis framework of life dynamic financial model that combines theoretical basis and practical application. This analysis framework includes seven categories of assets. The simulation models or related issues for each category will be discussed accordingly. – 1. Bonds and mortgage loans: providing CIR and Vesicek interest rate model for users to generate the interest term structure. 2. Stocks: applying CAPM method to simulate the stock prices and stock returns. 3. Real estate and rental income: using Geometric Brownian Motion to simulate the price of real estate and the rental income. 4. Foreign investment assets: using Geometric Brownian Motion to simulate the movement of exchange rate. 5. Cash and Deposits. 6. Account Receivable: after considering bad loans, we amortize the residual account receivables for a specific period. On the liability side, we use three types of products - term life, whole life endowment, and deferred annuity - to generate the business profile as well as the cash flows patterns of the life insurance company. By integrating the asset and liability sides of the model, we can simulate the revenue of the company for the following ten years and enable the users to predict the future cash flows under uncertain financial conditions. Finally, applications of this model are presented as thoroughly as possible to educate the users about how to make the optimal asset allocation decisions and sensitive scenario analysis. The application results show that the model reasonably fits the desired results. Since the model presented here is not a complete DFA model, future researches may consider adding more refined component into the analysis framework like using programming language.

本文主要是針對保險業及退休基金的資產負債管理議題為研究重心，延續Huang (2004)的研究，其研究是以理論求解的方式求出多期最適資產配置的唯一解，而其研究也衍生出兩個議題：首先是文中允許資產買賣空;再者其模型僅解決單期挹注資金的問題，而不考慮多期挹注資金。但這對於實際市場操作上會有一些的問題。因此本文延續了其研究，希望解決這兩個議題，讓模型更能解出一般化的資產負債管理問題。 本文所選擇的投資的標的是以一般退休基金與保險業所採用，分別是短債(short-term bonds)、永續債卷(consols)、指數連結型債券(index-linked gilts(ILG))、股票(equity)為四種投資標的，以蒙地卡羅模型模擬出4000組Wilkie 投資模型(1995)下的四種標的年報酬率以及負債年成長率，利用這些預期的模擬值找出最適的投資比例以及應該挹注的金額。而本文主要將問題化為決策變數的二次函數，並以一般化最小平方法(generalized least square,GLS)來求出決策變數，而用此方法最大的優點在於一般化最小平方法具有唯一解，且在利用軟體求解的速度相當快，因此是非常有效率的。本文探討的問題可以分成兩個部分。我們首先討論「單期挹注資金」的問題，只考慮在期初挹注資金。接著我們考慮「多期挹注資金」的問題，是在計畫期間內能將資金分成多期投入。兩者都能將目標函數化為最小平方的形式，因此本文除了找出合理的資產配置以及解決多期挹注資金的問題之外，也將重點著重於找一個能快速且精準的方法來解決資產配置的問題。 / This paper deals with the insurance and pension asset liability management issue. Huang (2004) derives a theoretical close solution of multi-period asset allocation. However, there are two further problems in his paper. First, short selling is allowable. Second, multi-period investing is not acceptable. These two restrictions sometimes are big problems in practice. This paper extends his paper and releases these two restrictions. In other words, we intend to find a solution of multi-period asset allocation so that we can invest money and change proportion of investment in each period without problems of short selling. In this paper, we use the standard asset classes used by pension or insurance funds such as short-term bonds, consols, index-linked gilts and equities. We generate thousand times of Monte Caro simulations of Wilkie investment model (1995) to predict future asset returns. Furthermore, in order to improve time-efficiency and accuracy, we derive a quadratic objective function and obtain a unique solution using sequential quadratic programming.

巴塞爾銀行監督委員會(Basel Committee on Banking Supervision, BCBS) 於2010年發布巴塞爾資本協定三。為強化銀行流動性風險管理，新增兩項流動性風險量化衡量指標：流動性覆蓋比率(Liquidity Coverage Ratio, LCR)以及淨穩定資金比率(Net Stable Funding Ratio, NSFR)。我國於2015年開始將流動性覆蓋比率納入監管要求，亦將於2018年開始導入淨穩定資金比率。然而在提高銀行風險控管及標準的同時，銀行需考量其股東權益報酬。新規範的實施使銀行需要進行調整以符合法規，過往鮮少有研究針對本國銀行探討其資產配置調整與結構調整。本研究除探討個案銀行如何在巴塞爾資本協定三框架下調整其資產負債配置與結構，更進一步探討其各項調整對銀行之獲利能力以及各項法定比率之影響，希望能幫助銀行在未來調整結構之前能更了解其決策所帶來之影響。 本研究發現，在不提高資產負債表規模的情況下，可以透過銀行結構調整達到巴塞爾資本協定三於2019年之標準，同時提高銀行獲利能力；在適度提高資產負債表規模的情況之下，其獲利能力高於不提高資產負債表規模之情況。此外，本研究針對不同情境探討銀行應如何調整資產負債配置與銀行結構。風險趨避情境相較於風險偏好下，應在存放款方面，吸收更多長天期之存款、降低長期放款占比；資產配置方面則應增加政府公債占比。由於巴塞爾資本協定三採階段性實施，本研究針對個案銀行2015到2019 年之資產負債配置與銀行結構做研究，發現個案銀行隨著法規越趨嚴格，應提高公司債占比並同時降低權益類等相對風險較高之資產占比；另一方面為達到淨穩定資金比率要求，銀行應提高其長期存款占比。最後，本研究針對各項結構與資產負債配置調整做更深入的分析，探討其對於各項指標之敏感度，以實際的量化數字表示每項變動的影響，以利銀行在做決策時更了解其決策之利與弊。 / Basel Committee on Banking Supervision (BCBS) released Basel III in 2010. In order to ensure the maintenance and stability of funding and liquidity profiles of banks’ balance sheets, two liquidity standards, Liquidity Coverage Ratio(LCR) and Net Stable Funding Ratio(NSFR), were introduced in Basel III. To in line with international norm, Taiwan government plans to implement LCR and NSFR in 2015 and 2018 respectively. However, there is a trade-off between return and risk. With the implement of new law, how to adjust banks’ asset allocation becomes a critical issue. In this study, we focus on business structure and ways to adjust A bank’s asset allocation. We found that A bank can meet government’s requirements and increase it’s return on equity without increasing balance sheet size by adjusting business structure; In the situation where balance sheet size is increased, A bank can meet the requirements with higher return on equity than where the balance sheet size isn’t increased. In three different scenarios: risk seeking, risk neutral and risk aversion, we found that A bank should increase more long-term deposits and decrease long-term loans in risk aversion scenario than in risk seeking scenario. In risk aversion scenario, A bank should also hold more government bonds than in risk seeking scenario. From 2015 to 2019, the requirements become stricter and stricter, A bank should hold more corporate bonds and less securities. At the same time, A bank should increase more long-term deposits to meet the NSFR requirement. The research also shows how business structure and asset allocation changes can affect A bank’s related required ratio and return on equity. Our findings can help A bank makes more precise decision by knowing actual quantitative influence before they implement the new policies.

日本經濟自1990年起，由「日本第一」落入「流動性陷阱」，而陷入長達10多年的不景氣，主因是日本股市及不動產市場重挫，企業向銀行貸款所提供之擔保品價值下滑，卻因在低利率時代已過度借貸，又經營不善面臨虧損，發生償債困難，一旦財務有所改善，只想提前償還貸款，而無增加貸款意願，故稱為「資產負債表的衰退」（Balance Sheet Recession）。整體經濟景氣蕭條，國內需求不振，亦使振興經濟之寬鬆貨幣政策無法達到預期效果。 日本資產泡沫的破滅使銀行體系的逾放問題日益嚴重。日本政府為了加強銀行體系的健全性，實施金融改革（Big Bang）。使原本以傳統存、放款業務為主的銀行，在面臨國際化浪潮時，也能同時經營證券、保險業務，並將新金融商品引進日本。並由隸屬於內閣府的金融廳(Financial Services Agency)來監督日本銀行及證券業務，負責金融檢查及金融法規企劃業務，落實金融與財政分離之原則。但日本金融業務日益多元化，及衍生性金融商品日趨複雜，對金融監理機關之專業能力，形成新的挑戰。以上所述為日本國內的經濟與金融問題。 至於日圓對外幣的匯率方面，由於日圓利率偏低，套利交易(carry trade) 盛行。投資人趁著日本央行維持低利率之際，借入低成本的日圓資金，然後換成利率較高的外幣轉戰國際市場，追逐收益較高的資產，同時賺取利差、匯率及資產升值的價差，使日圓匯率的走勢疲弱，也造成全球金融市場的波動。 本論文的分析包含： ㄧ、日本經濟不景氣問題剖析：股市及不動產資產泡沫化 二、日本金融危機形成原因：資產價格下跌，影響抵押品價值，企業償債能力變差，故使銀行不良債權增加。 三、日本總體經濟近況（GDP、CPI、失業率的變化）及經濟復甦後日本央行貨幣政策的改變 四、日本金融市場如股市、房地產市場及日本政府債券（JGB）市場的分析及展望。 五、探討日本銀行業獲利能力、不良債權問題、資本適足率以及銀行業股價指數的變化。 六、根據台灣以及日本最近的發展對金融監理單位及銀行業提出應有的改革與建議。 / The Japanese economy fell into a “liquidity trap” in 1990. Due to the stock market and real estate market plunge, the deep recession has lasted for over 10 years. The bursting of asset bubbles caused the balance sheets of enterprises to become weaker and weaker. All companies hoped to reduce their debt to banks if they were profitable. They had no intention to reinvest any more. So it was called - Balance Sheet Recession. Even though the Bank of Japan adopted an easy monetary policy, the financial system remained vulnerable. With the bad debt of commercial banks increasing, the NPL (non-performing loan) problem has been a major concern for city banks and regional banks. Japan's "Big Bang" reforms radically altered its financial marketplace. The barriers separating banks, securities, and insurance companies were lowered. The Financial Services Agency replaced Ministry of Finance to oversee banking, securities and exchange and insurance in order to ensure the stability of the financial system. As for financial business diversified and derivative products complicated, there were many great challenges facing the financial regulatory authorities. During the past decade, the yen carry trade has become a target for many investors or speculators. Traders using this strategy attempt to capture the difference between the interest rates of two currencies. Taking USD/Yen for example, they borrowed the cheaper yen and invested in U.S. Treasuries yielding a higher interest rate. It causes the depreciation of Japanese Yen and increases the volatility of financial markets. This essay describes Japanese financial crisis, Japanese monetary policy, stock market, and real estate market. Besides, I analyze the profitability, capital adequacy, and non-performing problems of Japanese banks. Finally, I give my personal opinions on Taiwan and Japan’s banking industry.

自從美國於1999年11月通過金融現代化法案（Gramm-Leach-Bliley Act），排除銀行不得兼營證券及銀行控股公司不得兼營保險業務之規定，准許原銀行控股公司可申請改制為金融控股公司，並以此金融控股公司來經營銀行、證券及保險業務後，我國為尋求國內金融機構能與國際接軌，順應國際金融集團跨業經營之趨勢，遂於2000年通過「金融機構合併法」及「銀行法部分條文修正案」，隨後再於2001年6月26、27日通過包括「金融控股公司法」等之金融六法，期望透過金融機構間之合併與成立金融控股公司，整合銀行、證券、保險、票券等金融相關產業擴大金融機構之規模，透過金融控股公司之跨業平台來滿足客戶之需求，發揮金融資源整合之綜效(Synergy)，進而得以提升競爭力與獲利能力。 然而，本國金融控股公司自成立以來發展至今，有關金融控股公司之風險管理之組織、功能與執掌，除了金管會發布之「金融控股公司內部控制及稽核制度實施辦法」之第11條、第12條及第13條，規範金控須訂定適當之風險管理政策與程序，建立獨立有效風險管理機制、應設置獨立之專責風險控管單位，並定期向董事會提出風險控管報告及風險控管機制應包括之內容等原則性規範外，並未有其他較為詳盡之法令或可遵循之規範。 本論文以個案金融控股公司之實務運作為探討，期望可提供國內金融控股公司風險管理之運行之參考，吾人從此次2007及2008次貸風暴所形成之2008世紀金融大海嘯，亦可深知風險管理之重要性，金融機構之風險管理就如同蓋一棟大樓一樣，風險管理之制度與機制是該大樓之鋼樑與鋼柱，每個樓地板是金融機構之各項業務，而串連各樓層之樓梯或電梯為風險管理與各業務部門間之溝通管道，但要大樓不倒，重點在於地基的扎實與穩固，而此大樓之地基即是所謂的「風險管理文化」，透過該地基穩固的支撐每個鋼樑鋼柱及樓地板，才能有效防止並保護大樓能夠屹立不搖。因此，重視風險管理文化之深耕，建立金融機構全員之共識與確實遵循，乃是保有地位與安全之不二法門。