Reference no: EM131264535
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.
|
Does tension or compression govern
: The simply supported column is a C310 × 45 channel, 2.2 m long. Find the largest value of the load P that can be carried with a factor of safety of 2.5 against yielding. Use E = 200 GPa and σyp = 380 MPa. Does tension or compression govern?
|
|
Discuss characters performances in the areas of acting
: Select 2 characters from the Play and discuss their performances in the areas of Acting, Singing, and Dance. Include Discussions of their vocal success in the areas of Projection, Diction, Clarity of Speech.
|
|
Comparative ratios
: Comparative Ratios. The government-wide financial statements for the City of Arborland for a three-year period are presented on the following pages Which of the financial performance measures in Illustration 10-4 can be calculated for the City of Arb..
|
|
Understand the structure and aims of business organisations
: Provide an assessment for the owners of Jazzmusic of the potential impact on the organisation's aims, structure, functions and stakeholders of implementing an Internet based facility for the sale of music in an MP3 format.
|
|
Create a cash budget showing expected cash receipts
: 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 ..
|
|
Determine the largest eccentricity e
: The C150 × 19:3 channel is used as a column with an effective length of 3 m. Determine the largest eccentricity e of the 14.5-kN load for which the maximum tensile stress does not exceed the maximum compressive stress. Use E = 200 GPa.
|
|
Prepare the consolidation entry
: 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..
|
|
Additional items would appear in the trial balance
: The Longs Fertilizer Company has about 500 customers that buy fertilizer on account. If the customers' accounts were kept in the general ledger, how many additional items would appear in the trial balance?
|
|
Construct an art journal using prezi
: You will begin to construct an art journal using Prezi. Registering to use Prezi is free, and it is highly recommended that you sign up as soon as possible and review the "Learning Prezi is easy" page and the various ways you can design your journ..
|