financial forecasting
CreamSodaLover
financial_forecasting_template.xlsxPro Forma Income Statement
| PRO FORMA INCOME STATEMENT |
Pro Forma Balance Sheet
| PRO FORMA BALANCE SHEET |
Variance Analysis
| VARIANCE ANALYSIS | ||||||||||||
| Cells E6 and F6 have prepopulated formulas and will calculate automatically for you. | ||||||||||||
| EXAMPLE | LINE ITEM | Q4, 20NN
Kevin Kuznia: This colum is the budget. In reality we know it is the previous quarter, but for this scenario we willl pretend it is the budgeted amount. |
Q1, 20NN
Kevin Kuznia: This column are the actual results. In other words, it is the final amount that was reported. |
AMOUNT | PERCENT VARIANCE
Webster, Amanda: This is variance. It is how much in a percent you are over or under. |
POTENTIAL RATIONALE FOR VARIANCE
Webster, Amanda: Explain the plausiable reasons why there is a variance. |
||||||
| Interest Expense | $ (25.90) | $ (75.00)
Kevin Kuznia: This amount is in millions of dollars. Note that this is negative. This is because it appers as a credit on the income statement. In other words, the company made money on interest expenses rather than paying money on interest. Be sure to carefully review if an item is a credit or debit. |
$ (49.10) | 189.58% | Due to raising interest rates, the company was able to earn more money from interest bearing investments. | |||||||
| ASSIGNMENT | LINE ITEM | Q4, 20NN
Kevin Kuznia: This colum is the budget. In reality we know it is the previous quarter, but for this scenario we willl pretend it is the budgeted amount. |
Webster, Amanda: This is variance. It is how much in a percent you are over or under. |
Q1, 20NN
Kevin Kuznia: This column are the actual results. In other words, it is the final amount that was reported. |
Webster, Amanda: Explain the plausiable reasons why there is a variance. |
AMOUNT | PERCENT VARIANCE
Webster, Amanda: This is variance. It is how much in a percent you are over or under. |
POTENTIAL RATIONALE FOR VARIANCE
Webster, Amanda: Explain the plausiable reasons why there is a variance. |
||||
| Enter your line item | 0 | ERROR:#DIV/0! | ||||||||||
| End of Variance Analysis worksheet and end of workbook |
