Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Financial Accounting Expert

Cash Budget

Thunder, Inc. is developing its cash budget for the upcoming year. Of Thunder’ sales, 20% is for cash, another 60% is gathered in the month following sale, and 20% is gathered in the second month following sale. November and December sales for 2010 were $229000 and $250,000, correspondingly.

Thunder’ purchases its raw materials 2 months in advance of its sales equivalent to 70% of its final sales price. The supplier is paid one month after it makes delivery. For instance, purchases for April sales are made in month of February, and payment is made in the month of March.

In addition, Thunder pays $10,000 per month for rent and $20,000 each and every month for other expenditures. Tax prepayments for $32,000 are made each quarter start in March.

The company’s cash balance at December 31, 2010, was $26,000 and minimum balance of $25,000 should be maintained at all times. Suppose that any short-term financing required maintaining cash balance would be paid off in the month following the month of financing if sufficient funds are accessible.

Interest on short-term loans (12%) is paid monthly. Borrowing to meet estimated monthly cash requires takes place at the beginning of month. For instance, if in the month of April the firm anticipates to have require for an additional $60,500, these funds would be borrowed at the beginning of April with interest of $605 (.12 x 1/12 x $60,500) owed for April and paid at the starting of May.

Sales for Thunder Inc.:

January

$229,000

February

$250,000

March

$270,000

April

$275,000

May

$280,000

June

$290,000

July

$280,000

August

$260,000


Required:

problem1. Prepare a monthly cash budget for Thunder Inc. covering the first 7 months of 2010.

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M93843

Have any Question? 


Related Questions in Financial Accounting

Discussion 4answer in 2-3 paragraphs and use

DISCUSSION 4 ANSWER IN 2-3 PARAGRAPHS AND USE SCHOLARLY SOURCE(S) Using the U.S. Securities and Exchange Commission's EDGAR database, select a public company that has consolidated subsidiaries. To minimize the chances of ...

Assignmentexcel format requiredbobs beans a coffee shop and

Assignment EXCEL Format Required Bob's Beans, a coffee shop and breakfast catering chain, operates three cafes in South Florida. Segment reporting for the last quarter as follows: Bob's Beans, Inc. Income Statement For t ...

In chapter 4 we discussed the six sigma methodology for

In chapter 4 we discussed the six sigma methodology for process improvement (DMAIC). Give an example of how this process could be used to structure a spend analysis effort.

Assignmentswish watch corporation manufactures sells and

Assignment Swish Watch Corporation manufactures, sells, and services expensive, ugly watches. The company has been in business for three years. At the end of the most recent year, 2006, the accounting records reported to ...

Assignmentcomprehensive receivables problem connecticut inc

Assignment (Comprehensive Receivables Problem) Connecticut Inc. had the following long-term receivable account balances at December 31, 2006. Note receivable from sale of division $1,800,000 Note receivable from officer ...

Read harvard business reviews in search of a second act

Read Harvard Business Review's "In Search of a Second Act" case study. You can search for it in Business Source Complete (EBSCO) or use the see "How to find an article" in the Course Information tab. Two authors gave the ...

Assignmentbullwhen a company owns inventory it has to

Assignment • When a company owns inventory, it has to decide how to consistently value the inventory sold and on hand. Four inventory valuation methods are available to help the organization effectively value its invento ...

Assignment intermediate accounting for finance working

Assignment: Intermediate Accounting for Finance Working Capital Case Study Your job is to make ABC cash flow in years 2 and 3 (positive ending cash balances); which means you must balance ABC's cash conversion cycle days ...

What is meant by the statement when a resource becomes

What is meant by the statement: "when a resource becomes essential to competition but inconsequential to strategy, the risks it creates become more important than the advantages it provides"? On the topic " It doesn't ma ...

1-describe in detail the guidelines used for leading

1-Describe in detail the guidelines used for leading decision group meetings. 2-Explain leadership in? self-managed teams and the differences between internal and external leadership roles.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen