Reference no: EM133005967
Question - You have been asked to prepare a Cash Budget for Melnick Company for July 2021. Melnick is a MERCHANDISING company. The following information is available:
The cash balance on July 1 is $30,000
All sales are on account. Actual sales for May and June and expected sales for July are as follows:
May June July
Sales on Account $780,000 $640,000 $520,000
Sales are collected as follows: 40% in the month of sale and 60% in the month following sale.
Purchases of inventory will total $280,000 for July. Thirty percent of a month's inventory purchase are paid during the month of purchase. The remaining seventy percent is paid the following month. June's inventory purchases totaled $360,000.
Labour costs during July are estimated to be $118,000
Selling and administration expenses are budgeted at $125,000 for July. Of this amount, $12,000 is for depreciation.
New equipment costing $60,000 will be purchased for cash during July.
Dividends of $25,000 will be paid during July.
The company maintains a minimum cash balance of $20,000
Melnick Company has an open line of credit allowing them to borrow up to $100,000 at any time to meet cash shortages.
Required - Prepare a Cash Budget for July indicating any financing that may be required.
|
How much of their first payment goes toward interest
: Joe and Lauren have decided to buy a house for $279,000. How much of their first payment goes toward interest
|
|
Describe the purpose of preparing financial statements
: Describe the purpose of preparing financial statements. describe the key differences between non-reporting entities and reporting entities
|
|
Find how much will have at the end of three years
: How much will you have at the end of 3 years? You are saving to buy a house and deposit $10,000 per year at the beginning of each year into an investment.
|
|
How much would be willing to pay for the investment today
: If the rate of return on the investment is 6%, compounded monthly, how much would you be willing to pay for the investment today?
|
|
Prepare a Cash Budget for July
: New equipment costing $60,000 will be purchased for cash during July. Prepare a Cash Budget for July indicating any financing
|
|
Calculate the annual rate of return for the investment
: The investment will provide an annuity of $2,000 at the end of each month for 10 years. Calculate the annual rate of return for the investment?
|
|
Advanced research methods
: Advanced Research Methods - explain the background to the business problem or opportunity, and justify the reasons for, and the value of, the research
|
|
How much money do need to be able to afford pension
: You are just hired at age of 25 and want to save for retirement. How much money do you need, as of the start of retirement, to be able to afford your pension?
|
|
What is the actual rate of interest are paying
: Your credit card company quotes you an APR of 18.9 percent. Interest is billed monthly. What is the actual rate of interest you are paying?
|