Question

In: Accounting

The actual case study assignment should be uploaded to the Week 6 Assignment Dropbox by 11:59...

The actual case study assignment should be uploaded to the Week 6 Assignment Dropbox by 11:59 p.m. mountain time on Sunday at the end of Week 6. You are encouraged to use the Excel template file provided in Doc Sharing.

The Cambridge Company has budgeted sales revenues as follows.

                                                                                      Jan                    Feb                  Mar__

Credit sales                                                            $45,000             $36,000             $27,000

Cash sales                                                              27,000             76,500             58,500

Total sales                                                              $72,000          $112,500             $85,500

Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month.

Purchases of inventory are all on credit; 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $97,500 in January, $67,500 in February, and $31,500 in March.

Other budgeted cash receipts: (a) sale of plant assets for $18,525 in February, and (b) sale of new common stock for $25,275 in March. Other budgeted cash disbursements: (a) operating expenses of $10,125 each month, (b) selling and administrative expenses of $18,750 each month, (c) dividends of $28,500 will be paid in February, and (d) purchase of equipment for $9,000 cash in March.

The company has a cash balance of $15,000 at the beginning of February and wishes to maintain a minimum cash balance of $15,000 at the end of each month. An open line of credit is available at the bank and carries an annual interest rate of 12%. Assume that all borrowing is done on the first day of the month in which financing is needed and that all repayments are made on the last day of the month in which excess cash is available. Also assume that there is no outstanding financing as of February 1.

Requirements:

1. Use this information to prepare a cash budget for the months of February and March,

Solutions

Expert Solution


Related Solutions

CASE STUDY CH.6 DROPBOX ASSIGNMENT A spice manufacturer has a machine that fills bottles. The bottles...
CASE STUDY CH.6 DROPBOX ASSIGNMENT A spice manufacturer has a machine that fills bottles. The bottles are labeled 16 grams net weight so the company wants to have that much spice in each bottle. The company knows that just like any packaging process this packaging process is not perfect and that there will some variation in the amount filled. If the machine is set at exactly 16 grams and the normal distribution applies, then about half of the bottles will...
The Week 6 Case Study Assignment asks that you consider the agency relationship between a corporate...
The Week 6 Case Study Assignment asks that you consider the agency relationship between a corporate financial manager and the shareholders of the corporation. As a corporate financial manager, you have the opportunity to manage the company's cash on behalf of its owners (shareholders). Consider the case of Apple, Inc, and the company's cash stockpile. The company's financial managers bear the responsibility of managing the cash reserves on behalf of Apple's shareholders. Write a 1-2 page paper, using the following...
The Week 6 Case Study Assignment asks that you consider the agency relationship between a corporate...
The Week 6 Case Study Assignment asks that you consider the agency relationship between a corporate financial manager and the shareholders of the corporation. As a corporate financial manager, you have the opportunity to manage the company's cash on behalf of its owners (shareholders.) Consider the case of Apple, Inc, and the company's cash stockpile. The company's financial managers bear the responsibility of managing the cash reserves on behalf of Apple's shareholders. Write a 1-2 page paper, using the following...
The Week 7 Case Study Assignment is an individual assignment that requires you to analyze a...
The Week 7 Case Study Assignment is an individual assignment that requires you to analyze a select group of alternative industries to determine which is most likely to perform best over the next 12 months. Factors to consider when comparing the industry groups include how the current and prospective economic conditions over the next year will affect them and the current and prospective domestic and global supply and demand conditions in their markets. Review briefly the list of industries below...
Week 6 Assignment: Case Study: Stephenson Real Estate Recapitalization Stephenson Real Estate Company was founded 25...
Week 6 Assignment: Case Study: Stephenson Real Estate Recapitalization Stephenson Real Estate Company was founded 25 years ago by the current CEO, Robert Stephenson. The company purchases real estate, including land and buildings, and rents the property to tenants. The company has shown a profit every year for the past 18 years, and the shareholders are satisfied with the company’s management. Prior to founding Stephenson Real Estate, Robert was the founder and CEO of a failed alpaca farming operation. The...
haleen: Pregnancy & Lactation Case Study (10 pts.) Instructions: This case study assignment should be treated...
haleen: Pregnancy & Lactation Case Study (10 pts.) Instructions: This case study assignment should be treated as a short paper, including a cover page, a heading, and page numbers. Set up the paper with one-inch margins, double-spacing, with the font set at 12-point Times New Roman. The introduction to the paper should summarize the case you have chosen to discuss. Responses to the case study questions should be written in paragraph form. Each paragraph in the case study should begin...
Shaleen: Pregnancy & Lactation Case Study (10 pts.) Instructions: This case study assignment should be treated...
Shaleen: Pregnancy & Lactation Case Study (10 pts.) Instructions: This case study assignment should be treated as a short paper, including a cover page, a heading, and page numbers. Set up the paper with one-inch margins, double-spacing, with the font set at 12-point Times New Roman. The introduction to the paper should summarize the case you have chosen to discuss. Responses to the case study questions should be written in paragraph form. Each paragraph in the case study should begin...
haleen: Pregnancy & Lactation Case Study (10 pts.) Instructions: This case study assignment should be treated...
haleen: Pregnancy & Lactation Case Study (10 pts.) Instructions: This case study assignment should be treated as a short paper, including a cover page, a heading, and page numbers. Set up the paper with one-inch margins, double-spacing, with the font set at 12-point Times New Roman. The introduction to the paper should summarize the case you have chosen to discuss. Responses to the case study questions should be written in paragraph form. Each paragraph in the case study should begin...
haleen: Pregnancy & Lactation Case Study (10 pts.) Instructions: This case study assignment should be treated...
haleen: Pregnancy & Lactation Case Study (10 pts.) Instructions: This case study assignment should be treated as a short paper, including a cover page, a heading, and page numbers. Set up the paper with one-inch margins, double-spacing, with the font set at 12-point Times New Roman. The introduction to the paper should summarize the case you have chosen to discuss. Responses to the case study questions should be written in paragraph form. Each paragraph in the case study should begin...
This Individual Case Study Assignment should be around 1,000 words in total and should be submitted...
This Individual Case Study Assignment should be around 1,000 words in total and should be submitted in the form of a business report (approximately 500 words for each part). Individual Case Study Assignment Part A BLC Ltd. is a medium-sized UK manufacturing company based in Liverpool. The company is seeking to expand its operations with the establishment of an office block to house the marketing and human resources staff in Manchester. The company has narrowed the choice to two alternatives...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT