Prepare a monthly cash budget from july

Assignment Help Accounting Basics
Reference no: EM133153245

Question - One day in March 2013, Robert Sutherland, industrial commissioner for the city of South Elk, received a telephone call from Nick Miron, president of Seal Equipment Ltd., who wanted to see him as soon as possible.

When Sutherland arrived at Miron's office, Miron was sitting at his desk going over his current year's cash budget. Miron informed Sutherland that as a result of the revised credit restrictions adopted by his bank, he was being asked to prepare an estimate of his financial requirements for the balance of the calendar year. All major customers of the bank were asked to provide this information.

Miron also informed Sutherland that he was going to have a meeting with Joanne Armstrong, the lending officer responsible for handling the company's account, and that he wanted to show her his financial requirements for the rest of the calendar year. Consequently, Miron asked Sutherland to help prepare a budget forecast. On the basis of the information available, Miron felt that it would not be necessary to borrow funds before July 2013. The budget would therefore be prepared for the period July 1, 2013, to January 31, 2014.

The marketing department provided the following sales forecast:

July $50,000

August 100,000

September 500,000

October 650,000

November 550,000

December 400,000

January 400,000

Ten percent of sales are for cash, 60% of sales are collected after 30 days, and the remaining 30% after 60 days. Purchases, which are 80% of sales, are incurred in the month in which the sales are made. These goods are paid 30% in cash and 70% within 30 days. Distribution and administrative expenses are $20,000 per month, plus 1% of monthly sales. Start-up costs in July are $50,000. Income taxes for the entire operating period are paid in April and are 40% of the profit. The monthly depreciation is $20,000. The company feels that it is necessary to maintain a minimum cash balance of $30,000 during the selling season.

The cash balance on July 1 is $75,000.

Required - Prepare a monthly cash budget from July 1, 2013 to January 31, 2014.

Reference no: EM133153245

Questions Cloud

How to describe them or to assess reproductive strategies : Describe the species present in each of the strata. Your transect should be between 50 and 100 m long, and probably about 10 m wide although you may need
Examples of topical areas : Search online for a recent news story and then summarize how this news story is relevant to business ethics or environmental sustainability issues that we are l
Calculate an interest table : Calculate an interest table for how to figure out the interest for the following 4 years and how much the note is worth each year
Explain how the gpa does : Some college students have a goal to "earn a degree". Others have a goal to "get an education". Explain why the GPA is, or is not, a useful metric for either, o
Prepare a monthly cash budget from july : The cash balance on July 1 is $75,000. Prepare a monthly cash budget from July 1, 2013 to January 31, 2014
Facilitate international trade : Governments are under immense pressure to protect and support domestic companies. How will you overcome the challenges of entering the Belgium, Japan or UAE mar
Different species of non-cultivated plants : Make a plant collection in order to learn identification skills and techniques, particularly as these are required in many environmental studies
Calculate the quick ratio : Question - Snowy Ltd has Cash $30,000, Accounts Receivable $15,000, Prepaid Expenses $6,000, Inventory $18,000, Calculate the Quick Ratio
Business culture and craft : Provide an example of a "single story" perception that someone has had and explain why you believe these assumptions were incorrect.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Calculate amount of michaels deduction for capital losses

Calculate the amount of Michael's deduction for capital losses on his tax return for 2015

  Why would a firm want to issue both preferred stock

Firm by issuing some kind of equity. Why would a firm want to issue both preferred stock and common stock rather than just one category of stock?

  What will his contributory earnings be

Mohamoud is currently making 62,500 working as an HR Manager with a large Canadian Corporation. He is 47 years old. What will his contributory earnings be

  Appraise the project using npv approach

Pine & Oak have spent €20,000 researching the prospects for a new range of products. If it were decided that production is to go ahead an investment of €240,000 in capital equipment will be required. The accounts department has produced budget..

  What amount, provided today, will provide for withdrawals

Question - What amount, provided today, will provide for withdrawals of $2600 at the end of each 6 months for 3 years at a rate of 3.1% compounded annually

  Audience-focused communication matrix

Use the matrix to complete the information. Write 3-4 sentences for each item. • What are some audience characteristics you need to consider?

  Prepare an estimate of total operating costs

IN 2017, total net sales are budgeted to be $ 24,000. Using the high-low method, prepare an estimate of total operating costs for 2017

  Find what amount be reported as unearned revenue on dec

Find what amount should be reported as unearned revenue on December 31, 2020? Regal Company sells gift certificates, redeemable tor store merchandise.

  Harold corporations net income

What would be the Harold Corporations net income for 2012 using absorption costing?

  Which side of this ongoing debate would you support

Which side of this ongoing debate would you support and why? Provide specific details to support your opinion in your response.

  For each of the following items state whether each would be

for each of the following items state whether each would be recorded as revenue or unearned liability. include

  What were the equivalent units for conversion costs

Seaside Company uses the weighted-average method in its process costing system. What were the equivalent units for conversion costs in the Sanding Department

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd