Prepare the cash flow budget

Assignment Help Finance Basics
Reference no: EM131473914

THE TRAVEL PHOTOGRAPH

ANNUAL BUDGET:

  May  June   July   August 
 


 
Sales     200          1,000          2,000          2,500   
 


 
Cost of goods sold


 
Supplies       40             200             400             500   
 


 
Gross profit margin     160             800          1,600          2,000   

Prepare the cash flow budget considering the following elements:

1- The photograph is always paid 30 days after the sale

2- The photograph has to pay his supplies cash on delivery

3- At the beginning of June the bank account amounts to ($1,000); this means that he is using the line of credit

THE FISHING POND - Seasonal business

The Festival takes place in August; it is in operation only from May to September

   August   September   October   November   December   January   February 
 





 
Sales     75,000        45,000        20,000          5,000                 -   
 
 





 
Cost of goods sold





 
Supplies     15,000          9,000          4,000          1,000                 -   
 
Guides     22,500        13,500          6,000          1,500                 -       
Total Cost of good sold     37,500        22,500        10,000          2,500                 -   
 
 





 
Gross profit margin     37,500        22,500        10,000          2,500                 -       
 





 
Operational Expenses       8,000          8,000          8,000          8,000          8,000          8,000          8,000   
 





 
Net profit     29,500        14,500          2,000        (5,500)       (8,000)       (8,000)       (8,000)  

Prepare the cash flow budget for September to December considering the following elements:
1- Sales receipts
a- On average, 20% of the sales are received 30 days before the sales as deposits
b- On average, 80% of the sales are received on delivery
2- The pond pays its supplies 30 days later
3- The guides are paid the day of the sales
4- The operational expenses are paid in the same month as the purchase
5- The pond will purchase $5,000 worth of equipement in September
6- The pond will contract a loan of $4,000 in September to pay for the equipment
7- The pond will start reimbursing the loan in September at the amount of $115 per month
8- At the beginning of September the bank account amounts to $40, 000
9- What is going to happen in January and February

Reference no: EM131473914

Questions Cloud

What is the design defect theory : The Black Talon bullet, designed and manufactured by Olin Corp., is a hollow-point bullet designed to bend upon impact into six, ninety-degree-angle, razor-shar
Approved a large capital project : Let's assume that you've approved a large capital project based on a positive NPV. After you start the construction process
Aftertax cash flow from the sale : If the relevant tax rate is 35 percent, what is the aftertax cash flow from the sale of this asset?
Review the case study of ronald anderson : Ronald Anderson Jr. is a self-employed construction contractor from New York. While working on a project in Connecticut, Anderson purchased lumber from a Home.
Prepare the cash flow budget : Prepare the cash flow budget - Prepare the cash flow budget for September to December-What is going to happen in January and February
Has there been a breach of express warranty : In 1994, Daniel Scoggin hired Broward Marine for $5,000 to perform a "bottom job" on his 77-foot sailboat, the "Jubilem." A "bottom job" is a final paint job.
When a company introduces a product at a high price : If Ming was interested in capturing distribution metrics for her retail organization, which of the following might she consider?
What warranties should they allege were breached : In an attempt to save on utility costs, Metro National Corp. decided to construct a thermalenergy-storage system to replace its centralair-conditioning system.
Review the case of reliance granite company : Reliance Granite Company, run by James R. Noggle, manufactures gravestone monuments for monument dealers. Willis Mining, Inc., quarries granite, cuts.

Reviews

Write a Review

Finance Basics Questions & Answers

  Ethical guidelines for supervisors-self-awareness

Identify and discuss the seven ethical guidelines to live by. Provide examples of each guideline for supervisors to consider.

  A stock will have quarterly dividends of $0.78

A stock will have quarterly dividends of $0.78, $0.83, $0.76, $0.92, $0.98, $13, $36, $38 and then grow by 0.02 a year, compounded quarterly. If the required return is 0.07 per year compounded quarterly, what should the price be?

  Te yield on preferred is 70 cost of retained earnings is

you were hired as a consultant to locke company and you were provided with the following data target capital structure

  What is the value of one share of this stock today

You own 300 shares of Abco, Inc. stock. The company has stated that it plans on issuing a dividend of $.60 a share one year. Your required rate of return is 10%. Ignoring taxes, what is the value of one share of this stock today?

  Calculated from the last two weeks of data recorded

Setting up a p chart. After inspecting Figure 27.16, you decide to monitor the next four weeks' absenteeism rates using a center line and control limits calculated from the last two weeks of data recorded in Table 27.8. Find  for these 10 days an..

  What is the breakeven number of units for the firm

You are an analyst working in a single-product manufacturing firm. You have developed your firms cost structure below, based on an output level of 10 million units. Based upon your analysis, what is the breakeven number of units for the firm.

  What are the likely effects on japanese shipbuilders

What are the likely effects on Japanese shipbuilders of a yen appreciation to ¥180 = $1? The South Korean won has maintained its dollar value.

  Planning for the cost their child''s education

Planning for the cost their child's education and their retirement

  The business was in loss for the said financial period

In the Lone Pine Cafe case, Ski Instructor are Account Receivable for $870 for the financial balance sheet as on 30thMarch'2006. It has effect in Asset for Closing Balance Sheet as A/c Receivable. In the Successive Financial year, it has the effec..

  List the perceived deficiencies of those not selected

Which two of the methods used to evaluate project, and used to decide whether or not they should be accepted, do you prefer as a financial manager? Explain why you decided on these two and not the others. List the perceived deficiencies of those n..

  Statement of cash flows

Which of the following is not a true statement? The cash flow statement superceded the previously required statement of changes in financial position.

  Calculate the required return on equity for this firm

Swamp & Sand's current dividend is $1.6 per share. Analysts expect the firm's growth rate of 2% per year to continue indefinitely. The current stock price is 12.5 . Calculate the required return on equity for this firm.

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