Personal Financial Statement

Many financial institutions will require information about your personal financial data. This spreadsheet will help you prepare a personal financial statement. Your personal financial statement should show only your personally held assets and liabilities (debts) outside the business. Do not include any business assets or liabilities.

Monthly Event Calendar

This is a monthly excel calendar where it will show event information based on your filled information in available event column. The formula will adjust the event into corresponding date automatically.

Break Even Analysis

One of the best uses of breakeven analysis is to play with various scenarios. For instance, if you add another person to the payroll, how many extra sales dollars will be needed to recover the extra salary expense? If you borrow, how much will be needed to cover the increased principal and interest payments? Many… Read More »

Term Structure Modeling and Balance Sheet Simulation

In this model spreadsheet, forward term structure of interest rates is modeled. Then, using the model predicted forward yield curves, balance sheet of a hypothetical bank is simulated by employing the duration measure. This balance sheet simulation shows the possible variations in the shareholders’ wealth (assets minus liabilities, sometimes called “economic value”) caused by the… Read More »