Posted on: 02nd Jun, 2009 05:42 pm
Cash Balance Nov.1 2007 $12,000
Sales $120,000
Gross profit % (based on sales) 45%
Decrease in Acc.Receivable during month $12,000
Increase in Accounts Payable $51,000
Increase in Inventories during month $90,000
Selling Exp. $32,000 per month plus 15% of sales.Depreciation exp. of $5,000 per month.
I am confused on how to input these details in the Cash Budget.
Sales $120,000
Gross profit % (based on sales) 45%
Decrease in Acc.Receivable during month $12,000
Increase in Accounts Payable $51,000
Increase in Inventories during month $90,000
Selling Exp. $32,000 per month plus 15% of sales.Depreciation exp. of $5,000 per month.
I am confused on how to input these details in the Cash Budget.
Pryanradha,
Welcome to the forum.
probably you will need some software like quicken or microsoft money. Quicken offers a free online budgetign tool. Tyr it out
Realgeni
-Good credit is easy to achieve, as logn as you use it responsibly.
Welcome to the forum.
probably you will need some software like quicken or microsoft money. Quicken offers a free online budgetign tool. Tyr it out
Realgeni
-Good credit is easy to achieve, as logn as you use it responsibly.
Hi priyaradha
In my opinion, you would require the help of a financial adviser in order to put these details in the cash budget. Consult a financial adviser. He is the best person to help you.
Thanks.
In my opinion, you would require the help of a financial adviser in order to put these details in the cash budget. Consult a financial adviser. He is the best person to help you.
Thanks.