Answered step by step
Verified Expert Solution
Link Copied!

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%

image text in transcribed

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 value

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Commercial Real Estate Finance

Authors: Gail Ramshaw, Mortgage Bank

1st Edition

0793157099, 9780793157099

More Books

Students also viewed these Finance questions