+91-9519066910
CAD:+1-604-396-3267 ,IN:+91-7503070001, IN:+91-9519066910

Assignment

Computing Skills Assignment Help

Matlab Assignment Help

TFIN 603 Corporate Finance Assignment Help

Rating:
TFIN 603 Corporate Finance Assignment Help

TFIN 603 Corporate Finance

 
Date Due: 25/5/2020 in Turnitin and before class
Total Marks: 20 marks of the Unit
 
Instructions:
1. State and justify all your assumptions
2. This Group Assignment contains two parts:
• Part 1 (50%) is the work contained in the instructions below.
• Part 2 (50%) is the final report, follow the “Example Business Report Structure” found in Moodle. It should contain a report of the main points found in Part 1, and not the details already reported in Part
 
1.
• Part 1 work should be separated from Part 2 and include no more than 12 A4 pages.
• Part 2 should be no more than 4 A4 pages, or maximum of 1,200 words.
• Both Part 1 and 2 should be typed in Times New Roman, font 12, 1.5 spacing.
• Part 1 should only contain the table from Step 7, the regression summary (no data please), the graphs and the correlation matrix from step 8 to 12.
 
3. A copy of Part 1 (DO NOT INCLUDE EXCEL) and 2 should be submitted in Turnitin before 9am on 25 May 2020.

4. A soft copy (one copy per Group) of all WORD and EXCEL files should be emailed to siang.chang@top.edu.au before the beginning of the class, complete with cover sheet found in Moodle. Failure to submit on time will receive a 10% deduction in marks

5. Email your “Group Assignment Peer and Self-Assessment” with the document stated in point 4. You can find this form in Moodle.
6. Any form of cheating will attract a mark of ZERO.
 
OBJECTIVE
Relationship between Beta and Financial Ratio of a company assigned to your group

Part 1 Instructions
Step 1 Collect 10 years of closing price data from https://au.finance.yahoo.com
Step 2 Collect 10 years of All Ordinaries Index (^AORD) from the same site.
Step 3 For a one-year data series for year 2010:

3a) Calculate weekly security return Ri. Ri = ln Price at t + 1/ ln Price at t
3b) Calculate weekly market return Rm. Rm = ln AORD at t + 1/ ln AORD at t
3c) Use Regression Analysis in Excel, regress Ri vs Rm (Refer to example in Moodle)
3d) Record the value of 1-year beta from the regression
Step 4 Repeat Step 3 for each year from 2010 to 2019, a total of 10 regressions, including 2010 (if your company data does not go as far back as 2010, start from the earliest year where you can find the data)

finance assignment help, finance homework help, finance assignment, finance homework, financial accounting assignment, corporate finance assignment help, corporate finance assignment, finance assignment help online, do my finance homework, finance homework solutions, business finance assignment, corporate finance homework help, financial management assignment help, finance homework help online, business finance assignment help, international finance assignment help, financial planning assignment help, personal finance assignment help, financial management homework help, accounting and finance assignment, finance assignment writing service
 
Step 5 Go to the website of your assigned company, and find the balance sheet and profit and loss statements from 2010 to 2019.
Step 6 Calculate the following ratios for each of the years from 2010 to 2019:

1. PE = Price per shareEarnings per share 2. DebtEquity = Total DebtTotal Equity 3. Times Interest Earned = EBITInterest
4. Market Value/Book Value = Market Value per shareBook Value per share

Step 7 Regress Beta against P/E, where Beta is the y variable, and P/E the x variable.
Step 8 Draw a time series graph, where Beta and P/E are the y values, and year the x values.
Step 9 Repeat Step 8 and 9 for D/E, Times Interest Earned and MV/BV, one ratio at a time.
Step 10 a) Repeat Step 8 and 9, but with Beta against all the four ratios.

This multiple linear regression is expressed as: y = a + b1 x1+ b2 x2 + b3 x3 + b4 x4
where y = Beta, x1 = P/E, x2 = D/E, x3 = Times interest earned, x4 = MV/BV
a = y intercept, bi = slope for each of the ratios (where i = 1, 2, 3 4)
b) You should plot a time series graph containing all five variables, where y-axis represents the five variables, and x-axis the “year”.
(5% per regression and graph, a total of 25%)

Step 12 Find “Correlation” under Data/Data Analysis in Excel, and compute the correlation matrix of beta and the four ratios.

Part 2 (50%)
In a Business Report format, include the summary results (do not include data-series) from Part 1 and answer the following questions
1. What is the meaning of beta? (5%)
2. What type of beta have you found in Part 1-asset beta, equity beta or debt beta? Explain. (5%)
3. Explain briefly the meaning of the financial ratios you are studying in this assignment. (5%)
4. Explain the meaning of R-Square of the regression. Refer to the Excel example in Moodle. (5%)
5. From each of the regressions in step 8 and 10, comment on the R-Square and the p-value for the slope. Similarly for step 11, comment on R-Square and p-values of the 4 slopes. (10%)
Show your results as follows:
Regression
R-Square
p-value
Beta vs P/E
Beta vs D/E
Beta vs TIE
Beta vs MV/BV
Beta vs all 4 ratios
show all 4 p-values
Note that p-value is compared to the level of significance α.
e.g.
a) if α > p, the regression model in step 8 and 10 are significant and can be used at a confidence level of (1-α). Test at α = 5%
b) if α < p, the regression model in step 8 and 10 are insignificant and cannot be used at a confidence level of (1-α). Test at α = 5%
c) For step 11, some or all of the slopes may be significant. The model is significant when only the significant x-variables are included. Test at α = 5%.
6. Comment on the correlations in the correlation matrix found in step 12, include the correlation matrix here. (10%)

7. Report and comment on your observation of the graphs-how does Beta move with respect to each of the ratios over time, and why? Include your observation of
R-Square, p-value and correlation in your comments. (10%)
 
finance assignment help, finance homework helpfinance assignment, finance homeworkfinancial accounting assignment, corporate finance assignment helpcorporate finance assignment, finance assignment help onlinedo my finance homework, finance homework solutionsbusiness finance assignment, corporate finance homework helpfinancial management assignment help, finance homework help onlinebusiness finance assignment help, international finance assignment helpfinancial planning assignment help, personal finance assignment helpfinancial management homework help, accounting and finance assignmentfinance assignment writing service


 DOWNLOAD SAMPLE ANSWER


   

Details

  • Number of views:
    48
  • PRICE :
    AU$ 0.00

Submit Works

Assignment Help Australia

Our Top Experts


Karen Betty

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders


Daphne Lip

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders


Mr Roberto Tuzii

Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...

102 - Completed Orders


Harsh Gupta

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders


ARNAB BANERJEE

JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders


KARAN BHANDARI

Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders


Tan Kumar Ali

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders


Wesenu Irko

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders


Lizzy Darley

I'm Lizzy, full time education specialist in English, Essay Writing, Economics and Maths. Having Assi...

109 - Completed Orders


CRYSTAL

HSC PREPARATION I specialise in English coaching programs for HSC students. My personalised and results-...

202 - Completed Orders