After you've created your management income statement, management balance…statement, and cash flow statement, you can update those documents for next year.…Part of your analysis that doesn't appear in the financial statements, but…should appear in your discussion and presentation is your assumption regarding…sales growth and also growth of expenses.…For example, do you have a goal of 20% sales growth for next year, to hire…another 15 employees, or maybe finance renovating an office building through…long-term borrowing?…Each of those assumptions must find your way into your budget, but that's a…business analysis problem, not an Excel problem.…
When you do settle on your numbers for next year, enter them into a copy of your…income balance and cash flow statements.…Be sure to add another column that calculates the difference between the two…values, indicating an increase or decrease in the revenue or expense.…For example I've taken the balance statement that I created earlier.…And I have added a Projected column for fiscal year 2011 and a % Change column.…
Author
Released
6/16/2010- Tracking income and expenses by category and contract
- Using balance sheets
- Designing worksheets to assist decision making
- Creating income statements
- Calculating loans payments and interest
- Creating cell references to other worksheets
- Summarizing data in a chart
- Building alternative budget scenarios
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2007: Financial Analysis
with Curt Frye2h 18m Intermediate -
Excel 2007: Introduction to Formulas and Functions
with Curt Frye2h 26m Intermediate -
Excel 2007: Business Statistics
with Curt Frye4h 19m Intermediate
-
Introduction
-
Welcome1m 1s
-
-
1. Managing Cash on Hand
-
2. Calculating Loan Repayments
-
3. Budgeting Using Financial Statements
-
4. Managing Budgets
-
5. Defining Alternative Budget Scenarios
-
Summarizing scenarios2m 18s
-
Conclusion
-
Goodbye16s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating a budget for next year