Determine the cash surplus-deficit-and financing needs

Assignment Help Financial Management

Reference no: EM131072322

Precision Machines is preparing a financial plan for the next six months to determine the financial needs of the company. The historical analysis of the company’s sales shows that the company’s total sales are 30% cash sales and 70% credit sales. Further analysis of credit sales shows that the company receives 50% of the credit sales one month after the sale and the remaining 50% in the second month after the sale. This means the cash collections from sales are 30% in the first month of the sale, 35% in the second month, and 35% in the third month. The materials purchased by the company amounts to 50% of the sales for the month. The company pays for the purchases one month after the initial purchase. The company likes to maintain a cash balance of $5,000. The cost of borrowing is 10%. The company plans to pay off the loan whenever there is a surplus and borrow when there is a deficit. The attached spreadsheet shows revenues (sales), expenses, capital expenditures, and other expenses for Precision Machines’ next six months. Using the information given on the spreadsheet, prepare a cash budget for January through June and determine the cash surplus, deficit, and the financing needs of the company.

Annual Cost of borrowing 10.00%

Minimum Cash Balance $5,000.00

Beginning Cash Balance $7,500.00 Revenues (Sales)

NOV$40,000.00 DEC$50,000.00 JAN$48,000.00 FEB$55,000.00 MARCH $35,000.00 APRIL$50,000.00 MAY$65,000.00 JUNE$40,000.00

Cash Collections

First Month (30%)

Second Month (35%)

Third Month (35%)

Total Collections

Cash Disbursements

Material Purchases Salaries JAN 6,000.00 FEB 6,000.00 MARCH 6,000.00 APRIL 6,000.00 MAY 6,000.00 JUNE 6,000.00

Wages JAN 3,000.00 FEB 3,500.00 MARCH 3,000.00 APRIL 3,200.00 MAY 3,500.00 JUNE 3,000.00

Other Expenses

Capital Expenditure MARCH 45,000.00

Dividends MARCH 1,000.00 JUNE 1,000.00

Interest Total Disbursements

Cash flows

Net cash flows

Cumulative cash flows

Minimum Cash Balance

Cash Surplus or (Deficit) Recommendations:

Reference no: EM131072322

Questions Cloud

Product from a factory to a terminal by rail : A new logistics system is being designed to transport one product from a factory to a terminal by rail. A simulation study is needed to estimate the following:

Compensating balances : Compensating balances have the following advantages EXCEPT:

Do you think licensing process is unnecessary hurdle meant : Do you think the licensing process for international medical graduates is an unnecessary hurdle meant to shield U.S. doctors from foreign competition?

Evaluate information in a specific area of business : Reflect on the essential academic skills to present evaluate and interpret information in a specific area of business, accounting, economics or tourism, as appropriate for the named award.

Determine the cash surplus-deficit-and financing needs : Precision Machines is preparing a financial plan for the next six months to determine the financial needs of the company. The historical analysis of the company’s sales shows that the company’s total sales are 30% cash sales and 70% credit sales. Usi..

How many years would you hold the wine before selling : If in addition to interest rate costs, there is a cost of storing the wine that equals 2% of the wine's value each year, for how many years would you hold the wine before selling?

Product delivery and raw material acquisition : A company supplies a customer product for which daily demand, expressed in truck loads, is normally distributed with a mean of 10 and a standard deviation of 2. Production capacity is 14 truck loads per day.

What price will the monopolist charge for his output : What price will the monopolist charge for his output?

Recommend the file system that the network administrator : Multiple users access a specific computer on the network in ABC Inc. The users use the computer to access a remote FTP server. The computer runs the Windows Server OS. The network administrator wants user-specific data on the computer system to be..

User Account

All Pages