Question

In: Finance

Please show all calculation manually by applying the formula, don't solve it on powerpoint. Your client...

Please show all calculation manually by applying the formula, don't solve it on powerpoint.

Your client is closely following a publicly listed Australian company, however your client does not have the requisite skills to evaluate the company and, as such, has provided you with the following information. Your client indicates that the company is closely integrated with the Australian economy and that he is happy for you to use the rates of return for the Australian economy as a whole in the evaluation process.

You have researched the following returns and other characteristics for this company:

Australian Treasury bills currently pay a return of 3% p.a.

Australian stock market return over the same period has averaged 8% p.a.

Australian stock market standard deviation of returns is 13% p.a.

This company’s beta is estimated at 1.10.

Historical returns and dividends (below).

Year Price Dividend

2010 $15.62 $0.00

2011 $12.77 $0.80

2012 $11.96 $0.00

2013 $14.08 $0.85

2014 $14.45 $0.00

2015 $15.82 $0.95

2016 $17.31 $0.00

2017 $24.01 $1.20

Using the above information, identify whether it is a good idea, for your client, to invest in this company. Explain your reasoning for your decision.

Expert Solution

jeff jeffy answered 1 year ago

please don't do it by excel, do it manually and show work! 1. A manufacturing company...

please don't do it by excel, do it manually and show work! 1. A manufacturing company decides to buy solar cells in anticipation of rising electricity costs. The company is modeling its purchase to save it $20,000 for the first year, and this saving increases 5% each year for the next 20 years as the solar cells generate enough electricity to compensate for the rising power bills. If the expected rate of return for the company equals 8%, what is...

Financial Management Please show formula and get the calculation in detail. Russell Industries retains all of...

Financial Management Please show formula and get the calculation in detail. Russell Industries retains all of its earnings and does not pay a dividend. A major hedge fund is interested in buying Russell’s stock. The hedge fund manager estimates the free cash flow over the next 4 years will be $3mm, $6mm, $10mm, and $12mm. After the 4th year, the free cash flow is expected to grow at 5%. Russell’s WACC is 12%, its debt is $40mm, and it has...

Please show all your work step by step and all the formula that is used. This...

Please show all your work step by step and all the formula that is used. This is my 3rd time posting as people do not explain what they are doing. Therefore, do not answer if you can't explain. D. What is the present value (PV) of a 12-years lease arrangement with an interest rate of 7.5% that requires annual payments of $4250. Per year with first payment being due now? E. A recent college graduate hopes to have $200000. Saved...

Please solve the recurrence relation by finding the explicit formula of each problem. Show all work,...

Please solve the recurrence relation by finding the explicit formula of each problem. Show all work, thanks! A. ck = 6ck-1 - 9ck-2 k≥2, c0 =1, c1=3 B. dk = 2dk-1 +k k≥1, d0 =1, d1=3 C. ak = 3ak-1 + 2 k≥1, a0 =3 D. bk = -bk-1 + 7bk-2 k≥2, b0 =1, b1=4

Based on the information above, do you think that IRP holds or not? Please show your formula and calculation.

Exchange RateInterest Rate (APR)S0($/€) $1.50=€1.00 i$=2%F360($/€) $1.58=€1.00 i€=4%Based on the information above, do you think that IRP holds or not? Please show your formula and calculation.

Show in excel please with correct formula Solve all the problems using after tax cash flow...

Show in excel please with correct formula Solve all the problems using after tax cash flow analysis, even the book ask in some of them to use BTCF The Container Corporation of America is considering replacing an automatic painting machine purchased 9 years ago for $700,000. It has a market value today of $40,000. The unit costs $350,000 annually to operate and maintain. A new unit can be purchased for $800,000 and will have annualO&Mcosts of $120,000. If the old...

Please show all the steps of calculation. The following are the financial statements for Patriots and...

Please show all the steps of calculation. The following are the financial statements for Patriots and Jets Companies for 2018: Statements of Financial Position Patriots Jets Cash $ 25,000 $ 45,000 Accounts receivable (net) 55,000 5,000 Inventory 110,000 25,000 Property, plant, and equipment (net) 550,000 160,000 Other long-term assets 140,000 57,000 Total assets $880,000 $292,000 Accounts payable $110,000 $ 10,000 Salaries payable 10,000 5,000 Current liabilities $120,000 $ 15,000 Long-term liabilities 190,000 55,000 Total liabilities $310,000 $ 70,000 Common shares 530,000 214,000 Retained earnings 40,000...

Instructions: Show all work, including every calculation and every formula, with proper symbols. Formulas must be...

Instructions: Show all work, including every calculation and every formula, with proper symbols. Formulas must be those used in the required textbook for the course. Use the t-table in your book to find the critical t value(s). Calculators are fine; computer software of any kind is NOT. (You are welcome to use SPSS to check your work, but all values generated/reported below must come from hand calculations or the t table in your book.) A therapist was interested in determining...

Please solve all parts of the following question. Please show all work and all steps. 1a.)...

Please solve all parts of the following question. Please show all work and all steps. 1a.) Solve x' = x + 3y + 2t y' = x - y + t^2 1b.) Solve x' + ty = -1 y' + x' = 2 1c.) Solve x' + y = 3t y' - tx' = 0

PLEASE SHOW ALL THE FORMULA IN AN EXCEL FORMAT AND ANSWER ALL QUESTIONS All problems must...

PLEASE SHOW ALL THE FORMULA IN AN EXCEL FORMAT AND ANSWER ALL QUESTIONS All problems must be solved using Excel formulas to receive credit. Question Set 1. You are in charge of quality control for computer monitors at Dell. You have data on twenty-five batches of monitors, tracking five types of defects: brightness, color, contrast, dead pixels, and stuck pixels. These data are given in the table below. 1. For each defect type, find the average number of defects per...