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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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