Reference no: EM131264417
Use the below data to create a cash budget showing expected cash receipts and disbursements for the month of May, and cash balance expected as of May 31, 2017.
1. Planned cash balance, April 30, 2017: $100,000
2.Customer receivables as of April 30: $530,000 total, $80,000 from March sales, $450,000 from April sales
3. Accounts Payable, April 30: $460,000
4. Merchandise purchases for May: $450,000, 40% paid in month of purchase, 60% paid in next month
5. Payrolls due in May: $90,000
6. Other expenses for May, payable in July: $7,500
7. Bank note due May 15: $90,000 plus $7,200 interest
8. Depreciation for May: $2,100
9. Three-year insurance policy due May 10 for renewal: $1,500, to be paid in cash
10. Sales for May: $1,000,000, half collected in month of sale, 40% in next month, 10% in third month
Question:
1) Prepare the cash budget for the month ending May 31, 2017.
2) Provide an analysis of the cash budget you just created. Must include a mention of the at least: The A/R terms? What are the A/P terms? What impact do these terms have on the ending cash balance?
Requirement:Using Excel and coculate the data by correct excel fomula
Please post the answer with a excel formation.
|
The overhead per direct labor dollar is
: If overhead is 100,000, total direct labor hours is 10,000, total direct labor dollar is 200,000 and total machine hours is 20,000, the overhead per direct labor dollar is ?
|
|
Find the horizontal and vertical components of the reactions
: Find the horizontal and vertical components of the reactions at A and D when the 800-N horizontal force is applied to the frame. The bending rigidity is EI for members AB and BC, and 2EI for member CD. Consider only deformation due to bending.
|
|
Distribution from noncontributory-qualified pension plan
: Nanette Mcphee receives $100,000 as a lump-sum distribution from a noncontributory, qualified pension plan upon early retirement to start a child care business. If, after receiving the distribution, Nanette decides not to start the business, is she p..
|
|
Analyze major consequence the conflict had on us society
: Analyze 1 major consequence the conflict had on United States' society. How did this war affect American sensibilities, including the way Americans viewed the war and themselves?
|
|
Prepare the cash budget for the month ending
: Use the below data to create a cash budget showing expected cash receipts and disbursements for the month of May, and cash balance expected as of May 31, 2017. Prepare the cash budget for the month ending May 31, 2017. Provide an analysis of the cash..
|
|
Determine the smallest diameter d of the bar
: determine the smallest diameter d of the bar for which the impact can be absorbed without permanent deformation. Assume that the pendulam does not rebound.
|
|
Developing a detailed risk assessment methodology
: Developing a detailed risk assessment methodology. You are a senior information technology analyst at your company. Your company has 250 employees. Each employee has his or her own terminal to access the company's network.
|
|
Describe how disney decided to deal with long lines
: Read page Service Insights 9.2 and Service Insights 9.3. Describe how Disney decided to deal with long lines. SERVICE INSIGHTS 9.2 - Disney Turns Queue Management into a Science and SERVICE INSIGHTS 9.3 - Waiting in a Virtual Queue
|
|
Accept in order to maximize operating income
: Assume an engineering company provides services for three types of clients. Each service requires a different amount of a specific form of specialized labor that is in limited supply. If the company is limited to 4,000 hours of this specialized labor..
|