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

Apple inc accumulates large amounts of excess cash

Apple Inc. accumulates large amounts of excess cash throughout the year. It typically invests these funds in marketable securities until they are needed. The company’s most recent financial statements revealed a nearly $ ...

The following information relates nickel company for

The following information relates Nickel Company for 2015: Direct materials used                                        $50,000 Direct manufacturing labor              21,000 Manufacturing costs transferred to work-in-pr ...

Dont all consolidations end up with one of the companies

Don't all consolidations end up with one of the companies dominating? Isn't it the nature of the beast? So, did pooling of interests ever make any sense in terms of two companies having equal influence after the consolid ...

The city of wolfe has issued its financial statements for

The City of Wolfe has issued its financial statements for Year 4 (assume that the city uses a calendar year). The city’s General Fund is made up of two functions: (1) education and (2) parks. The city also utilizes capit ...

The merchant company issed 10-year bonds on january 1 2011

The Merchant Company issed 10-year bonds on January 1, 2011. The 15% bonds have a face value of $100,000 and pay interest every January 1 and July 1. The bonds were sold for $117,205 based on the market interest rate of ...

Applied case assignment 7 chapters 10 and 11answer the

Applied Case Assignment #7 (Chapters 10 and 11) Answer the following questions based on the provided excerpts from a selection of greater Washington area public companies' recent 10-Ks. Part I: Booz Allen Hamilton Holdin ...

Tom and jerry formed a partnership at the beginning of year

Tom and Jerry formed a partnership at the beginning of year 19x5 by investing $30,000 and $50,000, respectively, on January 1, 19x5. Tom invested an additional $15,000 on March 1, and Jerry invested an additional $5,000 ...

A company is considering the purchase of a new bus for

A company is considering the purchase of a new bus for transporting students between its north and south campuses. A similar bus was purchased 2 years ago at a cost of $95,000. At an interest rate of 3% per year, what wo ...

Suppose you are analyzing the financial statements of

Suppose you are analyzing the financial statements of BartelleBartelle , Inc. Identify each item with its appropriate financial statement, using the following abbreviations: Income statement (I); Statement of retained ea ...

Judys estimated tax payments for the current year total

Judy's estimated tax payments for the current year total $14,000 , and federal income taxes withheld from her salary amount to $12,000. Judy's actual tax liability for the current year is $30,000. Her income was earned e ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate