Cash Flow Analysis - Flight Centre Ltd Case Study - Accounting and Finance Assignment Help

Assignment Task :

QUESTION 1 TIME VALUE of MONEY 

A total debt of $ 1,000 due now, $4000 due 2 years from now, and $6000 due 5 years from now is  to be repaid by 3 payments. 

(1) The first payment is made now. 

(2) The second payment, which is 80% of the first, is made at the end of 30 months from now. 

(3) The third payment, which is 60% of the second, is made at the end of 4 years from now. 

The annual interest rate is 4%, compounded semi-annually. Calculate the amount of each of the 

three payments. A timeline is required for full points. 

QUESTION 2 Cash Flow Analysis

You are considering a 5-year investment project which is expected to cost $1, 000, 000. In each year, you have decided that there are 3 possible states of the economy: good, average, and poor. In each individual year there is a 35% chance of the economy being good and a 15% chance of it being poor. You forecast the following net cash flows for the project: 

(a) What is the expected net cash flow each year?

You have arranged the following sources of funding: 

(i) $200,000 from a 5-year fixed interest loan whose annual loan payments are $48,126.91. 

(ii) $250,000 from a 5-year zero-coupon bond with a face value of $350,000. 

(iii) $300,000 from an ordinary share issue where a dividend of $18,000 will be paid in one year and it is expected to grow at 3% per annum. 

(iv) $250,000 from a 5-year coupon-paying bond issue whose coupon rate is 7% and face value is $250,000. 

(b) what is the discount rate given above sources of financing? 

(c) What is the NPV of this investment project and should you invest in this project? 

QUESTION 3 STOCK VALUATION: 

• Use the spreadsheet “Q2-Stock-FLT.xlsx” on Blackboard to complete this question. The spreadsheet contains information output from Bloomberg Terminal. 
• All financial statement numbers are in millions of dollars unless otherwise indicated. 
• Assume today is 30th June 2017 and you have just been paid a dividend and that the next dividend will be received in exactly one year (assume dividend is paid annually). 
• The stock price as at 30th June 2017 was $38.30. 

a) You expect Flight Centre Ltd. to maintain the same dividend payout ratio as at 30th June 2017 for the next three years. After three years, the company will increase the dividend payout ratio to 70%. Assume company’s return on new investment is 16.6% and the required rate of return is 10%. Using the dividend discount model, calculate the intrinsic value for stock today. 

b) Based on your answer in Part (a), would you recommend to buy, sell or hold the stock? Give the recommendation and briefly discuss the difference between the intrinsic value and stock price. 

c) Calculate the following ratios for financial year ending at 30th June 2017 

• Forward Price-Earnings Ratio and Trailing Price-Earnings Ratio. Briefly discuss the difference between these two ratios. 
• If the stock was fairly priced according to the dividend discount model, what would be its Price- Earnings ratio (both Forward and Trailing)? 
• The P/E ratio of the “S&P/ASX 200 Consumer Discretionary Sector GICS Level 1 Index” is 25.07 as at the end of financial year of 2017, use this number as the average industry P/E ratio for 
• Flight Centre. Comparing your estimate of P/E ratio for Flight Centre with the industry average P/E ratio, what conclusion could you make?  
• Now assume you bought this share two years ago: 

d) If you bought share in the company on the 1st July 2015 at $34 and the share price exactly one year ago was $31, what is your capital gain per share today? 

e) Use the information in part (d), if you reinvested the dividends you received in more FLT shares, what is your wealth on 30th June 2017 on a per share basis? Assume that you have bought 1000 shares. 

This Accounting and Finance Assignment has been solved by our Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.