EFM-16problem

# EFM-16problem - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

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

16problem 3/22/2010 7:08 11/2/2005 Chapter 16. Solution to End-of-Chapter Comprehensive/Spreadsheet Problem Problem 16-11 This spreadsheet develops a cash budget as required for Problem 16-10, Part a. It then goes on to ask and answer a few additional questions. Input Data Collections during month of sale 10% Assumed constant. Don't change. Collections during month after sale 75% Formula. Don't change. Collections during second month after sale 15% Allow this value to change to reflect slower collections. Lease payments \$9,000 General and administrative salaries \$27,000 Depreciation charges \$36,000 \$63,000 Miscellaneous expenses \$2,700 New design studio payment \$180,000 Cash on hand July 1 \$132,000 Minimum cash balance \$90,000 Sales adjustment factor 0% Sales \$180,000 \$180,000 \$360,000 \$540,000 \$720,000 \$360,000 \$360,000 \$90,000 \$180,000 \$90,000 \$90,000 \$126,000 \$882,000 \$306,000 \$234,000 \$162,000 \$90,000 a. Prepare a monthly cash budget for the last 6 months of 2006. The Cash Budget May June July August September October November December January Collections and purchases worksheet Sales (gross) \$180,000 \$180,000 \$360,000 \$540,000 \$720,000 \$360,000 \$360,000 \$90,000 \$180,000 Collections During month of sale 18,000 18,000 36,000 54,000 72,000 36,000 36,000 9,000 During 1st month after sale 135,000 135,000 270,000 405,000 540,000 270,000 270,000

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

EFM-16problem - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

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

View Full Document
Ask a homework question - tutors are online