Complete the cash budget, After entering the following data

Complete the cash budget

Assignment Help Financial Accounting

Reference no: EM131168398

The Cash Budget
You recently began a job as an Accounting Intern at Dejesus Delivery Company in Queens, New York. Your first task was to help prepare the Cash Budget for April and May of 2013. Unfortunately, the computer with the budget file crashed, and you did not have a back-up or even a paper copy.

You, later, ran a program to salvage bits of data from the Budget File. After entering the following data in the budget, you may have just enough information to reconstruct the budget.

Dejesus Delivery Company eliminates any cash deficiency by borrowing the exact amount needed from Queens County Saving Bank where the current interest rate is 6%. Dejesus Delivery first pays interest on its outstanding debt at the end of each month. The company, then, repays all borrowed amounts at the end of each month with any excess cash above the minimum required, but after paying monthly interest expenses.

Required: Complete the Cash Budget.

Dejesus Delivery Company
Cash Budget
April and May 2013

Item	April	May
Beginning Cash Balance	$18,000	?
Cash Collections	?	$82,000
Cash from Sales of Plant Assets	-----	2,100
Cash Available	$113,000	?
Cash Payments:
Purchase of Inventory	?	44,000
Operating Expenses	46,000	?
Total Cash Payments	97,000	?
Ending Cash Balance Before Financing	?	22,100
Less: Minimum Cash balance Required	20,000	20,000
Cash Excess (deficiency)	?	?
Financing of Cash Deficiency:
Borrowing at end of month	?	?
Principal Repayment at end of month		?
Interest Expense		?
Total Effects of Financing	?	?
Ending Cash Balance	?	?

Reference no: EM131168398

Questions Cloud

What is the probability that the other side is also black : what is the probability that the other side is also black?

Prove that a cryptosystem : Prove that a cryptosystem has perfect secrecy if and only if H(P|C) = H(P).

Present the main neurological findings about the human brain : Optimal learningAbstract: The purpose of this paper is to present the main neurological findings about the human brain that provide the basis for brain-based learning

Critical thinking assignment : At the top of your Word file, include the title of this Critical Thinking assignment, your name, and the date. Screen snapshots can be made by hitting the PrtScrn button on the keyboard and then pasting the captured image into Word. You can use Al..

Complete the cash budget : After entering the following data in the budget, you may have just enough information to reconstruct the budget.- Complete the Cash Budget.

Explain promotional strategy for your product or service : Develop an initial sales revenue forecast and marketing budget for your plan. Prepare a pie chart showing the dollars/percentages budgeted for each included marketing activity for the first year. Provide justification for your choices.

What is global warming : What is "global warming"? Is there general agreement (consensus) on what causes it? Please back up your comments with research (certainly beyond the textbook) and not platitudes or mantras?

What would you predict for results with the serial recall : You've now learned about the serial position curve. The relevant research in your text describes this curve using a free recall task. What would you predict for the results with the serial recall task

Historical timeline of homeland security incidents : Provide a historical timeline of homeland security incidents/events (natural and man-made) along with the call for improved preparedness, response and recovery needs that lead to the creation of NIMs and the NRF documents. Be sure to include each ..

User Account

All Pages