Prepare cash budget for july to september

Assignment Help Financial Management
Reference no: EM131305654

Financial Management Assignment

In this assignment, you are expected to:

  • Compute and interpret financial ratios
  • Evaluate investment proposals
  • Apply knowledge to decide appropriate financing plan and dividend policy

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

Income statement for the year 2015

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 payout ratio remains constant.

Question 2 - 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 3 - 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 4 - 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.

Reference no: EM131305654

Questions Cloud

Analyze commonly accepted forensic techniques : Explain how to process and retrieve trace evidence involving firearms.Evaluate accepted methodologies employed in contemporary crime scene management relative to firearms. Analyze commonly accepted forensic techniques and contemporary specialized tec..
Discuss about the police leadership and organizations : Discuss about the Police leadership and Organizations.Write two paragraphs on your opinion on the subject provided and what you would or would not change based on your beliefs, opinions and thoughts.
Draw an arbitrary budget constraint for a person : Draw an arbitrary budget constraint for a person assuming that he or she receives no workers' compensation - Analyze the difference in the labor supply incentive effects of these two programs.
Determine the family and school risk factors for gang : Discuss the three models used to understand the relationship between delinquency and gang involvement. Which do you agree with most? Why?Determine the family and school risk factors for gang involvement.
Prepare cash budget for july to september : FIN303 Financial Management Assignment. 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
What are the physical locations where workstations : What are the physical locations where workstations, printers, servers, and other hardware will be installed? How will you provide users enough information about the system being installed to gain their confidence?
Compare and contrast mutual funds and hedge funds : Discuss "securitization" in the context of that in which a commercial (Hint: collateralized mortgage obligation circa 2006) and an investment bank may engage. What are two reasons-of many-why securitization likely occurs with financial intermediar..
Determine the final velocity of the rider : ENSY5000 - Fundamentals of Energy System Integration - Determine how long an energy storage device can be used when the required power load is a polynomial function of time and Determine the final velocity of the rider if they start the descent at a ..
Explain how these technologies can bring value : Explain why an Internet systems developer might choose one technology over another technology. Explain how these technologies can bring value to the business or organization.Incorporate additional research or academic information to support your pape..

Reviews

Write a Review

Financial Management Questions & Answers

  How much total capital gain or loss

Kelsey Drums, Inc., is a well-established supplier of fine percussion instruments to orchestras all over the United States. The company's class A common stock has paid a dividend of $11 per share per year for the last 17 years. The current required r..

  What conclusions can you reach about the sources

What conclusions can you reach about the sources of green power?

  Equity-financed firm plans to grow at an annual rate

An all-equity-financed firm plans to grow at an annual rate of at least 16%. Its return on equity is 24%. What is the maximum possible dividend payout rate the firm can maintain without resorting to additional equity issues?

  Project evaluation

Your firm is contemplating the purchase of a new $625,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $69,000 at the end of that time. what is the IRR for this proj..

  What is expected current share price

General Industries is expected to generate $22 million, $26 million, $29 million, $30 million and $32 million in free cash flows over the next five years, after which free cash flows are expected to grow at a rate of 3% per year. If the weighted aver..

  What is the total cost of leasing

The toyota motor company is advertising a 24 month lease of 2014 camry for $189 payable at the beginning of each month. The lease requires $2,399 down payment plus first month payment. what is the total cost of leasing if you put 40,000 miles at the ..

  What should be value of the hedged portfolio at expiration

What are its intrinsic values at stock prices of $45 and $38, respectively, what should be the hedge ratio and what should be the value of the hedged portfolio at expiration

  What was the cash balance at the end of quarter

Jupiter stores had a Quarter 2 beginning cash balance of $430. Sales for Quarters 1 through 3 are estimated at $600, $800, and $900, respectively. The cost of goods sold is equal to 70 percent of sales. Goods are purchased one quarter prior to the mo..

  Questiona describe concept of future value and present

questiona describe concept of future value and present value. b natasha has graduated from high school and has

  Compute the cost of capital for the firm

(Individual or component costs of capital) Compute the cost of capital for the firm for the following: A bond that has a $1000 par value (face value) and a contract or coupon interest rate of 11 percent. Interest payments are $55.00 and are paid semi..

  What is the reward-to-volatility ratio for the equity fund

You manage an equity fund with an expected risk premium of 12% and a standard deviation of 34%. The rate on Treasury bills is 6.4%. Your client chooses to invest $80,000 of her portfolio in your equity fund and $120,000 in a T-bill money market fund...

  What is the aftertax cash flow from this sale

ABC Company purchased $24,914 of equipment 5 years ago. The equipment is 7-year MACRS property. The firm is selling this equipment today for $8,758. What is the aftertax cash flow from this sale if the tax rate is 33 percent? The MACRS allowance perc..

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