You can use the debt amortization starter workbooks, as shown in Figures 14-1 through 14-4, to construct debt amortization schedules for a variety of debt instruments. Given four parameters—principal, debt term, amortization term, and interest rate—these starter workbooks … [Read more...] about Using the Debt Amortization Starter Workbooks
Using Excel
Customizing the Cash Flow Forecasting Starter Workbook
You can use the cash flow forecast and analysis starter workbook without modification for many cash flow forecasts and analyses. However, you might want to change the workbook so that it more closely matches your requirements. For example, you can add text that describes the asset or investment for … [Read more...] about Customizing the Cash Flow Forecasting Starter Workbook
Understanding the Cash Flow Forecasting Starter Workbook’s Calculations
The cash flow forecast and analysis starter workbook has eight parts: the inputs area, the Profit and Loss Statement, the Gain and Loss Statement, the Operating Cash Flow Statement, the Liquidation Cash Flow Statement, the Cash Flow Analysis, the Pretax Cash Flow Scenarios, and the After-Tax Cash … [Read more...] about Understanding the Cash Flow Forecasting Starter Workbook’s Calculations
Using the Cash Flow Forecast and Analysis Starter Workbook
You can use the cash flow forecast and analysis starter workbook, as shown in Figures 13-1 through 13-5, to construct cash flow forecasts and analysis summaries for assets or investments for which you want to measure profitability and liquidity. To complete it for an asset or investment, develop and … [Read more...] about Using the Cash Flow Forecast and Analysis Starter Workbook
Customizing the Sales Forecasting Starter Workbook
You can use the sales forecasting starter workbook without modification for many sales forecasts. However, you might want to change the workbook so that it more closely matches your requirements. For example, you can add text that describes the product being manufactured or purchased and for which … [Read more...] about Customizing the Sales Forecasting Starter Workbook
Understanding the Sales Forecasting Starter Workbook’s Calculations
The sales forecasting starter workbook has five parts: the Sales Forecast heading box, the Sales Forecast Inputs (discussed above), Cost Totals and Statistics, Sales and Gross Margin Forecast, and Inventory Forecast. Sales Forecast Schedule The Sales Forecast Schedule heading box provides column … [Read more...] about Understanding the Sales Forecasting Starter Workbook’s Calculations