Cash Flow, 4 Yrs

Cash Flow, 4 Yrs - Assumptions The ABC Company Mo. 1 Mo. 2...

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

View Full Document Right Arrow Icon
Assumptions The ABC Company Mo. Mo. Mo. Mo. Mo. Mo. Mo. Mo. Mo. Mo. Mo. Mo. Year Year Year Year 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 Sales Factor QTY QTY QTY QTY QTY QTY QTY QTY QTY QTY QTY QTY QTY QTY QTY QTY $120 Product 1 40 50 60 70 80 100 120 130 160 180 200 210 1400 150% 125% 120% $85 Service 1 23 30 35 40 45 50 55 60 65 70 75 80 628 150% 125% 120% Cost of Goods Sold $30 Product 1 $22 Service 1 Fixed costs To make changes to the P&L, $2,000 /month Rent change the ORANGE assumptions ONLY $600 /month Utilities $1,200 /year Insurance $1,000 /month Advertising additional Income or Expenses lines should be added w 8% /year Interest on loan(s) commands 'Copy' and 'Insert Copied Cells' $100,000 Loan(s) Variable Costs $2,000 /month Employees 1 1 1 1 2 2 2 2 2 2 2 2 2 3 3 3 $0 /month Owner's draw 30% EmplBenefits Copyright © 2001-2006 RealEasyBooks Inc . All rights reserved.
Background image of page 1

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

View Full DocumentRight Arrow Icon
The ABC Company Mo. Mo. Mo. Mo. Mo. Mo. Mo. Mo.
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Cash Flow, 4 Yrs - Assumptions The ABC Company Mo. 1 Mo. 2...

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

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