Prepare a cash budget for each quarter

Assignment Help Accounting Basics
Reference no: EM131608008

Problem: Cash Budget

In the fourth quarter of 2017, Eurofit Cycling, a bike shop, had the following net income:

Sales

$550,000

Less cost of sales

250,000

Gross margin

300,000

Selling and administrative

70,000

Income before taxes

230,000

Income taxes

80,500

Net income

$  149,500

Purchases in the fourth quarter amounted to $195,000. Estimated data for Eurofit Cycling for 2018 are as follows:


Quarter 1

Quarter 2

Quarter 3

Quarter 4

 Sales

$400,000

$475,000

$550,000

$600,000

 Cost of Sales

170,000

185,000

220,000

230,000

 Purchases

160,000

200,000

225,000

267,000

 Selling and Administration

67,000

69,000

71,000

73,000

Taxes are 35 percent of pretax income and are paid in the quarter incurred. Fifty percent of sales are collected in the quarter of sale and 50 percent are collected in the next quarter. Seventy percent of purchases are paid in the quarter of purchase and 30 percent are paid in the next quarter. Selling and administrative expenses are paid in the quarter incurred except for $7,000 of depreciation included in selling and administrative expense. A capital expenditure for $20,000 is planned for the fourth quarter of 2018.

Prepare a cash budget for each quarter of 2018.

Reference no: EM131608008

Questions Cloud

Discuss social capital and sprawl : In preparation for this week's Critical Thinking assignment, introduce a concept related to your workplace or another community
Bullying is a public health problem : Analyze at least 3 classmates' comments into one new comment of your own. You must analyze/synthesize viewpoints and assumptions.
Usual combined return on the sale and the financing : How much do you need to charge for the bedroom set during the sale in order to earn your usual combined return on the sale and the financing?
Earliest theories of management : Fayol's fourteen principles was one of the earliest theories of management to be created, and still remains one of the most comprehensive.
Prepare a cash budget for each quarter : In the fourth quarter of 2017, Eurofit Cycling, a bike shop, had the following net income: Prepare a cash budget for each quarter of 2018
Write a c program that prints the integer equivalents : (Integer Value of a Character) Here's a peek ahead. In this chapter you learned about integers and the type int. C can also represent uppercase letters.
Brazil performing aircraft maintenance in brazil : Considering "Global Sources of Conflict" as the topic of this module, speculate on a conflict that might arise from an international team of technicians.
Require an effective annual return : If you require an effective annual return of 8 percent on this investment, how much will you pay for the contract today?
Collaboration systems at isuzu australia limited : Read the case study in Chapter 12 of the Bidgoli textbook titled "Collaboration Systems at Isuzu Australia Limited".

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