Prepare a cash budget for pandoricaltd

Assignment Help Financial Econometrics
Reference no: EM13341187

Budgeting

Pandorica Ltd has provided the estimates below for the October-December quarter in 2014:

October November December

$ $ $

Sales 55,000 63,000 57,000

Purchases 31,000 36,000 29,000

Operating expenses 20,000 21,000 23,500

You are also given the following additional information:

50% of sales are cash sales, the remaining 50% are credit sales and are collected as follows:
25% in the month of sale
40% in the month after sale
30% 2 months after sale
5% lost in bad debts

· Sales in the months of August and September were $53,000 and $51,500 respectively.

· Operating expenses include depreciation each month of $1,350. All expenses and purchases are paid for in the same month they are incurred.

· The firm expects to sell some old machinery for $11,000 in October. New machinery worth $38,000 will be purchased in November (depreciation expense will not change as a result).

· The cash balance on 30th September 2014 is $2,500.

REQUIRED:

a) Prepare a cash budget for PandoricaLtd for the three months October to December 2014. Show all workings.

b) Pandorica Ltd is budgeting for a cash deficit at the end of one of the months included in their cash budget. Explain how PandoricaLtd could prepare for this forecasted deficit. (maximum 150 words)

 

Reference no: EM13341187

Questions Cloud

What is the total distance that the top of building moves : On windy days it sways with a frequency of 0.21 , and the acceleration of the top of the building can reach 2.4 of the free-fall acceleration, enough to cause discomfort for occupants.
Management of working capital and business structures : Sadly, one week after your friend makes the first payment, Xander Ltd is sued. The case goes to trial immediately due to the serious nature of the circumstances. The legal matter is clear, and within a week the case is finished.
Calculate the peak current in the circuit : In a series circuit, r=21ohms L=25mH C=17uF V=150v and w=637rad/s, Calculate the peak current in the circuit
Determine usefulness of information in financial statement : Determine the usefulness of information in financial statements, how disclosing the loan in the financial statements of Dracula Ltd, where it will appear in the balance sheet as a long-term liability
Prepare a cash budget for pandoricaltd : Pandorica Ltd is budgeting for a cash deficit at the end of one of the months included in their cash budget. Explain how PandoricaLtd could prepare for this forecasted deficit. (maximum 150 words)
Documented the detrimental health effects of shift work : There are several studies that have documented the detrimental health effects of shift work. One study conducted by Gordon et al.
Find the pressure in the upper pipe : Water has a density of 1000 kg/m^3. One atmosphere is 1.013 X 10^5 N/m^2. Find the pressure in the upper pipe
Whats the electric field strength 28 nanometer : A 5.0micrometer strand of DNA carries +e charge per nm of length. Treating it as a charged line, what's the electric field strength 28 nanometer from the DNA, not near either end
Find the magnitude of the gravitational acceleration : After landing on an unfamiliar planet, a space explorer constructs a simple pendulum of length 50.0cm. What is the magnitude of the gravitational acceleration on this planet

Reviews

Write a Review

Financial Econometrics Questions & Answers

  At what upfront costs does project cease to be worthwhile

An investor is considering a project that will generate $800,000 per year for four years. In addition to upfront costs, at the completion of the project at the end of the fifth year there will be shut-down costs of $500,000.

  Calculate the effective rate of interest for treasury bills

Assume the $13,000 Treasury bill, 5.50% for 20 weeks. Calculate the effective rate of interest.

  Determine what is beta of the portfolio in stocks

You have invested $5,500, $5,500, and $6,600 in stocks A, B, and C. The betas for these stocks are ( 1.35, 1.40, and 1.40 ). What is beta of your portfolio

  What is the forward rate between 6-month and 9 month

a bank can borrow or lend LIBOR. suppose that the six- month rate is 2% and the nine- month rate is 3%. The rate that can be locked in for the period between six months and nine months using an FRA is 4%.

  What is expected free cash flow in second year of project

A firm is considering a new project that will generate cash revenue of $1,000,000 and cash expenses of $700,000 per year for five years. The equipment necessary for the project will cost $200,000 and will be depreciated straight line over four yea..

  What is the current share price for havanna tobacco

The growth rate in dividends is expected to be a constant 5 percent per year, indefinitely. Investors require a 16 percent return on the stock for the first three years, a 14 percent return for the next three years, and then a 10 percent return th..

  What annual contributes to the retirement fund will allow

during the period before retirement you can earn 8% annually, while after retirement you can earn 10% on your money. What annual contributes to the retirement fund will allow you to recieve the $12,000 annuity

  Determine what is one share of this stock worth today

Mother and daughter enterprises is a relatively new firm that appears to be on the road to great success. The company paid their first annual dividend yesterday in the amount of $.28 a share.

  What will be the change in the bonds price in dollars

The firm recently became more financially stable and the rating agency is upgrading the bonds to BBB. The new appropriate discount rate will be 7.1%. What will be the change in the bond's price in dollars

  How long on average did a unit of inventory sit on the shelf

Bobaflex Corporation has ending inventory of $684,273 and cost of goods sold for the year just ended was $4,358,722.What is the inventory turnover

  What are distributive differences in monopoly nd competition

What are the allocative and distributive differences between monopoly and perfect competition. What causes these differences.

  Determine what will the monthly payment be

ou want to buy a new sports car from Muscle Motors for $73,000. The contract is in the form of a 60-month annuity due at a 7.00 percent APR. What will your monthly payment be

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd