Prepare cash budget for july to september

Assignment Help Financial Management
Reference no: EM131339244

Financial Management Assignment- Presentation

Alpha Limited manufactures and sells marine equipment. Its income statement for the year 2015 and balance sheet as of December 2015 are shown below:

Sales

5,000,000

Cost of Goods Sold

3,000,000

Gross profit

2,000,000

Selling and Admin Expenses

800,000

Depreciation

500,000

EBIT

700,000

Interest

100,000

Earnings before tax

600,000

Tax (20%)

120,000

Net Income

480,000

Dividends paid

360,000

Addition to retained earnings

120,000

Balance Sheet as of December 31, 2015

Cash

1,000,000

inventory

600,000

receivables

500,000

Total Current assets

2,100,000

Gross Fixed Assets

14,000,000

less: Accumulated depreciation

5,500,000

Net Fixed Assets

8,500,000

Total Assets

10,600,000

Accounts payables

300,000

Notes Payables

700,000

Total Current Liabilities

1,000,000

Long Term debt

1,000,000

Common Stock

6,000,000

Balance Sheet as of December 31, 2015

retained earnings

2,600,000

Total Liabilities and Equity

10,600,000

Number of shares outstanding

1,000,000

Market price per share

$12

Question 1

Assess the amount of new equity to be issued if:

• Sales are expected to increase by 20%.

• Cost of goods sold, Selling and Administrative Expenses, Inventory, Receivables, and Accounts Payables will increase in the same proportion as sales.

• New fixed assets will be purchased for $1 million which will be depreciated over 4 years to zero salvage value.

• The cash balance will be maintained at $ 1 million by the end of 2016.

• The amount of long-term and notes payable will remain the same and so will the interest payment.

• Additional financing will be provided by issue of new equity.

• Assume that the dividend pay out ratio remains constant.

Question 2

Analyse how the concepts of the degree of operating leverage and financial leverage are important for management decisions.

Question 3

As part of its overall planning, the company prepares its cash budget every month. The details for the 3 months, July, August and September are shown below:

 

Jun

Jul

Aug

Sep

Sales

180,000

200,000

220,000

180,000

Purchases Cash


70,000

80,000

60,000

Purchase Credit

30,000

40,000

30,000

40,000

Operating expenses


30,000

30,000

30,000

Interest


10,000

10,000

10,000

Capital expenses


100,000



Cash Balance as of July 1


44,000



One quarter of the firm's sales are for cash and the balance is received one month later. All credit purchases are paid for with one month delay.

Prepare cash budget for July to September.

Question 4

Alpha Limited is considering a project to supply 25,000 tons of machine screws annually to its major customer. It requires an initial $3,600,000 investment to get the project started. This project will last for 5 years. It is estimated that annual fixed costs will be $850,000 and that variable costs will be $185/ton. The fixed assets will be depreciated using straight line depreciation to zero salvage value over 5 years. The estimated salvage value at the end of 5 years is $500,000.

The marketing department estimates that the selling price will be $280 per ton. It is estimated that the net working capital of 10% of sales will have to be provided at the beginning of the project which will be recovered at the end of the project.

The beta of Alpha Limited is 1.2. The risk free rate is 5% and the market risk premium is 7%.

Estimate the relevant cash flows and calculate the net present value and recommend the decision about this project.

Question 5

Alpha limited plans to raise the needed funds of $3,600,000 through issue of new shares in the form of rights. The company plans to set the subscription price 10% below its current market price of $12 per share. The number of shares outstanding is 1 million.

Apply the technique of rights issue by calculating:

(a) The number of new shares to be issued
(b) The number of rights to be issued to buy a new share
(c) Value of right

Question 6

Examine the factors that should be considered while the company is planning its capital structure.

Reference no: EM131339244

Questions Cloud

