When you create a balance sheet you do so to summarize your operating income and expenses.…Even though you should keep any publicly released documents as general as…possible, you do need to add as much details you can to the private version…so you can call out the information you require for your budgets.…In this case I have a management balance statement.…And if this were a public balance statement then I wouldn't have these breakouts…here, Cost of Goods Sold, or these two projects.…In other words, it would just be Cost of Revenue, which would be that total of…these two lines, one for each year.…
And then Research and Development would have the total of these two lines in this cell.…And these details would not be broken out.…The private version of the balance sheet contains proprietary information, such…as the names of projects and their associated costs, which help you make…budgeting decisions.…Always be certain which version of the document you are showing to your audience.…You don't want to leak internal information to your competitors.…
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 management balance sheet