Balance sheet spreadsheet is something that you will always need when you are involving in the world of accounting. The balance sheet will determine the financial position of a company by the end of a term or a specified date. Basically, a company will always need a balance sheet to present or to show to… Read More »
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.
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.
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 »
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 »