Income & Cash Flow Template

Income & Cash Flow Template - Sales Forecast 1...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Sales Forecast 1 2 3 4 5 6 7 8 9 10 11 12 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Sales Forecast Product 1 (units) - - - 130 130 130 130 130 130 130 130 130 Revenue Product 1 ($s) - - - 10,400 10,400 10,400 10,400 10,400 10,400 10,400 10,400 10,400 Cost Product 1 ($s) - - - 3,900 3,900 3,900 3,900 3,900 3,900 3,900 3,900 3,900 Sales Price per unit $80.00 Cost per unit $30.00 Operating Expenses $4,500 per month beginning in the 1st month Company Funds $20,000 in the 1st month
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Row 2 3 1 2 3 4 5 6 7 8 9 10 11 12 4 Month Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Total 5 Revenues 6 Product 1 7 Product 2 8 Total Revenues 9 less: Cost of goods sold Cost of goods sold (COGS) includes all expenses that vary directly with units sold. 10 Gross Profit Total Revenue less COGS 11 12 Operating expenses 13 Operating expenses are fixed expenses that do not vary with units sold 14 Interest Expense 15 Depreciation 16 Investment Income Investment income can be positive (gain) or negative (loss)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/16/2012 for the course ENGR 265 taught by Professor Arnold during the Spring '09 term at University of Arizona- Tucson.

Page1 / 5

Income & Cash Flow Template - Sales Forecast 1...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online