Topic 5: Forecasting the Financial Statements
This topic corresponds to Chapter 5 in your textbook.
Spreadsheets for this Section:
Financial Forecasting Setup Spreadsheet
Financial Forecasting Setup Spreadsheet After Part 1
Financial Forecasting Setup Spreadsheet Completed
Corrected version of Setup Spreadsheet Completed (SEE NOTE BELOW)
Videos for this Section:
(Note: These videos are also posted on YouTube with optional captions at this link.)
05-01-01 Financial Forecasting Part 1A
05-01-02 Financial Forecasting Part 1B (SEE NOTE BELOW)
05-02-01 Financial Forecasting Part 2A
05-02-02 Financial Forecasting Part 2B
NOTE: At about 2:45 minutes into 05-01-02 I made a mistake. The formulas in H38:J38 for the relationship of Short-Term Notes Payable to Sales got moved by mistake from Row 38 to Row 39. Short-term notes payable for 2010 was then left at $225 instead of being forecast using the average of the previous two years percentage of sales, and 2010 Other Current Liabilites was computed incorrectly using the average percentage for Short-term Notes Payable. The error is left alone through the rest of the videos, but it is corrected in the so-noted version of the completed spreadsheet above.
Problems:
7th Edition: Do Problem 1, Part A only.
6th Edition: Do Problem 1, Part A only
