Information concerning raising new capital Bonds $1,000 Face value 13% Coupon Rate (Annual… 1 answer below »

This assignment is to be completed in groups of three and carries 30 per-cent of the marks in this unit. The following considerations will be applied when evaluating the submission: Questions 1,2 and 3 (23 marks) of this assignment MUST be completed on an Excel Spreadsheet. The use of an accurate Excel (for Windows) model: 1. The setting and presentation. 2. Accuracy of calculations and Analysis. Question 1. (11 marks) Information concerning raising new capital Bonds $1,000 Face value 13% Coupon Rate (Annual Payments) 20 Term (Years) $25 Discount offered (required) to sell new bonds $10 Flotation Cost per bond Preference Shares 11% Required rate to sell new preference shares $100 Face Value $3 Flotation cost per share Ordinary Shares $83.33 Current Market Price $4.00 Discount on share price to sell new shares $5.40 Flotation Cost per bond $5.00 2018 – Proposed Dividend Dividend History $4.63 2017 $4.29 2016 $3.97 2015 $3.68 2014 $3.40 2013 Current Capital Structure Extract from Balance Sheet $1,000,000 Long-Term Debt $800,000 Preference Shares $2,000,000 Ordinary Shares Current Market Values $2,000,000 Long-Term Debt $750,000 Preference Shares $4,000,000 Ordinary Shares Tax Rate 33% Risk Free Rate 5% a) Calculate the cost associated with each new source of finance. The firm has no retained earnings available. b) Calculate the WACC given the existing weights The financial controller does not believe the existing capital structure weights are appropriate to minimise the firm’s cost of capital in the medium term and believes they should be as follows Long-term debt 40% Preference Shares 15% Ordinary Shares 45% c) What impact do these new weights have on the WACC? The firm is considering the following investment opportunity. (2019-2026) Data is as follows


Request for a custom paper or place a new order

Assignment Solutions For You


Forget All Your Assignment & Essay Related Worries By Simply Filling Order Form