extra-cash-flow-homework

extra-cash-flow-homework - Extra Cash Flow Homework Use the...

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

View Full Document Right Arrow Icon
Extra Cash Flow Homework Use the Excel form on the website and fill it in. Email me the worksheet when you complete it. Information: 1) Beginning cash balance 1/1/07 is $3,500. 2) There is no initial current debt. Noncurrent debt has a beginning value of $100,000. 3) Cash receipts are from crop sales. Projected to be: $50,000 in February, $60,000 in March, $40,000 in September, and $16,000 in November. 4) A piece of equipment will be sold in February for $20,000. New equipment costing $80,000 will be purchased that same month. The machinery will be paid for partly out of cash on hand and partly from a $35,000 equity loan (e.g. new noncurrent debt) 5) There is nonfarm income of $1200 each month. Investments pay $700 each quarter (March, June, September, and December). 6) Estimated monthly expenses are listed on the next page. 6) Scheduled noncurrent debt payments are $1,000 per month in January and February and $2,000 per month for the rest of the year. 7) Interest on all noncurrent debt (new and existing) is calculated at a rate of 8% a year.
Background image of page 1

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

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

This note was uploaded on 11/15/2011 for the course AGEC 7100 taught by Professor Duffy,p during the Fall '08 term at Auburn University.

Page1 / 2

extra-cash-flow-homework - Extra Cash Flow Homework Use the...

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