Reference no: EM131264522
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.
|
What was one example of symbolism identified in work of art
: What were some details shared regarding the method, tools, subjects, and social implications of the work of art? What was one example of symbolism identified in the work of art?
|
|
Explore the new york metropolitan museum of art
: Explore the New York Metropolitan Museum of Art. We often envision a painting when we think of art though there are many different forms and categories of art.
|
|
Find the factor of safety against yielding
: The simply supported column is a W360 × 122 section 10 m long.
|
|
The equipments residual value is considered negligible
: Kline Corporation holds 90 percent ownership of Andrews Company. On July 1, 20X3, Kline sold equipment that it had purchased for $36,000 on January 1, 20X1, to Andrews for $32,000. The equipment’s original six-year estimated total economic life remai..
|
|
What impact do these terms have on the ending cash balance
: 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. Provide an analysis of the cash budget you just created. Must include a mention of the at..
|
|
Estimate the value of operating leases
: Analyze Regeneron Pharm (REGN)'s Financial Liabilities and Leases at end of 2015. What proportion of this capital is composed of debt? What proportion is composed of capital/financial leases? Estimate the value of operating leases
|
|
What is the basic for depreciation of this equipment
: Stone Age Concrete, Inc. purchased cement manufacturing equipment valued at $344,000 on March 14, 2001. The equipment is used for business 100% of the time. As the accountant, you have elected to take the maximum section 179 deduction. What is the b..
|
|
What is the cost factor and what is the price factor
: Given a total labor cost of $320,000, a Fringe Benefits rate of 43%, an Overhead Rate of 62%, a General & Administrative rate of 12%, Other Direct Costs of $27,000, and a desired Fee of 9%: What is the Cost Factor? What is the Price Factor?
|
|
Explains the development of finance theory from mpt to capm
: Using the first three chapters of the text and the assigned articles as your bibliography, write a paper that explains the development of finance theory from MPT to CAPM to EMH to Behavioral Finance
|