Find Jobs
Hire Freelancers

Calculate Weighted Average Cost of Capital (WACC) In excel with Formula's

$10-30 AUD

Selesai
Dibuat hampir 9 tahun yang lalu

$10-30 AUD

Dibayar ketika dikirim
Need to calculate the following question in excel using formulas please: CTW Constructions Limited is planning to expand its existing operations by assessing various investments. The management has identified two potential opportunities: projects A and B. It will compare the cost of projects A and B against their internal rate of returns, which are 14% and 18.5% respectively. The following information has been gathered which will apply to all projects. a. 10-year bonds currently outstanding were sold at a face value of $100 each with a yearly coupon rate of 7% per annum. The firm has been informed by an investment banker that bonds of equal risk and credit rating are now selling at a yield of 15 % per year. b. The CTW preference share is selling at a price of $0.76 per share. c. The ordinary share has a value of $0.90 per share in the market. The risk free rate is currently yielding 4.5% per year and the market risk premium is 10% per annum. The company has a beta coefficient of 1.4. d. The following information has been extracted from CTW’s latest balance sheet and is considered to be an optimal mix of financing sources: Bonds $2,000,000 Preference shares, (5% dividend, $2 par) $60,000 Ordinary share paid up capital ($1 par) 2,000,000 What is the after-tax-cost of capital (WACC) for the company if the relevant tax rate of 30% applies? Discuss your answer in relation to the two projects identified by the company.
ID Proyek: 7574984

Tentang proyek

9 proposal
Proyek remot
Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
Dear Sir/Madam, I went trough the attached questions and 100% sure that I can do this task PERFECTLY within 1 hour. You can visit my profile to see my qualifications, experience and reliability. I assure you that I will go beyond your expectations. Awaiting for your feedback. Best regards, Priyal
$30 AUD dalam 1 hari
5,0 (118 ulasan)
6,2
6,2
9 freelancer menawar dengan rata-rata $33 AUD untuk pekerjaan ini
Avatar Pengguna
Hi there? Am a quality academic writer who presents !00% original, well researched work, high quality and in good time. I personally handle your work, no outsourcing. I have good experience and skills related to financial management. Kindly contact me to have quality work and in no time. Welcome
$60 AUD dalam 2 hari
4,9 (28 ulasan)
5,3
5,3
Avatar Pengguna
Hi, Ill do this for 25AUD, I find it easy, here, WACC is made up of three things, the cost of odinary share capital, the cost of debt and the costs of preference shares. The cost of debt will take into account the tax implication of 30%... thats just a summary to my approach. You could interview with me now so we can discuss timelines
$30 AUD dalam 1 hari
4,9 (9 ulasan)
3,1
3,1
Avatar Pengguna
A proposal has not yet been provided
$25 AUD dalam 1 hari
3,7 (3 ulasan)
1,8
1,8
Avatar Pengguna
i have all you need. i have written many report before. I can work with excel as well and i love working with it. Also, i can analyse and interpret data as well. hope you consider me. Thank you
$10 AUD dalam 1 hari
5,0 (1 ulasan)
1,0
1,0
Avatar Pengguna
Hi I am a qualified accountant with real time exposure to financial management and treasury operations. Would be able to solve your query on a structured basis
$25 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I'm an experienced financial analyst with high Excel proficiency. I'm a project dedicated worker with high level of satisfied costumers.
$30 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera AUSTRALIA
COLO VALE, Australia
5,0
6
Memverifikasi Metode pembayaran
Anggota sejak Okt 3, 2014

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.