Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show how to find the values for the yellow cells in excel with the excel functions required to get the answer. thanks 4,568,199 30.00%
Please show how to find the values for the yellow cells in excel with the excel functions required to get the answer. thanks
4,568,199 30.00% Sample Question 5 (x marks) (a) From the extracts of the company's Year ending 30-Jun-13 financial statements, work out last year's Cash $11,345,576 (year ending 30 June 2013) free cash flow and Other assets $154,269,130 Number of shares on issue display the FCF in cell C23. Debt and liabilities $57,546,119 Company tax rate Equity (book value) $108,068,5871 (b) Apply the annual growth rates in cells D22 to G22 to project the free cash flows in cells Year ending 30-Jun-13 Growth rate D23 to G23. Sales revenue $84,326,549 Operating expenses -$41,749,655 (c) In cell F24, work out the Terminal Value in Depreciation -$14,891,032 the year to June 2016, assuming constant EBIT growth thereafter. Interest paid $6,356,917 Tax payable (d) From the FCFs and Terminal Value, work Net income out the the value per share of the equity in this company and display this is cell C33. Capital expenditure $14,685,050 Increase in working capital $2,989,184 FCF in cell C23 --- 30-Jun-13 30-Jun-14 5.50% 30-Jun-15 7.00% 30-Jun-16 8.50% 30-Jun-17 4.25% and thereafter Year ending Growth rate in FCFS Free Cash Flows (FCFS) Terminal value FCF4+1 (WACC - 84+1) Weighted average cost of capital 12.65% per annum Enterprise valueStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started