AIS_Wk6Activity1ExcelBudget_021211

AIS_Wk6Activity1ExcelBudget_021211 - July August September...

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

View Full Document Right Arrow Icon
12 Month Cash Budget January February March April May Beginning Cash Balance 350,000 2,310,000 5,749,800 10,186,799 15,037,983 Sales 4,900,000 4924500 4949122.5 4973868.11 4998737.45 Cash Collections 1,960,000 3,439,800 4,436,999 4,851,184 4,875,440 Ending Cash Balance 2,310,000 5,749,800 10,186,799 15,037,983 19,913,423 Initial Sales 4900000 Monthly Growth Rate 0.5% Sales Rate Cell 490 Growth Rate Cell 5
Background image of page 1

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

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

Unformatted text preview: July August September October November December 19,913,423 24,813,240 29,737,556 34,686,494 39,660,176 44,658,727 49,682,271 5023731.14 5048849.8 5074094.05 5099464.52 5124961.84 5150586.65 5176339.58 4,899,817 4,924,316 4,948,938 4,973,682 4,998,551 5,023,544 5,048,661 24,813,240 29,737,556 34,686,494 39,660,176 44,658,727 49,682,271 54,730,932...
View Full Document

Page1 / 2

AIS_Wk6Activity1ExcelBudget_021211 - July August September...

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