前回の連載で紹介した「関数PMT」や「関数NPER」などを使って積立投資のシミュレーションを行うことも可能だ。今回は、ここ数年、話題になっているFIRE（早期リタイア）を目指す場合を例に、積立投資のシミュレーションをExcelで行う方法を紹介していこう。

James Chen, CMT is an expert trader, investment adviser, and global market strategist. Charlene Rhinehart is a CPA , CFE, chair of an Illinois CPA Society committee, and has a degree in accounting and ...

The future value function capability in Microsoft Excel helps business owners easily assemble data for projects such as budgeting and company or asset valuation exercises. The Excel formula is fairly ...

To determine this future value of your money using Microsoft Excel, you'll need to perform some basic calculations based on the interest rate, how often the interest compounds and how long you plan to ...

Michael Boyle is an experienced financial professional with more than 10 years working with financial planning, derivatives, equities, fixed income, project management, and analytics. Pete Rathburn is ...