Explain the issues that exist between 3nf and bcnf : Explain the issues that exist between 3NF and BCNF.  Now normalize through BCNF.  Show the relations at each step even if there is no change so I can see the process.
What do you make of principal joe clarks unorthodox leaders : Compare and contrast the leadership approach Clark uses in the first assembly where he removed the incorrigible students, with the second assembly where he is attempting to motivate the students to excel in the upcoming state testing. What was he..
Determine the symmetry in the graph of the comet’s path : Determine the symmetry in the graph of the comet's path.
Products with vendor information : How would you generate using SQL a list of all products with their vendor information? Make sure the output is in order of increasing price.
Prepare cash budget for july to september : TMA02- As part of its overall planning, the company prepares its cash budget every month. The details for the 3 months, July, August and September are shown. Prepare cash budget for July to September.
Values listed are different from one another : Write the SQL code to list a unique value for V_CODE from the PRODUCT table so that the values listed are different from one another. This should be true no matter what values are in the table.
Pros and cons of aggression : Question - Pros and Cons of Aggression and Is aggression in sport helpful or harmful? Explain, using examples
Sql code to update the inventory on hand : You have sold 10 units of product X. Write the SQL code to update the inventory on hand (PROD_QOH) for this PROD_CODE in the PRODUCT table to reflect the sale. PROD_QOH is a numeric field. PROD_CODE is a character field.
Examine the current balance : Write the SQL code to examine the current balance, ACC_BALANCE, for the account, ACC_NUM, with the value 45689 located in the CHECKACC table.  The ACC_NUM is a character field.

Reviews

Write a Review

Financial Management Questions & Answers

  What is the forward exchange rate

International Machinery Company (IMC) is a Swedish multinational manufacturing company. Currently, IMC's financial planners are considering undertaking a 1-year project in the United States. The project's expected dollar-denominated cash flows consis..

  Short-term variable-rate plan and long-term fixed-rate plan

Biochemical Corp. requires $730,000 in financing over the next three years. The firm can borrow the funds for three years at 11.90 percent interest per year. Determine the total interest cost under each plan. Which plan is less costly? Short-term var..

  Use the figure to find out the average rate

Use the figure to find out the average rate of change in the percent of the U.S. population that was foreign-born from 1960 to 2005. Interpret your result.

  Share after tax salvage value if the machine is sold

Lion's share inc just bought a 3 million dollar machine that will be depreciated over its 10 year life using straight line depreciation. The marginal tax rate is 40%. What is Lion Share's after tax salvage value if the machine is sold in year 8 for 4..

  Time for a lump sum to double

How long will it take $200 to double if it is deposited and earns the following rates? Round your answers to the closest year. [Notes: (1) This problem cannot be solved exactly with some financial calculators. If you are using a financial calculator,..

  What amount of taxes will he pay on his capital gain

How much would Joel save in taxes if he held the stock for more than a year, assuming he sold it for the same amount?

  When managing project trade-offs

When managing project trade-offs, it is important to understand the root cause of the conflict, and why the need for trade-offs exists. Project managers must carefully evaluate information about the problems that are occurring in their project. As we..

  What is expected return on equally weighted portfolio

Consider the following information: Rate of Return If State Occurs. Probability of state of economy, Boom=.64, Bust= .36 Stock A, Boom=.11 Bust=.18 Stock B, Boom=.20 Bust= .10 Stock C, Boom=.38, Bust=-.04 A. What is the expected return on an equally ..

  Type of investment annual rate of return

A credit union wants to make investments in the following: Type of Investment Annual Rate of Return (%). Vehicle loans 6. Write the objective function that is to maximize total annual return. Write the constraint that indicates Consumer loans plus ot..

  Calculate the payback-cash flows for two products

Assume a $250,000 investment and the following cash flows for two products. Year Product X Product Y 1 $ 90,000 $ 50,000 2 90,000 80,000 3 60,000 60,000 4 20,000 70,000 a. Calculate the payback for products X and Y. Payback Product X Years Product Y ..

  Find the duration of plan obligations if interest rate

A pension plan is obligated to make disbursements of $2.7 million, $3.7 million, and $2.7 million at the end of each of the next three years, respectively. Find the duration of the plan's obligations if the interest rate is 10% annually.

  What are the benefits of the jit inventory control system

Refer to the Bulldog battery company’s cash budget in Table 18-7.  Explain why the company would probably not issue $1 million worth of new common stock in January to avoid all short-term borrowing during the year.

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