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

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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