Assignment
Student29
FinancialForecastingTemplate.xlsxProforma Income Statement
| PROFORMA INCOME STATEMENT |
Proforma Balance Sheet
| PROFORMA BALANCE SHEET |
Variance Analysis
| VARIANCE ANALYSIS | |||||||||
| 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. |
Webster, Amanda: Explain the plausiable reasons why there is a variance. | $ (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. | 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. |
|||
| The highlighted cells have prepopulated formulas and will calculate automatically for you. | |||||||||
| Enter your line item | 0 | ERROR:#DIV/0! |
